read_excel()
noun
say it: “REED ek-SEL” /ˈrid ɪkˈsɛl/
A pandas function that reads one sheet of an Excel workbook into a table that Python can work with.
What does read_excel() do in pandas?
read_excel() (pd.read_excel) loads one sheet of an Excel workbook (.xlsx) into a DataFrame. sheet_name
picks the sheet, the first one by default, and skiprows steps over title rows above the real column names. It needs
the openpyxl package installed.
import pandas as pd
vendors = pd.read_excel("vendors.xlsx", sheet_name="2026", skiprows=2)
vendors.head(4)
In a sentence
- “Two title rows sat above the headers, so he gave read_excel() skiprows=2.”
- “read_excel() loaded the 2026 sheet of the vendor workbook.”
Level: Journeyman · More Python terms at this level
Updated