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 Collect and Clean Data for Your Dashboard - Data Dashboard Day 16!
You have completed Collect and Clean Data for Your Dashboard - Data Dashboard Day 16!
Preview
Improve the quality and safety of your data by removing sensitive information, resolving missing values and duplicates, and standardizing dates, categories, and formatting before analysis.
This video doesn't have any notes.
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
which records meet our small business
filter, whether the file contains contact
0:00
information, what some unusual amounts mean,
and which columns we actually need to keep.
0:04
I'll start by asking how many records are
marked as small businesses and also have
0:10
no blank fields.
0:14
There are two conditions here.
0:15
Small business status has to be marked yes,
and every column has to contain a value.
0:17
At this point, I'm only asking a question
about the dataset.
0:22
I haven't told Claude to remove anything
yet.
0:26
Claude reports that the full file contains
about 124,000 award records.
0:29
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