title: Pandas DataFrame Read Skipping line XXX: expected X fields, saw Y
body: <p>I can't figure out what's wrong with the csv file I'm trying to load:</p>
  
  <p>I get error messages such as this:
  <code>b'Skipping line 2120260: expected 6 fields, saw 8\n'
  </code></p>
  
  <p>But when I view the lines, they look ok to me. See below -- (I am going to press enter after each tab \t  to make it easier to read).</p>
  
  <p>Line 2,120,260 (failing):
  <code>
  ['user_000104\t
  2005-09-12T06:25:50Z\t
  a019a8cf-2601-4a81-b3c3-7b279a873713\t
  Anne Clark\t
  8f8e6bc0-c3c0-4062-875a-773a1de6206f\t
  Empty Me']
  </code></p>
  
  <p>Line 9,000 (not failing):
  <code>
  ['user_000001\t
  2008-06-15T17:28:31Z\t
  a3031680-c359-458f-a641-70ccbaec6a74\t
  Steve Reich\t
  2991db42-3b19-4344-a340-605ac3fbd7e9\t
  Drumming: Part Iv']
  </code></p>
  
  <p>If anyone wants to try it out for themselves, download this:</p>
  
  <p><a href="http://www.dtic.upf.edu/~ocelma/MusicRecommendationDataset/lastfm-1K.html" rel="noreferrer">http://www.dtic.upf.edu/~ocelma/MusicRecommendationDataset/lastfm-1K.html</a></p>
  
  <p>and run:
  <code> inpFile2 = pd.read_csv(fPath, sep='\t', error_bad_lines= False)</code></p>
  
  <p>to generate the error. And:
  <code>
  def checkRow(path,N):
      with open(path, 'r') as f:
          print("This is the line.")
          print(next(itertools.islice(csv.reader(f), N, None)))
  </code></p>
  
  <p>to view the error row (pass in the file path and the row you are interested in). Make sure you import csv and import itertools.</p>