Data Extraction Automation: pandas for Financial Analysis
https://sites.google.com/view/vinegar...
Python Programming for Economics and Finance. The Pandas library is developed using QuantEcon Python code available in Github fromThomas J. Sargent & John Stachurski.
Open Github Python Notebook directly with Google Colab
pandas defines fundamental structures for working with data and endows them with methods that facilitate operations such as: reading in data, adjusting indices, working with dates and time series, sorting, grouping, re-ordering. Please see:
https://python-programming.quantecon....
Please find github here:
https://github.com/QuantEcon/quanteco...
Google Colab:
https://colab.research.google.com/dri...
0:00 Introduction to QuantEcon Lectures and quantecon-notebook-python
1:13 Load directly the python notebook into Google Colab using github url
3:51 !pip install -- upgrade pandas_datareader version 0.10
5:00 import pandas as pd
5:11 pd.series create a pandas series
8:41 create an index for the pandas series
11:05 create a pandas dataframe
12:58 pd.read_csv and url link
14:25 select particular rows using standard Python array slicing notation
15:45 pandas iloc
17:08 pandas loc
20:18 change population column to scientific notation format using pandas
20:50 create a new column in pandas dataframe
21:26 visualize pandas series and dataframes using matplotlib
24:43 query online databases (e.g. FRED St. Louis Federal Reserve) programmatically using pandas reader
26:00 FRED unemployment data import directly into Google Colab using pandas