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])]