title: JSON from API call to pandas dataframe
body: <p>I'm trying to get an API call and save it as a dataframe.
  problem is that I need the data from the 'result' column. 
  Didn't succeed to do that.</p>
  
  <p>I'm basically just trying to save the API call as a csv file in order to work with it.</p>
  
  <p>P.S when I do this with a "JSON to CSV converter" from the web it does it as I wish. (example: <a href="https://konklone.io/json/" rel="nofollow noreferrer">https://konklone.io/json/</a>)   </p>
  
  <pre><code>import requests
  import pandas as pd
  import json
  
  res = requests.get("http://api.etherscan.io/api?module=account&amp;action=txlist&amp;
  address=0xddbd2b932c763ba5b1b7ae3b362eac3e8d40121a&amp;startblock=0&amp;
  endblock=99999999&amp;sort=asc&amp;apikey=YourApiKeyToken")
  
  j = res.json()
  
  j
  
  df = pd.DataFrame(j)
  
  df.head()
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/zCInx.png" rel="nofollow noreferrer">output example picture</a></p>