代码描述:将一个文件夹中的许多csv文件批量转为txt文件,放在一个新的文件夹中,而且要保证txt文件中每一列数据格式是左对齐的。
import csv
import os
def process_csv_file(csv_file_path, txt_file_path):
with open(csv_file_path, 'r', newline='', encoding='utf-8') as file:
reader = csv.reader(file)
all_rows = list(reader)
with open(txt_file_path, 'w', encoding='utf-8') as txt_file:
for row in all_rows:
formatted_row = ' '.join(['{: <9}'.format(cell) for cell in row]) + '\n'
txt_file.write(formatted_row)
# 文件夹路径
folder_path = r'D:\data\csv' # 输入文件夹路径
output_folder = r'D:\txt' # 输出文件夹路径
os.makedirs(output_folder, exist_ok=True)
for file in os.listdir(folder_path):
if file.endswith('.csv'):
csv_file_path = os.path.join(folder_path, file)
txt_file_path = os.path.join(output_folder, file.replace('.csv', '.txt'))
process_csv_file(csv_file_path, txt_file_path)
print("所有CSV文件已转换为TXT格式!")