Need help in Python code. My requirement is to extract all the excel files from source folder, convert to csv, move these csv files to target folder and delete all excel files in source folder. I tried the following command but it just converts the excel files to csv.
path_to_excel_files = glob.glob('path/to/excel/files/*.xlsx')
for excel in path_to_excel_files:
out = excel.split('.')+'.csv'
df = pd.read_excel(excel)