Read in an Excel File with Python

It’s very simple to read in an Excel file with Python — only two lines are required. See the code below. Run the code and you can see on the right side an area called the “Variable Explorer” to ensure the code ran successfully. You can use any Excel file, and make sure that in the code below you enter your Excel name where it says “Enter Your Excel Filename Here“.

The first line imports pandas, a very useful library in Python and the second line reads in the Excel file into a “dataframe“, which you can think of as a mini Excel-like sheet in Python that has many use cases we’ll soon see.

Code:

import pandas as pd

df = pd.read_excel('Enter Your Excel Filename Here.xlsx')