Pandas DataFrame Floordiv Method

Introduction

In this lab, we will learn about the floordiv() method in the pandas DataFrame class. This method is used to perform integer division between a DataFrame and another data structure, element-wise. It is equivalent to the // operator but provides support for filling missing values with a specified fill value.

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

Create a DataFrame

First, let's create a DataFrame to work with. In this example, we will create a DataFrame with three columns: A, B, and C.

## Import the pandas library
import pandas as pd

## Create the DataFrame
df = pd.DataFrame({"A": [2, 5], "B": [6, 7], "C": [3, 1]})

Apply the floordiv() method

Now, let's apply the floordiv() method to the DataFrame and perform integer division with a constant value. This will divide each element in the DataFrame by the constant value.

## Apply the floordiv method
result = df.floordiv(2)

## Print the result
print(result)

Apply the floordiv() method with a Series

Next, let's apply the floordiv() method to the DataFrame and perform integer division with a Series. This will divide each element in the DataFrame by the corresponding element in the Series.

## Create a Series
series = pd.Series([2, 3])

## Apply the floordiv method with the Series
result = df.floordiv(series, axis=0)

## Print the result
print(result)

Apply the floordiv() method with a fill value

Lastly, let's apply the floordiv() method to the DataFrame and perform integer division with a fill value of 30. This fill value will be used to replace any missing values in the DataFrame.

## Create a DataFrame with missing values
df = pd.DataFrame({"A": [2, 5, None], "B": [6, 7, np.nan], "C": [np.nan, 3, 1]})

## Apply the floordiv method with a fill value of 30
result = df.floordiv(3, fill_value=30)

## Print the result
print(result)

Summary

In this lab, we learned about the floordiv() method in the pandas DataFrame class. We saw how to perform integer division between a DataFrame and other data structures, such as constants and Series. We also learned about the fill value parameter, which allows us to handle missing values during the division operation. The floordiv() method is a useful tool for performing element-wise integer division in pandas DataFrames.