Skip to content

Latest commit

 

History

History
50 lines (39 loc) · 1.82 KB

README.md

File metadata and controls

50 lines (39 loc) · 1.82 KB

I taught Data Preprocessing with Python to 200+ students through an online platform. These are the course materials I built for my students (Mostly graduate-level students from the Non-CS background).

Video Lectures on YouTube: https://lnkd.in/gK5epasB

Medium blogs for pandas: https://kawsar34.medium.com/list/learn-pandas-from-leetcode-a06903853aed

Data Preprocessing with Python

Lecture 01: Importing Data with Pandas

  • Challenges of reading a CSV file
  • Understanding the data
  • Finding Data Statistics, data types and missing value information

Lecture 02: Data Preprocessing with Pandas (Part 1)

  • Challenges of reading a CSV or Excel file
  • Choose columns by name before reading a csv file
  • Choose columns by number before reading a csv file
  • Reading only the first n number of rows

Lecture 03: Data Preproccessing with Pandas (Part 2)

  • How to extract new information from a column?
  • How to create a column based on a condition or function?
  • Removing a string from a column
  • Checking the unique values for each column
  • performing calculation in dataframe columns
  • dataframe sorting

Lecture 04: HW review

Lecture 05: Handling Missing values

  • performing data cleaning
  • data visualization of missing values
  • string to datetime conversion
  • removing missing values
  • replacing missing values by: 1. mean, 2. median, 3. constant, 4. interpolation, 5. forward imputation, 6. backward imputation

Lecture 06: Data Joining using Pandas

  • inner join, outer join, left join, right join

Lecture 07: Data Aggregation/grouping and Pivot table using Pandas

  • Data filtering
  • Data preprocessing
  • Data Aggregation/grouping
  • Pivot table
  • Data Visualization: Barplot

Lecture 08: Data Correlation and Categorical Variable Encoding

  • Dealing with categorical variables
  • Label encoding
  • One-hot encoding