Python - Replace negative infinity values within a pandas dataframe

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 Jun 13 '18 at 14:03 — FHTMitchell, Jun 13 '18 at 14:03
`df.replace(np.NINF, np.nan)`? – harvpan Jun 13 '18 at 14:03 — harvpan, Jun 13 '18 at 14:03

score 4 · Accepted Answer · answered Jun 13 '18 at 14:04

4

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

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

answered Jun 13 '18 at 14:04

muzzyq

904
6
14

Python - Replace negative infinity values within a pandas dataframe

1 Answers1