python how to read a xlsx file

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.