python - 如何在熊猫中组合/合并多个 DataFrameGroupBy

Question

我有 2 个<pandas.core.groupby.DataFrameGroupBy>对象，想用一个键将它们组合起来？我该怎么做？拥有'as_index = False'不起作用（它以前可以工作）我尝试了以下

result = pd.merge(groupobject_a, groupobject_b, on='important_key', how='inner')

但我在下面收到错误

ValueError: can not merge DataFrame with instance of type <class 'pandas.core.groupby.DataFrameGroupBy'>

这是我创建 groupby 对象的最小代码

import pandas as pd
my_dataframe = pd.read_csv("here is my csv")
groupobject_a= my_dataframe[(my_dataframe['colA'] > 0) & (my_dataframe['colB'] < 15) & (my_dataframe['colC'].notnull())].groupby(['important_key'], as_index=False)
groupobject_b= my_dataframe[(my_dataframe['colA'] > 25) & (my_dataframe['colB'] < 65) & (my_dataframe['colC'].notnull())].groupby(['important_key'], as_index=False)

标签： pythonpandas