Reading/Writing CSV, Excel & JSON

Summary

The everyday I/O operations that connect Python to the rest of your workflow — pulling data in from whatever format it arrives in, and exporting results back out for others to use.

How to Learn This

1Practice reading a CSV, an Excel file, and a JSON file into Pandas.
2Export a cleaned DataFrame back to Excel for a non-technical stakeholder.
3Learn common encoding and delimiter issues that break naive CSV reads.

Matplotlib & Seaborn

Working With APIs in Python

More topics in Python for Data Analysis

Python Basics for Analysts Jupyter Notebooks Pandas Fundamentals DataFrames & Series Data Cleaning With Pandas Merging & Joining DataFrames GroupBy & Aggregation in Pandas NumPy Basics Matplotlib & Seaborn Working With APIs in Python Basic Web Scraping (Overview)

Stuck on this topic? Ask an Insider

Get 1:1 guidance from people who've walked this exact path — free on the InsideEdge app.

Download