How to read xlsx file in Python using Pandas

You can read the xlsx file in Python using Pandas with the following code. I highly recommend you This book to learn Python.

Read XLSX File

# Import the Pandas libraray as pd
import pandas as pd

# Read xlsx file
df = pd.read_excel("Data.xlsx")

# Display the Data
print(df)

Output:

  Students  Scores
0    Harry      77
1     John      59
2  Hussain      88
3   Satish      93

Free Learning Resources