Contenido del Curso
Excel Automation with Python
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.
Tarea
Swipe to start coding
- Import
pandas
andopenpyxl
; - 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;
- Use
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.
- Use
Solución
Mark tasks as Completed
¿Todo estuvo claro?
¡Gracias por tus comentarios!
Sección 1. Capítulo 10
AVAILABLE TO ULTIMATE ONLY