Openpyxl and Pandas

Let's now import an excel file and transform it into a pandas DataFrame!

Using openpyxl and pandas together allowing for efficient data analysis and the creation of feature-rich Excel reports directly from Python.

Task

Swipe to show code editor

Import pandas and openpyxl;
Extract the values of the workbook:
- Use load_workbook() function that reads the file from the disk so that you can manipulate it;
- workbook.active help get access to the currently active worksheet in the workbook;
sheet.values property generates a generator of all the rows in the worksheet, where each row is represented as a tuple of cell values.
Create a DataFrame (df) out of them:
- Use pd.DataFrame() function.

Mark tasks as Completed

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Thanks for your feedback!

Let's now import an excel file and transform it into a pandas DataFrame!

Using openpyxl and pandas together allowing for efficient data analysis and the creation of feature-rich Excel reports directly from Python.

Task

Swipe to show code editor

Import pandas and openpyxl;
Extract the values of the workbook:
- Use load_workbook() function that reads the file from the disk so that you can manipulate it;
- workbook.active help get access to the currently active worksheet in the workbook;
sheet.values property generates a generator of all the rows in the worksheet, where each row is represented as a tuple of cell values.
Create a DataFrame (df) out of them:
- Use pd.DataFrame() function.

Mark tasks as Completed

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Section 1. Chapter 10

AVAILABLE TO ULTIMATE ONLY