We’ll learn how to automate a PowerPoint presentation from Excel data using Python. Below picture illustrates what we’ll do in this project: The input for this project is an excel file with 2 sheets: First sheet name: KPI, that have 7 columns {Start Time, NE Name, Cell, RRC Connected User, Cell Traffic Volume DL(Gbits), DLContinue reading “How to Create PowerPoint presentation from Excel Data with Python”
Category Archives: python
How to create PowerPoint Presentation with Python
Before we start, please make sure to install python-pptx library. With python-pptx library, you can create/edit (add a slide, text, paragraph, table, and much more) a PowerPoint (.pptx) file, but remember this won’t work on MS Office 2003. Installation: Open the command prompt on your system and write the given below command: From this post,Continue reading “How to create PowerPoint Presentation with Python”
Create a chart from Excel data in Python with matplotlib
In this post, you will learn how to use Pandas, Matplotlib, and BytesIO to visualize the data from an Excel file. The step we need is below: Read Excel file with Pandas. In this part, you can use CReadExcel or (CExcelFile & CSheet) classes from the previous post “How to read excel (xls, xlsx) fileContinue reading “Create a chart from Excel data in Python with matplotlib”
How to read excel (xls, xlsx) files in python using pandas
Excel file is one of the most popular files in the world because it is easy and very instinctive and user-friendly which makes it ideal for manipulating large datasets even with less technical skill. And everyone who uses a computer at one time or the other has come across and worked with excel spreadsheets. ThisContinue reading “How to read excel (xls, xlsx) files in python using pandas”
Convert Jupyter file (.ipynb) to Python file (.py) and Python file (.py) to executable file (.exe)
The main objective of this post is to convert IPython Notebook file (.ipynb) to standalone, one-file Windows executables (.exe) with no need for the installer for client setup, should work plug and play, and be as small as possible. Below are the steps you need: You can use Notebook Menu to save the file directlyContinue reading “Convert Jupyter file (.ipynb) to Python file (.py) and Python file (.py) to executable file (.exe)”
Know the anatomy of the Pandas Series
Pandas Series is a one-dimensional labeled-array that capable to hold of any data type. Labels must be a hashable type. And element in the series can be accessed similarly to ndarray from numpy library (to create ndarray need to import numpy library). Elements of a series can be accessed in two ways: position or label/index.Continue reading “Know the anatomy of the Pandas Series”
Software Technology 