Course overview
In your data science career, you’ll rarely get a dataset that is in precisely the state you want. That’s why data cleaning is such an invaluable skill in data science. This course builds on our previous Advanced Data Cleaning course and will make you a valuable asset to any data science team.
After learning how to prepare the data for analysis, the real fun begins — you’ll complete two data analysis and visualization guided projects using data from some of the biggest names in film culture.
Key skills
- Using the “two-phase” process to complete end-to-end data cleaning projects
- Combining, manipulating, exploring, and analyzing multiple datasets
- Completing compelling data cleaning guided projects
Course outline
Data Cleaning Project Walkthrough [6 lessons]
Data Cleaning Walkthrough 2h
Lesson Objectives- Research and prepare multiple datasets
- Clean data across multiple datasets
Data Cleaning Walkthrough: Combining the Data 2h
Lesson Objectives- Combine multiple datasets
- Perform joins in pandas
Data Cleaning Walkthrough: Analyzing and Visualizing the Data 1h
Lesson Objectives- Compute correlations in pandas
- Map schools using basemap
Guided Project: Analyzing NYC High School Data 1h
Lesson Objectives- Generate scatter plots to compare columns
Challenge: Cleaning Data 1h
Lesson Objectives- Clean data in pandas
- Apply functions over columns in pandas
Guided Project: Star Wars Survey 2h
Lesson Objectives- Clean and map column values in pandas
- Compute summary statistics
Projects in this course
Guided Project: Analyzing NYC High School Data
Perform additional analysis on a clean dataset with maps and visualizations.
Guided Project: Star Wars Survey
Use survey data to better understand Star Wars fans.
The Dataquest guarantee
Dataquest has helped thousands of people start new careers in data. If you put in the work and follow our path, you’ll master data skills and grow your career.
We believe so strongly in our paths that we offer a full satisfaction guarantee. If you complete a career path on Dataquest and aren’t satisfied with your outcome, we’ll give you a refund.
Master skills faster with Dataquest
Go from zero to job-ready
Learn exactly what you need to achieve your goal. Don’t waste time on unrelated lessons.
Build your project portfolio
Build confidence with our in-depth projects, and show off your data skills.
Challenge yourself with exercises
Work with real data from day one with interactive lessons and hands-on exercises.
Showcase your path certification
Impress employers by completing a capstone project and certifying it with an expert review.
Grow your career with
Dataquest.
![Aaron Aaron](https://www.dataquest.io/wp-content/uploads/2023/02/Aaron.webp)
![Jessi Jessi](https://www.dataquest.io/wp-content/uploads/2023/02/Jessi.webp)
![Victoria Victoria](https://www.dataquest.io/wp-content/uploads/2023/02/Victoria.webp)