title: how to load a json into a pandas dataframe?
body: <p>I am using a <code>REST API</code> to get a <code>json</code> file as follows:</p>
  
  <pre><code>import urllib2
  import pandas as pd
  import numpy as np
  import requests
  
  request='myrequest'
  data= requests.get(request)
  json=data.json()
  df=pd.DataFrame(json)
  </code></pre>
  
  <p>and the dataframe looks like</p>
  
  <pre><code>                                               items
  0  {u'access': u'all', u'count': 501, u'time': 2014}
  1  {u'access': u'all', u'count': 381, u'time': 2015}
  </code></pre>
  
  <p>How can I transform this single column (that looks like a dictionary) into proper columns in Pandas?</p>
  
  <p>EDIT</p>
  
  <p>the raw json data looks like this</p>
  
  <pre><code>{
    "items": [
      {
        "access": "all",
        "count": 200,
        "time": 2015
      },
      {
        "access": "all",
        "count": 14,
        "time": 2015
      },
    ]
  }
  </code></pre>
  
  <p>Thanks!</p>