title: Remove commas from CSV file before Pandas read_csv()
body: <p>When I read in a ~35MB CSV with Pandas read_csv(), I get the an error from the CParser that there may be a malformed input file. Example is below, please see line with "PNCBANK,NATL"</p>
  
  <p>UPDATE-----
  When I save as a Windows CSV instead of "comma delimited" filetype with 'c' engine it runs completely fine</p>
  
  <p>I read cut a sample of the CSV with commas removed from all observations and the problem persists. So this comma present in the strings below is not causing this.</p>
  
  <blockquote>
    <p>685   201603  N   204602      0   1   O   80  44  134000  80  4.125   R   N   FRM IL  SF  61900   F116Q1000024    P   360 2   Other sellers   CENTRALMTGECO</p>
  </blockquote>
  
  <p>776 201604      204603      0   1   O   46  47  108000  46  3.875   R   N   FRM CO  SF  81200   F116Q1000025    C   360 1   Other sellers   USBANKNA</p>
  
  <p>693 201603      203102      0   1   S   21  44  81000   21  3.25    R   N   FRM CO  PU  81100   F116Q1000026    N   180 2   Other sellers   USBANKNA</p>
  
  <p>715 201603      204602      0   1   S   75  46  63000   75  4.375   R   N   FRM CO  CO  81100   F116Q1000027    P   360 1   Other sellers   PNCBANK,NATL</p>
  
  <p>691 201603      204602  30460   0   1   O   24  14  35000   24  3.875   R   N   FRM KY  SF  40300   F116Q1000028    N   360 1   Other sellers   Other servicers</p>
  
  <p>758 201603      204602      0   2   I   75  36  85000   75  4.5 R   N   FRM KY  SF  40300   F116Q1000029    P   360 2   Other sellers   USBANKNA</p>
  
  <p>However, when I try swapping the engine to the Python engine for this, I get a readlines error (second error below).</p>
  
  <p>I believe it is because there is a column in the file that has a string with occasional commas within the string, and the file delimiter is also a comma. If this is, in fact, the problem, how can I go about replacing these commas with some other notation, if not just removing them entirely, while preserving the rest of the file. I DO know what strings have these commas, as its a particular subset of the observations for that column. Thanks!</p>
  
  <p>Error with C engine for read_csv()</p>
  
  <pre><code>Traceback (most recent call last):
    File "/Users/paltamura/Desktop/fmData/fmData/exploratory/creditScore_descriptives.py", line 160, in &lt;module&gt;
      lender_by_msa = lender_PerformanceByMSA()
    File "/Users/paltamura/Desktop/fmData/fmData/exploratory/creditScore_descriptives.py", line 32, in lender_PerformanceByMSA
      date_col_fmt_dict={'firstPaymentDate': '%Y%m'}
    File "/Users/paltamura/Desktop/fmData/fmData/Load/load_loans.py", line 19, in load_data
      nrows=10000 if nrows == 'sample' else nrows
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 562, in parser_f
      return _read(filepath_or_buffer, kwds)
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 325, in _read
      return parser.read()
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 815, in read
      ret = self._engine.read(nrows)
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 1314, in read
      data = self._reader.read(nrows)
    File "pandas/parser.pyx", line 805, in pandas.parser.TextReader.read (pandas/parser.c:8748)
    File "pandas/parser.pyx", line 827, in pandas.parser.TextReader._read_low_memory (pandas/parser.c:9003)
    File "pandas/parser.pyx", line 881, in pandas.parser.TextReader._read_rows (pandas/parser.c:9731)
    File "pandas/parser.pyx", line 868, in pandas.parser.TextReader._tokenize_rows (pandas/parser.c:9602)
    File "pandas/parser.pyx", line 1865, in pandas.parser.raise_parser_error (pandas/parser.c:23325)
  pandas.io.common.CParserError: Error tokenizing data. C error: Buffer overflow caught - possible malformed input file.
  </code></pre>
  
  <p>readlines() error with Python engine for read_csv()</p>
  
  <pre><code>Traceback (most recent call last):
    File "/Users/paltamura/Desktop/fmData/fmData/exploratory/creditScore_descriptives.py", line 160, in &lt;module&gt;
      lender_by_msa = lender_PerformanceByMSA()
    File "/Users/paltamura/Desktop/fmData/fmData/exploratory/creditScore_descriptives.py", line 32, in lender_PerformanceByMSA
      date_col_fmt_dict={'firstPaymentDate': '%Y%m'}
    File "/Users/paltamura/Desktop/fmData/fmData/Load/load_loans.py", line 20, in load_data
      engine='python'
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 562, in parser_f
      return _read(filepath_or_buffer, kwds)
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 315, in _read
      parser = TextFileReader(filepath_or_buffer, **kwds)
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 645, in __init__
      self._make_engine(self.engine)
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 805, in _make_engine
      self._engine = klass(self.f, **self.options)
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 1608, in __init__
      self.columns, self.num_original_columns = self._infer_columns()
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 1823, in _infer_columns
      line = self._buffered_line()
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 1975, in _buffered_line
      return self._next_line()
    File "/anaconda/lib/python2.7/site-packages/pandas/io/parsers.py", line 2006, in _next_line
      orig_line = next(self.data)
  _csv.Error: new-line character seen in unquoted field - do you need to open the file in universal-newline mode?
  </code></pre>