title: Reading and Passing Excel Filename with Pandas
body: <p>I want to read excel file with Pandas, delete the header row and the first column and write the resultant data in an excel file with the same name. I want to do it for all the excel files in a folder. I have written the code for data reading and writing but having trouble with saving the data in a file with the same name. The code I have written is like this-</p>
  
  <pre><code>import numpy as np
  import pandas as pd
  import os
  for filename in os.listdir ('./'):
      if filename.endswith ('.xlsx'):
          df = pd.read_excel ('new.xlsx', skiprows=1)
          df.drop (df.columns [0], axis=1, inplace=True)
          df.to_csv ('new.csv', index=False)    
  </code></pre>
  
  <p>How can I automate my code for all the excel files in the same folder?</p>