Preparing Data for Analysis Course (How To)

Learn how to clean and prep data for analysis using spreadsheet tools and Python's Pandas.

What you'll learn

• Cleaning data with spreadsheet tools
• Cleaning data with pandas
• Types of bad data

Understanding Cleaning Data

Learn what cleaning data is and the different types of bad data to look out for.

Chevron 4 steps

• What Is Cleaning Data?

  2:13

• Context

  1:59

• Bad Data Types

  5:54

• Bad Data

  5 questions

Data Cleaning

Find bad data in a dataset and use spreadsheet and Pandas knowledge to fix the errors.

Chevron 7 steps

• Cleaning A Spreadsheet

  11:23

• Cleaning A Spreadsheet Part 2

  8:15

• Cleaning A CSV

  11:21

• Cleaning A CSV Part 2

  11:32

• Cleaning A CSV Part 3

  10:50

• Cleaning A CSV Part 4

  10:21

• Cleaning Data

  5 questions