Pandas — Export CSV

Read CSV

import pandas as pd

df = pd.read_csv('data.csv')

# With options
df = pd.read_csv('data.csv', 
                 index_col=0,
                 usecols=['name', 'age'],
                 dtype={'age': int})

Write CSV

df.to_csv('output.csv', index=False)

Handle errors

# Custom na values
df = pd.read_csv('data.csv', na_values=['N/A', '--'])

# Skip rows
df = pd.read_csv('data.csv', skiprows=2)

# Use specific encoding
df = pd.read_csv('data.csv', encoding='utf-8')

Large files

# Read in chunks
chunks = pd.read_csv('large.csv', chunksize=10000)
for chunk in chunks:
    process(chunk)

Mini Practice

1. Read a CSV file
2. Write a CSV file
3. Handle missing values
4. Process large files

Up Next

Continue with JSON - Working with JSON data.