Lesson 19 of 60
pythonReading Data: CSV, Excel, JSON, and More
20 minutes
Course progress32%
Reading Data into Pandas
In practice, data lives in files, databases, or APIs. Pandas can ingest many formats.
CSV files
df_csv = pd.read_csv('data/sales.csv')
print(df_csv.head())
Excel files
df_excel = pd.read_excel('data/financials.xlsx', sheet_name='2023')
(df_excel.shape)