PATIENT_ID | PATHOLOGIES |
---|---|
12 | null |
12 | null |
3 | patho1 |
3 | null |
5 | patho2 |
2 | patho1 |
12 | null |
如果可以看到,患者ID 12始终为空
PATIENT_ID | PATHOLOGIES |
---|---|
12 | null |
12 | null |
3 | patho1 |
3 | null |
5 | patho2 |
2 | patho1 |
12 | null |
如果可以看到,患者ID 12始终为空
要删除只有"null"
个变量的所有患者,可以使用以下示例:
import csv
from itertools import groupby
with open("input.csv", "r") as f_in:
reader = csv.reader(f_in)
next(reader) # skip header
out = []
for id_, g in groupby(sorted(reader), lambda k: k[0]):
g = list(g)
if all(pathology == "null" for _, pathology in g):
continue
out.extend(g)
with open("output.csv", "w") as f_out:
writer = csv.writer(f_out)
writer.writerow(["PATIENT_ID", "PATHOLOGIES"])
writer.writerows(out)
这将创建output.csv
个:
PATIENT_ID | PATHOLOGIES |
---|---|
2 | patho1 |
3 | null |
3 | patho1 |
5 | patho2 |