title: How to format the index column of excel while using dataframe to convert xls to csv Python
body: <p>I am trying to convert xls to csv using python df. However I am not able to remove the \n or whatever is present in the index col of the excel.</p>
  
  <p>The input excel : </p>
  
  <p><a href="https://i.stack.imgur.com/QKYkR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QKYkR.png" alt="Input excel"></a></p>
  
  <p>And the output is printing the words in brackets in different lines.</p>
  
  <p>The expected output is like : </p>
  
  <p><a href="https://i.stack.imgur.com/gIT7V.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/gIT7V.png" alt="output csv"></a></p>
  
  <p>The Code is :</p>
  
  <pre><code>  data_xls = pd.read_excel('/home/scripts/usless/HP_PO_hist.xls', 'sheet1', index_col=4,skiprows=3)
    data_xls.to_csv('HH_PO_output.csv', encoding='utf-8')
  </code></pre>
  
  <p>But this is scrambling the index line. How to handle this?</p>