How to parse a list of dictionaries in Python 3

Question

I'm using python(requests) to query an API. The JSON response is list of dictionaries, like below:

locationDescriptions = timeseries.publish.get('/GetLocationDescriptionList')['LocationDescriptions']


print(locationDescriptions[0])

{'Name': 'Test',
 'Identifier': '000045',
 'UniqueId': '3434jdfsiu3hk34uh8',
 'IsExternalLocation': False,
 'PrimaryFolder': 'All Locations',
 'SecondaryFolders': [],
 'LastModified': '2021-02-09T06:01:25.0446910+00:00',}

I'd like to extract 1 field (Identifier) as a list for further analysis (count, min, max, etc.) but I'm having a hard time figuring out how to do this.

Have you tried locationDescriptions[0]['Identifier'] ?

Tony Suffolk 66
– Tony Suffolk 66

2021-04-26 21:04:27 +00:00
Commented Apr 26, 2021 at 21:04 — Tony Suffolk 66
– Tony Suffolk 66, Commented Apr 26, 2021 at 21:04

alumarcu · Accepted Answer · 2021-04-26 21:05:38Z

1

Python has a syntax feature called "list comprehensions", and you can do something like:

identifiers = [item['Identifier'] for item in locationDescriptions]

Here is a small article that gives you more details, and also shows an alternate way using map. And here is one of the many resources detailing list comprehensions, should you need it.

answered Apr 26, 2021 at 21:05

alumarcu

1316 bronze badges

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

Comments

msanford · Accepted Answer · 2021-04-26 21:05:19Z

1

You could extract them with a list comprehension:

identifiers = [i['Identifier'] for i in locationDescriptions]

You allude to needing a list of numbers (count, min, max, etc...), in which case:

identifiers = [int(i['Identifier']) for i in locationDescriptions]

answered Apr 26, 2021 at 21:05

msanford

12.4k13 gold badges73 silver badges100 bronze badges

Comments

Tony Suffolk 66 · Accepted Answer · 2021-04-26 21:07:29Z

1

You can do

ids = [locationDescription['Identifier'] for locationDescription in locationDescriptions]

You will have a list of identifiers as a string.

Best regards

edited Apr 26, 2021 at 21:07

Tony Suffolk 66

9,7723 gold badges32 silver badges37 bronze badges

answered Apr 26, 2021 at 21:05

TOTO

3071 silver badge6 bronze badges

Collectives™ on Stack Overflow

How to parse a list of dictionaries in Python 3

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related