title: Parsing Excel data with pandas - why is it skipping columns when renaming columns?
body: <p>I really hope its something simple im missing. I'm reading in excel workbooks using python pandas. When I rename my columns to be numbers 1:len(columns) it skips the first few columns.</p>
  <p>It seems to only skip them if the cells don't have values in them. Even if the column doesn't have a value, i still want it to number them 1,2,3...</p>
  <pre><code>xl = pd.ExcelFile('Excel.xlsm')
  df = xl.parse('Worksheet1')
  df.columns = [str(x) for x in range(0,df.shape[1])]
  </code></pre>
  <p>I hope someone could point me in the right direction. I have tried using a header to skip the first few columns, but nothing gave me a consistent and reliable result. Thanks!</p>
  <p><a href="https://i.stack.imgur.com/auslI.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/auslI.png" alt="This is the output I get with skipped columns." /></a></p>