Lesson 1.3
Reading files and CSVs
Real data arrives as a slightly wrong file. Encodings, delimiters, and missing values are the first three problems you will meet.
6mBeginner28,200 students
Sign in to watch this lesson
Browsing is free. Create an account to play videos and track your progress.
Overview
Real data arrives as a slightly wrong file. Encodings, delimiters, and missing values are the first three problems you will meet.
What this lesson covers
- Read and write files safely with context managers
- Parse CSV data and handle encoding issues
- Deal with missing and malformed rows on load
This lesson sits in Python Foundations for Data, part of Python for Data Work. It assumes what came before it and leads directly into the next lesson in the module.
In this lesson you will:
- Read and write files safely with context managers
- Parse CSV data and handle encoding issues
- Deal with missing and malformed rows on load
Pro Tip
Open a file with a context manager. It closes even when the code inside raises.