title: How to read a csv file with Pandas with more delimiters in the rows that in the header?
body: <p>I want to read a csv file using read_csv function from Pandas, the file has more delimiters in the rows that in the header. Pandas thinks the first columns are multi-index. The 'NAME' column can have an arbitrary number of delimiters and the affected column could be any one (we do not know which one is affected), even more than one.</p>
  
  <p>I have tried to tune the key-word arguments of read_csv without success. I am using Python 3.7.0 and Pandas 0.25.0. However, Excel can read the file correctly.</p>
  
  <pre class="lang-py prettyprint-override"><code>import pandas
  
  with open('test.csv', mode='w') as csv_file:
      csv_file.write('A,NAME,B\n')
      csv_file.write('a, Peter, Parker, b\n')
  
  df = pandas.read_csv('test.csv', header=0, delimiter=',')
  print(df)
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>   A            NAME   B
  0  a   Peter, Parker   b
  </code></pre>
  
  <p>Actual output:</p>
  
  <pre><code>    A     NAME   B
  a   Peter   Parker   b
  </code></pre>
  
  <p>Other example:</p>
  
  <pre class="lang-py prettyprint-override"><code>import pandas
  
  with open('test.csv', mode='w') as csv_file:
      csv_file.write('A,NAME,B,PLACE\n')
      csv_file.write('a, Peter, Parker, b, Queens, New York City\n')
  
  df = pandas.read_csv('test.csv', header=0, delimiter=',')
  print(df)
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>   A            NAME   B                 PLACE
  0  a   Peter, Parker   b Queens, New York City
  </code></pre>
  
  <p>Actual output:</p>
  
  <pre><code>                A NAME        B           PLACE
  a  Peter   Parker    b   Queens   New York City
  </code></pre>