Parse Key and Value Field using Python Json file

Viewed 19

Im given a JSON file like so:

[{
           "ANIMAL_NAME FOOD HOUSENAME": "Jack Cat Chewy Food Owners House"
   
   },
{
           "ANIMAL_NAME FOOD HOUSENAME": "Harry Parrot Bird Chewy Food Good A Owners House"
   
   },
   {
           "ANIMAL_NAME FOOD HOUSENAME": "Fred Dog Dog Fun Steak Rack Dog"
     },
  {
           "ANIMAL_NAME FOOD HOUSENAME": "Fred Dog Dog Some Kind of Food Some Kind of House"
     }]

I would like the json to look like so

    [{
           "ANIMAL_NAME": "Jack Cat" 
            "FOOD": "Chewy Food"
            "HOUSENAME": "Owners House"
   
   },

    {       "ANIMAL_NAME": "Harry Parrot Bird" 
            "FOOD": "Chewy Food Good"
            "HOUSENAME": "A Owners House"
   
   },
   {
            "ANIMAL_NAME": "Fred Dog Dog" 
            "FOOD": "Fun Steak Rack"
            "HOUSENAME": "Dog"
     },
  {
            "ANIMAL_NAME": "Fred Dog Dog" 
            "FOOD": "Some Kind of Food"
            "HOUSENAME": "Some Kind of Food Some Kind of House"
     }]

I am not sure how to go about this as the data is unpredictable. I would like to parse these the keys and the values. Here is my code so far

with open('data.json') as file:
data= json.load(file)
for i, fact in enumerate(data['ANIMAL_NAME FOOD HOUSENAME'], 1):
0 Answers
Related