title: Nested JSON Array to Python Pandas DataFrame
body: <p>I'm trying to expand nested json array in pandas dataframe.</p>
  
  <p>That's the JSON I have:</p>
  
  <pre><code>[ {
          "id": "0001",
          "name": "Stiven",
          "location": [{
                  "country": "Colombia",
                  "department": "Chocó",
                  "city": "Quibdó"
              }, {
                  "country": "Colombia",
                  "department": "Antioquia",
                  "city": "Medellin"
              }, {
                  "country": "Colombia",
                  "department": "Cundinamarca",
                  "city": "Bogotá"
              }
          ]
      }, {
          "id": "0002",
          "name": "Jhon Jaime",
          "location": [{
                  "country": "Colombia",
                  "department": "Valle del Cauca",
                  "city": "Cali"
              }, {
                  "country": "Colombia",
                  "department": "Putumayo",
                  "city": "Mocoa"
              }, {
                  "country": "Colombia",
                  "department": "Arauca",
                  "city": "Arauca"
              }
          ]
      }, {
          "id": "0003",
          "name": "Francisco",
          "location": [{
                  "country": "Colombia",
                  "department": "Atlántico",
                  "city": "Barranquilla"
              }, {
                  "country": "Colombia",
                  "department": "Bolívar",
                  "city": "Cartagena"
              }, {
                  "country": "Colombia",
                  "department": "La Guajira",
                  "city": "Riohacha"
              }
          ]
      }
  ]
  </code></pre>
  
  <p>That's the dataframe I have:</p>
  
  <pre class="lang-py prettyprint-override"><code>index   id    name         location
  0       0001  Stiven       [{'country':'Colombia', 'department': 'Chocó', 'city': 'Quibdó'}, {'country':'Colombia', 'department': 'Antioquia', 'city': 'Medellin'}, {'country':'Colombia', 'department': 'Cundinamarca', 'city': 'Bogotá'}]
  1       0002  Jhon Jaime   [{'country':'Colombia', 'department': 'Valle del Cauca', 'city': 'Cali'}, {'country':'Colombia', 'department': 'Putumayo', 'city': 'Mocoa'}, {'country':'Colombia', 'department': 'Arauca', 'city': 'Arauca'}]
  2       0003  Francisco    [{'country':'Colombia', 'department': 'Atlántico', 'city': 'Barranquilla'}, {'country':'Colombia', 'department': 'Bolívar', 'city': 'Cartagena'}, {'country':'Colombia', 'department': 'La Guajira', 'city': 'Riohacha'}] 
  </code></pre>
  
  <p>I need to convert to dataframe per id something like this:</p>
  
  <pre class="lang-py prettyprint-override"><code>index   id    name         country   department       city
  0       0001  Stiven       Colombia  Chocó            Quibdó
  1       0001  Stiven       Colombia  Antioquia        Medellin
  2       0001  Stiven       Colombia  Cundinamarca     Bogotá
  3       0002  Jhon Jaime   Colombia  Valle del Cauca  Cali
  4       0002  Jhon Jaime   Colombia  Putumayo         Mocoa
  5       0002  Jhon Jaime   Colombia  Arauca           Arauca
  6       0003  Francisco    Colombia  Atlántico        Barranquilla
  7       0003  Francisco    Colombia  Bolívar          Cartagena 
  8       0003  Francisco    Colombia  La Guajira       Riohacha   
  </code></pre>
  
  <p>Thanks in advance.</p>