Is it possible to rename a json key name using its value in Python?

Question

I have this nested json dictionary and I want to rename the key name 'Keys' with its equivalent value using Python. I wonder if this is possible?

Current - 'Keys': ['AWS Backup'] I want it to be - 'AWS Backup': ['AWS Backup']

Sample json dictionary {'TimePeriod': {'Start': '2022-11-28', 'End': '2022-11-29'}, 'Total': {}, 'Groups': [{'Keys': ['AWS Backup'], 'Metrics': {'UnblendedCost': {'Amount': '0.000000111', 'Unit': 'USD'}}}, {'Keys': ['AWS Direct Connect'], 'Metrics': {'UnblendedCost': {'Amount': '0.0000111', 'Unit': 'USD'}}}, {'Keys': ['AWS Key Management Service'], 'Metrics': {'UnblendedCost': {'Amount': '0.000000111', 'Unit': 'USD'}}}

Tried do flatten the json but after doing it still no luck. I'm not sure if I can do it using pandas dataframe also? Plan to save that json also in a csv file.

Juan · Accepted Answer · 2022-12-07 00:42:15Z

0

I think it is best if you follow the same method as the answer here, you cannot rename it, but you can copy the data to a new key and get rid of the old one

d = {'old_name': 1}
d['new_name'] = d.pop('old_name')

Python Edit/Rename Key Names in .json

answered Dec 7, 2022 at 0:42

Juan

1176 bronze badges

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

Collectives™ on Stack Overflow

Is it possible to rename a json key name using its value in Python?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related