How to replace 0 to null value in dataframe pandas?

Question

I have a dataframe, some of the cell in the dataframe have 0 , how to replace all the 0 with ' ' ?

final = final.replace(0, '')

This code not able run...Anyone can share me idea?

The code snippet you posted should've worked but it really depends on your actual data, please post raw data and code to reproduce your actual df — EdChum
– EdChum, Commented Apr 27, 2017 at 9:36

jezrael · Accepted Answer · 2017-04-27 09:54:37Z

5

I think you need:

final = final.replace(0, np.nan)
              .style.apply(color, axis=None)
              .set_table_attributes('border="" class = "dataframe table table-hover table-bordered"')
              .set_precision(10)
              .render()

edited Apr 27, 2017 at 9:54

answered Apr 27, 2017 at 9:42

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

Shi Jie Tio Over a year ago

but my 0 is a number

Shi Jie Tio Over a year ago

it is in int type

jezrael Over a year ago

All values are int? Or floats?

Shi Jie Tio Over a year ago

some are float some are integer

jezrael Over a year ago

What return df.dtypes ?

|

Collectives™ on Stack Overflow

How to replace 0 to null value in dataframe pandas?

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related