Open In App

Replace Negative Number by Zeros in Pandas DataFrame

Last Updated : 05 Sep, 2020
Improve
Improve
Like Article
Like
Save
Share
Report

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 :



Like Article
Suggest improvement
Previous
Next
Share your thoughts in the comments

Similar Reads