Book a Demo!
CoCalc Logo Icon
StoreFeaturesDocsShareSupportNewsAboutPoliciesSign UpSign In
jupyter-naas
GitHub Repository: jupyter-naas/awesome-notebooks
Path: blob/master/Excel/Excel_Read_file.ipynb
2972 views
Kernel: Python 3

Excel.png

Excel - Read file

Give Feedback | Bug report

Tags: #excel #pandas #read #finance #snippet #dataframe

Last update: 2023-04-12 (Created: 2021-02-28)

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