title: Pandas.read_json(JSON_URL)
body: <p>I am using Pandas to get data from an API. The API returns data in JSON format. However the json has some values that I don't want in the dataframe. Because of these values, I am not able to assign an index to data frame. Following is the format.</p>
  
  <pre><code>{
  "Success": true,
  "message": "",
  "result": [{"id":12312312, "TimeStamp":"2017-10-04T17:39:53.92","Quantity":3.03046306,},{"id": 2342344, "TimeStamp":"2017-10-04T17:39:53.92","Quantity":3.03046306,}]}
  </code></pre>
  
  <p>I am only interested in the "result" part. 
  One way to do this is to import json with <code>request.get(request_URL)</code> and then after extracting the "result" part, convert the result into the dataframe.
  2nd way can be to import the data with <code>Pandas.read_json(JSON_URL)</code> convert the returning dataframe back to a json, then after extracting "result" part, convert the result into the dataframe.</p>
  
  <p>Is there any other way to do this? What is the best approach and why? Thanks.</p>