How to change the CSV file field separator from ',' to ';'

0

I'm developing a utility to convert XLS and XLSX files to CSV, but I would like the CSV files to come out with a semicolon instead of a comma, here's the code:

# -*- coding: iso-8859-1 -*-
import glob
import pandas as pd

excel_files = glob.glob('D:\Conversao de Dados\Central de 
Utilitarios\PROJETOS\XLS2CSV\excel\*.xlsx') # caminho dos arquivos excel

for excel in excel_files:
    out = excel.split('.')[0]+'.csv'
    df = pd.read_excel(excel) # converte apenas 1 folha por arquivo
    df.to_csv(out) 

Much of the code is not my own and I am not experienced in Python, if anyone can help me, I would be very grateful ...

    
asked by anonymous 11.10.2018 / 18:47

0 answers