title: How can i transform the nested json to datafrmae?
body: <p>I exported raw data set from my database which is a nested json structure. So, based on this, i want to transform that kind of data set into pandas dataframe, But, I don't know how can i transform that kind of structure into dataframe i want. </p>
  
  <p>I have practiced some tutorials about handling the nested json data structure from kaggle using the json_normalize , but, in my case, i cannot realize the json structure into dataframe i want.</p>
  
  <p>desired dataframe i want to realize is like that </p>
  
  <p>below is the nested json structure i exported</p>
  
  <pre><code>[
      {
          "tripId" : "19062521016",
          "driveDisstance" : 0,
          "devicetime" : "2019-06-26 06:02:30",
          "speeds" : "0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,2,1,2,4,11,13,13,14,14,14,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0",
          "locations" : "[{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0}]",
          "dangerousValues" : "[{\"quickTick\":0},{\"quicRatio\":1023},{\"quicCount\":0},{\"brakeTick\":0},{\"brakeRatio\":1023},{\"brakeCount\":0},{\"overSpeedRatio\":1023},{\"overSpeedCount\":0}]"
      },
      {
          "tripId" : "19062521016",
          "driveDisstance" : 0,
          "devicetime" : "2019-06-26 06:03:30",
          "speeds" : "0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0",
          "locations" : "[{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0},{\"latitude\":0,\"longitude\":0}]",
      ...,
  ]
  </code></pre>
  
  <p>I expect the output as below.</p>
  
  <pre><code>tripId | driveDisstance | devicetime | speeds | qucikTick | quickRatio | quickCount | brakeTick | brakeRatio | brakeCount | overSpeedRatio | overSpeedCount
  </code></pre>
  
  <p>as a columns </p>
  
  <p>and then one tripId has 60 rows which include 60 speeds values, 6 location values and dangerousValues.</p>