title: How to decode a JSON into a pandas dataframe?
body: <p>I am trying to decode a JSON I get from a RESTful API into a pandas dataframe. Here is snippet of how the JSON looks like:</p>
  
  <pre><code>{
     "success":true,
     "data":[
        {
           "id":26,
           "name":"A",
           "comment":"",
           "start_time_plan":null,
           "start_time_actual":"2016-09-13 00:00:00",
           "start_time_delta":null,
           "start_time_score":null,
           "start_time_score_achievement":null,
           "start_time_traffic_light":null,
           "end_time_plan":null,
           "end_time_actual":"2016-09-13 00:00:00",
           "end_time_delta":null,
           "end_time_score":null,
           "end_time_score_achievement":null,
           "end_time_traffic_light":null,
           "status":0,
           "measure_schedule_revision_id":63,
           "responsible_user_id":3,
           "created_time":"2016-09-13 11:29:14",
           "created_user_id":3,
           "modified_time":"2016-09-21 16:33:41",
           "modified_user_id":3,
           "model":"Activity"
        },
        {
           "id":27,
           "name":"B",
           "comment":"",
           "start_time_plan":null,
           "start_time_actual":"2016-09-13 00:00:00",
           "start_time_delta":null,
           "start_time_score":null,
           "start_time_score_achievement":null,
           "start_time_traffic_light":null,
           "end_time_plan":null,
           "end_time_actual":"2016-09-13 00:00:00",
           "end_time_delta":null,
           "end_time_score":null,
           "end_time_score_achievement":null,
           "end_time_traffic_light":null,
           "status":0,
           "measure_schedule_revision_id":63,
           "responsible_user_id":3,
           "created_time":"2016-09-13 11:29:48",
           "created_user_id":3,
           "modified_time":"2016-10-16 18:14:36",
           "modified_user_id":1,
           "model":"Activity"
        }
     ]
  }
  </code></pre>
  
  <p>My goal is to get a dataframe with two columns consisting of <code>end_time_delta</code> and <code>start_time_delta</code> and to build a simple scatterplot from it.  </p>
  
  <p>Here is what I do:</p>
  
  <pre><code>u = 'https://myurl.com'
  
  # urllib3 + poolmanager for requests
  import urllib3
  http = urllib3.PoolManager()
  
  
  # get the JSON
  import json
  r = http.request('GET', u)
  result = json.loads(r.data.decode('utf-8'))
  
  for item in result['data']:
      print(item['end_time_delta'])
  
  for item in result['data']:
      print(item['start_time_delta'])
  
  # decode JSON to pandas dataframe
  import pandas as pd
  
  df = pd.read_json( result, orient='values')
  </code></pre>
  
  <p>I manage to get the JSON and forloop through it. But I can't decode it to a pandas dataframe. How does that work?</p>
  
  <p>(I tried myself out with pandas read_json. But I am not sure, it is a smart idea. It is not working anyhow.) </p>