How to use Pandas Concat : Quandl Datasets
In the previous video : • How to use Quandl with Python for Data Ana...
we learnt how to extract data in Quandl using the Python package. The extraction is quite easy:
1- Read the documentation page for the dataset you want to download.
2- Find the code associated with each dataset.
3- Get the data. The code is simple: quandl.get('code')
Now the question is how to extract data from multiple datasets, and add a new column if we need whilst we are downloading the data. In other words, we would like to concatenate all datasets together from Quandl.
This video demonstrates how to do this. The Pandas Concatenation or pd.concat method comes handy here once we read the metadata file by Pandas.
Check out the full codes on Github :
https://github.com/Datavigo/quandl/bl...
Find us on:
🐦 / datavigo
💼 / datavigo
About DataVigo:
Welcome to the DataVigo Channel. Our aim in this channel is to provide you top level training in Data Science and Data Analytics subjects. Whether you are a beginner or would like to sharpen your skills, this channel offers practice based tutorials in a variety of topics such as Python Programming, Machine Learning, Data Extraction, Data Visualisation, and Advanced Excel.
Credits:
Song: MBB - Beach (Vlog No Copyright Music)
Music provided by Vlog No Copyright Music.
Video Link: • MBB - Beach (Vlog No Copyright Music)