How to create a data frame for each group in the pandas.groupby function?

Question

I have a data frame which has been grouped by 'hour'. I want to use a for loop which loops through each group and creates a data frame for each group. The code I'm using at the moment only creates a data frame for the last group that it iterates through. Any suggestions on how I can get it to work properly?

for name, group in data.groupby('hour'):
    d = {'group_' + str(name) : group}

EdChum · Accepted Answer · 2015-05-13 13:05:41Z

11

You're overwriting your object each time you want this:

d = {}
for name, group in data.groupby('hour'):
    d['group_' + str(name)] = group

answered May 13, 2015 at 13:05

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

1 Comment

daniel3412 Over a year ago

Oh my goodness, what a stupid mistake. Thanks very much. Works perfectly!

Collectives™ on Stack Overflow

How to create a data frame for each group in the pandas.groupby function?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related