Day 2 of 14 30 minread_csv()info()value_counts()
Read CSV files with the right options, then follow a quick routine to get to know any new dataset. info(), missing values, value_counts() and saving your results.
By the end of today you can
- Load a CSV file with pd.read_csv() and its most useful options
- Know which function reads Excel, JSON, Parquet and SQL data
- Inspect a dataset with info(), describe(), isna() and value_counts()
- Spot common problems such as missing values and wrong data types
- Save a DataFrame back to a CSV file
What's inside
- 5 sections
- 3 diagrams and mind maps
- 6 code examples you can run
- 5-question quiz
- 1Reading a CSV file
- 2Options that save you work later
- 3Other file formats
- 4A first-look routine
- 5Saving your work
Sign in free to read this lesson
Get the full lesson with diagrams, runnable code and the quiz. Your progress is saved across devices.
Sign in free