About this Course
4.6
5,178 ratings
829 reviews
Before you can work with data you have to get some. This course will cover the basic ways that data can be obtained. The course will cover obtaining data from the web, from APIs, from databases and from colleagues in various formats. It will also cover the basics of data cleaning and how to make data “tidy”. Tidy data dramatically speed downstream data analysis tasks. The course will also cover the components of a complete data set including raw data, processing instructions, codebooks, and processed data. The course will cover the basics needed for collecting, cleaning, and sharing data....
Stacks

Course 3 of 10 in the

Globe

100% online courses

Start instantly and learn at your own schedule.
Calendar

Flexible deadlines

Reset deadlines in accordance to your schedule.
Clock

Suggested: 5 hours/week

Approx. 14 hours to complete
Comment Dots

English

Subtitles: English, French, Chinese (Simplified), Vietnamese, Russian

What you will learn

  • Check
    Apply data cleaning basics to make data "tidy"
  • Check
    Obtain usable data from the web, APIs, and databases
  • Check
    Understand common data storage systems
  • Check
    Use R for text and date manipulation

Skills you will gain

Data ManipulationRegular Expression (REGEX)R ProgrammingData Cleansing
Stacks

Course 3 of 10 in the

Globe

100% online courses

Start instantly and learn at your own schedule.
Calendar

Flexible deadlines

Reset deadlines in accordance to your schedule.
Clock

Suggested: 5 hours/week

Approx. 14 hours to complete
Comment Dots

English

Subtitles: English, French, Chinese (Simplified), Vietnamese, Russian

Syllabus - What you will learn from this course

1

Section
Clock
2 hours to complete

Week 1

In this first week of the course, we look at finding data and reading different file types....
Reading
9 videos (Total 67 min), 4 readings, 1 quiz
Video9 videos
Raw and Processed Data7m
Components of Tidy Data9m
Downloading Files7m
Reading Local Files4m
Reading Excel Files3m
Reading XML12m
Reading JSON5m
The data.table Package11m
Reading4 readings
Welcome to Week 110m
Syllabus10m
Pre-Course Survey10m
Practical R Exercises in swirl Part 110m
Quiz1 practice exercise
Week 1 Quiz10m

2

Section
Clock
1 hour to complete

Week 2

Welcome to Week 2 of Getting and Cleaning Data! The primary goal is to introduce you to the most common data storage systems and the appropriate tools to extract data from web or from databases like MySQL. ...
Reading
5 videos (Total 41 min), 1 quiz
Video5 videos
Reading from HDF56m
Reading from The Web6m
Reading From APIs7m
Reading From Other Sources4m
Quiz1 practice exercise
Week 2 Quiz10m

3

Section
Clock
10 hours to complete

Week 3

Welcome to Week 3 of Getting and Cleaning Data! This week the lectures will focus on organizing, merging and managing the data you have collected using the lectures from Weeks 1 and 2. ...
Reading
7 videos (Total 60 min), 1 reading, 4 quizzes
Video7 videos
Summarizing Data11m
Creating New Variables10m
Reshaping Data9m
Managing Data Frames with dplyr - Introduction3m
Managing Data Frames with dplyr - Basic Tools12m
Merging Data6m
Reading1 reading
Practical R Exercises in swirl Part 210m
Quiz1 practice exercise
Week 3 Quiz10m

4

Section
Clock
6 hours to complete

Week 4

Welcome to Week 4 of Getting and Cleaning Data! This week we finish up with lectures on text and date manipulation in R. In this final week we will also focus on peer grading of Course Projects. ...
Reading
5 videos (Total 34 min), 2 readings, 3 quizzes
Video5 videos
Regular Expressions I5m
Regular Expressions II8m
Working with Dates6m
Data Resources3m
Reading2 readings
Practical R Exercises in swirl Part 410m
Post-Course Survey10m
Quiz1 practice exercise
Week 4 Quiz10m
4.6
Direction Signs

40%

started a new career after completing these courses
Briefcase

83%

got a tangible career benefit from this course

Top Reviews

By BEOct 26th 2016

This course is really a challenging and compulsory for any one who wants to be a data scientist or working in any sort of data. It teaches you how to make very palatable data-set fro ma messy data.

By ARMay 14th 2018

Loved the structure of the course. Learned a lot. The course project seemed a little funky , especially creating the codebook for an already existing set of data but was a useful teaching aid.

Instructors

Jeff Leek, PhD

Associate Professor, Biostatistics
Bloomberg School of Public Health

Roger D. Peng, PhD

Associate Professor, Biostatistics
Bloomberg School of Public Health

Brian Caffo, PhD

Professor, Biostatistics
Bloomberg School of Public Health

About Johns Hopkins University

The mission of The Johns Hopkins University is to educate its students and cultivate their capacity for life-long learning, to foster independent and original research, and to bring the benefits of discovery to the world....

About the Data Science Specialization

Ask the right questions, manipulate data sets, and create visualizations to communicate results. This Specialization covers the concepts and tools you'll need throughout the entire data science pipeline, from asking the right kinds of questions to making inferences and publishing results. In the final Capstone Project, you’ll apply the skills learned by building a data product using real-world data. At completion, students will have a portfolio demonstrating their mastery of the material....
Data Science

Frequently Asked Questions

  • Once you enroll for a Certificate, you’ll have access to all videos, quizzes, and programming assignments (if applicable). Peer review assignments can only be submitted and reviewed once your session has begun. If you choose to explore the course without purchasing, you may not be able to access certain assignments.

  • When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile. If you only want to read and view the course content, you can audit the course for free.

More questions? Visit the Learner Help Center.