Course

You'll learn how to:

Start this course today

Build hands-on data skills with interactive exercises and projects.

Sign up

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

Loading lessons....

Thousands of learners have changed their careers with Dataquest

97%

Learners who recommend
Dataquest for career advancement

4.9 stars

Dataquest rating on
G2Crowd and SwitchUp

$30k

Average salary boost
for learners who complete a path

Join a community of 1M+ data learners on Dataquest

1

Sign up for a free account

Get access to hundreds of free lessons.

2

Choose a course or path

Start anywhere, from beginner topics to advanced concepts.

3

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.

Sign up today

or