title: Pandas json_normalize with nested JSON
body: <p>I have tried many alternatives and the better result was with this statement:</p>
  
  <pre><code>json_normalize(a['solution'][0]['tour'])
  </code></pre>
  
  <p>I can see just one block of tours at a time. <strong>vehicle_id 0</strong> information and I need them all together. Thank you.</p>
  
  <p>The JSON is:</p>
  
  <pre><code>{
      "total_clusters": 6,
      "solution": [
          {
              "vehicles_id": "0",
              "vehicles_location": {
                  "lat": "",
                  "lng": ""
              },
              "tour": [
                  {
                      "shipping_id": "4a4b0750-63a7-11ea-8955-43fcb2cd860a",
                      "type": "dropoff",
                      "location_id": "797",
                      "coordinates": {
                          "lat": "-34.545736",
                          "lng": "-58.488340"
                      },
                      "cluster": 0
                  },
                  {
                      "shipping_id": "75e5a2c0-6314-11ea-b657-ddd473c629a3",
                      "type": "dropoff",
                      "location_id": "114",
                      "coordinates": {
                          "lat": "-34.568707",
                          "lng": "-58.452963"
                      },
                      "cluster": 0                 
                  }
              ]
          },
          {
              "vehicles_id": "1",
              "vehicles_location": {
                  "lat": "",
                  "lng": ""
              },
              "tour": [
                  {
                      "shipping_id": "c83ac7c0-51c4-11ea-9aef-973de7785221",
                      "type": "pickup",
                      "location_id": "687",
                      "coordinates": {
                          "lat": "-34.592824",
                          "lng": "-58.375457"
                      },
                      "cluster": 1
                  },
                  {
                      "shipping_id": "b5a295c0-51c4-11ea-b36d-651ee769ca89",
                      "type": "pickup",
                      "location_id": "687",
                      "coordinates": {
                          "lat": "-34.592824",
                          "lng": "-58.375457"
                      },
                      "cluster": 1            
                  }
              ]
          }
      ]
  }
  </code></pre>
  
  <p>Desired Output
  <a href="https://i.stack.imgur.com/0r3mQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0r3mQ.png" alt="enter image description here"></a></p>