The Pandas DataFrame/Series has several methods to re-shape, sort, and transpose the data. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The Xarray library works with labeled multi-dimensional arrays and advanced analytics. To install these libraries, navigate to an IDE terminal. … Read more
In this article, I want to discuss an important topic because it’s at the heart of what we are doing at Finxter. 💡 At the heart of Finxter is continuous improvement in computer science. For example, in my free email academy I deliver one piece of knowledge regarding Python, coding productivity and business, and computer … Read more
Problem Formulation Given a string, a substring, and a replacement string in Python. String s Substring sub Replacement string repl How to find and replace the last occurrence of sub with the replacement repl in the Python string s? Let’s have a look at a couple of examples to thoroughly understand the problem: Example 1: … Read more
Problem Formulation Given a string and a substring in Python. How to find the index of the last occurrence of the substring in Python? Let’s have a look at a couple of examples to thoroughly understand the problem: Example 1: string = ‘fifi’ substring = ‘fi’ result: 2 Example 2: string = ‘hello’ substring = … Read more
Ok, I must admit at the beginning that this topic is a bit of a clickbait – but if you find it cheating, I have to write in my defense that it was in good faith. If you were starting to write a book, it wouldn’t cross your mind to ask “what are the top … Read more
In this tutorial, we will learn all about the Pandas function get_dummies(). This method converts categorical data into dummy or indicator variables. Here are the parameters from the official documentation: Parameter Type Description data array-like, Series, or DataFrame Data of which to get the dummy indicators. prefix str, list of str, or dict of str,default … Read more
Problem Formulation How to list all files in the current directory given these constraints: Non-Recursive: You do not want to list files in subdirectories. ONLY Files: You do not want to list folder names. Current Directory: You run the Python script from the current directory. Here’s an example structure: current_folder — code.py — file.txt — … Read more
The Pandas DataFrame/Series has several methods to re-shape, sort, and transpose the data. When applied to a DataFrame/Series, these methods evaluate and modify the data to accommodate the selections. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports … Read more
Windows: How to Make Beep in Python To make a beep sound in Python on your Windows machine: Import the library using: import winsound Call windsound.Beep(frequency, duration) for your desired frequency (in Hertz) and duration (in milliseconds). For example, winsound.Beep(2000, 1500) would make a sound with 2000 Hz for 1.5 seconds. Here’s the relevant code … Read more
Do you feel stuck, and you don’t improve as a coder anymore? The reason you are stuck in coding likely is that you don’t produce enough — you are consuming way too much. It’s an ugly truth, and I’m sorry if you feel offended. It’s nonetheless the reason why you feel stuck. The purpose of … Read more
Use str.rstrip() to remove a trailing newline. Given a string s, create a new one without trailing newline character by calling s.rstrip(‘\n’). If you need the string stored in the original variable, simply assign the result to the original variable. Here’s an example: This actually removes all trailing newline characters: If you want to remove … Read more
The Pandas DataFrame/Series has several methods to handle Missing Data. When applied to a DataFrame/Series, these methods evaluate and modify the missing elements. Preparation Before any data manipulation can occur, two (2) new libraries will require installation. The Pandas library enables access to/from a DataFrame. The NumPy library supports multi-dimensional arrays and matrices in addition … Read more