title: How to turn Nested JSON into Pandas Data Frame using Python?
body: <p>I am new in understanding the JSON format and how to properly traverse it. I wanted to ask how I can read in a JSON file with nested keys and turn it into a Pandas Data Frame. (Example data below)</p>
  
  <p>I tried using json_load from the JSON package of Python and read_json from Pandas except they do not arrange the nested keys (below json_sample.txt) into their own. The tutorials on JSON I came across were relatively simple and do not apply to my case. </p>
  
  <p>Any guidance will be appreciated. </p>
  
  <p>"json_sample.txt"</p>
  
  <pre><code>{"Top_Shelf": [{"packageName": "big_game1",
    "sku": "big_game1_product1",
    "status": "active",
    "purchaseType": "User_A",
    "defPrice": {"price": "6", "currency": "CAD"},
    "prices": {"DZ": {"price": "6", "currency": "DZD"},
     "AU": {"price": "7", "currency": "AUD"},
    "listings": {"en-US": {"title": "game_currency_1",
      "description": "Pack2"}},
    "defaultLanguage": "English"}},
   {"packageName": "big_game1",
    "sku": "big_game1_bundle1",
    "status": "active",
    "purchaseType": "User_B",
    "defPrice": {"price": "1", "currency": "CAD"},
    "prices": {"DZ": {"price": "1", "currency": "DZD"},
     "AU": {"price": "1", "currency": "AUD"},
    "listings": {"en-US": {"title": "bundle",
      "description": "Pack1"}},
    "defaultLanguage": "English"}}]}
  
  </code></pre>
  
  <p>Final Structure of the results I would like to get (But even a table with all of the keys as their own column would be great</p>
  
  <pre><code>
  packageName     sku             countryCode   currency  price
  
  big_game1   big_game1_product1  CA          CAD      6
  
  big_game1   big_game1_product1  DZ          DZD      6
  
  .   .   .   .   .
  
  .   .   .   .   .
  
  .   .   .   .   .
  
  big_game1   big_game1_bundle1   AU          AUD      1
  
  </code></pre>