import pandas as pd df = pd.read_excel (r'Path where the Excel file is stored\File name.xlsx') print (df)
Here is what the above code is Doing:
1. We import the pandas library and aliasing as pd.
2. We use the read_excel method of the pandas library to read the excel file in to a dataframe.
3. We print the dataframe.