title: reading csv file with delimiter inside a field with several double quotes
body: <p>I have a csv file with <code>,</code> separating the columns that I want to read with pandas, i.e. <code>df = pd.read_csv("myfile.csv",sep=',',dtype=str,encoding='utf-8')</code>. Columns are of various types, but I want to read everything as strings. One row of the following form causes the reader to see more columns in that row than it expected:</p>
  
  <pre class="lang-py prettyprint-override"><code># column 1, column 2, column 3, ...
  46745,"\\"\\"\\"blabla\\"\\" a, b bli\\"\\"more bla.\\"\\" bl blu \\"\\"bli bla blub\\"\\"\\"","something else",...
  </code></pre>
  
  <p>Some of the fields, as the second and third column here, are in double quotes. What sets the second field apart from other double quoted fields is that it contains several quotes such that when the parser reaches the <code>,</code> it does not realize that it is actually still within a quote which it should have recognized because the final quote character should be followed by the delimiter. Interestingly, when you pass <code>engine='python'</code> the parser actually recognized this, but instead of drawing the conclusion that the quote simply has not finished yet it throws the error <code>',' expected after '"'</code>.</p>
  
  <p>I tried all kinds of combinations for the keyword arguments <code>quoting</code>, <code>quotechar</code>, <code>sep</code> and <code>engine</code>. All to no avail.      </p>
  
  <p><strong>Edit:</strong> Example as requested</p>
  
  <pre><code>import io
  s = 'column1,column2,column3\n3463,hello,"more, stuff"\n46745,"\\"\\"\\"blabla\\"\\" a, b bli\\"\\"more bla.\\"\\" bl blu \\"\\"bli bla blub\\"\\"\\"","something else"'
  df = pd.read_csv(io.StringIO(s),sep=',',dtype=str,encoding='utf-8')
  </code></pre>
  
  <p>If you comment out the last line, it works.</p>