pandas df to python nested dict

Question

Assume I have df below:

df = pd.DataFrame({
    'A': ['a', 'b'],
    'B': [1, 2],
    'C': [3, 4]
})

How can I turn this into a nested dict of the format:

{'a': {'B': 1, 'C': 2}, 'b': {'B': 3, 'C': 4}}

I've tried df.to_dict() which doesn't return the format I'm after.

Thanks!

BENY · Accepted Answer · 2020-06-24 13:42:27Z

3

Try set_index

df.set_index('A').to_dict('index')
Out[8]: {'a': {'B': 1, 'C': 3}, 'b': {'B': 2, 'C': 4}}

answered Jun 24, 2020 at 13:42

BENY

324k22 gold badges176 silver badges250 bronze badges

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

1 Comment

This is like watching a gun fight in those old spaghetti westerns.

Quang Hoang · Accepted Answer · 2020-06-24 13:42:33Z

1

You can set A as index and use to_dict:

df.set_index('A').to_dict('i')
# {'a': {'B': 1, 'C': 3}, 'b': {'B': 2, 'C': 4}}

answered Jun 24, 2020 at 13:42

Quang Hoang

151k11 gold badges64 silver badges86 bronze badges