Pandas DataFrame Mod Method

Introduction

In this lab, we will learn how to use the mod() method in Pandas DataFrame to perform element-wise modulo operation on a DataFrame. The mod() method returns a new DataFrame with the result of the modulo operation.

VM Tips

After the VM startup is done, click the top left corner to switch to the Notebook tab to access Jupyter Notebook for practice.

Sometimes, you may need to wait a few seconds for Jupyter Notebook to finish loading. The validation of operations cannot be automated because of limitations in Jupyter Notebook.

If you face issues during learning, feel free to ask Labby. Provide feedback after the session, and we will promptly resolve the problem for you.

Skills Graph

Import the necessary libraries

First, we need to import the Pandas library to work with DataFrames:

import pandas as pd

Create a DataFrame

Let's create a DataFrame to perform the modulo operation on. For example:

df = pd.DataFrame({'a': [2, 5, 6], 'b': [8, 10, 12], 'c': [14, 16, 18]})

The DataFrame df has three columns 'a', 'b', and 'c', with corresponding values [2, 5, 6], [8, 10, 12], and [14, 16, 18].

Perform modulo operation on a constant value

To perform the modulo operation on each element of the DataFrame with a constant value, use the mod() method with the constant value as the argument. For example, to compute the modulo of each element with 3:

df_mod = df.mod(3)

The resulting DataFrame df_mod will contain the modulo of each element in the original DataFrame with 3.

Perform modulo operation with another DataFrame

To perform the modulo operation on each element of the DataFrame with another DataFrame, pass the second DataFrame as the argument to the mod() method. For example, let's create another DataFrame df2 with the same shape as df:

df2 = pd.DataFrame({'a': [2, 2, 2], 'b': [2, 2, 2], 'c': [2, 2, 2]})

To compute the modulo of each element in df with the corresponding element in df2, use the mod() method:

df_mod = df.mod(df2)

The resulting DataFrame df_mod will contain the modulo of each element in df with the corresponding element in df2.

Handling missing values

By default, the mod() method ignores missing or null values. However, you can specify a fill_value parameter to fill missing values with a specific value before performing the modulo operation. For example, to fill missing values with 1:

df_mod = df.mod(df2, fill_value=1)

The resulting DataFrame df_mod will contain the modulo of each element in df and df2, with missing values filled with 1.

Summary

In this lab, we learned how to use the mod() method in Pandas DataFrame to perform element-wise modulo operation on a DataFrame. We saw how to perform the modulo operation with a constant value or another DataFrame, and how to handle missing values. This method is useful for performing calculations on DataFrames based on specific modulo requirements.