如何根据条件用 NaN 替换数据框列值? [英] How to replace a dataframe column values with NaN based on a condition?

问题描述

例如，数据框看起来像:

For example, The dataframe looks like:

DF=pd.DataFrame([[1,1],[2,120],[3,25],[4,np.NaN],[5,45]],columns=["ID","Age"])

在年龄列中，小于 5 且大于 100 的值必须转换为 NaN.

In the Age column, the values below 5 and greater than 100 have to converted to NaN.

感谢任何帮助！

推荐答案

Using where 和 between

df.Age=df.Age.where(df.Age.between(5,100))
df
   ID   Age
0  10   NaN
1  20   NaN
2  30  25.0

这篇关于如何根据条件用 NaN 替换数据框列值?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！