python中txt转成csv_python批量转换excl为csv

import pandas as pd

import os

#获取excl

excl_files = []

path = os.getcwd()

print(path)

files = os.listdir(path)

print(files)

for file in files:

# print(file.split(".")[-1])

if file.split(".")[-1] == ‘xlsx‘ or file.split(".")[-1] == ‘xls‘:

excl_files.append(file)

print(excl_files)

#创建文件夹

input_dir = os.path.exists(‘csv‘)

if input_dir is False:

os.mkdir(‘csv‘)

print(input_dir)

#循环转换

for excl_file in excl_files:

print(excl_file)

data = pd.read_excel(excl_file)

input_name = excl_file.split(‘.‘)[0]+‘.csv‘

print(input_name)

csv_path = os.path.join(path,‘csv‘,input_name)

print(csv_path)

data.to_csv(csv_path,encoding=‘utf-8‘,index=False)

#把脚本放在需要处理的文件加下运行就好了

原文地址：https://www.cnblogs.com/lazy-sang/p/13300199.html