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
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
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
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
When you get the error name ‘openai’ is not defined, it means that Python cannot find the openai library in your current namespace. This is probably due to one of the following reasons: Why you get the openai name error? The openai library allow to interface with OpenAI’s API services. If you haven’t installed it, … Read more
Understand the no module named langchain in Python The fundamental issue is that your Python program cannot locate the langchain module. Most probably, the module is not installed in the environment you’re using or is installed in a different Python environment that the IDE is not configured to use. Read on to learn how to … Read more
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