title: pandas json normalize not working as expected
body: <p>I'm using pandas json normalize to transform a json into a pandas dataframe. This is the json that's giving me problems:</p>
  <pre><code>    {
     &quot;P48PrecTer&quot;:{
        &quot;@xmlns&quot;:&quot;http://sujetos.esios.ree.es/schemas/2010/05/31/P48PrecTer-esios-MP/&quot;,
        &quot;IdSesion&quot;:&quot;16&quot;,
        &quot;SeriesTemporales&quot;:{
           &quot;IdentificacionSeriesTemporales&quot;:&quot;STP0&quot;,
           &quot;TipoNegocio&quot;:&quot;A10&quot;,
           &quot;UnidadPrecio&quot;:&quot;EUR:MWH&quot;,
           &quot;Periodo&quot;:[
              {
                 &quot;IntervaloTiempo&quot;:&quot;2020-07-12T00:00Z/2020-07-12T01:00Z&quot;,
                 &quot;Resolucion&quot;:&quot;PT60M&quot;,
                 &quot;Intervalo&quot;:{
                    &quot;Pos&quot;:&quot;1&quot;,
                    &quot;PrecioBaj&quot;:&quot;25.20&quot;
                 }
              },
              {
                 &quot;IntervaloTiempo&quot;:&quot;2020-07-12T03:00Z/2020-07-12T11:00Z&quot;,
                 &quot;Resolucion&quot;:&quot;PT60M&quot;,
                 &quot;Intervalo&quot;:[
                    {
                       &quot;Pos&quot;:&quot;1&quot;,
                       &quot;PrecioSub&quot;:&quot;27.36&quot;
                    },
                    {
                       &quot;Pos&quot;:&quot;2&quot;,
                       &quot;PrecioBaj&quot;:&quot;23.50&quot;
                    },
                    {
                       &quot;Pos&quot;:&quot;8&quot;,
                       &quot;PrecioBaj&quot;:&quot;16.90&quot;
                    }
                 ]
              },
              {
                 &quot;IntervaloTiempo&quot;:&quot;2020-07-12T12:00Z/2020-07-12T16:00Z&quot;,
                 &quot;Resolucion&quot;:&quot;PT60M&quot;,
                 &quot;Intervalo&quot;:[
                    {
                       &quot;Pos&quot;:&quot;1&quot;,
                       &quot;PrecioSub&quot;:&quot;29.90&quot;
                    },
                    {
                       &quot;Pos&quot;:&quot;4&quot;,
                       &quot;PrecioBaj&quot;:&quot;15.75&quot;
                    }
                 ]
              }
           ]
        }
     }
  }
  </code></pre>
  <p>I'm using this piece of code:</p>
  <pre><code>prueba=pd.json_normalize(body,record_path=['P48PrecTer','SeriesTemporales','Periodo','Intervalo'], meta=[['P48PrecTer','IdSesion'], ['P48PrecTer','SeriesTemporales','Periodo','IntervaloTiempo']])
  </code></pre>
  <p>I expect something with a csv structure. However, I get this:</p>
  <pre><code>0|P48PrecTer.IdSesion|P48PrecTer.SeriesTemporales.Periodo.IntervaloTiempo
  Pos|06|2020-07-12T22:00Z/2020-07-12T23:00Z
  PrecioBaj|06|2020-07-12T22:00Z/2020-07-12T23:00Z
  PrecioSub|06|2020-07-12T22:00Z/2020-07-12T23:00Z
  {'Pos': '1', 'PrecioBaj': '4.41', 'PrecioSub': 'null'}|06|2020-07-13T00:00Z/2020-07-13T03:00Z
  {'Pos': '2', 'PrecioBaj': '9.00', 'PrecioSub': 'null'}|06|2020-07-13T00:00Z/2020-07-13T03:00Z
  {'Pos': '3', 'PrecioBaj': '10.10', 'PrecioSub': 'null'}|06|2020-07-13T00:00Z/2020-07-13T03:00Z
  </code></pre>
  <p>I am guessing that the problem may be the list associated with 'Periodo' key, as I've worked with other json with a similar structure and didn't have any problem.
  Is there any way to get to the point I'm aiming?
  Thank you.</p>