title: How to skip footer in csv file while reading with pandas read_csv and chunksize option
body: <p>I'm reading big csv files using pandas.read_csv() and chunksize = 500000.
  Since I'm using chunksize so "skipfooter=1" option doesn't work with chunksize as it returns a generator instead of dataframe.</p>
  
  <p>What's the best way to skip footer record from the file while reading in chunks?</p>