How to Read Nested Json file in PandasSql

Question

I used to have a simple row and column format in table and was reading it by pandassql .

but if you have structure like below and want to get age>10 from this , how do I get it using pandassql?

  [  {
    "response":{
      "version":"1.1",
      "token":"dsfgf",
       "body":{
         "customer":{
             "customer_id":"1234567",
             "verified":"true"
           },
         "contact":{
             "email":"[email protected]",
             "mobile_number":"0123456789"
          },
         "personal":{
             "gender": "m",
             "title":"Dr.",
             "last_name":"Muster",
             "first_name":"Max",
             "family_status":"single",
             "dob":"1985-12-23",
         }
       }
     } ]

there is an error with the json. need to remove the first bracket. — darren
– darren, Commented May 27, 2021 at 22:42

darren · Accepted Answer · 2021-05-27 22:55:57Z

0

This is answered here:

Pandas read nested json

You can use json_normalize

There is also a full description of the dame issue here:

https://medium.com/swlh/converting-nested-json-structures-to-pandas-dataframes-e8106c59976e

answered May 27, 2021 at 22:55

darren

6,0818 gold badges42 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

How to Read Nested Json file in PandasSql

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related