python - 从堆叠的 csv 文件中删除空格和标题

Question

我有两个 .csv 文件(csv1 和 csv2)，如下所示:

csv1:

Quarter  Body   Total requests  Requests Processed
Q3 2019     A               93                  92
Q3 2019     B              228                 210
Q3 2019     C              180                 178
Q3 2019     D               31                  31

csv2:

Quarter  Body   Total Requests  Requests Processed
Q2 2019     A               50                  50
Q2 2019     B              191                 177
Q2 2019     C              186                 185
Q2 2019     D               35                  35

我使用以下代码堆叠了两个 .csv 文件:

with open(pathCsv2, 'r') as f1:
    Csv2 = f1.read()

with open(pathCsv1, 'a') as f2:
    f2.write('\n')
    f2.write(csv2)

这给了我输出:

Quarter  Body   Total requests  Requests Processed
Q3 2019     A               93                  92
Q3 2019     B              228                 210
Q3 2019     C              180                 178
Q3 2019     D               31                  31

Quarter  Body   Total Requests  Requests Processed
Q2 2019     A               50                  50
Q2 2019     B              191                 177
Q2 2019     C              186                 185
Q2 2019     D               35                  35

有没有办法删除连接文件之间的空白行(我认为空白与 csv1 中的最后一行相关)和第二个标题，因此最终输出如下所示:

Quarter  Body   Total requests  Requests Processed
Q3 2019     A               93                  92
Q3 2019     B              228                 210
Q3 2019     C              180                 178
Q3 2019     D               31                  31
Q2 2019     A               50                  50
Q2 2019     B              191                 177
Q2 2019     C              186                 185
Q2 2019     D               35                  35

Answer 1

使用next跳过标题

例如:

with open(pathCsv2, 'r') as f1:
    next(f1) #Skip first line
    Csv2 = f1.read()

with open(pathCsv1, 'a') as f2:
    f2.write('\n')
    f2.write(Csv2)