How do I read JSON file into a Dataframe?
<p>I'm new to python so can anyone help me out?</p>

<p>i have the following contents in a json file (ie. file12.json)</p>

<pre><code>{
    "TimeSeries": {
        "Row": [
            {
                "CLOSE": 41.85,
                "TIMESTAMP": "2016-09-22T00:00:00+00:00"
            },
            {
                "CLOSE": 41.37,
                "TIMESTAMP": "2016-09-23T00:00:00+00:00"
            },
            {
                "CLOSE": 40.88,
                "TIMESTAMP": "2016-09-26T00:00:00+00:00"
            },
            {
                "CLOSE": 40.98,
                "TIMESTAMP": "2016-09-27T00:00:00+00:00"
            },
            {
                "CLOSE": 44.33,
                "TIMESTAMP": "2016-12-21T00:00:00+00:00"
            }
        ]
    }
}
</code></pre>

<p>I am trying to create a structured Dataframe, like this:</p>

<pre><code>      CLOSE        TIMESTAMP
0     41.85        2016-09-22T00:00:00+00:00 
1     41.37        2016-09-23T00:00:00+00:00 
2     40.88        2016-09-26T00:00:00+00:00
3     40.98        2016-09-27T00:00:00+00:00 
</code></pre>

<p>if i want to do the same with a csv, i simply use 'read_csv' but read_python produces a different output.</p>

<p>i've used this code...</p>

<pre><code>file = pd.read_json('file12.json')
print file
</code></pre>

<p>...but the format isn't quite how i want it. i get the following:</p>

<pre><code>TimeSeries
Row  [{u'CLOSE': 41.85, u'TIMESTAMP': u'2016-09-22T...
</code></pre>

<p>..ie. everything is simply on one row, rather than in a formatted table.</p>

<p>can anyone help me? please : - )</p>