title: Trailing delimiter confuses pandas read_csv
body: <p>A csv (comma delimited) file, where lines have an extra trailing delimiter, seems to confuse <code>pandas.read_csv</code>. (The data file is [1])</p>
  
  <p>It treats the extra delimiter as if there's an extra column. So there's one more column than what headers require. Then <code>pandas.read_csv</code> takes the first column as row labels. The overall effect is that columns and headers are not aligned any more - the first column becomes row labels, the second column is named by first header, etc.</p>
  
  <p>It is quite annoying. Any idea how to tell <code>pandas.read_csv</code> do the right thing? I couldn't find one.</p>
  
  <p>Great book, BTW.</p>
  
  <hr>
  
  <p>[1]: 2012 FEC Election Database from chapter 9 of the book <em>Python for Data Analysis</em> </p>