如何比较CSV文件中的两个表？

Question

我需要从一个csv文件中获取一列，并将此列与另一个csv文件中的另一列进行比较以找到匹配项。你知道吗

我不能用熊猫，我提取表和卡后。。你知道吗

def first():
    with open('1.csv') as csv_file:
        for line in csv_file.readlines():
            array = line.split(',')
            list_pk = array[1]

def sec():
    with open('2.csv') as csv_file:
        for line in csv_file.readlines():
            array = line.split(',')
            list_fk = array[0]

Answer 1

希望对你有帮助

def findMatch():
  with open('old.csv', 'r',  newline='') as t1, open('new.csv', 'r',  newline='') as t2:
    for line1,line2 in zip(t1,t2):
      if line1.split(' ')[colum_index]!=line2.split(' ')[colum_index]:
        print(line1,line2)
findMatch()

• 有关更多帮助，请参阅csv doc
• 有关zip/izip的信息，请参阅zip/izip

使用zip地址

from itertools import zip_longest
def findMatch():
  with open('old.csv', 'r',  newline='') as t1, open('new.csv', 'r',  newline='') as t2:
    for line in zip_longest(t1,t2):
      print(line)
      if line[0]!=line[1]:
        print("nq")
findMatch()

拉链最长参考文献：-zip_longest