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.
提供方
约翰霍普金斯大学
課程信息
121,408 次近期查看
您將學到的內容有
Apply data cleaning basics to make data "tidy"
Obtain usable data from the web, APIs, and databases
Understand common data storage systems
Use R for text and date manipulation
您將獲得的技能
Data ManipulationRegular Expression (REGEX)R ProgrammingData Cleansing
教學大綱 - 您將從這門課程中學到什麼
週
1完成時間為 2 小時
Week 1
In this first week of the course, we look at finding data and reading different file types.
9 個視頻 （總計 67 分鐘）, 4 個閱讀材料, 1 個測驗
9 個視頻
Raw and Processed Data7分鐘
Components of Tidy Data9分鐘
Downloading Files7分鐘
Reading Local Files4分鐘
Reading Excel Files3分鐘
Reading XML12分鐘
Reading JSON5分鐘
The data.table Package11分鐘
4 個閱讀材料
Welcome to Week 110分鐘
Syllabus10分鐘
Pre-Course Survey10分鐘
Practical R Exercises in swirl Part 110分鐘
1 個練習
Week 1 Quiz10分鐘
週
2完成時間為 1 小時
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 個視頻 （總計 41 分鐘）, 1 個測驗
5 個視頻
Reading from HDF56分鐘
Reading from The Web6分鐘
Reading From APIs7分鐘
Reading From Other Sources4分鐘
1 個練習
Week 2 Quiz10分鐘
週
3完成時間為 10 小時
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 個視頻 （總計 60 分鐘）, 1 個閱讀材料, 4 個測驗
7 個視頻
Summarizing Data11分鐘
Creating New Variables10分鐘
Reshaping Data9分鐘
Managing Data Frames with dplyr - Introduction3分鐘
Managing Data Frames with dplyr - Basic Tools12分鐘
Merging Data6分鐘
1 個閱讀材料
Practical R Exercises in swirl Part 210分鐘
1 個練習
Week 3 Quiz10分鐘
週
4完成時間為 6 小時
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 個視頻 （總計 34 分鐘）, 2 個閱讀材料, 3 個測驗
5 個視頻
Regular Expressions I5分鐘
Regular Expressions II8分鐘
Working with Dates6分鐘
Data Resources3分鐘
2 個閱讀材料
Practical R Exercises in swirl Part 410分鐘
Post-Course Survey10分鐘
1 個練習
Week 4 Quiz10分鐘
4.6
1010 個審閱40%
完成這些課程後已開始新的職業生涯
37%
通過此課程獲得實實在在的工作福利
11%
加薪或升職
來自获取和整理数据的熱門評論
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.
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.
講師
Jeff Leek, PhD
Associate Professor, BiostatisticsBloomberg School of Public Health
Roger D. Peng, PhD
Associate Professor, BiostatisticsBloomberg School of Public Health
Brian Caffo, PhD
Professor, BiostatisticsBloomberg School of Public Health
關於 约翰霍普金斯大学
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.
常見問題
我什么时候能够访问课程视频和作业？
注册以便获得证书后，您将有权访问所有视频、测验和编程作业（如果适用）。只有在您的班次开课之后，才可以提交和审阅同学互评作业。如果您选择在不购买的情况下浏览课程，可能无法访问某些作业。
我订阅此专项课程后会得到什么？
您注册课程后，将有权访问专项课程中的所有课程，并且会在完成课程后获得证书。您的电子课程证书将添加到您的成就页中，您可以通过该页打印您的课程证书或将其添加到您的领英档案中。如果您只想阅读和查看课程内容，可以免费旁听课程。
退款政策是如何规定的？
有助学金吗？
還有其他問題嗎？請訪問 學生幫助中心。
