Keep finite entries only in Pandas

Question

In Pandas, I can use df.dropna() to drop any NaN entries. Is there anything similar in Pandas to drop non-finite (e.g. Inf) entries?

Answer 1

You can use:

with pd.option_context('mode.use_inf_as_null', True):
   df = df.dropna()

Answer 2

df[np.isfinite(df) | np.isnan(df)]

Answer 3

You can use .dropna() after a DF[DF==np.inf]=np.nan, (unless you still want to keep the NANs and only drop the infs)