Skip to main content
 首页 » 编程设计

python之从分组数据框中获取选定的行

2025年02月15日11bjzhanghao

我有以下数据框我想过滤组并只从左侧组中选择行。

  state  city  voting_majority_status_fk  other 
0     A    A1                          4   True 
1     A    A1                          4   True 
2     A    A1                          2  False 
3     A    A2                          3   True 
4     B    B2                          4  False 
5     B    B2                          2   True 
6     C    C1                          4   True 
7     C    C1                          4   True 
8     C    C1                          2  False 

我想对它进行分组,只从正组中取出一行:

我希望我的最终结果是:

2     A    A1                          2  False 
8     C    C1                          2  False 

到目前为止我的代码:

columns = ['state', ' city', 'voting_majority_status_fk', 'other'] 
        data = [['A', 'A1', 4, True], 
                ['A', 'A1', 4, True], 
                ['A', 'A1', 2, False], 
                ['A', 'A2', 3, True], 
                ['B', 'B2', 4, False], 
                ['B', 'B2', 2, True], 
                ['C', 'C1', 4, True], 
                ['C', 'C1', 4, True], 
                ['C', 'C1', 2, False], 
                ['C', 'C3', 2, False]] 
 
        df = pd.DataFrame(data=data, columns=columns) 
        grouped_df = df.groupby(['state', ' city']) 
        filtered_data = grouped_df.filter(VotingDataFetcher.my_filter) 
 
@staticmethod 
    def my_filter(group): 
        if 3 in group.voting_majority_status_fk.unique(): 
            return False 
        if 2 not in group.voting_majority_status_fk.unique(): 
            return False 
        if 4 in group.voting_majority_status_fk.unique(): 
            majority = group[group.voting_majority_status_fk == 4].head(1) 
            if not majority.other.tolist()[0]: 
                    return False 
            else: 
                minority = group[group.voting_majority_status_fk == 2] 
                tt = minority.head(1) <= I only want those lines. 
                return True 
        return False 

我得到以下输出,我得到整个组,但我只需要从组中选择行。

0     A    A1                          4   True 
1     A    A1                          4   True 
2     A    A1                          2  False <= only this one 
6     C    C1                          4   True 
7     C    C1                          4   True 
8     C    C1                          2  False <= and this one 

请您参考如下方法:

您需要应用返回tt的自定义函数:

def my_filter(group): 
    vuniq = group.voting_majority_status_fk.unique() 
    if (4 in vuniq) and (2 in vuniq) and not (3 in vuniq): 
        majority = group[group.voting_majority_status_fk == 4].head(1) 
        if majority.other.tolist()[0]: 
            minority = group[group.voting_majority_status_fk == 2] 
            tt = minority.head(1) #<= I only want those lines. 
            return tt 
 
df = pd.DataFrame(data=data, columns=columns) 
grouped_df = df.groupby(['state', ' city']) 
filtered_data = grouped_df.apply(my_filter).reset_index(drop=True) 
print (filtered_data) 
  state  city  voting_majority_status_fk  other 
0     A    A1                          2  False 
1     C    C1                          2  False 

您不能使用 filter,因为它会为每个组返回 True 或 False 并决定是否删除组。

您可以通过以下方式测试它:

filtered_data = grouped_df.apply(my_filter) 
print (filtered_data) 
state   city 
A      A1        True 
       A2       False 
B      B2       False 
C      C1        True 
       C3        None 
dtype: object