Python - how to extract multiple Json files from Json list

Question

Have a json contain list of dictionaries as following:

[
  {
    "native_data": {
      "PopOrGuess": null,
      "role": "D",
      "TSX": "Included"
    },
    "id": "3dsdsa_a_12sss"
  },
  {
    "native_data": {
      "PopOrGuess": 123,
      "role": "A",
      "TSX": "NA"
    },
    "id": "12_123_saba"
  }
]

I need to extract this list and create new json file per element in list, so file_name will get the "id" value ,and the json content the first element in dict, meaning for first element "id": "12_123_saba" file name: 3dsdsa_a_12sss.json

{
    "native_data": {
      "PopOrGuess": null,
      "role": "D",
      "TSX": "Included"
    }
  }

I tried :

def ExtractJsonPrice( file ):
    jsonFile = open(file, "r") # Open the JSON file for reading
    try:
       json_data = json.load(jsonFile)
    except ValueError:
           print("error loading JSON")
           logging.error("Exception occurred", exc_info=True)
    
    for item in json_data:
        file_name = item['id']
        json_content = item['native_data']

and from there i have the file name , but the problem , the json_content holds now the content of the key of 'native_data' but it actually missing the KEY "native_data", I guess I could append it as post process but im sure there's more efficient way.

jedimasterbot · Accepted Answer · 2021-01-19 13:47:22Z

2

yes you are getting the key, you can do this,

json_content = {'native_data': item['native_data']}

answered Jan 19, 2021 at 13:47

jedimasterbot

2371 silver badge8 bronze badges

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

Comments

AviC · Accepted Answer · 2021-01-19 13:56:22Z

1

Found a way:

    
    for item in json_data:
        json_content = {}
        file_name = item['id']
        json_content["native_data"]= item['native_data'] 
        file_name = list(item.values())[1]
        
        with open('ID_' + file_name + '.json' , 'w') as fp:  
             json.dump(json_content,fp)

answered Jan 19, 2021 at 13:56

AviC

4242 gold badges7 silver badges19 bronze badges

Collectives™ on Stack Overflow

Python - how to extract multiple Json files from Json list

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