title: Importing Json File URL to pandas data frame
body: <p>I am trying to import as a dataframe a URL that has a JSON file in it.</p>
  
  <pre class="lang-py prettyprint-override"><code>import urllib.request, json 
  import pandas as pd
  
  with urllib.request.urlopen("https://financialmodelingprep.com/api/v3/company-key-metrics/AAPL?period=quarter") as url:
      data = json.loads(url.read().decode())
      df = pd.DataFrame(data)
  print(df)
  </code></pre>
  
  <p>It is not considering each metric in the JSON file as a column, but puts all the metrics under one column called "metrics"</p>
  
  <p>while the output I am expecting is</p>
  
  <p><a href="https://i.stack.imgur.com/1HhRM.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1HhRM.png" alt="enter image description here"></a></p>