Create seperate dataframe from column items of dataframe in python

Question

i have a dataframe which looks like this players dataset. i want to make seperate dataframe for each club name for eg:

real_madrid=fifa[fifa['club']=='Real Madrid']
arsenal=fifa[fifa['club']=='Arsenal']

for every possible club present in dataset, how can i do so?

shullaw · Answer 1 · 2022-01-15T23:58:18.470

0

# generator
clubs = df.groupby('club')
clubs = (clubs.get_group(group) for group in clubs.groups)
clubs.__next__()
# or a list
clubs = [clubs.get_group(group) for group in clubs.groups]
clubs[0]

Or you could do a loop if you don't want a generator or list of dataframes

edited Jan 15 '22 at 23:58

answered Jan 15 '22 at 18:05

shullaw

96
1
5

2

this is highly inefficient, you'll redo the `groupby` every time – mozway Jan 15 '22 at 21:24
Noted. Adjusted the code accordingly. – shullaw Jan 15 '22 at 23:56

Create seperate dataframe from column items of dataframe in python

1 Answers1