title: Pandas convert JSON string to Dataframe - Python
body: <p>i have a json string that need to be convert to a dataframe with desired column name.</p>
  
  <pre><code>my_json = {'2017-01-03': {'open': 214.86,
    'high': 220.33,
    'low': 210.96,
    'close': 216.99,
    'volume': 5923254},
  '2017-12-29': {'open': 316.18,
    'high': 316.41,
    'low': 310.0,
    'close': 311.35,
    'volume': 3777155}}
  </code></pre>
  
  <p>use below code doesn't give the format i want</p>
  
  <pre><code>pd.DataFrame.from_dict(json_normalize(my_json), orient='columns')
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/S9sCP.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/S9sCP.png" alt="enter image description here"></a></p>
  
  <p>my expected format is below</p>
  
  <p><a href="https://i.stack.imgur.com/PtvLx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/PtvLx.png" alt="enter image description here"></a></p>
  
  <p>Not sure how to do it?</p>