Convert DataFrameGroupBy object to DataFrame pandas

Question

I had a dataframe and did a groupby in FIPS and summed the groups that worked fine.

kl = ks.groupby('FIPS')  kl.aggregate(np.sum) 

I just want a normal Dataframe back but I have a pandas.core.groupby.DataFrameGroupBy object.

Answer 1

The result of kl.aggregate(np.sum) is a normal DataFrame, you just have to assign it to a variable to further use it. With some random data:

>>> df = DataFrame({'A' : ['foo', 'bar', 'foo', 'bar', >>>                         'foo', 'bar', 'foo', 'foo'], ...                  'B' : ['one', 'one', 'two', 'three', ...                         'two', 'two', 'one', 'three'], ...                  'C' : randn(8), 'D' : randn(8)}) >>> grouped = df.groupby('A') >>> grouped <pandas.core.groupby.DataFrameGroupBy object at 0x04E2F630> >>> test = grouped.aggregate(np.sum) >>> test             C         D A                       bar -1.852376  2.204224 foo -3.398196 -0.045082