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