#5, First Floor, 4th Street , Dr. Subbarayan Nagar Kodambakkam, Chennai-600 024 pro@slogix.in

Office Address

  • #5, First Floor, 4th Street Dr. Subbarayan Nagar Kodambakkam, Chennai-600 024 Landmark : Samiyar Madam
  • pro@slogix.in
  • +91- 81240 01111

Social List

How to read excel file using pandas in python?
Description

To read excel file using pandas in python.

Process

   Import libraries.

   Read the excel file.

  Make it as a data frame.

Sapmle Code

#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)

Screenshots