Loading an Excel file in Python

Excel files are packed with headers, logos, merged cells, and multiple sheets but pandas handles it all.
With just a few extra parameters, you can skip junk rows, pick exact columns,e.t.c

# Import the pandas library 
import pandas as pd

# Specify the path to your Excel file (.xlsx or .xls)
filename = "data.xlsx"

# Read the Excel file into a DataFrame
# Common options you'll use all the time:
df = pd.read_excel(
    filename,
    sheet_name=0,              # 0 = first sheet
    header=0,                  # Row (0-indexed) to use as column names
    skiprows=4,                # Skip first 4 rows
    nrows=1000,                # Load only first 1000 rows
)
# Check the first five rows
df.head()

Next up ➡️ Loading a text file in Python

👉Join @datascience_bds for more
Part of the @bigdataspecialist family