COVID-19 Analytics Report Using Python 3 FPDF Pandas Plotly

Python 3 FPDF script to generate COVID-19 analytics report with Charts & Maps using pandas and plotly library.

Generate COVID-19 Analytics Report

Generate COVID-19 Analytics Report Using Python

In this article, we will use a GitHub repository to generate a COVID-19 analytics report. This repo goes along with a YouTube video “Generating an Analytics Report (PDF) in Python”. In it, we learn how to use the fpdf library to create a report like the one you see above.

Link to video: https://youtu.be/UmN2_R4KEg8

Setup

You’ll want to download all of this source code locally. The easiest way to do that is by cloning the repo.

git clone https://github.com/KeithGalli/generate-analytics-report.git

If you have any trouble doing this, you can download the .zip file of this repo and then extract the files to a local folder. Once you have all the files cloned locally, you should make sure you have all the necessary libraries installed.

pip install fpdf
pip install pandas numpy matplotlib
pip install plotly
pip install -U kaleido

If you run into an error with NumPy, changing the version to 1.19.3 fixed the issue for me.

pip install numpy==1.19.3

To test if everything is set up properly, try running python generate_report.py. You should get a fresh report file. You’ll have to change helper.py to read from the online version of the data if you want to access the previous day (uncomment the BASE_PATH URL and comment BASE_PATH=’./data’). You will also have to comment out the hard-coded date at the bottom of the generate_report.py file. I saved it this way so that not too many unnecessary requests to the GitHub server were made while testing.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.