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.

Tarefa

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

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Obrigado pelo seu 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.

Tarefa

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

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Seção 1. Capítulo 10

AVAILABLE TO ULTIMATE ONLY