Delete DataFrame Columns Based on Row Value

Question

Given a Pandas DataFrame, I'm trying to delete columns that contain any row values greater than or equal to 10⁹ and row values less than or equal to 10^-9.

What would be the best method to perform such an action?

Note: I have NaN types in the DataFrame, which I would like to keep, i.e. the code has to work with NaN types.

EFT · Accepted Answer · 2017-06-19 19:13:00Z

1

If you really must keep those values NaN, you could first fill them in with a placeholder, then remove the placeholder after filtering.

df.fillna('None placeholder', inplace=True)
df = df[(df > 10**(-9)) & (df < 10**9)].dropna(axis=1)
df.replace('None placeholder', np.nan, inplace=True)

answered Jun 19, 2017 at 19:13

EFT

2,3691 gold badge12 silver badges11 bronze badges

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

Collectives™ on Stack Overflow

Delete DataFrame Columns Based on Row Value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related