title: Error when using pandas read_excel(header=[0,1])
body: <p>I'm trying to use pandas read_excel to work with a file. The file has two columns of headers so I'm trying to use the multiIndex feature apart of the header keyword argument. </p>
  
  <pre><code>import pandas as pd, os 
  
  """data in 2015 MOR Folder"""
  filename = 'MOR-JANUARY 2015.xlsx'
  
  print(os.path.isfile(filename))
  
  df1 = pd.read_excel(filename, header=[0,1], sheetname='MOR')
  
  print(df1)
  </code></pre>
  
  <p>the error I get is ValueError: Length of new names must be 1, got 2. The file is in this google drive folder <a href="https://drive.google.com/drive/folders/0B0ynKIVAlSgidFFySWJoeFByMDQ?usp=sharing" rel="noreferrer">https://drive.google.com/drive/folders/0B0ynKIVAlSgidFFySWJoeFByMDQ?usp=sharing</a>
  I'm trying to follow the solution posted here
  <a href="https://stackoverflow.com/questions/40554106/read-excel-sheet-with-multiple-header-using-pandas">Read excel sheet with multiple header using Pandas</a></p>