Python - to_dict() creates unwanted nested dictionary

Question

Edit: the duplicate suggested was not able to resolve my issue as the indexed column is different from turning a normal df into a dict. Would appreciate it if the downvoter takes away the vote.

Very simple, I want to create a dictionary from a df, with the df indexes as keys, and a column called 'signal' as key-values. I've used the to_dict() method, however this produces a nested dictionary, rather than individual. Code:

df:

index             signal
james.mccallum    0
john.driscoe      1
...               ...
andrew.black      0

input:
score_dict = df.to_dict()

produces:
score_dict = {signal{james.mccallum: 0, john.driscoe: 1, ... andrew.black: 0}

desired:
score_dict = {james.mccallum: 0, john.driscoe: 1, ... andrew.black: 0}

I'm sure it's a simple fix, however have not been able to find anything related to what I want to do. Any help would be appreciated.

Possible duplicate of [Convert a Pandas DataFrame to a dictionary](https://stackoverflow.com/questions/26716616/convert-a-pandas-dataframe-to-a-dictionary) — scharette, Jul 19 '18 at 13:50

rafaelc · Accepted Answer · 2018-07-19T13:58:07.300

2

This is the intended behavior of to_dict (check this very good answer with inputs/outputs of the different possible args, followed with explanations on them).

In your case, just get all signal related values

>>> score_dict = df.to_dict()['signal']
{'james.mccallum': 0, 'john.driscoe': 1, 'andrew.black': 0}

edited Jul 19 '18 at 13:58

answered Jul 19 '18 at 13:54

rafaelc

57,686
15
58
82

1

Perfect, exactly what I wanted. I'll mark your answer as correct when the timer allows for it. Thanks and have a good day mate. – Laurie Jul 19 '18 at 13:56
@LaurieBamber glad I could help :) – rafaelc Jul 19 '18 at 14:06

Python - to_dict() creates unwanted nested dictionary

1 Answers1