title: Pandas: How to workaround "error tokenizing data"?
body: <p>A lot of questions have been already asked <a href="https://stackoverflow.com/q/18039057/7295599">about this topic on SO</a>. 
  (and many others).
  Among the numerous answers, none of them was really helpful to me so far. If I missed  <strong>the</strong> useful one, please let me know.</p>
  
  <p>I simply would like to read a CSV file with pandas into a dataframe. Sounds like a simple task.</p>
  
  <p>My file <code>Test.csv</code></p>
  
  <pre><code>1,2,3,4,5
  1,2,3,4,5,6
  ,,3,4,5
  1,2,3,4,5,6,7
  ,2,,4
  </code></pre>
  
  <p>My code:</p>
  
  <pre><code>import pandas as pd
  df = pd.read_csv('Test.csv',header=None)
  </code></pre>
  
  <p>My error:</p>
  
  <pre><code>pandas.errors.ParserError: Error tokenizing data. C error: Expected 5 fields in line 2, saw 6
  </code></pre>
  
  <p>My guess about the issue is that Pandas looks to the first line and expects the same number of tokens in the following rows. If this is not the case it will stop with an error.</p>
  
  <p>In the numerous answers, the suggestions for using options are, e.g.:
  <code>error_bad_lines=False</code> or <code>header=None</code> or <code>skiprows=3</code> and more non-helpful suggestions. </p>
  
  <p>However, I don't want to ignore any lines or skip. And I don't know in advance how many columns and rows the datafile has.</p>
  
  <p>So it basically boils down to how to find the maximum number of columns in the datafile. Is this the way to go? I hoped that there was an easy way to simply read a CSV file which does not have the maximum column number in the first line. Thank you for any hints. I'm using Python 3.6.3, Pandas 0.24.1 on Win7.</p>