Notice: This page requires JavaScript to function properly.
Please enable JavaScript in your browser settings or update your browser.Aprende Openpyxl and Pandas | Excel Automation with Python (project)
Excel Automation with Python (project)
course content

Contenido del Curso

Excel Automation with Python (project)

Excel Automation with Python (project)

IntroductionCreate WorkbookSaveLoad WorkbookCell Valuesiter_rows()Open, Edit and SaveFiltersFormulasOpenpyxl and PandasCharts

bookOpenpyxl 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 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.

Solución

Mark tasks as Completed
Switch to desktopCambia al escritorio para practicar en el mundo realContinúe desde donde se encuentra utilizando una de las siguientes opciones
¿Todo estuvo claro?

¿Cómo podemos mejorarlo?

¡Gracias por tus comentarios!

Sección 1. Capítulo 10
AVAILABLE TO ULTIMATE ONLY
some-alt