pandas 筛选出满足条件的行并赋值
1.将属性filter_data的属性满足条件(month>5)的数据,赋值为0.df["filter_data"].loc[df["Month"]>5] = 02.筛选多个条件:df["filter_data"].loc[(df["Month"]>5) & (df['Month']<12)] = 03.筛选等于某个值:df1 = df.loc[df['Month'
·
1.将属性filter_data的属性满足条件(month>5)的数据,赋值为0.
df["filter_data"].loc[df["Month"]>5] = 0
2.筛选多个条件:
df["filter_data"].loc[(df["Month"]>5) & (df['Month']<12)] = 0
3.筛选等于某个值:
df1 = df.loc[df['Month'].isin([1,2,3,4,5,12])]
参考资料:https://blog.csdn.net/qq_42902997/article/details/121668004
更新:
4.筛选满足多个条件的数据:
df1 = df[df['Year'].isin([2020])&df['Month'].isin([12])]
更多推荐
已为社区贡献13条内容
所有评论(0)