These are the exercise files used for Python Pandas Essential Training for Finance course.
The course outline can be found in
https://www.tertiarycourses.com.sg/python-pandas-essential-training-in-singapore.html https://www.tertiarycourses.com.my/python-pandas-essential-training-in-malaysia.html
Module 1 Overview of Numpy
- What is Numpy?
- 1D and 2D Array
- Array Arithmetics
- Special Functions
- Math Functions
- Selecting and Slicing Array Elements
- Filtering Array Elements
- Transforming Array
- Statistics
Module 2 Pandas
- Series
- Data Frame
- Selecting/Slicing Data
- Import/Export Data - CSV, Excel, Internet
- Filtering Data
- Missing Data
- Removing Duplicated Data
- Joining Data from Different Sources
- Transforming Data
- Aggregating Data
- Pandas Statistics
Module 3 Time Series
- Trend & Seasonality
- Time Range
- Rolling Window
Module 4 Data Visualization
- Overview of Matplotlib & Seaborn
- Plot Types
- Plot Attributes
- Object Oriented Plots
- Time Series Plot