import os
import pandas as pd
# 定义文件夹路径
folder_path = 'your_folder_path' # 替换为包含文本文件的文件夹路径
# 列出文件夹中的所有文本文件
text_files = [f for f in os.listdir(folder_path) if f.endswith('.txt')]
# 创建一个Excel Writer
excel_writer = pd.ExcelWriter('output_individual_records.xlsx', engine='openpyxl')
# 遍历每个文本文件
for file_name in text_files:
file_path = os.path.join(folder_path, file_name)
with open(file_path, 'r') as file:
lines = file.readlines()
# 创建一个DataFrame用于存储记录
records = []
record = []
# 逐行处理数据并将每个记录添加到DataFrame
for line in lines:
if line.strip(): # 检查是否为空行
record.extend(line.split())
else:
if record:
records.append(record)
record = []
if record:
records.append(record)
df = pd.DataFrame(records)
df.to_excel(excel_writer, sheet_name=file_name, index=False, header=False)
excel_writer.save()
print("分割并写入完成")