Data Extraction Automation: pandas for Financial Analysis

Показать описание

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:

Please find github here:

Google Colab:

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
8:41 create an index for the pandas series
11:05 create a pandas dataframe
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