how to filter json array in python

Question

That is the current json array I have. I want get all json objects that type=1

before filter:

[ 
        {
            "type": 1
            "name" : "name 1",
        }, 
        {
            "type": 2
            "name" : "name 2",
        }, 
        {
            "type": 1
            "name" : "name 3"
        }, 
]

after filter:

[ 
        {
            "type": 1
            "name" : "name 1",
        }, 
        {
            "type": 1
            "name" : "name 3"
        }, 
]

please help.

turn it into the object it represents, delete the item, turn it back into json — Paul Collingwood
– Paul Collingwood, Commented Nov 28, 2014 at 13:37
It looks like you want us to write some code for you. While many users are willing to produce code for a coder in distress, they usually only help when the poster has already tried to solve the problem on their own. A good way to demonstrate this effort is to include the code you've written so far, example input (if there is any), the expected output, and the output you actually get (console output, stack traces, compiler errors - whatever is applicable). The more detail you provide, the more answers you are likely to receive. — Martijn Pieters
– Martijn Pieters, Commented Nov 28, 2014 at 13:38

Joaquin Sargiotto · Accepted Answer · 2014-11-28 14:00:57Z

88

The following snippet of code does exactly what you want, but BEWARE that your input (as written in the question) is not a valid json string, you can check here: http://jsonlint.com.

import json

input_json = """
[
    {
        "type": "1",
        "name": "name 1"
    },
    {
        "type": "2",
        "name": "name 2"
    },
    {
        "type": "1",
        "name": "name 3"
    }
]"""

# Transform json input to python objects
input_dict = json.loads(input_json)

# Filter python objects with list comprehensions
output_dict = [x for x in input_dict if x['type'] == '1']

# Transform python object back into json
output_json = json.dumps(output_dict)

# Show json
print output_json

answered Nov 28, 2014 at 14:00

Joaquin Sargiotto

1,76613 silver badges12 bronze badges

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

2 Comments

PirateApp Over a year ago

instead of loading everything and then filtering it, cant you supply a function for object_hook and filter it inside that method?

mlenthusiast Over a year ago

Is there a way to do this with a nested JSON string?

Andy Ecca · Accepted Answer · 2014-11-28 13:57:53Z

18

Simply

print [obj for obj in dict if(obj['type'] == 1)]

Example Link.

answered Nov 28, 2014 at 13:57

Andy Ecca

1,98914 silver badges14 bronze badges

Comments

N N K Teja · Accepted Answer · 2021-03-25 18:15:09Z

14

The filter() method filters the given sequence with the help of a function that tests each element in the sequence to be true or not. Documentation for filter

>>> obj=[
...     {
...         "type": 1,
...         "name": "name 1"
...     },
...     {
...         "type": 2,
...         "name": "name 2"
...     },
...     {
...         "type": 1,
...         "name": "name 3"
...     }
... ]
>>> filter(lambda x: x['type'] == 1, obj)
<filter object at 0x7fd98805ca00>
>>> list(filter(lambda x: x['type'] == 1, obj))
[{'type': 1, 'name': 'name 1'}, {'type': 1, 'name': 'name 3'}]
>>> list(filter(lambda x: x['type'] == 2, obj))
[{'type': 2, 'name': 'name 2'}]

answered Mar 25, 2021 at 18:15

N N K Teja

4474 silver badges9 bronze badges

Collectives™ on Stack Overflow

how to filter json array in python

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related