Prepare the environment
- Course introduction
- Install Anaconda
- Prepare the datasets
- Say Hi to Our Playground
Python Basics
- Python Introduction
- Master variables: number, string, and boolean
- Master Strings
- Master Lists
- Master Dictionaries
- Master Sets
- Indentation
- Loops
- If-Else Condition
- Functions
Numpy Array
- Import Numpy
- Create Array
- Print Array
- Array Operations
- Indexing, Slicing, and Iterating
- Generate Statistics
Pandas Series
- Series Creation
- Series Operation
- Indexing
- Masking
- Handouts for Pandas Series
Pandas Dataframe - Import and Selection
- Import Data (Excel, CSV)
- Export Data (Excel, CSV)
- Array Transformation
- Select by Column
- Select by Row
- Select by Column and Row
- Select by Condition
- Exercise: Dataframe Selection
- Solution: Dataframe Selection
- Handouts for Pandas Dataframe Import and Selection
Pandas Dataframe - Manipulation
- Backup Data
- Re-name and Re-arrange Columns
- Changing and Restore Index
- Delete Columns/Rows
- Insert Columns/Rows
- Section Quiz
- Handouts for Pandas dataframe manipulation
Data Visualization
- Introduction to Visualization
- Series Plot and Bar Plot
- Prettify Plots
- Data Distribution: Histogram and Box Plot
- Data Concentration: Scatter Plot and Heat Map
- Data Composition: Pie Plot and Area Plot
- Handouts for Data Visualization
- Section Quiz
- Handouts for Numpy
Regression Analysis
- Linear Regression - Part 1
- Linear Regression - Part 2
