How to check JSON data in Python

Question

Data sample:

import pandas as pd

patients_df = pd.read_json('C:/MyWorks/Python/Anal/data_sample.json', orient="records", lines=True)

patients_df.head()

//in python



//my json data sample

  "data1": {
    "id": "myid",
    "seatbid": [
      {
        "bid": [
          {
            "id": "myid",
            "impid": "1",
            "price": 0.46328014,
            "adm": "adminfo",
            "adomain": [
              "domain.com"
            ],
            "iurl": "url.com",
            "cid": "111",
            "crid": "1111",
            "cat": [
              "CAT-0101"
            ],
            "w": 00,
            "h": 00
          }
        ],
        "seat": "27"
      }
    ],
    "cur": "USD"
  },

What I want to do is to check if there is a "cat" value in my very large JSON data. The "cat" value may/may not exist, but I'm trying to use Python Pandas to check it.

for seatbid in patients_df["win_res"]:

    for bid in seatbid["seatbid"]:

I tried to access JSON data while writing a loop like that, but it's not being accessed properly. I simply want to check if "cat" exist or not.

Learner · Accepted Answer · 2021-04-27 07:11:21Z

2

You can use python's json library as follows:

import json
patient_data = json.loads(patientJson)
if "cat" in student:
    print("Key exist in JSON data")
else
    print("Key doesn't exist in JSON data")

answered Apr 27, 2021 at 7:11

Learner

212 bronze badges

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

Collectives™ on Stack Overflow

How to check JSON data in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related