How to transform index values into columns using Pandas?

Question

I have a dictionary like this:

my_dict = {'RuleSet': {'0': {'RuleSetID': '0',
   'RuleSetName': 'Allgemein',
   'Rules': [{'RulesID': '10',
     'RuleName': 'Gemeinde Seiten',
     'GroupHits': '2',
     'KeyWordGroups': ['100', '101', '102']}]},
  '1': {'RuleSetID': '1',
   'RuleSetName': 'Portale Berlin',
   'Rules': [{'RulesID': '11',
     'RuleName': 'Portale Berlin',
     'GroupHits': '4',
     'KeyWordGroups': ['100', '101', '102', '107']}]},
  '6': {'RuleSetID': '6',
   'RuleSetName': 'Zwangsvollstr. Berlin',
   'Rules': [{'RulesID': '23',
     'RuleName': 'Zwangsvollstr. Berlin',
     'GroupHits': '1',
     'KeyWordGroups': ['100', '101']}]}}}

When using this code snippet it can be transformed into a dataframe:

rules_pd = pd.DataFrame(my_dict['RuleSet'])
rules_pd

The result is:

I would like to make it look like this:

Does anyone know how to tackle this challenge?

pd.DataFrame(my_dict['RuleSet']) work for me

BENY
– BENY

2022-05-19 15:11:47 +00:00
Commented May 19, 2022 at 15:11 — BENY
– BENY, Commented May 19, 2022 at 15:11
I added the wrong dictionary data. I edited my post.

Daniel
– Daniel

2022-05-19 15:16:48 +00:00
Commented May 19, 2022 at 15:16 — Daniel
– Daniel, Commented May 19, 2022 at 15:16

BENY · Accepted Answer · 2022-05-19 15:26:54Z

1

Doing from_dict with index

out = pd.DataFrame.from_dict(my_dict['RuleSet'],'index')
Out[692]: 
  RuleSetID  ...                                              Rules
0         0  ...  [{'RulesID': '10', 'RuleName': 'Gemeinde Seite...
1         1  ...  [{'RulesID': '11', 'RuleName': 'Portale Berlin...
6         6  ...  [{'RulesID': '23', 'RuleName': 'Zwangsvollstr....
[3 rows x 3 columns]
#out.columns
#Out[693]: Index(['RuleSetID', 'RuleSetName', 'Rules'], dtype='object')

answered May 19, 2022 at 15:26

BENY

324k22 gold badges176 silver badges250 bronze badges

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

Comments

Diana Carolina Ttica Huanca · Accepted Answer · 2022-05-19 15:37:19Z

1

You could try use Transpose()

rules_pd = pd.DataFrame(my_dict['RuleSet']).transpose()
print(rules_pd)

answered May 19, 2022 at 15:37

Diana Carolina Ttica Huanca

362 bronze badges

Collectives™ on Stack Overflow

How to transform index values into columns using Pandas?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related