Read JSON to pandas dataframe - ValueError: Mixing dicts with non-Series may lead to ambiguous ordering : <p>I am trying to read in the JSON structure below into pandas dataframe, but it throws out the error message: </p>

<blockquote>
  <p>ValueError: Mixing dicts with non-Series may lead to ambiguous
  ordering.</p>
</blockquote>

<p><strong>Json data:</strong></p>

<pre><code>{
    "status": {
        "statuscode": 200,
        "statusmessage": "Everything OK"
    },

    "result": [{
        "id": 22,
        "club_id": 16182
    }, {
        "id": 23,
        "club_id": 16182
    }, {
        "id": 24,
        "club_id": 16182
    }, {
        "id": 25,
        "club_id": 16182
    }, {
        "id": 26,
        "club_id": 16182
    }, {
        "id": 27,
        "club_id": 16182
    }]
}
</code></pre>

<p>How do I get this right? I have tried the script below...</p>

<pre><code>j_df = pd.read_json('json_file.json')
j_df

with open(j_file) as jsonfile:
    data = json.load(jsonfile)
</code></pre>
