Skip to main content
 首页 » 编程设计

python之比较两列(在两个文件中),然后打印相似行和不同行

2024年12月31日16jackei

我有两个文件,每个文件包含两列,第一列中的行通常相似。

文件1.csv

C(2)—C(1) 1.5183 
C(3)—C(2) 1.49 
C(3)—C(1) 1.4991 
O(4)—C(3) 1.4104 
H(10)—O(4) 0.964 
C(2)—C(1)—C(3) 59.19 
C(3)—C(1)—H(5) 118.4 

文件2.csv

C(2)—C(1) 1.5052 
C(3)—C(2) 1.505 
C(3)—C(1) 1.5037 
S(4)—C(3) 1.7976 
H(10)—S(4) 1.3445 
C(2)—C(1)—H(6) 117.68 
C(2)—C(1)—C(3) 60.3 
C(3)—C(1)—H(5) 116.99 

这是一个“使用 itertools”的 python 脚本,它比较 file1.csv 和 file2.csv 中的第一个冒号,然后打印类似的行。

import itertools 
 
files = ['file1.csv', 'file2.csv'] 
d = {} 
 
for fi, f in enumerate(files): 
    fh = open(f) 
    for line in fh: 
        sl = line.split() 
        name = sl[0] 
        val = float(sl[1]) 
        if name not in d: 
            d[name] = {} 
        if fi not in d[name]: 
            d[name][fi] = [] 
        d[name][fi].append(val) 
    fh.close() 
 
for name, vals in d.items(): 
    if len(vals) == len(files): 
        for var in itertools.product(*vals.values()): 
            if max(var) - min(var) <= 20: 
                out = '{}\t{}'.format(name, "\t".join(map(str, var))) 
                print(out) 
                break 

输出.csv

C(2)-C(1)        1.5183   1.5052 
C(3)-C(2)        1.49     1.505 
C(3)-C(1)        1.4991   1.5037 
C(2)-C(1)-C(3)   59.19    60.3 
C(3)-C(1)-H(5)   118.4    116.99 

但我找不到同时打印不同行的想法。

我想要的输出:

similar_lines 
C(2)-C(1)           1.5183    1.5052 
C(3)-C(2)           1.49      1.505 
C(3)-C(1)           1.4991    1.5037 
C(2)-C(1)-C(3)      59.19     60.3 
C(3)-C(1)-H(5)      118.4     116.99 
 
different_lines 
O(4)-C(3)           1.4104      non 
H(10)-O(4)          0.964       non 
S(4)-C(3)            non       1.7976 
H(10)-S(4)           non       1.3445 
C(2)-C(1)-H(6)       non       117.68 

请您参考如下方法:

你可以使用itertools.groupby:

import itertools, csv 
file1 = [i+[True] for i in list(csv.reader(open('filename1.csv')))] 
file2 = [i+[False] for i in list(csv.reader(open('filename2.csv')))] 
new_data = [[a, list(b)] for a, b in itertools.groupby(sorted(file1+file2, key=lambda x:x[0]), key=lambda x:x[0])] 
similar = ['{} {}'.format(a, '     '.join(h for _, h, flag in b)) for a, b in new_data if len(b) > 1] 
different = ['{} {}'.format(a, 'non  {}'.format(b[0][1]) if not b[0][-1] else '{}     non'.format(b[0][1])) for a, b in new_data if len(b) == 1] 
last_output = 'similar_lines\n{}\n\ndifferent_lines\n{}'.format('\n'.join(similar), '\n'.join(different)) 

输出:

similar_lines 
C (2)-C(1) 1.5183     1.5052 
C (2)-C(1)-C(3) 59.19     60.3 
C (3)-C(1) 1.4991     1.5037 
C (3)-C(1)-H(5) 118.4     116.99 
C (3)-C(2) 1.49     1.505 
 
different_lines 
C (2)-C(1)-H(6) non  117.68 
H (10)-O(4) 0.964     non 
H (10)-S(4) non  1.3445 
O (4)-C(3) 1.4104     non 
S (4)-C(3) non  1.7976