Using Pandas to pd.read_excel() for multiple worksheets of the same workbook

by

Try pd.ExcelFile:

xls = pd.ExcelFile('path_to_file.xls')
df1 = pd.read_excel(xls, 'Sheet1')
df2 = pd.read_excel(xls, 'Sheet2')

As noted by @HaPsantran, the entire Excel file is read in during the ExcelFile() call (there doesn’t appear to be a way around this). This merely saves you from having to read the same file in each time you want to access a new sheet.

Note that the sheet_name argument to pd.read_excel() can be the name of the sheet (as above), an integer specifying the sheet number (eg 0, 1, etc), a list of sheet names or indices, or None. If a list is provided, it returns a dictionary where the keys are the sheet names/indices and the values are the data frames. The default is to simply return the first sheet (ie, sheet_name=0).

If None is specified, all sheets are returned, as a {sheet_name:dataframe} dictionary.

More Related Contents:

  1. How can I see the formulas of an excel spreadsheet in pandas / python?
  2. From password-protected Excel file to pandas DataFrame
  3. Putting many python pandas dataframes to one excel worksheet
  4. error when applying function to a series object
  5. Groupby value counts on the dataframe pandas
  6. Python: pandas merge multiple dataframes
  7. Find the column name which has the maximum value for each row
  8. Import CSV file as a pandas DataFrame
  9. How to pivot a dataframe in Pandas? [duplicate]
  10. Get a list from Pandas DataFrame column headers
  11. Concatenate rows of two dataframes in pandas
  12. What does axis in pandas mean?
  13. Normalize columns of pandas data frame
  14. How do I sum values in a column that match a given condition using pandas?
  15. How to loop over grouped Pandas dataframe?
  16. Update a dataframe in pandas while iterating row by row
  17. Is there a simple way to change a column of yes/no to 1/0 in a Pandas dataframe?
  18. Conditionally format Python pandas cell
  19. How to concatenate multiple column values into a single column in Pandas dataframe
  20. Changing multiple column names but not all of them – Pandas Python
  21. python pandas flatten a dataframe to a list
  22. How to create a dictionary of two pandas DataFrame columns
  23. AttributeError: ‘DataFrame’ object has no attribute ‘ix’
  24. Pandas dataframe – running sum with reset
  25. What is dtype(‘O’), in pandas?
  26. Checking if particular value (in cell) is NaN in pandas DataFrame not working using ix or iloc
  27. Move column by name to front of table in pandas
  28. Convert List to Pandas Dataframe Column
  29. dataframe to dict such that one column is the key and the other is the value [duplicate]
  30. Is there a way to speed up handling large CSVs and dataframes in python?

Leave a Comment