Getting and Cleaning Data

Getting and Cleaning Data

Getting and Cleaning Data

Johns Hopkins University

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.

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.

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

Rated 4.5 out of 5 of 3,515 ratings

Good material and excellent exercises.

Great course to learn how to manipulate data

I really enjoyed this course. The instructors were good and the assignment was enjoyable.