Scaling Pandas – Forty tips for better Data Analysis

Pandas – Python’s most powerful Data Analysis library, is more than just a data manipulation tool – it is resource rich in features that many overlook. This article reveals 40 of such features. We will demonstrate every capability using some fictitious HR data to highlight their practical use. Let’s get started. We will organize the … Read more

How to read and write files in a directory with pathlib?

Today, we’ll explore how to read and write files using Python’s pathlib module. It provides methods to perform standard file operations without the need for importing other Python modules like os or shutil. Writing files with Python pathlib To begin, let’s assume we have a list of employee names and IDs that we want to … Read more

How to add a string to a path in Python using pathlib?

In this blog post, we’ll explore how to add a string to a path using pathlib, a library introduced in Python 3.4. The key benefit of the pathlib module is that it brings together the capabilities of many other Python modules like os.path, os, and glob into one object, making file system interactions way easier. … Read more

Create shapes and change their color, shape with PowerPoint VBA

You can use Visual Basic for Applications (VBA) to automate repetitive tasks and add dynamic content to your presentations. One good example is to create and customize shapes. In this tutorial, i will show how to add a shape, change its properties like color and size, and manipulate it further using PowerPoint VBA. Open your … Read more

How to Save Excel sheets as PDF with Current Date Using VBA?

If you often find yourself converting Excel reports to PDF format and manually typing in the current date to keep your file versions in order, you will find this trick pretty useful. We will use VBA (Visual Basic for Applications) to automate this task, saving you time and reducing the risk of errors. #1: Prepare … Read more

How to create a column based on a date range in Power BI?

Here’s a question from David: Is there a Power BI function that allows to create a table showing specific values for a date range? Let’s assume that i am interested to create a dummy table showing sales figures for all days in July 2023. Any ideas on how to accomplish that. Add a column based … Read more