Pandas — Read Excel

Read Excel

import pandas as pd

df = pd.read_excel('data.xlsx')

# Specific sheet
df = pd.read_excel('data.xlsx', sheet_name='Sheet2')

# With options
df = pd.read_excel('data.xlsx', 
                   index_col=0,
                   na_values=['N/A'])

Write Excel

df.to_excel('output.xlsx', index=False)

# Multiple sheets
with pd.ExcelWriter('output.xlsx') as writer:
    df1.to_excel(writer, sheet_name='Sheet1')
    df2.to_excel(writer, sheet_name='Sheet2')

Install openpyxl

pip install openpyxl

Mini Practice

1. Read Excel file
2. Write Excel file
3. Work with multiple sheets
4. Handle missing values

Up Next

Continue with SQL - Database operations.