Create mutliple dataframes from list of dictonaries

Asked Feb 05 '23 at 19:40

Active Feb 05 '23 at 19:40

Viewed 14 times

I am trying to filter a dataframe to create multiple other dataframes based on a list of dictionaries. An example would be to create dataframes one, two, three:

dfa = pd.DataFrame({"ID": ["one", "two", "three"],"Color":["Red", "White", "Blue"],"Length":["16", "14.97", "22.75"]})

What I am trying to get is:

one=dfa[dfa['ID'].astype(str)=='one']

two=dfa[dfa['ID'].astype(str)=='two']

three=dfa[dfa['ID'].astype(str)=='three']

I want to do this over an unlimited number of dataframes so it would be easier to do it programmatically but I appreciate any help you can provide

asked Feb 05 '23 at 19:40

Shawn Jamal

1

`out = dict(list(dfa.groupby('ID')))` then access by name: `out['one']` – mozway Feb 05 '23 at 19:44
If I wanted to create dataframes from this in a for loop how would I go about it? I tried: dfa['ID'][i]=pd.DataFrame(out[i]) for i in range(len(dfa)): – Shawn Jamal Feb 05 '23 at 19:59
`for k, subdf in dfa.groupby('ID'): print(subdf)` – mozway Feb 05 '23 at 21:29

Create mutliple dataframes from list of dictonaries

0 Answers0