Replace Negative Number by Zeros in Pandas DataFrame

Last Updated : 05 Sep, 2020

In this article, Let's discuss how to replace the negative numbers by zero in Pandas

Approach:

Import pandas module.
Create a Dataframe.
Check the DataFrame element is less than zero, if yes then assign zero in this element.
Display the final DataFrame

First, let's create the dataframe.

Python3

# importing pandas module
import pandas as pd

# Creating pandas DataFrame
df = pd.DataFrame({"A": [1, 2, -3, 4, -5, 6],
                   "B": [3, -5, -6, 7, 3, -2],
                   "C": [-4, 5, 6, -7, 5, 4],
                   "D": [34, 5, 32, -3, -56, -54]})

# Displaying the original DataFrame
print("Original Array : ")
df

Output :

Now, let's find the negative element and replace it with zero.

Python3

# checking the element is < 0
df[df < 0] = 0
print("New Array :")
df

Output :

Align columns to Left in Pandas - Python

kumar_satyam

Improve

Article Tags :

Python
Python-pandas
Python pandas-dataFrame
Python Pandas-exercise

Practice Tags :

python

Replace Negative Number by Zeros in Pandas DataFrame

Similar Reads

Pandas DataFrame Practice Exercises

Pandas Dataframe Rows Practice Exercise

Pandas Dataframe Columns Practice Exercise

Pandas Series Practice Exercise

Pandas Date and Time Practice Exercise

DataFrame String Manipulation

Accessing and Manipulating Data in DataFrame

DataFrame Visualization and Exporting

Thank You!

What kind of Experience do you want to share?