How to remove json element with empty quotes?

Question

In the python3 code below I read all the objects in the json then loop through the elements in the json. If I only search for the id is not None that element and the null value are removed. However when I add the or statement to remove the id is not "" the entire file is printed with neither of the id in the or statement removed. Being new to python I am not sure what I am doing wrong. Thank you :).

file

{
"objects": [
    {
        "version": "1",
        "list": [
            {
                "
                    "json": null
                },
                "id": "",
            }
        ],
        "h": "na"
    },
{
        "version": "1",
        "list": [
            {
                "
                    "json": null
                },
                "id": "This has text in it and should be printed",
            }
        ],
        "h": "na"
    },
{
        "version": "1",
        "list": [
            {
                "
                    "json": null
                },
                "id": null,
            }
        ],
        "h": "na"
    }
]
}

desired

{
        "version": "1",
        "list": [
            {
                "
                    "json": null
                },
                "id": "This has text in it and should be printed",
            }
        ],
        "h": "na"
    },

python3

if v["id"] is not None or v['id'] is not "":

Also tried the below and id were changed:

for obj in data['objects']:
if obj.get('id') is "":
    obj['description'] = 'na'

You want __`and`__ not __`or`__. Or `if v["id"] not in (None, "")` — Pranav Hosangadi, Feb 03 '23 at 21:47
Also this is relevant to your usage of `is` to check string equality: https://stackoverflow.com/a/17680240/843953 — Pranav Hosangadi, Feb 03 '23 at 21:51
The JSON in the question is not valid syntax at all; it does not parse. — Charles Duffy, Feb 03 '23 at 21:56

score 1 · Accepted Answer · answered Feb 03 '23 at 21:50

1

if v["id"] is not None or v['id'] is not "":

No matter what the value is, this statement will always be true.

If the value is None, then the is not "" part will be true.

If the value is an empty string, then the is not None part will be true.

And if the value is anything else, then both parts will be true.

As @Pranav commented, you want to use and here, not or.

answered Feb 03 '23 at 21:50

John Gordon

29,573
7
33
58

Thank you very much, I appreciate the explanation as I am learning :). – justaguy Feb 03 '23 at 21:54

How to remove json element with empty quotes?

1 Answers1