title: convert JSON text string to Pandas, but each row cell ends up as an array of values inside
body: <p>I manage to extract a time-series of prices from a web-portal. The data arrives in a json format, and I convert them into a pandas dataFrame.</p>
  
  <p>Unfortunately, the data for the different bands come in a text string, and I can't seem to extract them out properly.</p>
  
  <p>The below is the json data I extract</p>
  
  <p><a href="https://i.stack.imgur.com/2s7dp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2s7dp.png" alt="enter image description here"></a></p>
  
  <p>I convert them into a pandas dataframe using this code</p>
  
  <pre><code>data = pd.DataFrame(r.json()['prices'])
  </code></pre>
  
  <p>and get them like this</p>
  
  <p><a href="https://i.stack.imgur.com/oEgxW.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/oEgxW.png" alt="enter image description here"></a></p>
  
  <p>I need to extract (for example) the data in the column ClosePrice out, so that I can do data analysis and cleansing on them.</p>
  
  <p>I tried using</p>
  
  <pre><code>data['closePrice'].str.split(',', expand=True).rename(columns = lambda x: "string"+str(x+1))
  </code></pre>
  
  <p>but it doesn't really work.</p>
  
  <p>Is there any way to either
  a) when I convert the json to dataFrame, such that the prices within the closePrice, bidPrice etc are extracted in individual columns OR
  b) if they were saved in the dataFrame, extract the text strings within them, such that I can extract the prices (e.g. the bid, ask and lastTraded) within the text string?</p>