How to get multiple data from json list in python

Question

I'm new to python

I'm attempting to use the Hans volcano api to produce a map (https://volcanoes.usgs.gov/hans2/apiv2/volcanoApi/allWithNotice)

When printing my URL as json I am presented with many volcanoes in this format

[{'obsAbbr': 'avo', 'volcCd': 'ak6', 'volcName': 'Akutan', 'volcUrl': 'https://avo.alaska.edu/volcanoes/volcinfo.php?volcname=Akutan', 'vnum': '311320', 'imgUrl': 'https://avo.alaska.edu/images/dbimages/display/1108076476_60_3.jpg', 'threat': 'Very High Threat'},

From this I'm looking to extract volcano names. When making my dictionary I'm given one volcano only. I'm looking to obtain all the volcano names from this json file.

v = requests.get(url2.format()).json()

volcano = {
    'name' : v[0]['volcName'],
}

Any help would be appreciated, cheers

volcano = { 'name' : [d['volcName'] for d in v]}? You'll have to loop through v. Where you assign it depends on what format you want it in. — Axe319
– Axe319, Commented Oct 7, 2022 at 20:31
What is your desired output? A list of dicts where each have a name attribute? (like this [{'name':'Akutan'},{'name':'Aniakchak'},...]); or only 1 dict where the value for name is a list of names? (like this {'name':['Akutan','Aniakchak',...]}) — Rodrigo Rodrigues
– Rodrigo Rodrigues, Commented Oct 7, 2022 at 20:44

Tom McLean · Accepted Answer · 2022-10-07 21:31:57Z

1

I wouldn't keep it as a list of dictionaries, just use a dictionary:

volcano_threats = {x['volcName']: x['threat'] for x in v}

Output:

{'Akutan': 'Very High Threat',
 'Alaskan Volcanoes': None,
 'Aniakchak': 'High Threat',
 'Atka volcanic complex': 'High Threat',
...
}

Or to keep all the data:

volcanos = {x['volcName']: x for x in v}

answered Oct 7, 2022 at 21:31

Tom McLean

6,6332 gold badges23 silver badges52 bronze badges

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

Comments

Rahul K P · Accepted Answer · 2022-10-07 21:05:35Z

1

You could do like this,

v = requests.get(url2.format()).json()
print([i['volcName'] for i in v])

Results

['Akutan', 'Alaskan Volcanoes', 'Aniakchak', 'Atka volcanic complex', 'Augustine', 'Bogoslof', 'Cleveland', 'Davidof', 'Dutton', 'Edgecumbe', 'Fourpeaked', 'Frosty', 'Gareloi', 'Great Sitkin', 'Griggs', 'Iliamna', 'Kanaga', 'Kasatochi', 'Katmai', 'Korovin', 'Little Sitkin', 'Mageik', 'Makushin', 'Martin', 'Novarupta', 'Okmok', 'Pavlof', 'Redoubt', 'Sanford', 'Semisopochnoi', 'Shishaldin', 'Snowy Mountain', 'Spurr', 'Takawangha', 'Tanaga', 'Trident', 'Ugashik-Peulik', 'Ukinrek Maars', 'Veniaminof', 'Westdahl', 'Wrangell', 'Coso Volcanic Field', 'Lassen Volcanic Center', 'Long Valley Caldera', 'Cascade Range', 'Mount Hood', 'Mount St. Helens', 'Newberry', 'Three Sisters', 'Haleakala', 'Hualalai', "Kama'ehuakanaloa", 'Kilauea', 'Mauna Kea', 'Mauna Loa', 'Ofu-Olosega', "Ta'u Island", 'Tutuila Island', 'Agrigan', 'Ahyi Seamount', 'Anatahan', 'Pagan', 'Sarigan', 'Yellowstone']

Edit

If you have more data to fetch,

[{'name':i['volcName'], 'threat':i['threat']} for i in v]

# result
[{'name': 'Akutan', 'threat': 'Very High Threat'},
 {'name': 'Alaskan Volcanoes', 'threat': None},
 {'name': 'Aniakchak', 'threat': 'High Threat'},
 {'name': 'Atka volcanic complex', 'threat': 'High Threat'},
 {'name': 'Augustine', 'threat': 'Very High Threat'},
....

edited Oct 7, 2022 at 21:05

answered Oct 7, 2022 at 20:37

Rahul K P

16.2k4 gold badges40 silver badges56 bronze badges

1 Comment

Harry BM Over a year ago

Thanks, this works for obtaining all the names. How could I put this into a dictionary with another attribute such as 'threat'?

Rodrigo Rodrigues · Accepted Answer · 2022-10-07 21:18:30Z

0

You can iterate over your data and generate a list with remapped dicts, all easily with a list comprehension syntax. Like this:

v = requests.get(url2.format()).json()
volcanoes = [dict(name=x['volcName'], threat=x['threat']) for x in v]

# [{'name': 'Akutan', 'threat': 'Very High Threat'},
#  {'name': 'Alaskan Volcanoes', 'threat': None},
#  {'name': 'Aniakchak', 'threat': 'High Threat'},
#  {'name': 'Atka volcanic complex', 'threat': 'High Threat'}, ...
# ]

answered Oct 7, 2022 at 21:18

Rodrigo Rodrigues

8,6321 gold badge32 silver badges43 bronze badges

Collectives™ on Stack Overflow

How to get multiple data from json list in python

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related