Course Content

Excel: the Power of Openpyxl

Introduction Create Workbook Save Load Workbook Cell Values iter_rows()Open, Edit and Save Filters Formulas Openpyxl and Pandas Charts

Excel: the Power of Openpyxl

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

Import pandas and openpyxl;
Extract the values of the workbook;
Create a DataFrame out of them.

Mark tasks as Completed

Everything was clear?

Section 1. Chapter 10

AVAILABLE TO ULTIMATE ONLY

some-alt