About this course
Data analysts and data scientists alike report that while there are definitely “sexier” parts of the job, most of their time is spent on data preparation and cleaning.
In our advanced data cleaning course, you’ll learn how to supercharge your workflow with some advanced data cleaning techniques that will make you a data analysis superstar.
You’ll learn about regular expressions (regex), a powerful tool that allows you to match and manipulate text data with a lot of precision. You’ll also learn to work with JSON data, a common format you’ll encounter when pulling data from web APIs.
Then you’ll dive into map and anonymous functions, two intermediate-to-advanced concepts in R that are extremely useful for working with data and that can speed up your data cleaning work.
You’ll also learn how to handle missing values in your data, a critical part of almost every data analysis project. Rather than dropping rows or columns, which reduces the amount of data you have to work with, you’ll learn statistical techniques to impute missing data, and you’ll also learn how to insert data from outside sources.
By the end of this course, you’ll be able to:
- Use regular expressions to clean and manipulate text data
- Understand how to use map and anonymous functions
- Work with missing data.
Lessons in this course
Thousands of learners have changed their careers with Dataquest
Learners who recommend
Dataquest for career advancement
Dataquest rating on
G2Crowd and SwitchUp
Average salary boost
for learners who complete a path
Join a community of 1M+ data learners on Dataquest
Sign up for a free account
Get access to hundreds of free lessons.
Choose a course or path
Start anywhere, from beginner topics to advanced concepts.
Learn with hands-on exercises
Learn with real data and build your experience.
Apply your skills
Create projects, build your portfolio, and build your career.