我有两个csv文件。你知道吗
具有如下文件路径、组、权限的文件1
/path/eds/aws/file1.dat,dp_card,640
/path/eds/aws/file2.dat,dp_card,600
/path/edh/vs/file1.dat,dp_card,640
/pth/edw/de/file1.dat,pdp_card,640
/pth/edn/de/file1.dat,pdp_card,640
文件2的目录路径、组、批所有者如下
/path/eds/aws/,dp_card,dp_batchown
/path/edh/vs/,dp_card,dp_batchown
/path/edw/de/,pdp_card,dp_batchown
我想根据file2中的路径比较两个文件。如果路径存在于文件1中,我想将文件名、组、权限、路径、组写入另一个文件。你知道吗
示例输出:
文件3
/path/eds/aws/file1.dat,dp_card,640,/path/eds/aws/,dp_card
/path/eds/aws/file2.dat,dp_card,600,/path/eds/aws/,dp_card
/path/edh/vs/file1.dat,dp_card,640,/path/edh/vs/,dp_card
/pth/edw/de/file1.dat,pdp_card,640,/path/edw/de/,dp_card
有人能帮我写上面的代码吗。我昨天就开始试了。你知道吗
到目前为止我写的代码。你知道吗
#!/usr/bin/python
import csv
import os.path
csv_dialect = dict(delimiter=',', quotechar='|')
path = set()
with open('hdfs','rb') as file_a :
reader1 = csv.reader(file_a, **csv_dialect)
next(reader1)
for row in reader1:
dirpath = os.path.dirname(row[0])
#absp = abspath[:-1]
path.add(dirpath)
#print(abspath)
with open('file2', 'ab') as file_c:
writer = csv.writer(file_c, **csv_dialect)
with open('lake.csv', 'rb') as file_b:
reader2 = csv.reader(file_b, **csv_dialect)
next(reader2)
for row in reader2:
dirpath1 = os.path.dirname(row[0])
#print(dirpath1)
if (dirpath1) in path:
writer.writerow(row)
#print(row)
熊猫使这非常容易,也非常可读
输出文件3.txt:
相关问题 更多 >
编程相关推荐