1 Hour CSV Data Processing Project - Find Close Matching Values in Two CSV Files
Budget: $15 – $25 USD
Project Duration: 1 Hour
Project Output: CSV
Project Type: Data Processing
Project Overview:
I’ve got two csv files:
In File 1 I have a column called: funealHomeName
I want you to find a very close match in the “Title” column in File 2
Once you find a very close match retrieve the “id” from the matching row in File 2
Create a new column in File 1 called “matchedIds”, & insert the “id” value into that field for each row
Skip rows that you can’t find a match, I do not want them removed
5* FEEDBACK WILL BE LEFT FOR YOU
Project Output: CSV
Project Type: Data Processing
Project Overview:
I’ve got two csv files:
In File 1 I have a column called: funealHomeName
I want you to find a very close match in the “Title” column in File 2
Once you find a very close match retrieve the “id” from the matching row in File 2
Create a new column in File 1 called “matchedIds”, & insert the “id” value into that field for each row
Skip rows that you can’t find a match, I do not want them removed
5* FEEDBACK WILL BE LEFT FOR YOU