Automate address cross-check
Budget: €30 – €250 EUR
I've got a listing of car dealers in two different excel sheets
The file 1 is about 6000 rows from 6 countries , it has country code, name, address, zip code and region. This info is not standardized
I have file 2 with a official dealers list with similar information from my customer
I should automate the process to check if each dealer of file 1 is listed in the second file. Then I would tag that dealer as official in a new column.
Else I would tag the dealer as non official
ChatGPT could be useful to complete this task successfully but not to classify the information as it invents the output too often
The file 1 is about 6000 rows from 6 countries , it has country code, name, address, zip code and region. This info is not standardized
I have file 2 with a official dealers list with similar information from my customer
I should automate the process to check if each dealer of file 1 is listed in the second file. Then I would tag that dealer as official in a new column.
Else I would tag the dealer as non official
ChatGPT could be useful to complete this task successfully but not to classify the information as it invents the output too often