Pandas DataFrame Rdiv Method

Introduction

In this lab, we will learn how to use the rdiv() method in pandas DataFrame. The rdiv() method is used to perform element-wise division in a DataFrame with other data structures, such as scalar, sequence, Series, or another DataFrame. It returns a new DataFrame with the result of the division 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 pandas library

import pandas as pd

Create a DataFrame

Let's start by creating a DataFrame using the pd.DataFrame() function. We will pass a dictionary containing column names as keys and lists as values.

df = pd.DataFrame({'a': [1, 6, 2], 'b': [3, 4, 6], 'c': [12, 1, 0]})
print("--------The DataFrame is----------")
print(df)

Perform division using rdiv() method

Now, let's perform division on the DataFrame using the rdiv() method. We will divide the DataFrame by a scalar value (12) and print the result.

print("---------------------------------")
print(df.rdiv(12))

Divide DataFrame with another DataFrame

Next, let's divide one DataFrame (df2) by another DataFrame (df1) using the rdiv() method. We will create two DataFrames and perform division using the rdiv() method.

df1 = pd.DataFrame({'a': [2, 2, 2], 'b': [2, 2, 2], 'c': [2, 2, 2]})
df2 = pd.DataFrame({'a': [2, 5, 6], 'b': [8, 10, 12], 'c': [14, 16, 18]})
print("---------------------------------")
print(df1.rdiv(df2))

Fill null values with a specified value

In some cases, the two DataFrames may not be aligned properly, resulting in NaN values after division. We can use the fill_value parameter of the rdiv() method to replace those NaN values with a specified value.

df1 = pd.DataFrame({'a': [2, 5, 6], 'b': [8, 10, 12]})
df2 = pd.DataFrame({'a': [2, 2, 2], 'b': [2, 2, 2], 'c': [2, 2, 2]})
print(df1.rdiv(df2, fill_value=2))

Summary

In this lab, we learned how to use the rdiv() method in pandas DataFrame to perform element-wise division. We learned how to divide a DataFrame by a scalar value, divide one DataFrame by another DataFrame, and fill null values with a specified value. The rdiv() method is a powerful tool for performing arithmetic operations on DataFrames in pandas.