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 to a collection of mathematical functions. To install these libraries, navigate to an IDE terminal. At the command prompt ($), execute the code … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to convert a Dictionary into a NumPy array in Python. Example: Input Dictionary: {2017: 74, 2018: 80, 2019: 84, 2020: 73, 2021: 79} Output NumPy Array: [[2017 74] [2018 80] [2019 84] [2020 73] [2021 79]] To make it more fun, we have the … Read more
In Python, the pandas.DataFrame.groupby() function splits a pandas.DataFrame into subgroups. It is a part of a full groupby operation, where we usually split the data, apply a function, and then combine the result. Here is the argument table of pandas.DataFrame.groupby(). If it sounds great to you, please continue reading, and you will fully understand the … Read more
Quick Fix: Python raises the ImportError: No module named pandas when it cannot find the Pandas installation. The most frequent source of this error is that you haven’t installed Pandas explicitly with pip install pandas. Alternatively, you may have different Python versions on your computer, and Pandas is not installed for the particular version you’re … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to locate and return the common elements of two (2) lists in Python. To make it more fun, we have the following running scenario: Bondi Brokers offers two (2) Marketable Bonds: 3-years and 5-years. Each yields different amounts. To determine which Bond best suits … Read more
Problem: How to convert one or more tuples to a csv file? Example: Given is a tuple or list of tuples—for example, salary data of employees in a given company: Your goal is to write the content of the list of tuples into a comma-separated-values (CSV) file format. Your out file should look like this: … Read more
Problem: How to convert a list of lists to a csv file? Example: Given is a list of list—for example salary data of employees in a given company: Your goal is to write the content of the list of lists into a comma-separated-values (CSV) file format. Your out file should look like this: # file.csv … Read more
Problem Formulation and Solution Overview In this article, you’ll learn how to convert HEX values to an ASCII string in Python. To make it more fun, we have the following running scenario: Carrier Coders has decided to display a Quote of the Day on their website. Each quote is transmitted daily as HEX values. You … Read more
You have a tuple of integers—but you want a single integer. What can you do? Problem Formulation and Solution Overview Given a tuple of values. Goal: Convert the tuple to a single integer value. If you simply pass a tuple t into the int(t) built-in function, Python will raise a TypeError: int() argument must be … Read more
This article will demonstrate how to use a pandas dataframe method called rolling(). What does the pandas.DataFrame.rolling() method do? In short, it performs rolling windows calculations. It is often used when working with time-series data or signal processing. I will shortly dive into a few practical examples to clarify what this means in practice. The … Read more
The most Pythonic way to convert a list of integers ints to a list of strings is to use the one-liner strings = [str(x) for x in ints]. It iterates over all elements in the list ints using list comprehension and converts each list element x to a string using the str(x) constructor. This article … Read more
Problem Formulation and Solution Overview As a Python Coder, situations arise where you will need to apply a function against elements of a Series. To make it more fun, we have the following running scenario: Rivers Clothing does business with six (6) different countries. The Tax Rates for the associated countries have increased by 2%. … Read more