容错合并文件

shiyiming

I think this is a very challenging problem I am facing and I have no idea how to deal with it
Suppose I have two csv files

A.csv
Toyota Camry,1998,blue
Honda Civic,1999,blue
Acura Inf,2000,yellow

B.csv
Toyota Inc. Camry, 2000km
Honda Corp Civic,1500km
HondaUSA Inf, 2000, 2300km

I want to generate C.csv
Toyota Camry,1998,blue ,2000km
Honda Civic,1999,blue,1500km
HondaUSA Inf,2000,yellow,2300km

The worst part of the task is that there needs to be error tolerance to deal with the variations in the company name
1.extra spaces
2.extra dots
3.phrases such as Inc, corp.
4.Create a list of manual translation tables(Acura translates to HondaUSA)

Is this mission impossible?

shiyiming

您到网上下一个车厂的清单，手工转一下好啦，没有程序能在没有额外输入的情况下100%帮您弄对，就算机器人也得学好多次才能让您称心如意。