Get a list of keys and values in a nested dictionary oriented by index

Viewed 705

I have an Excel file with a structure like this:

name age status
anna 35 single
petr 27 married

I have converted such a file into a nested dictionary with a structure like this:

{'anna': {'age':35}, {'status': 'single'}},
{'petr': {'age':27}, {'status': 'married'}}

using pandas:

import pandas as pd
df = pd.read_excel('path/to/file')
df.set_index('name',  inplace=True)
print(df.to_dict(orient='index'))

But now when running list(df.keys()) it returns me a list of all keys in the dictionary ('age', 'status', etc) but not 'name'.

My eventual goal is that it returns me all the keys and values by typing a name.

Is it possible somehow? Or maybe I should use some other way to import a data in order to achieve a goal? Eventually I should anyway come to a dictionary because I will merge it with other dictionaries by a key.

3 Answers
Related