Stop Wasting Time: Automate Your Presentation with Python

Photo by Agê Barros on Unsplash

There is nothing more boring than spending time on presentation creation, especially for recurrent analysis. Is there a solution to save data analysts’ lives? Yes! And of course, it’s thanks to Python !

One part of my job involves producing analysis each week or month, and I can assure you that it is always worth spending a few days on automating the process.

In this article, I want to show you how to outsource the most boring part of your job to Python. Now, it takes only 2 to 3 minutes to run the analysis from data ingestion to slide creation. Let’s walk through the process of analyzing a dataset and creating a presentation using the python-pptx library. We’ll use an open-source dataset from Kaggle, perform some basic analysis, and then create slides to present our findings.

Prerequisites are:

• Basic knowledge of Python
• Jupyter Notebook or any Python IDE (VS Code or PyCharm)
• Python libraries: pandas, seaborn, matplotlib, python-pptx

Let’s get started!

Step 1: Setting up the environment

First, let’s set up a virtual environment :

python venv auto_pptx
auto_pptx\Scripts\activate

And then, install the required libraries:

pip install -r requirements.txt

You can clone my github repository here.

Step 2: Importing libraries and loading the dataset

We’ll use the “Netflix Movies and TV Shows” dataset from Kaggle. Download it and place it in your working directory.

import pandas as pd

# Load the dataset
df = pd.read_csv('netflix_titles.csv')
display(df.head())

Dataset first lines

Step 3: Analyzing the dataset

Let’s perform some basic analysis on the Netflix dataset, we just want to plot some graphs in the presentation: