Category Archives: Tips & Tricks

Split a String Column into Multiple Columns in Pandas DataFrame with Regex

To use the .str.split() function in pandas DataFrame, you can refer to this link: But in this article, we’ll use regex to split the sting values and change them to multiple columns. Let’s see the sample: Example: Script: Output: Summary The best part of using regex when you want to split a column into multipleContinue reading “Split a String Column into Multiple Columns in Pandas DataFrame with Regex”

Working with CSV File with Pandas (Python)

A Comma Separated Values (CSV) is the simplest form of storing data in tabular form as a plain text file. And these files (CSV) are often used for data exchange between different applications or sometimes used as an input for data-processing to get an insight about the data and to visualize it. Challenge How toContinue reading “Working with CSV File with Pandas (Python)”

How to Create PowerPoint presentation from Excel Data with Python

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”

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)”