How to Create Pandas DataFrame using Excel and CSV
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)
