Python: How to get Dataframes with get_groups in for loops

Question

I have grouped a DataFrame using data.groupby('column) and now I want to create a dataframe from each group:

for i in data_group.indices:
    i = data_group.get_group(i)

I can print the dataframes out within the for-loop, but I can't access them otherwise... Somehow the naming of the DataFrame with a variable is not working. Does anyone have a solution?

As you iterate, store them in a list. If they need names, store them in a dictionary and use the names as keys. — wwii
– wwii, Commented Feb 3, 2018 at 16:03
Why do you need them assigned to variables? Can you just use .get_group('whatever') when you need it? — wwii
– wwii, Commented Feb 3, 2018 at 16:06
Possible duplicate of Using a loop in Python to name variables — wwii
– wwii, Commented Feb 3, 2018 at 16:07

BENY · Accepted Answer · 2018-02-03 16:02:33Z

1

You can store them in a list

g=data.groupby('column') 
l=[]
for x,df in g : 
    l.append(df)

Or using get_group

g.get_group('groupkey')

answered Feb 3, 2018 at 16:02

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

maerzm Over a year ago

Even though this does not yield individual dataframes, but one dictionary with key-value pairs I can access them from outside the for-Loop.

Collectives™ on Stack Overflow

Python: How to get Dataframes with get_groups in for loops

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related