How To Read Excel Workbook Into Python DataFrame | The Best Way
This video covers how to read an Excel Workbook into a Python DataFrame. Three methods of reading the workbook into a dataframe are covered:
1. By default, Pandas will read the first Excel worksheet into the dataframe.
2. If you wish to read a specific sheet, use the sheet_name argument.
3. If you want to read all Excel sheets of the workbook into a single dataframe, you can use sheet_name=None and then concatenate the values of the resulting dictionary object.