title: How to make index=False or get rid of first column while using MultiIndex and to_excel in Python
body: <p>Here is the code sample:</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  import xlsxwriter
  
  tuples = [('bar', 'one'), ('bar', 'two'), ('baz', 'one'), ('baz', 'two'), ('foo', 'one'), ('foo', 'two'), ('qux', 'one'), ('qux', 'two')]
  
  index = pd.MultiIndex.from_tuples(tuples, names=['first', 'second'])
  
  iterables = [['bar', 'baz', 'foo', 'qux'], ['one', 'two']]
  
  pd.MultiIndex.from_product(iterables, names=['first', 'second'])
  
  df = pd.DataFrame(np.random.randn(3, 8), index=['A', 'B', 'C'], columns=index)
  
  print(df)
  
  writer = pd.ExcelWriter('test.xlsx', engine='xlsxwriter')
  df.to_excel(writer, sheet_name='test1')
  </code></pre>
  
  <p>The excel output created: <a href="https://i.stack.imgur.com/a1oKV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/a1oKV.png" alt="enter image description here"></a></p>
  
  <p>Now how to get rid of first column.</p>
  
  <p>Even if I don't mention index=['A', 'B', 'C'] or names=['first', 'second']</p>
  
  <p>It'll by default create index=[0, 1, 2]</p>
  
  <p>So how to get rid of that first column while creating the excel.</p>