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