How to Create Pandas DataFrame using Excel and CSV

Get Job-Ready: Data Analysis using Python with 70+ Projects Start Now!!

Program 1

import pandas as pd
# myfile=pd.read_excel("E://mypandas/mydata.xlsx",sheet_name='employee')
df=pd.read_excel("E://mypandas/mydata.xlsx",sheet_name='employee')
# df=pd.DataFrame(myfile)
print(df)
# df=pd.read_csv("E://mypandas/employee.csv")
# print(df)

 

 

We work very hard to provide you quality material
Could you take 15 seconds and share your happy experience on Google

courses
Image

TechVidvan Team

TechVidvan Team provides high-quality content & courses on AI, ML, Data Science, Data Engineering, Data Analytics, programming, Python, DSA, Android, Flutter, full stack web dev, MERN, and many latest technology.

Leave a Reply

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