Convert pandas.core.groupby.SeriesGroupBy to a DataFrame

Question

This question didn't have a satisfactory answer, so I'm asking it again.

Suppose I have the following Pandas DataFrame:

df1 = pd.DataFrame({'group': ['a', 'a', 'b', 'b'], 'values': [1, 1, 2, 2]})

I group by the first column 'group':

g1 = df1.groupby('group')

I've now created a "DataFrameGroupBy". Then I extract the first column from the GroupBy object:

g1_1st_column = g1['group']

The type of g1_1st_column is "pandas.core.groupby.SeriesGroupBy". Notice it's not a "DataFrameGroupBy" anymore.

My question is, how can I convert the SeriesGroupBy object back to a DataFrame object? I tried using the .to_frame() method, and got the following error:

g1_1st_column = g1['group'].to_frame()

AttributeError: Cannot access callable attribute 'to_frame' of 'SeriesGroupBy' objects, try using the 'apply' method.

How would I use the apply method, or some other method, to convert to a DataFrame?

@ManishSaraswat, that's it! That's the answer. So simple! Thanks a lot! :D — Sean McCarthy
– Sean McCarthy, Commented Mar 20, 2018 at 17:43

Sean McCarthy · Accepted Answer · 2018-03-20 17:45:27Z

16

Manish Saraswat kindly answered my question in the comments.

g1['group'].apply(pd.DataFrame)

answered Mar 20, 2018 at 17:45

Sean McCarthy

5,7189 gold badges47 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Convert pandas.core.groupby.SeriesGroupBy to a DataFrame

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related