Read file

​​
​

Template request | Bug report | Generate Data Product​
Tags: #excel #pandas #read #finance #snippet #dataframe
Author: Florent Ravenel​
Description: This notebook reads an Excel file and allows users to manipulate the data within it.
Input
Import libraries
import pandas as pd
Variables
excel_file_path = "Excel-Sales_Jan2020.xlsx"
Model
Read excel
You want to add more parameters ?
👉 Check out the pandas documentation here.
df = pd.read_excel(excel_file_path)
Output
Display result
df

Save file

List sheets in workbook

Last modified 1mo ago