title: How to remove index column after Converting xlsx to csv using pandas
body: <pre><code>import pandas as pd
  
  data_xls=pd.read_excel('/users/adam/abc.xlsx',index=False) 
  data_xls.to_csv('def.csv,encoding='utf-8')
  </code></pre>
  
  <p>Also tried: </p>
  
  <pre><code>data_xls=pd.read_excel('/users/adam/abc.xlsx',index_col=False)
  data_xls=pd.read_excel('/users/adam/abc.xlsx',index=None)
  data_xls=pd.read_excel('/users/adam/abc.xlsx',index_col=None)
  </code></pre>
  
  <p>Actual Output:</p>
  
  <pre><code>     Name    Age
  
  0    Adam    24
  
  1    Steve   25
  
  2    Jhon    23
  </code></pre>
  
  <p>Expected Output:</p>
  
  <pre><code>Name    Age
  
  Adam    24
  
  Steve   25
  
  Jhon    23 
  </code></pre>
  
  <p>Is there a way If I can drop the index column before inserting the data into a hive table? </p>