Welcome to our new Generate Reports with Python automatically series. You'll generate an example report in different formats.

In this Part 2 video, we'll generate reports as Excel file (multiple sheets and a chart) using ExcelWriter.

GitHub Repo with code: github.com/liannewriting/YouTube-videos-public/tre…


Part 1: Overview
▶️Part 2: Excel
Part 3: HTML (with template) & HTML to PDF
Part 4: PDF directly

Technologies that will be used
☑️ JupyterLab (Notebook)
☑️ pandas
☑️ Jinja2
☑️ WeasyPrint
☑️ FPDF


Links mentioned in the video
►OpenPyXL documentation: openpyxl.readthedocs.io/en/stable/

There's also an article version of the same content. If you prefer reading, please check it out. How to generate Reports with Python (3 Formats/4 Tools): www.justintodata.com/generate-reports-with-python/

Get access to more data science materials, check out our website Just into Data: justintodata.com/