title: how to write this json multi-lists into seperate columns in python pandas
body: <p>I have this JSON file:</p>
  
  <pre><code>{"a": [{"Name": "name1",
  "number": "number1",
  "defaultPrice": {"p": "232", "currency": "CAD"},
  "prices": {"DZ": {"p": "62", "currency": "RMB"},
   "AU": {"p": "73", "currency": "AUD"},
  "lg": "en"}},
  {"Name": "name2",
  "number": "number2",
   "defaultPrice": {"p": "233", "currency": "CAD"},
   "prices": {"DZ": {"p": "63", "currency": "RMB"},
   "US": {"p": "72", "currency": "USD"},
   "Lg": "en"}}]}
  </code></pre>
  
  <p>Now I get this table with name, number, defaultprices, prices, but prices column is like three rows and price 63 need to be read from key p <code>"p": "63", "currency": "RMB".</code></p>
  
  <p>But I hope to get a table with price and currency in seperate column, I used this:</p>
  
  <p>ndf = pd.concat([pd.Series(x) for x in prices], axis=1)</p>
  
  <p>But just get a wrong answer:</p>
  
  <pre><code> 0                                                  1
   DZ           {"p": "232", "currency": "CAD"}  {"p": "62", "currency": "RMB"}
   AU           {"p": "233", "currency": "CAD"}    {"p": "63","currency":"RMB"}
  </code></pre>
  
  <p>Anyways to correct this so I can get this expected output? </p>
  
  <pre><code>Name    Number   Code  currency
  name1   number1   AU    AUD      
  name1   number1   DZ    RMB      
  </code></pre>
  
  <p>Thanks a lot!!</p>