3. Excel files using pandas

import pandas as pd

file = 'battledeath.xlsx'

xls = pd.ExcelFile(file) # Load spreadsheet

print(xls.sheet_names) # Print sheet names

df1 = xls.parse("2004") # Load a sheet into a DataFrame by name

print(df1.head())

df2 = xls.parse(0) # Load a sheet into a DataFrame by index

print(df2.head())

label = [1,2,3]

df = pd.DataFrame(data, index =label)

print(df.iloc[:3]) # Print the first three rows of data