title: Importing JSON into Pandas
body: <p>I have to following JSON that is coming from an API (e.g. my_json). The array of entities is stored in a key called entities:</p>
  
  <pre><code>{
      "action" : "get",
      "application" : "4d97323f-ac0f-11e6-b1d4-0eec2415f3df",
      "params" : {
        "limit" : [ "2" ]
      },
      "path" : "/businesses",
      "entities" : [
          {
              "uuid" : "508d56f1-636b-11e7-9928-122e0737977d",
              "type" : "business",
              "size" : 730 },
          {
              "uuid" : "2f3bd4dc-636b-11e7-b937-0ad881f403bf",
              "type" : "business",
              "size" : 730 
          } ],
    "timestamp" : 1499469891059,
    "duration" : 244,
    "count" : 2
  }
  </code></pre>
  
  <p>I am trying to load them into a data frame as follows:</p>
  
  <pre><code>import pandas as pd
  
  pd.read_json(my_json['entities'], orient='split')
  </code></pre>
  
  <p>I get the following error:</p>
  
  <pre><code>ValueError: Invalid file path or buffer object type: &lt;type 'list'&gt;
  </code></pre>
  
  <p>I have tried records orientation and still doesn't work.</p>