使用Python在CSV文件中将单行文本拆分为同一列的多行

import csv

def split_text_in_csv(input_file, output_file, column_index):
    with open(input_file, 'r', newline='', encoding='utf-8') as infile, \
         open(output_file, 'w', newline='', encoding='utf-8') as outfile:
        
        reader = csv.reader(infile)
        writer = csv.writer(outfile)
        
        for row in reader:
            if len(row) > column_index:
                text = row[column_index]
                split_texts = text.split()  # 这里可以根据需要使用其他分隔符或正则表达式
                for split_text in split_texts:
                    new_row = row[:column_index] + [split_text] + row[column_index+1:]
                    writer.writerow(new_row)
            else:
                writer.writerow(row)

# 使用示例
input_file = 'input.csv'
output_file = 'output.csv'
column_index = 1  # 假设要拆分的列是第二列（索引为1）
split_text_in_csv(input_file, output_file, column_index)