title: Read CSV with extra commas and no quotechar with Pandas?
body: <p>Data:</p>
  
  <pre><code>from io import StringIO
  import pandas as pd
  
  s = '''ID,Level,QID,Text,ResponseID,responseText,date_key
  375280046,S,D3M,Which is your favorite?,D5M0,option 1,2012-08-08 00:00:00
  375280046,S,D3M,How often? (at home, at work, other),D3M0,Work,2010-03-31 00:00:00
  375280046,M,A78,Do you prefer a, b, or c?,A78C,a,2010-03-31 00:00:00'''
  
  df = pd.read_csv(StringIO(s))
  </code></pre>
  
  <p>Error received:</p>
  
  <pre><code>pandas.io.common.CParserError: Error tokenizing data. C error: Expected 7 fields in line 3, saw 9
  </code></pre>
  
  <p>It's very obvious why I'm receiving this error. The  data contains text such as <code>How often? (at home, at work, other)</code> and <code>Do you prefer a, b, or c?</code>.</p>
  
  <p>How does one read this type of data into a pandas DataFrame?</p>