组合CSV文件中相似字符串的值

import csv

def combine_similar_values(csv_file):
    # 读取CSV文件
    with open(csv_file, 'r') as file:
        reader = csv.reader(file)
        rows = list(reader)

    # 组合相似字符串的值
    combined_rows = []
    for i in range(len(rows)):
        row = rows[i]
        combined_row = [row[0]]
        for j in range(1, len(row)):
            if row[j].startswith(combined_row[-1]):
                combined_row[-1] += row[j]
            else:
                combined_row.append(row[j])
        combined_rows.append(combined_row)

    # 将结果写入新的CSV文件
    with open('combined.csv', 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerows(combined_rows)

    print("组合相似字符串的值完成，结果已保存到combined.csv文件。")

# 调用函数进行处理
combine_similar_values('input.csv')