title: Pandas dataframe read_csv on bad data
body: <p>I want to read in a very large csv (cannot be opened in excel and edited easily) but somewhere around the 100,000th row, there is a row with one extra column causing the program to crash. This row is errored so I need a way to ignore the fact that it was an extra column. There is around 50 columns so hardcoding the headers and using names or usecols isn't preferable. I'll also possibly encounter this issue in other csv's and want a generic solution. I couldn't find anything in read_csv unfortunately. The code is as simple as this:</p>
  
  <pre><code>def loadCSV(filePath):
      dataframe = pd.read_csv(filePath, index_col=False, encoding='iso-8859-1', nrows=1000)
      datakeys = dataframe.keys();
      return dataframe, datakeys
  </code></pre>