Python: csv按列划分为ifiles

Question

我有一个具有以下结构的CSV文件：

Column A: Date (1500 records)

Column A: Layer1 (1500 records)

Column B: Layer2 (1500 records)

Column C: Layer3 (1500 records)

Column D: Layer4 (1500 records)

我想把这个文件分成四个新的，这样新的文件只有两列(很明显是它的记录)：Column Date + Column Layer。所以在这个例子中：

File Record1.csv: Date + Layer1

File Record2.csv: Date + Layer2

File Record3.csv: Date + Layer3

File Record4.csv: Date + Layer4

Answer 1

下面是一个可以尝试的示例代码

import csv
import json

a = open("t.csv", "r")
wa1=open("Record1.csv", "w")
wa2=open("Record2.csv", "w")

wr1 = csv.writer(wa1, dialect='excel')
wr2 = csv.writer(wa2, dialect='excel')

fieldnames = ("Date","Layer1")
reader = csv.DictReader( a, fieldnames)
for row in reader:
    wr1.writerow([row["Date"]])
    wr2.writerow([row["Layer1"]])

wa1.close()
wa2.close()