title: Convert JSON data from Request into Pandas DataFrame
body: <p>I'm trying to scrape some data from a web page and put it into a pandas dataframe. I tried and read many things but I just cannot get what I want. And I want a dataframe with all the data in separate columns and rows. Below is my code. </p>
  
  <pre><code>import requests
  import json
  import pandas as pd
  from pandas.io.json import json_normalize
  
  r = requests.get('http://www.starcapital.de/test/Res_Stockmarketvaluation_FundamentalKZ_Tbl.php')
  
  a = json.loads(r.text)
  
  res = json_normalize(a)
  ##print(res)
  
  df = pd.DataFrame(res)
  print(df)
  
  ##df = pd.read_json(a)
  ##print(df)
  </code></pre>
  
  <p><code>pd.read_json(a)</code> doesn't seem to work in any way. Could someone give it a try?</p>
  
  <p>Thanks for all the help in advance.</p>
  
  <p>Best regards, David</p>