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

Swipe to start coding

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.

import pandas as pd

from openpyxl import load_workbook

workbook = load_workbook(filename="sample_data.xlsx")

sheet = workbook.active

values = sheet.values

df = pd.DataFrame(values)

Mark tasks as Completed

Tudo estava claro?

Obrigado pelo seu feedback!

Seção 1. Capítulo 10

AVAILABLE TO ULTIMATE ONLY