Python for Data · Unit 5
Unit 5: Getting Data In
Load CSV and JSON files into pandas and check what arrived.
Lessons
- CSV Options That MatterSeparators, headers and the arguments you reach for on a real file.
- Missing Markers on LoadFiles write missing values in a dozen ways; na_values names yours.
- Selecting What You NeedRead the columns you want, and stop carrying the ones you do not.
- Reading JSON DataA list of records is a table waiting to happen.
- Writing Data OutSaving a result, and the index that gets written with it.
- Checking What You LoadedFour questions to ask a new table before you trust a number from it.
-
Take the Unit 5 test
End of unit test
Ten multiple choice questions and one free response problem. You need 70 to finish the unit. Retakes are unlimited and your best score is the one that counts.