Python - Replace negative infinity values within a pandas dataframe [duplicate]

Question

As written in the title, I need to replace -inf values within a pandas data frame. I would like to replace them by nan-values. There are multiple columns containing -inf so it should be run over the whole data frame.

I tried df.replace(np.inf, np.nan) which only seems to work with positive infinity. Also tried df.replace('-inf', np.nan).

How do I replace negative infinity values in my dataframe?

df.replace(-np.inf, np.nan)?

FHTMitchell
– FHTMitchell

2018-06-13 14:03:15 +00:00
Commented Jun 13, 2018 at 14:03 — FHTMitchell
– FHTMitchell, Commented Jun 13, 2018 at 14:03
df.replace(np.NINF, np.nan)?

harpan
– harpan

2018-06-13 14:03:35 +00:00
Commented Jun 13, 2018 at 14:03 — harpan
– harpan, Commented Jun 13, 2018 at 14:03

muzzyq · Accepted Answer · 2018-06-13 14:04:31Z

5

Try the below, rather than 'inf' as a string:

df.replace(-np.Inf, np.nan)

answered Jun 13, 2018 at 14:04

muzzyq

9046 silver badges15 bronze badges

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

Collectives™ on Stack Overflow

Python - Replace negative infinity values within a pandas dataframe [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related