Gili 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
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
Convert Date Range to column in Pandas First, let’s create a DataFrame that we can work with. This DataFrame will represent basic employee information: We will now add a column to our DataFrame for storing a range of dates. In this scenario, we will populate this column with dates spanning couple days. We then assign … Read more
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
When working with PySpark DataFrames, you might need to update specific cell values in its rows and columns. This could be for data cleaning, transformations, or simply to correct errors. Create a Spark DataFrame Let’s consider that we have a DataFrame that contains employee data with the following columns: id, name, department, and salary. Update … Read more
To check if a column in a Spark DataFrame contains a specific value, you can use the filter function alongside with the isin method. In this tutorial, i will provide a detailed step-by-step guide for finding one or multiple values in an employee dataset, which we will use as an example. #1 – Import PySpark … Read more
Step 1: Make sure that PySpark is installed Firstly, ensure that PySpark is installed in your environment. If not, you can install it using using the Python Package Installer (PIP) or the Anaconda Package Manager. You can ensure that PySpark is installed by running the following command: Then if PySpark is not installed use pip … Read more
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
In this tutorial, we will explore how to utilize variables with the msgbox and inputbox functions to create dynamic dialog boxes. The code provided below will run in Microsoft 365 (or earlier) Excel, PowerPoint and Word applications. Using variables with MsgBox and InputBox can make your VBA dialog interactions more dynamic and user-friendly. In this … Read more
The error message “Import ‘openai’ could not be resolved” in VSCode, is caused due to the fact that the Pylance extension in Python cannot locate the openai 3rd party package. This issue often arises due to one of the following reasons: openai is not installed in your environment, you are using an incorrect Python environment, … Read more