title: json to dataframe conversion / Python
body: <p>I just imported an API to get the exchange rate of Taiwan dollar (TWD) with other currencies.
  So I import it with this code :</p>
  <pre><code>import requests
  r=requests.get('http://api.cambio.today/v1/full/TWD/json?key=X')
  dico = r.json()
  </code></pre>
  <p>And it gives me:</p>
  <pre><code>{'result': {'from': 'TWD',
    'conversion': [{'to': 'AED',
      'date': '2020-06-23T07:23:49',
      'rate': 0.124169},
     {'to': 'AFN', 'date': '2020-06-23T07:19:53', 'rate': 2.606579},
     {'to': 'ALL', 'date': '2020-06-19T20:48:10', 'rate': 3.74252},
     {'to': 'AMD', 'date': '2020-06-22T12:00:19', 'rate': 16.176679},
     {'to': 'AOA', 'date': '2020-06-22T12:32:59', 'rate': 20.160418},
     {'to': 'ARS', 'date': '2020-06-23T08:00:01', 'rate': 2.363501}
    ]}
  }
  </code></pre>
  <p>To turn it into a dataframe I tried two things:</p>
  <pre><code>df = pd.DataFrame(dico.get('result', {}))
  </code></pre>
  <p>and</p>
  <pre><code>from pandas.io.json import json_normalize
  dictr = r.json()
  df = json_normalize(dictr)
  </code></pre>
  <p>In both cases, I end up with a &quot;conversion&quot; column with one line per currency. For example the first line is: &quot;{'to': 'AFN', 'date': '2020-06-23T07:19:53', 'rate': 2.606579}&quot;.
  While I would like to have one column for the currency and one for the exchange rate.</p>
  <p>Could someone please help me?</p>