How to store a Dataframe in a Dictionary

Question

I have a Dataframe that extends column-wise by using a for-loop. now I want to store certain "stages" of the evolving DF somehow and I thought it would be the best to use a Dictionary.

to give you a picture:

df_dict={}
for i in range(1,13):
    df=pd.read_csv('./test.csv').iloc[:,0:i*4-1]

so I want to store this as "first stage" of the df:

col1     col2     col3     col4
  1        3        5        7
  2        4        6        8

in the "second stage":

col1     col2     col3     col4     col5     col6     col7     col8
  1        3        5        7        9        11       13       15
  2        4        6        8        10       12       14       16

3rd stage contains 12 cols:

col1     col2     col3     col4     col5     col6     col7     col8     ...
  1        3        5        7        9        11       13       15     ...
  2        4        6        8        10       12       14       16     ...

Ongoing till the 12th stage contains 48 cols.

So in general I want to store in the Dict these stages where every new stage has 4 more columns. And I need to be able to use these different Dataframes seperatly later.

I know that

df_dict.update({i, df})

doesn't work since DFs are mutable, but I did not manage to find a way to work around it.

I'm new to Python so please by gentle with me. Cheers!

EDIT: I wasn't searching the Idea of how to get variable variables since I allready mentioned that I want to use a Dict, but I was looking for a way of storing my Dataframe in a Dict.

How I understand you want to add this dataFrame into dict, so you can transform your datafreame into dict with this df.to_dict(), and after that update your dict. — Carp-Bezverhnii Maxim, Sep 26 '19 at 15:06
Possible duplicate of [How do I create a variable number of variables?](https://stackoverflow.com/questions/1373164/how-do-i-create-a-variable-number-of-variables) — G. Anderson, Sep 26 '19 at 15:08

jezrael · Accepted Answer · 2019-09-27T06:20:16.290

5

I believe you need to assign each DataFrame in loop:

df_dict={}
for i in range(1,13):
    df=pd.read_csv('./test.csv').iloc[:,0:i*4-1]
    df_dict[i] = df

Another solution is use dictionary comprehension:

df_dict = {i: pd.read_csv('./test.csv').iloc[:,0:i*4-1] for i in range(1,13)}

edited Sep 27 '19 at 06:20

answered Sep 27 '19 at 06:09

jezrael

822,522
95
1,334
1,252

How to store a Dataframe in a Dictionary

1 Answers1