About this Course
113,889 recent views

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Approx. 15 hours to complete

English

Subtitles: French, Chinese (Simplified), Vietnamese, Korean, Russian, English...
User
Learners taking this Course are
  • Biostatisticians
  • Data Analysts
  • Risk Managers
  • Data Scientists
  • Process Analysts

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
User
Learners taking this Course are
  • Biostatisticians
  • Data Analysts
  • Risk Managers
  • Data Scientists
  • Process Analysts

100% online

Start instantly and learn at your own schedule.

Flexible deadlines

Reset deadlines in accordance to your schedule.

Approx. 15 hours to complete

English

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

Syllabus - What you will learn from this course

Week
1
2 hours to complete

Week 1

9 videos (Total 67 min), 4 readings, 1 quiz
9 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
4 readings
Welcome to Week 110m
Syllabus10m
Pre-Course Survey10m
Practical R Exercises in swirl Part 110m
1 practice exercise
Week 1 Quiz10m
Week
2
1 hour to complete

Week 2

5 videos (Total 41 min), 1 quiz
5 videos
Reading from HDF56m
Reading from The Web6m
Reading From APIs7m
Reading From Other Sources4m
1 practice exercise
Week 2 Quiz10m
Week
3
10 hours to complete

Week 3

7 videos (Total 60 min), 1 reading, 4 quizzes
7 videos
Summarizing Data11m
Creating New Variables10m
Reshaping Data9m
Managing Data Frames with dplyr - Introduction3m
Managing Data Frames with dplyr - Basic Tools12m
Merging Data6m
1 reading
Practical R Exercises in swirl Part 210m
1 practice exercise
Week 3 Quiz10m
Week
4
6 hours to complete

Week 4

5 videos (Total 34 min), 2 readings, 3 quizzes
5 videos
Regular Expressions I5m
Regular Expressions II8m
Working with Dates6m
Data Resources3m
2 readings
Practical R Exercises in swirl Part 410m
Post-Course Survey10m
1 practice exercise
Week 4 Quiz10m
4.6
1009 ReviewsChevron Right

40%

started a new career after completing these courses

37%

got a tangible career benefit from this course

11%

got a pay increase or promotion

Top reviews from Getting and Cleaning Data

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 DHFeb 2nd 2016

Easy, mostly instructive Course. The Assignments and quizzes are quite good, and illustrates the lessons very well.\n\nSee the videos for general presentation, but use the energy on the excersizes.

Instructors

Avatar

Jeff Leek, PhD

Associate Professor, Biostatistics
Bloomberg School of Public Health
Avatar

Roger D. Peng, PhD

Associate Professor, Biostatistics
Bloomberg School of Public Health
Avatar

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....

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.