Extract varying levels of nested key value pairs from dictionary

Question

I'm having difficulty with extracting the different levels of key value pairs. Thanks for any support.

Dictionary is as follows:

print(data)
{'plrNum': '29221', 
 'plrName': {'last': 'Simpson', 'first': 'Webb', 'middle': '', 'nickname': ''}, 
 'statValues': {'rndEvents': '8', 'statValue1': '1,660', 'statValue2': '2', 'statValue3': '6', 'statValue4': '', 'statValue5': ''}, 
 'curRank': '1', 
 'curRankTied': '', 
 'prevRank': '1', 
 'prevRankTied': ''}

Desired output into dataframe:

 'plrNum', '29221'
 'last', 'Simpson'
 'first', 'Webb'
 'rndEvents', '8'
 'statValue1', '1,660'
 ...
 'curRank', '1'

Currently, I can pull the highest level with the below:

 df = pd.DataFrame.from_dict(data,orient='Index')
 df

 plrNum                                                    29221
 plrName       {'last': 'Simpson', 'first': 'Webb', 'middle':...
 statValues    {'rndEvents': '8', 'statValue1': '1,660', 'sta...
 curRank                                                       1
 curRankTied                                                    
 prevRank                                                      1
 prevRankTied

Does this answer your question? [python pandas flatten a dataframe to a list](https://stackoverflow.com/questions/25440008/python-pandas-flatten-a-dataframe-to-a-list) — Luke Storry, Jul 09 '20 at 13:55
I believe your thread @Ric S is most similar to my situation, thank you — sousvidesteak, Jul 09 '20 at 14:05
@Luke Storry thank you for the reference but the varying levels of pairs is a differentiator I think — sousvidesteak, Jul 09 '20 at 14:06

Extract varying levels of nested key value pairs from dictionary

0 Answers0