使用bash/python合并两个CSV文件

#!/bin/bash
cat file1.csv file2.csv > merged.csv

import csv

def merge_csv(file1, file2, merged_file):
    with open(file1, 'r') as f1, open(file2, 'r') as f2, open(merged_file, 'w') as out_file:
        reader1 = csv.reader(f1)
        reader2 = csv.reader(f2)
        writer = csv.writer(out_file)
        
        # 写入第一个文件的内容
        for row in reader1:
            writer.writerow(row)
        
        # 写入第二个文件的内容
        for row in reader2:
            writer.writerow(row)

# 调用函数进行合并
merge_csv('file1.csv', 'file2.csv', 'merged.csv')

import pandas as pd

def merge_csv(file1, file2, merged_file):
    df1 = pd.read_csv(file1)
    df2 = pd.read_csv(file2)
    
    merged_df = pd.concat([df1, df2])
    merged_df.to_csv(merged_file, index=False)

# 调用函数进行合并
merge_csv('file1.csv', 'file2.csv', 'merged.csv')