Is there a way to name a new data frame given i from a for loop?

Question

I hope the question is clear enough. I have one giant data set (30 mil+) and would like to split it up into 8 smaller ones.

Is there a way to name a data frame based on the i in the for loop?

So for example if I have a list with lst = ['machine_1', 'machine_2', 'machine_3'] and I would like to create dataframes for each of these, is it possible to get them so that the data frames are called df_machine_1, df_machine_2 and df_machine_3?

Something like:

lst = ['machine_1', 'machine_2', 'machine_3']

for i in lst:
    df_i = df[df['Machines'] == i]]

I know that this doesn't work, but is there another solution?

this may help : https://stackoverflow.com/questions/58055458/export-csv-with-dynamic-file-name — Othmane Messaoud, May 26 '22 at 13:45
Not really to be hones, but I do see that it seems like a bad idea so I will do it manually. Thanks for the speedy reply — GT1992, May 26 '22 at 13:49

Celius Stingher · Answer 1 · 2022-05-26T22:08:57.793

0

You could also consider making a dictionary with dict comprehension:

dfs = {i:df[df['Machines']==i] for i in lst}

And call them via their key, for example: dfs['machine_1']

edited May 26 '22 at 22:08

answered May 26 '22 at 13:47

Celius Stingher

17,835
6
23
53

1

It misses a "]" after the "==i" ;) – Drakax May 26 '22 at 18:00

Is there a way to name a new data frame given i from a for loop?

1 Answers1