title: Parsing CSV file in pandas with commas
body: <p>I need to create a <code>pandas.DataFrame</code> from a <code>csv</code> file.  For that I am using the method <code>pandas.csv_reader(...)</code>. The problem with this file is that one or more columns contain commas within the values (I don't control the file format). 
  I been trying to implement the solution from this <a href="https://stackoverflow.com/questions/24164249/parsing-csv-file-in-pandas-with-commas-in-last-column?answertab=active#tab-top">question</a> but I get the following error:</p>
  
  <pre><code>pandas.errors.EmptyDataError: No columns to parse from file 
  </code></pre>
  
  <p>For some reason after implementing this solution the csv file I tried fixing is blank. </p>
  
  <p><strong>Here is the code I am using:</strong></p>
  
  <pre><code># fix csv file
  with open ("/Users/username/works/test.csv",'rb') as f,\
  open("/Users/username/works/test.csv",'wb') as g:
      writer = csv.writer(g, delimiter=',')
      for line in f:
          row = line.split(',', 4)
          writer.writerow(row)
  # Manipulate csv file
  data = pd.read_csv(os.path.expanduser\
  ("/Users/username/works/test.csv"),error_bad_lines=False)
  </code></pre>
  
  <p>Any ideas? </p>
  
  <p><strong>Data overview:</strong></p>
  
  <pre><code> Id0    Id 1    Id 2 Country Company Title       Email                  
    23    123     456   AR     name    cargador   email@email.com                 
  
    24    123     456   AR     name    Executive assistant    email@email.com                 
  
    25    123     456   AR     name   Asistente Administrativo    email@email.com                 
  
    26    123     456   AR     name   Atención al cliente vía telefónica   vía online email@email.com             
    39    123     456   AR     name   Asesor de ventas    email@email.com                 
  
    40    123     456   AR     name    inc.   International company representative    email@email.com             
    41    123     456   AR     name   Vendedor de campo   email@email.com                 
  
    42    123     456   AR     name   PUBLICIDAD   ATENCIÓN AL CLIENTE    email@email.com             
    43    123     456   AR     name   Asistente de Marketing  email@email.com                 
  
    44    123     456   AR     name   SOLDADOR    email@email.com                 
    217   123     456   AR     name   Se requiere vendedores       Loja    Quevedo     Guayas)    email@email.com 
    218   123     456   AR     name   Ing. Civil recién graduado   Yaruquí    email@email.com             
   219    123     456   AR     name   ayudantes enfermeria    email@email.com                 
  
   220    123     456   AR     name   Trip Leader for International Youth Exchange    email@email.com                 
   221    123     456   AR     name   COUNTRY MANAGER / DIRECTOR COMERCIAL    email@email.com                 
   250    123     456   AR     name   Ayudante de Pasteleria  email@email.com  Asesor email@email.com email@email.com     
  </code></pre>
  
  <p><strong>Pre-parsed CSV:</strong></p>
  
  <pre><code>#,Id 1,Id 2,Country,Company,Title,Email,,,,
  23,123,456,AR,name,cargador,email@email.com,,,,
  24,123,456,AR,name,Executive assistant,email@email.com,,,,
  25,123,456,AR,name,Asistente Administrativo,email@email.com,,,,
  26,123,456,AR,name,Atención al cliente vía telefónica , vía online,email@email.com,,,
  39,123,456,AR,name,Asesor de ventas,email@email.com,,,,
  40,123,456,AR,name, inc.,International company representative,email@email.com,,,
  41,123,456,AR,name,Vendedor de campo,email@email.com,,,,
  42,123,456,AR,name,PUBLICIDAD, ATENCIÓN AL CLIENTE,email@email.com,,,
  43,123,456,AR,name,Asistente de Marketing,email@email.com,,,,
  44,123,456,AR,name,SOLDADOR,email@email.com,,,,
  217,123,456,AR,name,Se requiere vendedores,, Loja , Quevedo, Guayas),email@email.com
  218,123,456,AR,name,Ing. Civil recién graduado, Yaruquí,email@email.com,,,
  219,123,456,AR,name,ayudantes enfermeria,email@email.com,,,,
  220,123,456,AR,name,Trip Leader for International Youth Exchange,email@email.com,,,,
  221,123,456,AR,name,COUNTRY MANAGER / DIRECTOR COMERCIAL,email@email.com,,,,
  250,123,456,AR,name,Ayudante de Pasteleria,email@email.com, Asesor,email@email.com,email@email.com,
  251,123,456,AR,name,Ejecutiva de Ventas,email@email.com,,,,
  </code></pre>