how to load a json into a pandas dataframe?
<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>