我有兩個 CSV 文件需要幫助映射/合并：CSV 文件 1："ID","Name","Flavor""45fc754d-6a9b-4bde-b7ad-be91ae60f582","test1","m1.medium""83dbc739-e436-4c9f-a561-c5b40a3a6da5","test2","m1.tiny""ef68fcf3-f624-416d-a59b-bb8f1aa2a769","test3","m1.medium"CSV 文件 2："Name","RAM","Disk","VCPUs""m1.medium",4096,40,2"m1.xlarge",16384,160,8"m1.tiny",128,1,1理想的輸出是："ID","Name","Flavor","RAM","Disk","VCPUs""45fc754d-6a9b-4bde-b7ad-be91ae60f582","test1","m1.medium",4096,40,2"83dbc739-e436-4c9f-a561-c5b40a3a6da5","test2","m1.tiny",128,1,1"ef68fcf3-f624-416d-a59b-bb8f1aa2a769","test3","m1.medium",4096,40,2請注意，Flavor在 CSV 文件 1 中和Name在 CSV 文件 2 中是相同的。名稱上的差異是用于提取信息的不同工具的結果。另請注意，CSV File2 有一個flavor/name m1.xlarge. 如上所述，如果m1.xlarge flavor/name在 CSV File1 中未找到 ，則應將其從合并輸出中丟棄。我整天都在做這件事，結果好壞參半。任何想法，將不勝感激。
3 回答
斯蒂芬大帝
TA貢獻1827條經驗 獲得超8個贊
你可以使用這個awk：
awk -v hdr='"ID","Name","Flavor","RAM","Disk","VCPUs"' 'BEGIN {
FS=OFS=","
print hdr
}
NR == FNR {
a[$1] = $2 FS $3 FS $4
next
}
$3 in a {
print $0, a[$3]
}' file2.csv file1.csv
"ID","Name","Flavor","RAM","Disk","VCPUs"
"45fc754d-6a9b-4bde-b7ad-be91ae60f582","test1","m1.medium",4096,40,2
"83dbc739-e436-4c9f-a561-c5b40a3a6da5","test2","m1.tiny",128,1,1
"ef68fcf3-f624-416d-a59b-bb8f1aa2a769","test3","m1.medium",4096,40,2
白豬掌柜的
TA貢獻1893條經驗 獲得超10個贊
像這樣的東西，但你必須玩轉報價選項才能看到你喜歡什么。
#!/usr/bin/env python3
import csv
by_name = {}
with open('b.csv') as b:
for row in csv.DictReader(b):
name = row.pop('Name')
by_name[name] = row
with open('c.csv', 'w') as c:
w = csv.DictWriter(c, ['ID', 'Name', 'Flavor', 'RAM', 'Disk', 'VCPUs'])
w.writeheader()
with open('a.csv') as a:
for row in csv.DictReader(a):
try:
match = by_name[row['Flavor']]
except KeyError:
continue
row.update(match)
w.writerow(row)
輸出：
ID,Name,Flavor,RAM,Disk,VCPUs
45fc754d-6a9b-4bde-b7ad-be91ae60f582,test1,m1.medium,4096,40,2
83dbc739-e436-4c9f-a561-c5b40a3a6da5,test2,m1.tiny,128,1,1
ef68fcf3-f624-416d-a59b-bb8f1aa2a769,test3,m1.medium,4096,40,2
撒科打諢
TA貢獻1934條經驗 獲得超2個贊
如果我正確理解了您的問題，并且您想根據列中的字符串將第一個文件中的行與第二個 csvFlavor中的列中具有該值的行進行匹配Name，那么這很容易做到xsv（您'可能需要先安裝）：
$ xsv join "Flavor" file1.csv "Name" file2.csv
ID,Name,Flavor,Name,RAM,Disk,VCPUs
45fc754d-6a9b-4bde-b7ad-be91ae60f582,test1,m1.medium,m1.medium,4096,40,2
83dbc739-e436-4c9f-a561-c5b40a3a6da5,test2,m1.tiny,m1.tiny,128,1,1
ef68fcf3-f624-416d-a59b-bb8f1aa2a769,test3,m1.medium,m1.medium,4096,40,2
您還必須刪除重復的Name列，您可以xsv再次使用它：
$ xsv join "Flavor" file1.csv "Name" file2.csv | xsv select ID,Name,Flavor,RAM,Disk,VCPUs
ID,Name,Flavor,RAM,Disk,VCPUs
45fc754d-6a9b-4bde-b7ad-be91ae60f582,test1,m1.medium,4096,40,2
83dbc739-e436-4c9f-a561-c5b40a3a6da5,test2,m1.tiny,128,1,1
ef68fcf3-f624-416d-a59b-bb8f1aa2a769,test3,m1.medium,4096,40,2
添加回答
舉報
0/150
提交
取消