How to put JSON values into a list Python

Question

I have a json list that looks like this:

{
    "callback": [{
            "id": "R_puFk4fZ8m1lE4bD",
            "set": "Default Response Set",
            "ace": "asdf",
            "date": "asdfdsa",
            "1": "asdf",
            "2": "s",
            "3": "3",
            "4": "1",
            "zone": "0",
            "long": "33.564498901367",
            "lat": "-112.00869750977"
        }
    ]
}

My actual data has a lot of json objects within the list and I am wondering how I would put the numbers between "date" and "zone" in a separate list within the json. The numbers vary between the json objects, but they are always in between the "date" and "zone" values.

What would I do to transform it into this:

{
    "callback": [{
            "id": "R_puFk4fZ8m1lE4bD",
            "set": "Default Response Set",
            "ace": "asdf",
            "date": "asdfdsa",
            "Q": [
                "1": "asdf",
                "2": "s",
                "3": "3",
                "4": "1"
            ],
            "zone": "0",
            "long": "33.564498901367",
            "lat": "-112.00869750977"
        }
    ]
}

Note: Nothing is "always between 'date' and 'zone'" because that is equivalent to a Python dictionary and the ordering is not guaranteed. Are they the only keys that are numeric (represented as strings)? — roganjosh
– roganjosh, Commented Jul 18, 2017 at 18:40
@roganjosh Oh okay, thank you. They are keys represented as strings, but not all of the callbacks are numeric representations of strings, some are just strings. — j doe
– j doe, Commented Jul 18, 2017 at 18:43
ok... maybe you could go the other way round. Barring those keys that you want to capture, is the list of keys you don't want to capture always the same? — roganjosh
– roganjosh, Commented Jul 18, 2017 at 18:56
Are all the rest of the fields static and the dynamic fields are the ones you want to group? if key not in ["id", "set", "ace", "date", ..., "lat"]: — TemporalWolf
– TemporalWolf, Commented Jul 18, 2017 at 19:00
Good idea @TemporalWolf, although it'd be more efficient to use a set rather than a list. — PM 2Ring
– PM 2Ring, Commented Jul 18, 2017 at 19:02

TemporalWolf · Accepted Answer · 2017-07-18 19:18:31Z

2

You can sort them out via set membership (as PM 2Ring mentioned, set membership is faster O(1)):

def group_questions(source_dct):
    meta_tags = {"id", "set", "ace", "date", "zone", "long", "lat"}

    result_dct = {"Q": {}}
    for key in source_dct:
        if key not in meta_tags:
            result_dct["Q"][key] = source_dct[key]
        else:
            result_dct[key] = source_dct[key]
    return result_dct

Result (note dictionaries are not ordered):

>>> print group_questions(dct)
{'set': 'Default Response Set', 
 'ace': 'asdf', 
 'zone': '0', 
 'long': '33.564498901367', 
 'Q': {'1': 'asdf', 
       '3': '3', 
       '2': 's', 
       '4': '1'}, 
 'lat': '-112.00869750977', 
 'date': 'asdfdsa', 
 'id': 'R_puFk4fZ8m1lE4bD'}

answered Jul 18, 2017 at 19:18

TemporalWolf

8,0121 gold badge33 silver badges54 bronze badges

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

Comments

Sam Chats · Accepted Answer · 2017-07-18 18:50:09Z

1

Use the built-in int() function to check for integer keys:

new_list = []
for old_data in old_list: #old_list is the value of 'callback' key
    data = {'Q': {}}
    for key in old_data.keys():
        try:
            num = int(key)
            data['Q'][key] = old_data[key]
        except ValueError: # stringy keys
            data[key] = old_data[key]
    new_list.append(data)

Now, printing new_list using something like json.dumps() will give something like:

[
    {
        "Q": {
            "1": "asdf",
            "2": "s",
            "3": "3",
            "4": "1"
        },
        "id": "R_puFk4fZ8m1lE4bD",
        "set": "Default Response Set",
        "ace": "asdf",
        "date": "asdfdsa",
        "zone": "0",
        "long": "33.564498901367",
        "lat": "-112.00869750977"
    }
]

edited Jul 18, 2017 at 18:50

answered Jul 18, 2017 at 18:43

Sam Chats

2,3211 gold badge14 silver badges36 bronze badges

7 Comments

TemporalWolf Over a year ago

This assumes Q should contain all elements whose key is an int. This may or may not satisfy the OP.

Sam Chats Over a year ago

@TemporalWolf No it doesn't do that. Q has string keys. See my output.

j doe Over a year ago

Thank you for the response, but as TemporalWolf said not all of the keys that I need to capture are integers.

Sam Chats Over a year ago

@jdoe I'm sorry but do you mean that there are keys other that just "numbers" you want in Q?

Sam Chats Over a year ago

@jdoe Oh I understand your point. So you originally wanted to separate the keys which were being displayed between the date and zone keys.

|

Collectives™ on Stack Overflow

How to put JSON values into a list Python

2 Answers 2

Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related