About this course: 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.
Created by: Johns Hopkins University
Taught by: Jeff Leek, PhD, Associate Professor, Biostatistics
Bloomberg School of Public Health
Taught by: Roger D. Peng, PhD, Associate Professor, Biostatistics
Bloomberg School of Public Health
Taught by: Brian Caffo, PhD, Professor, Biostatistics
Bloomberg School of Public Health
| Basic Info | Course 3 of 10 in the Data Science Specialization |
| Language | English, Subtitles: Russian, French, Chinese (Simplified) |
| How To Pass | Pass all graded assignments to complete the course. |
| User Ratings |
Syllabus
WEEK 1
Week 1
In this first week of the course, we look at finding data and reading different file types.
9 videos, 4 readings
- Reading: Welcome to Week 1
- Reading: Syllabus
- Reading: Pre-Course Survey
- Video: Obtaining Data Motivation
- Video: Raw and Processed Data
- Video: Components of Tidy Data
- Video: Downloading Files
- Video: Reading Local Files
- Video: Reading Excel Files
- Video: Reading XML
- Video: Reading JSON
- Video: The data.table Package
- Reading: Practical R Exercises in swirl Part 1
Graded: Week 1 Quiz
WEEK 2
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.
5 videos
- Video: Reading from MySQL
- Video: Reading from HDF5
- Video: Reading from The Web
- Video: Reading From APIs
- Video: Reading From Other Sources
Graded: Week 2 Quiz
WEEK 3
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.
7 videos, 1 reading
- Video: Subsetting and Sorting
- Video: Summarizing Data
- Video: Creating New Variables
- Video: Reshaping Data
- Video: Managing Data Frames with dplyr - Introduction
- Video: Managing Data Frames with dplyr - Basic Tools
- Video: Merging Data
- Reading: Practical R Exercises in swirl Part 2
- Ungraded Programming: swirl Lesson 1: Manipulating Data with dplyr
- Ungraded Programming: swirl Lesson 2: Grouping and Chaining with dplyr
- Ungraded Programming: swirl Lesson 3: Tidying Data with tidyr
Graded: Week 3 Quiz
WEEK 4
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.
5 videos, 2 readings
- Video: Editing Text Variables
- Video: Regular Expressions I
- Video: Regular Expressions II
- Video: Working with Dates
- Video: Data Resources
- Reading: Practical R Exercises in swirl Part 4
- Ungraded Programming: swirl Lesson 1: Dates and Times with lubridate
- Reading: Post-Course Survey
Graded: Week 4 Quiz
Graded: Getting and Cleaning Data Course Project
FAQs
How It Works
Coursework
Each course is like an interactive textbook, featuring pre-recorded videos, quizzes and projects.
Help from Your Peers
Connect with thousands of other learners and debate ideas, discuss course material, and get help mastering concepts.
Certificates
Earn official recognition for your work, and share your success with friends, colleagues, and employers.
Creators
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.
Pricing
| Audit | Purchase Course | |
|---|---|---|
| Access to course materials | Available | Available |
| Access to graded materials | Not available | Available |
| Receive a final grade | Not available | Available |
| Earn a shareable Course Certificate | Not available | Available |
Ratings and Reviews
I really enjoyed this course. The instructors were good and the assignment was enjoyable.
Very useful class!
This course will let you manage your data as you want
Coursera provides universal access to the world’s best education, partnering with top universities and organizations to offer courses online.
© 2017 Coursera Inc. All rights reserved.
Great course to learn how to manipulate data