title: Pandas not reading first column from xlsx file
body: <p>I'm working through one excel file where it contains multiple (36) sheets by month_year (Sep 18 - Oct 15) reading all of them using a dictionary </p>
  
  <pre><code>import pandas as pd
  
  fileName = 'project_dropColumnICSv2.xlsx'
  df = pd.ExcelFile(fileName)
  
  sheetNames = df.sheet_names
  vars_dict = {}
  
  for sheetName in sheetNames:
      vars_dict["the_{0}".format(sheetName)] = pd.read_excel(fileName, sheet_name=sheetName, index_col=False)
  
  mykeys = []
  
  for key, value in vars_dict.items():
      mykeys.append(key)
  </code></pre>
  
  <p>I need to set their 14 column names all at once but I'm getting ValueError: Length mismatch</p>
  
  <p>Here, we can see some sheets only contain 13 columns</p>
  
  <pre><code>for mykey in mykeys:
      print("'{}' contains {} columns".format((mykey), len(vars_dict.get(mykey).columns)))
  
  'the_Sep 18' contains 14 columns
  'the_Aug 18' contains 14 columns
  'the_Jul 18' contains 14 columns
  'the_Jun 18' contains 14 columns
  'the_May 18' contains 14 columns
  'the_April 18' contains 14 columns
  'the_March 18' contains 14 columns
  'the_February 18' contains 13 columns
  'the_January 18' contains 14 columns
  'the_December 17' contains 13 columns
  'the_November 17' contains 13 columns
  'the_October 17' contains 13 columns
  'the_September 17' contains 13 columns
  'the_August 17' contains 14 columns
  'the_July 17' contains 14 columns
  'the_June 17' contains 14 columns
  'the_May 17' contains 14 columns
  'the_April 17' contains 14 columns
  'the_MARCH 17' contains 14 columns
  'the_February17' contains 14 columns
  'the_January17' contains 14 columns
  'the_December16' contains 14 columns
  'the_November16' contains 14 columns
  'the_October 16' contains 14 columns
  'the_September' contains 14 columns
  'the_August' contains 15 columns
  'the_July' contains 14 columns
  'the_June' contains 14 columns
  'the_May' contains 14 columns
  'the_April' contains 14 columns
  'the_March' contains 13 columns
  'the_February' contains 13 columns
  'the_January' contains 13 columns
  'the_December' contains 13 columns
  'the_November' contains 14 columns
  'the_October' contains 13 columns
  </code></pre>
  
  <p>I tried just adding another column</p>
  
  <pre><code>for mykey in mykeys:
      if len(vars_dict.get(mykey).columns) == 13:
          vars_dict.get(mykey)['Another Column'] = 'Nan'
  </code></pre>
  
  <p>change the column names using a for loop, but got a result where first column has a wrong field, in short, misaligned.</p>
  
  <p>Assuming a have an array of my column names, how can I make this work?</p>
  
  <pre><code>for mykey in mykeys:
      vars_dict.get(mykey).columns = column
  </code></pre>
  
  <p>P.S. there is one sheet that contain 15 columns, solved by simply dropping the last </p>