Heads up! To view this whole video, sign in with your Courses account or enroll in your free 7-day trial. Sign In Enroll
Well done!
You have completed Preparing Data for Analysis!
You have completed Preparing Data for Analysis!
Preview
Use tools in Google Sheets to clean a dataset.
Update
- "Remove Duplicates" in Google Sheets can now be found under
Data > Data Cleanup > Remove Duplicates
Resources
Duplicates Conditional Formatting Formula
=countif(A:A,A1)>1
Related Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign upRelated Discussions
Have questions about this video? Start a discussion with the community and Treehouse staff.
Sign up
in this video we're going to practice
cleaning a data set using Google Sheets.
0:00
If you haven't already, check the teacher's
notes for a link to this dataset so
0:01
you can follow along with me.
0:05
Pause me until you're ready.
0:07
Ready?
0:10
Okay, let's go.
0:11
First let's tackle the duplicates.
0:13
Google Sheets has a built in
feature now to remove duplicates.
0:16
You just have to choose a column that
should have only unique values and
0:20
that will remove them.
0:25
First, let's select the entire data set.
0:27
You need to sign up for Treehouse in order to download course files.
Sign upYou need to sign up for Treehouse in order to set up Workspace
Sign up