Splitting JSON python string

Question

I was wondering how I could go about splitting this json into 3 different movie types in order for me to better retrieve each movies rating and then return a list, showing them from highest to lowest rating. I have tried pythons split("}") but then I got an error saying it's no longer a json object and should not be a list when I am trying to perform my other operations such convertToJSON() function. This also didn't work well to split the movies correctly

import json

def convertToJSON(movieData):
    return json.loads(movieData)

#JSON string python object

Data = """[{ "title": “Spider-Man Homecoming”, 

“Studio: “Marvel”, “Rating”: 98, “videoType: “Movie" },

{ "title": “Avengers Endgame”, 
“Studio: “Marvel”, “Rating”: 90, “videoType: “Movie" },

{ "title": “Godzilla vs  Kong”, 
“Studio: “
    Warner Bros. Pictures”, “Rating”: 89, “videoType: “Movie" }]”””

I am trying to split to return somehow a list like this:

'Spider-Man Homecoming': 98
'Avengers Endgame': 90
'Godilla vs Kong': 89

Woodford · Accepted Answer · 2021-05-27 17:44:25Z

Data is a json string consisting of a list of dictionaries. Simply breaking it up into substrings results in invalid json and produces the error you described. The simplest solution would be to decode the entire json string up front and then get the information you want from the result list of dicts:

>>> Data = """
[{ "title": "Spider-Man Homecoming", 
"Studio": "Marvel", "Rating": 98, "videoType": "Movie" },

{ "title": "Avengers Endgame", 
"Studio": "Marvel", "Rating": 90, "videoType": "Movie" },

{ "title": "Godzilla vs  Kong", 
"Studio": "Warner Bros. Pictures", "Rating": 89, "videoType": "Movie" }]
"""
>>> import json
>>> movies = json.loads(Data)
>>> movies
[{'title': 'Spider-Man Homecoming',
  'Studio': 'Marvel',
  'Rating': 98,
  'videoType': 'Movie'},
 {'title': 'Avengers Endgame',
  'Studio': 'Marvel',
  'Rating': 90,
  'videoType': 'Movie'},
 {'title': 'Godzilla vs  Kong',
  'Studio': 'Warner Bros. Pictures',
  'Rating': 89,
  'videoType': 'Movie'}]

>>> {m['title']: m['Rating'] for m in movies}
{'Spider-Man Homecoming': 98, 'Avengers Endgame': 90, 'Godzilla vs  Kong': 89}

(Note the Data string in your post contains typos and non-ASCII quotation marks.)

Ole · Accepted Answer · 2021-05-27 17:44:38Z

3

Not really sure whats wrong with your JSON data, but I tried to prettify it a bit, this might not be what you're looking for, but it gets the job done :)

import json

Data = '''[{ "title": "Spider-Man Homecoming",

"Studio": "Marvel", "Rating": 98, "videoType": "Movie" },

{ "title": "Avengers Endgame",
"Studio": "Marvel", "Rating": 90, "videoType": "Movie" },

{ "title": "Godzilla vs  Kong",
"Studio": "Warner Bros. Pictures", "Rating": 89, "videoType": "Movie" }]'''


movies = json.loads(Data)

ratings = {m['title']: m['Rating'] for m in movies}

print(ratings)

answered May 27, 2021 at 17:44

Ole

1,38212 silver badges22 bronze badges

1 Comment

Krellex Over a year ago

Thanks for getting back! This is very much what I was looking for thanks! If I wanted to retrieve the actual rating value and add a value to it, how would I go about doing this? For example I retrieved 89 rating for Godzilla and I wanted to add 4 so the rating is now 93. How would I do this?

rowBee · Accepted Answer · 2021-05-27 17:28:48Z

1

At most you could make a dict out of it.
with json.loads()
And you can then print the dictionary the way you wanted it down there.
A list would not work because it can only be [value, value, value]

answered May 27, 2021 at 17:28

rowBee

611 silver badge5 bronze badges

Comments

FabianClemenz · Accepted Answer · 2021-05-27 17:45:13Z

As the previous poster suggests, it would be good loading it with json.loads() and then iterating over it with something like

for movie in json.loads(Data):
   [...]

you can then access it with movie['title'] and build your list

PS: your posted json data has some problems when i tried it on https://jsonlint.com

bit prettier here:

Data = """[{
        "title": "Spider - Man Homecoming",
        "Studio": "Marvel",
        "Rating": 98,
        "videoType": "Movie"
    },
    {
        "title": "Avengers Endgame",
        "Studio": "Marvel",
        "Rating": 90,
        "videoType": "Movie"
    },

    {
        "title": "Godzilla vs Kong",
        "Studio": "Warner Bros.Pictures",
        "Rating": 89,
        "videoType": "Movie"
    }
]"""

Collectives™ on Stack Overflow

Splitting JSON python string

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related