Python3, iterate to JSON array without name

Question

I'm trying to iterate through this json array :

[{
    "date": "2018-02-21T12:53:00",
    "name": "System date",
    "ID_BBData": "none",
    "TOKEN_BBData": "none",
    "rawValue": 540916682
},
{
    "date": "2018-02-21T12:53:00",
    "name": "Temperature sensor 1",
    "ID_BBData": "none",
    "TOKEN_BBData": "none",
    "rawValue": 11
},
{
    "date": "2018-02-21T12:53:00",
    "name": "Value week",
    "ID_BBData": "none",
    "TOKEN_BBData": "none",
    "rawValue": 1810
}]

With this loop :

# print the keys and values
for key in jsonObject:
    value = jsonObject[key]
    print("The key and value are ({}) = ({})".format(key, value))

Where jsonObject is the json above. The problem is that the json is enclosed by [] but there isn't any name to this array.

Any clue to iterate through this one ?

Thanks a lot !

The name of "the [] JSON" is jsonObject, no? It's a list. Iterating over a list yields the individual list items, not the keys. — deceze
– deceze ♦, Commented Feb 21, 2018 at 13:00
If you want a clue : there's no such thing as a "json object" in Python. json is a text format, once parsed it yields the equivalent Python data types : lists for json arrays, dicts for json objects, etc. So what you have here is a Python list of Python dicts. Now you can learn how to iterate over a Python list and how to use a Python dict (both being required skills if you hope to do anything with Python). — bruno desthuilliers
– bruno desthuilliers, Commented Feb 21, 2018 at 13:05

ferdy · Accepted Answer · 2018-02-21 13:42:37Z

2

At first, you should understand that your object is a list of dictionaries. You can check this easily, if you put the data into a variable, say lst, and then check the types:

>>> lst
[{'date': '2018-02-21T12:53:00', 'name': 'Temperature sensor 1', 'ID_BBData': 'none', 'TOKEN_BBData': 'none', 'rawValue': 11}, {'date': '2018-02-21T12:53:00', 'name': 'Value week', 'ID_BBData': 'none', 'TOKEN_BBData': 'none', 'rawValue': 1810}]
>>> type(lst)  # the type of the whole datastructure
<class 'list'>

>>> type(lst[0])  # the type of the first element of the list
<class 'dict'>

If you understand, that you have such a structure, you can begin to think about looping through the items of the list, of which each is a dictionary:

>>> for lst_item in lst:
...     for key, value in lst_item.items():  # this is python3 specific
...         print('key: {} value: {}'.format(key, value))
... 
key: date value: 2018-02-21T12:53:00
key: name value: Temperature sensor 1
key: ID_BBData value: none
key: TOKEN_BBData value: none
key: rawValue value: 11
key: date value: 2018-02-21T12:53:00
key: name value: Value week
key: ID_BBData value: none
key: TOKEN_BBData value: none
key: rawValue value: 1810

If you want to iterate a dictionary in python2, use

for key, value in lst_item.iteritems():

instead.

edited Feb 21, 2018 at 13:42

answered Feb 21, 2018 at 13:37

ferdy

7,7244 gold badges39 silver badges50 bronze badges

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

1 Comment

chepner Over a year ago

You can/could use items in Python 2 as well; it just returned a concrete list rather than an iterator. It's iteritems that was renamed items in Python 3, and getting a list requires an explicit call to list like list(lst_item.items()).

ibt23sec5 · Accepted Answer · 2018-02-21 13:17:12Z

1

If you want to iterate over all list elements (as mentioned in comments, it's a list not a json object):

for line in jsonObject:
    for key, value in line.items():
        print("The key and value are ({}) = ({})".format(key, value))

answered Feb 21, 2018 at 13:17

ibt23sec5

4174 silver badges13 bronze badges

Comments

Kenly · Accepted Answer · 2023-06-06 13:52:39Z

1

First, convert the JSON array, then loop over it to get values as dictionaries.

data = json.loads(array)
    
for event in data:
    ...

edited Jun 6, 2023 at 13:52

answered Feb 21, 2018 at 14:26

Kenly

27k7 gold badges50 silver badges67 bronze badges

Collectives™ on Stack Overflow

Python3, iterate to JSON array without name

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related