pandas excel python
import pandas as pd # reading in from external file movies = pd.read_excel('movies.xls') # prints first five rows movies.head(n=5) # prints last five rows movies.tail(n=5) # for excel files w/ multiple sheets movies_sheet1 = pd.read_excel(excel_file, sheetname=0) movies_sheet2 = pd.read_excel(excel_file, sheetname=1) movies_sheet2 = pd.read_excel(excel_file, sheetname='name of third sheet') # sort by column sorted_by_gross = movies.sort_values(['Gross Earnings'], ascending=False) # exporting to file movies.to_excel('output.xlsx')
