如何从 csv A 获取列，并将列作为 csv B 的键

Question

我正在尝试通过将A.csv中的districtname列映射到国家 CSV 数据库B.csv来更正我的列

以下是我A.csv的内容

"Series","No","districtname","PinCode"
"A","101","Mysuru","570010"
"A","103","D. K. ","574216"
"A","104","Bengaluru","560004"
"A","105","Bengaluru","560010"
"A","106","Doddaballapura","561203"
"A","107","Bengaluru","560002"
"A","109","Bengaluru","560050"
"A","110","Bengaluru","560076"
"A","111","Tumkur ","572112"

B.csv的内容

PinCode,districtname
744112,South Andaman
744101,South Andaman
744103,South Andaman
744104,South Andaman
744201,North And Middle Andaman
744107,South Andaman
744302,Nicobar
744301,Nicobar
744202,North And Middle Andaman
...……

如何使用A.csv中的第PinCode栏作为查找B.csv中提到的官方地区名称的钥匙

csvkit命令行方法将很有帮助。

Answer 1

它是

csvjoin -I --left -c 4,1 fil1.csv file2.csv