title: Import and Print Json objects in Dataframe in Pandas
body: <p>I have a json file which looks like the one shown in the picture.
  How can I import and print all the Quantity and Rate in Pandas?
  How can I print the sum of all the Quantity for Buy and Sell separately?
  How can I print the sum of all the Quantity who's values is greater than x. For eg:SUM(Qty > 5)</p>
  
  <p><a href="https://i.stack.imgur.com/SxThO.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SxThO.jpg" alt="enter image description here"></a></p>
  
  <p>In raw format, the data is like this</p>
  
  <pre><code>{"success":true,"message":"","result":{"buy":[{"Quantity":199538.30948659,"Rate":0.00000970},{"Quantity":62142.31715449,"Rate":0.00000968},{"Quantity":233476.03486058,"Rate":0.00000967},{"Quantity":75613.30879931,"Rate":0.00000966},{"Quantity":3109.14961399,"Rate":0.00000965},{"Quantity":66.22406639,"Rate":0.00000964},{"Quantity":401.06420081,"Rate":0.00000963},{"Quantity":186.93339628,"Rate":0.00000961},{"Quantity":122731.01165366,"Rate":0.00000960},{"Quantity":7718.27750144,"Rate":0.00000959},{"Quantity":802.00000000,"Rate":0.00000958},{"Quantity":2050.72163419,"Rate":0.00000956},{"Quantity":1000.00000000,"Rate":0.00000955}
  </code></pre>