title: Read JSON to pandas dataframe - ValueError: Mixing dicts with non-Series may lead to ambiguous ordering
body: <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>