python数据处理

Question

用python读取csv文件1，拿每一行的数据去跟csv2文件的数据进行匹配，取出文件2里包含文件1关键字的数据输出写入到新文件

文件1

表头
admin
root
qwer

文件2

ip	passwd
10.6.0.12	1qwer123!
10.6.0.22	123root123
10.6.0.32	pas213
10.6.0.42	pass21
10.6.0.52	adminroot

运行结果输出到新文件

ip	passwd
10.6.0.12	1qwer123!
10.6.0.22	123root123
10.6.0.52	adminroot

把包含文件1中关键字的密码 输出到一个新的csv文件里

Answer 1

with open('1.csv', 'r') as f:  # 读取1
    for line in f.readlines():
        passwd = line.replace('\n', '')
        # print(passwd)
        with open('2.csv', 'r') as f2:  # 读取 2
            for line_2 in f2.readlines():
                ip = line_2[:-1].split('    ')[0]
                passwd2 = line_2[:-1].split('    ')[1].replace('\n', '')
                if passwd2 == passwd:
                    with open('3.csv', 'w') as f3:  # 写入3
                        f3.write(ip + '\t' + passwd)