title: importing CSV file with values wrapped in " when some of them contains " as well as commas
body: <p>I think I searched throughout but if I missed something - let me know please.</p>
  
  <p>I am trying to import CSV file where all non numerical values are wrapped with ".
  I have encountered a problem with: </p>
  
  <pre><code> df = pd.read_csv(file.csv)
  </code></pre>
  
  <p>Example of CSV:</p>
  
  <pre><code>"Business focus","Country","City","Company Name"
  "IT","France","Lyon","Societe General"
  "Mining","Russia","Moscow","Company "MoscowMining" Owner1, Owner2, Owner3"
  "Agriculture","Poland","Warsaw","Company" Jankowski,A,B""
  </code></pre>
  
  <p>Because of multiple quotes and commas inside them, pandas is seeing more columns than 4 in this case (like 5 or 6).</p>
  
  <p>I have already tried to play with</p>
  
  <pre><code>df = pd.read_csv(file.csv, quotechar='"', quoting=2)
  </code></pre>
  
  <p>But got</p>
  
  <pre><code>ParserError: Error tokenizing data (...)
  </code></pre>
  
  <p>What works is skipping bad lines by </p>
  
  <pre><code>error_bad_lines=False
  </code></pre>
  
  <p>but I'd rather have all data somehow taken into consideration than just ommit it.</p>
  
  <p>Many thanks for any help!</p>