How do you detect and delete infinite values from a time series in a pandas dataframe?

Question

I can't calculate the mean of a variable because it has infinite values in it, but I can't find and fix them:

perc_df[['variable']].mean()

variable    inf
dtype: float64

I've never dealt with infinite values before, is there an equivalent to "isna()" and "dropna()" for infinite values in pandas? If there isn't, how do I deal with these values?

Jaroslav Bezděk · Accepted Answer · 2020-07-01 14:48:53Z

2

You can try to filter out the infinite values with numpy.inf. The code is following:

import numpy as np
perc_df[perc_df.variable != np.inf].variable.mean()

answered Jul 1, 2020 at 14:48

Jaroslav Bezděk

7,7156 gold badges34 silver badges59 bronze badges

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

Comments

itsmartinhi · Accepted Answer · 2020-07-01 14:54:59Z

1

I think this should work for you:

perc_df = perc_df.replace([np.inf, -np.inf], np.nan)

answered Jul 1, 2020 at 14:54

itsmartinhi

559 bronze badges

Collectives™ on Stack Overflow

How do you detect and delete infinite values from a time series in a pandas dataframe?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related