iterating through importing .csv files and exporting this files to .xlsx file

  operating-system, pandas, python

I have data files CSV (more than 100) and I want to import CSV file by pandas, fix the data (adjust type of columns etc), and export this modified data to XLSX file throught for loop. I want the same file name to XLSX as CSV have. I dont know how to do that with using for loop.

Please help and thanks

Source: Python Questions