How to convert dataframe into dictionary python

Question

I have a dataframe that looks like

Total_Time_words    Words
0      1.50         your
1      2.15         intention
2      2.75         is
3      3.40         dangerous
4      3.85         for

when I use this code:

new.set_index('Words').T.to_dict('records')

I get this output below:

[{'your': 1.5,
  'intention': 2.15,
  'is': 2.75,
  'dangerous': 3.4,
  'for': 3.85,
  'my': 4.0,
  'world': 4.3}]

But this is my expected output below:

[
   {
      1.50:"your"
   },
   
   {
      2.15:"intention"
   }
]

dataframe, i want to convert the dataframe to ordinary dictionary {'your': 1.5}, { 'intention': 2.15} — nath
– nath, Commented Jul 30, 2020 at 5:58

Sociopath · Accepted Answer · 2020-07-30 05:58:48Z

1

You can use list comprehension with zip as below:

new_dict = [{k:v} for k,v in zip(df["Total_Time_words"], df["words"])]
print(new_dict)

answered Jul 30, 2020 at 5:58

Sociopath

13.4k22 gold badges53 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to convert dataframe into dictionary python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related