title: Pandas: Convert JSON to Pandas Dataframe
body: <p>Experts,</p>
  
  <p>I am having issues parsing Json to Pandas and then save it in CSV format.</p>
  
  <pre><code>data2 = {"date":"2018-01-02","data":{"AAPL":{"open":"170.16","close":"172.26","high":"172.30","low":"169.26","volume":"25555934"},"MSFT":{"open":"86.13","close":"85.95","high":"86.31","low":"85.50","volume":"22483797"}}}
  </code></pre>
  
  <p>If I try :</p>
  
  <pre><code>df = pd.DataFrame.from_dict(json_normalize(data2), orient='columns')
  print(df)
  </code></pre>
  
  <p>Everything gets printed in a single line :</p>
  
  <p><a href="https://i.stack.imgur.com/ameZK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ameZK.png" alt="enter image description here"></a></p>
  
  <p>If I do :</p>
  
  <pre><code>jdata = json.loads(data2)
  df = pd.DataFrame(jdata)
  print(df.T)
  </code></pre>
  
  <p>I get an error : TypeError: the JSON object must be str, bytes or bytearray, not 'dict'</p>
  
  <p>I am looking to print it in the following table format so I can then save it as csv : </p>
  
  <pre><code>Date        Data    Open    Close   High    Low     Volume
  2018-01-02  AAPL    170.16  172.26  172.30  169.26  25555934
  2018-01-02  MSFT    86.13   85.95   86.31   85.50   22483797
  </code></pre>
  
  <p>What is the correct way to achieve my goal ?</p>
  
  <p>Thanks !!</p>