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

Contenuti del Corso

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.

Compito

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.

Soluzione

Mark tasks as Completed
Switch to desktopCambia al desktop per esercitarti nel mondo realeContinua da dove ti trovi utilizzando una delle opzioni seguenti
Tutto è chiaro?

Come possiamo migliorarlo?

Grazie per i tuoi commenti!

Sezione 1. Capitolo 10
AVAILABLE TO ULTIMATE ONLY
some-alt