title: Parsing csv which contains json
body: <p>I have a quite small csv (120mb).</p>
  
  <p>One of the columns contains a json strings which look like this.</p>
  
  <p><code>{"A":"Dart","B":"en","C":"[gb]","D":"4,5,7","E":"2019-03-07"}</code></p>
  
  <p>I need to parse this json from a csv and convert it to data frame or another csv which will contain A/B/C/D/E columns and corresponding values in a rows.</p>
  
  <p>I've tried to parse it with python and pandas, using different libraries but without any luck, data always seem to be corrupted.</p>
  
  <p>I've looked into raw text view of my csv and found out that raw data looks like this and it seems like parsers cannot chew it for some reason.</p>
  
  <p><code>"{""A"":""Dart"",""B"":""en"",""C"":""[gb]"",""D"":""4,5,7"",""E"":""2019-03-07""}"</code></p>