Pandas DataFrame Le Method

Introduction

In this lab, we will learn how to use the DataFrame.le() method in the pandas library in Python. The DataFrame.le() method is used to perform element-wise less than or equal to comparison between a DataFrame and another data structure, such as a scalar, sequence, Series, or another DataFrame. It returns a new DataFrame of boolean values that represent the result of the comparison 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 and create the DataFrame

Let's begin by importing the pandas library and creating a DataFrame. We will use the following code:

import pandas as pd
import numpy as np

df = pd.DataFrame({"A": [200, 500], "B": [60, 250], "C": [150, 1]})

Perform comparison with a scalar using DataFrame.le()

We can perform a less than or equal to comparison between the DataFrame and a scalar value using the DataFrame.le() method. This method returns a new DataFrame of boolean values. We will use the following code:

comparison_df = df.le(200)

Perform comparison with a Series using DataFrame.le()

We can also perform a less than or equal to comparison between the DataFrame and a Series using the DataFrame.le() method. This method broadcasts the comparison operation across the DataFrame based on the index values of the Series. We will use the following code:

series = pd.Series([150, 200, 150])
comparison_df = df.le(series, axis=0)

Perform comparison with another DataFrame using DataFrame.le()

Lastly, we can perform a less than or equal to comparison between the DataFrame and another DataFrame using the DataFrame.le() method. This method performs the comparison element-wise between the two DataFrames and returns a new DataFrame of boolean values. We will use the following code:

df2 = pd.DataFrame({"A": [200, 550], "B": [65, 251], "C": [100, 10]})
comparison_df = df.le(df2)

Summary

In this lab, we learned how to use the DataFrame.le() method in the pandas library. We learned how to perform less than or equal to comparisons between a DataFrame and a scalar, Series, or another DataFrame. The DataFrame.le() method allows us to easily compare elements in a DataFrame and obtain a new DataFrame of boolean values representing the result of the comparison.