title: How to Split a comma separated string of dictionaries into a Pandas dataframe
body: <p>I have a string in this format:</p>
  
  <pre><code>{apple:"34253453",oranges:"Sweet",x:"COOL"},{apple:"34222453",oranges:"Dry",x:"WARM"},{apple:"31113453",oranges:"Bitter",x:"HOT"},{apple:"38883453",oranges:"Sweet",x:"COOL"}
  </code></pre>
  
  <p>And looking to create a dataframe with the column labels as 'apple','oranges','x' and the values placed in their respective rows.</p>
  
  <p>I've tried to use this solution: <a href="https://stackoverflow.com/questions/32224363/python-convert-comma-separated-list-to-pandas-dataframe">Python convert comma separated list to pandas dataframe</a> as well as ast.literal_eval to convert it into a list before transforming it into a dataframe but to no luck.</p>