title: JSON to Pandas: is there a more elegant solution?
body: <p>I have some JSON, returned from an API call, that looks something like this:</p>
  
  <pre><code>{
      "result": {
          "code": "OK",
          "msg": ""
      },
      "report_name": "FAMOUS_DICTATORS",
      "columns": [
          "rank",
          "name",
          "deaths"
      ],
      "data": [
          {
              "row": [
                  1,
                  "Mao Zedong",
                  63000000
              ]
          },
          {
              "row": [
                  2,
                  "Jozef Stalin",
                  23000000
              ]
          }
      ]
  }
  </code></pre>
  
  <p>I'd like to convert the JSON into a Pandas DataFrame:</p>
  
  <pre><code>rank    name            deaths
  1       Mao Zedong      63000000
  2       Jozef Stalin    23000000
  </code></pre>
  
  <p>I wrote this and it works, but looks a bit ugly:</p>
  
  <pre><code>import pandas as pd
  import json
  
  columns = eval(r.content)['columns']
  
  df = pd.DataFrame(columns = eval(r.content)['columns'])
  
  for row in eval(r.content)['data']:
      df.loc[len(df)+1] = row['row']
  </code></pre>
  
  <p>Is there a more elegant/Pythonic way to do this (e.g. possibly using pandas.io.json.read_json)?</p>