title: Python Pandas read_csv not importing correctly
body: <p>I have a <code>.xls</code> file that looks similar to this...</p>
  
  <pre><code>Value of Construction Put in Place...
  (Millions of Dollars....)
  Blank Row
  Date    Total_Construction Total Residential Total Nonresidential...Columns 
  Dec-15  1,116,570          435,454           681,217 
  Nov-15  1,115,966          432,295           683,671
  Oct-15  1,122,749          431,164           691,585   
  .
  .
  .
  </code></pre>
  
  <p>I am trying to import the file to get the following:</p>
  
  <pre><code>Date    Total_Construction Total Residential Total Nonresidential 
  Dec-15  1,116,570          435,454           681,217 
  Nov-15  1,115,966          432,295           683,671
  Oct-15  1,122,749          431,164           691,585   
  .
  .
  . 
  </code></pre>
  
  <p>With the following code:</p>
  
  <pre><code>for chunk in pandas.read_csv('/PATH/totsatime.xls',
                   names      = ['Date', 'Total Residential', 'Total Nonresidential'],
                   header     = 4,
                   chunksize  = 1,
                   skiprows   = range(1, 4),
                   thousands  = ','):
  
      if chunk['Date'] == 'Dec-01':
          break
  
      else:
          df = pandas.DataFrame(chunk)
  </code></pre>
  
  <p>However, I end up with the following:</p>
  
  <pre><code>Date             Total Residential     Total Nonresidential
  Lodging          NaN                   NaN
  Office          NaN                   NaN
  Commercial      NaN                   NaN
  Health care     NaN                   NaN
  </code></pre>
  
  <p>The dates end up being formatted from the columns that I am not importing. Any advice would greatly be appreciated.</p>
  
  <p>Thank you in advance. </p>