title: 技巧23: 筛选出满足要求的分组 date: 2024-11-28
技巧23: 筛选出满足要求的分组
输入
import pandas as pd
df = pd.DataFrame({"a":[1,3,1], "b":[10.0,8.0,6.0]})
df
筛选分组
df.groupby(by=['a']).filter( lambda x: (x['b'].mean()>7.0) & (len(x['b']) > 1) )
title: 技巧23: 筛选出满足要求的分组 date: 2024-11-28
import pandas as pd
df = pd.DataFrame({"a":[1,3,1], "b":[10.0,8.0,6.0]})
df
df.groupby(by=['a']).filter( lambda x: (x['b'].mean()>7.0) & (len(x['b']) > 1) )