Dictionary of dictionaries from data frame

Question

I have created a data frame from data got from database. I need to convert the data frame to dictionary with format mentioned below.

{ 0 : {'column1': 'value', 'column2' : 'value',....},
1 : {'column1': 'value', 'column2' : 'value',....},....

I tried

data_list = [tuple(r) for r in data_df.to_numpy().tolist()]#convert df to list of tuples

data_dict = [dict(zip(ag_titles, x)) for x in data_list]
data_final = {i:{k:v for k,v in dict(data_dict).items}for i in range(len(data_dict))}

But I am not getting the expected output. How can this be done with dictionary comprehension?

What's the format of the input and wanted output? – Y.R. Sep 22 '21 at 06:40 — Y.R., Sep 22 '21 at 06:40

score 0 · Answer 1 · edited Sep 22 '21 at 06:51

0

You can try-

b = data_df.to_dict(orient='index')

edited Sep 22 '21 at 06:51

Dharman

30,962
25
85
135

answered Sep 22 '21 at 06:45

Sarthak Sinha

21
3

I want to display another list as index. Is that possible? – Sriram Sep 22 '21 at 09:19

Dictionary of dictionaries from data frame

1 Answers1