Powerpoint Def

2/14/2022by admin

Umpires Match Day Protocols (Powerpoint Presentation). Def by: Werribee CC. North/West 1st XI: GF: 27 Mar 21: Kew. Def by: Werribee CC. South/East 1st XI: SF. A PowerPoint slideshow (PPT) is a presentation created on software from Microsoft that allows users to add audio, visual and audio/visual features to a presentation. It is considered to be a multimedia technology and also acts as a tool for collaboration and content sharing. PowerPoint is a piece of Microsoft's 'Office Suite.' It is commonly used in a variety of ways by business, education and government employees to provide a computerized 'slide-show' for enhancing a presentation.

Introduction

Love it or loathe it, PowerPoint is widely used in most business settings. Thisarticle will not debate the merits of PowerPoint but will show you how to usepython to remove some of the drudgery of PowerPoint by automating the creation ofPowerPoint slides using python.

Powerpoint Def

Fortunately for us, there is an excellent python library for creating andupdating PowerPoint files: python-pptx. The API is very well documented so itis pretty easy to use. The only tricky part is understanding the PowerPoint documentstructure including the various master layouts and elements. Once youunderstand the basics, it is relatively simple to automate the creation of yourown PowerPoint slides. This article will walk through an example of reading inand analyzing some Excel data with pandas, creating tables and building a graphthat can be embedded in a PowerPoint file.

Powerpoint def free

PowerPoint File Basics

Python-pptx can create blank PowerPoint files but most people are going toprefer working with a predefined template that you can customize with your own content.Python-pptx’s API supports this process quite simply as long as you know a fewthings about your template.

Before diving into some code samples, there are two key components you need tounderstand: Slide Layouts and Placeholders. In the images below you can seean example of two different layouts as well as the template’s placeholders whereyou can populate your content.

In the image below, you can see that we are using Layout 0 and there is one placeholderon the slide at index 1.

In this image, we use Layout 1 for a completely different look.

In order to make your life easier with your own templates, I created a simplestandalone script that takes a template and marks it up with the various elements.

I won’t explain all the code line by line but you can see analyze_ppt.py ongithub. Here is the function that does the bulk of the work:

The basic flow of this function is to loop through and create an example ofevery layout included in the source PowerPoint file. Then on each slide, it willpopulate the title (if it exists). Finally, it will iterate through all of theplaceholders included in the template and show the index of the placeholder aswell as the type.

If you want to try it yourself:

Refer to the input and output files to see what you get.

Creating your own PowerPoint

For the dataset and analysis, I will be replicating the analysis inGenerating Excel Reports from a Pandas Pivot Table. The article explainsthe pandas data manipulation in more detail so it will be helpful to make sureyou are comfortable with it before going too much deeper into the code.

Powerpoint 2013 Help Guide

Let’s get things started with the inputs and basic shell of the program:

After we create our command line args, we read the source Excel file into apandas DataFrame. Next, we use that DataFrame as an input to create thePivot_table summary of the data:

Consult the Generating Excel Reports from a Pandas Pivot Table if this doesnot make sense to you.

The next piece of the analysis is creating a simple bar chart of sales performanceby account:

Here is a scaled down version of the image:

We have a chart and a pivot table completed. Now we are going to embed that informationinto a new PowerPoint file based on a given PowerPoint template file.

Before I go any farther, there are a couple of things to note. You need to know whatlayout you would like to use as well as where you want to populate your content.In looking at the output of analyze_ppt.py we know that the title slideis layout 0 and that it has a title attribute and a subtitle at placeholder 1.

Here is the start of the function that we use to create our output PowerPoint:

This code creates a new presentation based on our input file, adds asingle slide and populates the title and subtitle on the slide. It looks like this:

Pretty cool huh?

The next step is to embed our picture into a slide.

From our previous analysis, we know that the graph slide we want to use islayout index 8, so we create a new slide, add a title then add a picture intoplaceholder 1. The final step adds a subtitle at placeholder 2.

Here is our masterpiece:

For the final portion of the presentation, we will create a table for eachmanager with their sales performance.

Here is an image of what we’re going to achieve:

Creating tables in PowerPoint is a good news / bad news story. The good newsis that there is an API to create one. The bad news is that you can’t easilyconvert a pandas DataFrame to a table using the built in API. However, weare very fortunate that someone has already done all the hard work for usand created PandasToPowerPoint.

This excellent piece of code takes a DataFrame and converts it to a PowerPointcompatible table. I have taken the liberty of including a portion of it inmy script. The original has more functionality that I am not using so Iencourage you to check out the repo and use it in your own code.

The code takes each manager out of the pivot table and builds a simple DataFramethat contains the summary data. Then uses the df_to_table to convertthe DataFrame into a PowerPoint compatible table.

If you want to run this on your own, the full code would look something like this:

All of the relevant files are available in the github repository.

Powerpoint Default Template

Conclusion

One of the things I really enjoy about using python to solve real world businessproblems is that I am frequently pleasantly surprised at the rich ecosystem of verywell thought out python tools already available to help with my problems. In this specific case,PowerPoint is rarely a joy to use but it is a necessity in many environments.

After reading this article, you should know that there is some hope for you next timeyou are asked to create a bunch of reports in PowerPoint. Keep this article in mind andsee if you can find a way to automate away some of the tedium!

Comments

Comments are closed.