How to read excel file using pandas in python?

Description

To read excel file using pandas in python.

   Import libraries.

   Read the excel file.

  Make it as a data frame.

#import libraries

import pandas as pd

#read excel file

data=pd.read_excel(‘/home/soft27/soft27

/Sathish/Pythonfiles/Employee.xlsx’)

#create data from

df=pd.DataFrame(data)

#printing data frame

print(“Data in the excel file”)

print (df)

Leave Comment

Your email address will not be published. Required fields are marked *

clear formSubmit