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.

7m
Beginner

Video thumbnail for Reading files and CSVs

Video by Earthly · YouTube

Check your understanding

3 questions. Unlocks when you finish the video.

Overview

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

Resources

pandas documentationThe official reference for the tools used in this lesson.