Python解决excel批量转出为csv文件_python把excel按sheet数据转换成csv,unnamed=0怎么去掉

解决excel批量转csv

import pandas as pd
import os
import openpyxl
from pandas import read_csv
from pandas import read_excel
import xlrd
##如果报错，报错的原因是xlrd是最新的包，cmd先卸载包，装1.2.0版本，打开cmd，pip install xlrd==1.2.0

path=r"F:\***\***\***"
pathDir = os.listdir(path)
for f in pathDir:
    data = pd.read_excel(os.path.join(path, f))
    #data = read_csv(f)
    file_name = os.path.basename(f)
    file_name2 = file_name.split('.')[0]
    data.to_csv(r"F:\***\***\***\csv文件\%s.csv" % file_name2,encoding='utf_8_sig')
    print('ok')
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17