python 两个csv文件对此处理

发布网友发布时间：2022-05-10 16:33

共2个回答

懂视网时间：2022-05-10 20:54

这篇文章主要介绍了Python实现求两个csv文件交集的方法,涉及Python针对csv文件的读取、遍历、判断等相关操作技巧,需要的朋友可以参考下

本文实例讲述了Python实现求两个csv文件交集的方法。分享给大家供大家参考，具体如下：

#!/usr/bin/env python
rd3 = open('data_17_17_2.csv')
base = open('data_17_17_3.csv')
wr3 = open('delNoBuyed3DayAndStoreAndInCar4.5.2.csv','w+')
bsData = base.readlines()
i = 1
for key in rd3:
 if key in bsData:
 wr3.write(key)
 if i == 1:
 print key
 i = (i + 1)%100
rd3.close()
base.close()
wr3.close()

热心网友时间：2022-05-10 18:02

input = {}
with open('tst1.csv') as f:
    for line in f:
        key, field1, field2, field3 = line[:-1].split(',')
        input[key] = (key, field1, field2, field3)

with open('tst2.csv') as fr, open('output.csv', w) as fw:
    for line in fr:
        key, field1, field2, field3 = line[:-1].split(',')
        if key in input:
            if input[key][3] != '99991231':
                del input[key]
                continue
            if field3 == '99991231':
                fw.write(','.join(input[key]) + '\n')
                del input[key]
                continue
        fw.write(line)
    content = []
    for key in input:
        fw.write(','.join(input[key]) + '\n')

直接在网页里输入的，没测试。