8A: Reproducible Reporting with Quarto and xlsxwriter

At the end of this session, students should be able to:

RAP

• Describe the key principles of reproducible analytical pipelines

Quarto

• Produce a report using Python in Quarto, incorporating
  • python code cells producing static charts, interactive charts, maps and data tables
  • expandable boxes
  • markdown
  • tabsets
• Produce a dashboard using Quarto
• Produce a parameterised report in Quarto
• Automate the production of several variants of the same report using parameters
• Set up and populate a Quarto book and explain how this differs from a Quarto report
• Install and use additional Quarto Extensions
• Use Quarto Live and explain its benefits and limitations

Excel from Python

• Use Python and the xlsxwriter package to produce an Excel spreadsheet
• Enhance Excel sheets produced with xlsxwriter with various features, including
  • text formatting
  • table formatting
  • formulas
  • native charts
  • pivot tables

Datasets

Penguins

Size measurements, clutch observations, and blood isotope ratios for 344 adult foraging Adélie, Chinstrap, and Gentoo penguins observed on islands in the Palmer Archipelago near Palmer Station, Antarctica. Data were collected and made available by Dr. Kristen Gorman and the Palmer Station, Antarctica Long Term Ecological Research (LTER) Program.

• Source

Data are available by CC-0 license in accordance with the Palmer Station LTER Data Policy and the LTER Data Access Policy for Type I data.

Imported via the palmerpenguins package, created by Muhammad Chenariyan Nakhaee.

All penguins artwork by @allison_horst

Additional Datasets

Datasets for exercises 2 and 3 are randomly generated and relate to fictitious health systems.