Automate creating subtables based on values of one column

Question

Suppose i have a df with a column X with the following unique values ('A', 'B', 'C')

I want to create a function that will create dataframes containing only the items for such unique value of column X. How best to do this?

I would usually write line of codes by filtering it but I want to know how best to manage this.

`dict(list(df.groupby('X')))`? – mozway Mar 30 '22 at 06:50 — mozway, Mar 30 '22 at 06:50

score 1 · Answer 1 · answered Mar 30 '22 at 06:50

1

Try this:

sub_dfs = [df[df['X']== i] for i in list(df['X'].unique())]

answered Mar 30 '22 at 06:50

supratim saha

2

It's poorly efficient as it needs to read the whole thing for each unique value ;) – mozway Mar 30 '22 at 06:52

1 Answers1