Rotate your phone or change to desktop for better experience

Rotate your phone or change to desktop for better experience

11. Create Data Frame from Excel sheet using Pandas and Perform Operations on DataFrames

 import pandas as pd

# read by default 1st sheet of an excel file

dataframe1 = pd.read_excel('Book1.xlsx')

print(dataframe1)

# read 2nd sheet of an excel file

dataframe2 = pd.read_excel('Book1.xlsx',sheet_name = 0,index_col = 0)

print(dataframe2)

Post a Comment

0 Comments