Match & Insert Unique ID into Multiple CSV Files Based on Make/Model/Year Data
Budget: €70 – €100 EUR
Description:
We need an experienced freelancer to process multiple CSV files containing motorcycle data (make, model, year, etc.) and match them with a MAIN_FILE that holds the correct and standardized make/model/year information.
Task Overview:
- Each row in the MAIN_FILE has a Unique ID in column one, with verified make/model/year data.
- The other CSV files contain similar data, but the formatting, spelling, or year representation may slightly vary. Sometimes year ranges do overlapp or on entry in the other csv files can be assigend to multiple IDs from the MAIN_FILE, and os on, so its crucila you work smart and focused
- Your job is to accurately match the make/model/year information from the MAIN_FILE with the corresponding entries in the other CSV files and insert the correct Unique ID from the MAIN_FILE into column one of those files.
Requirements:
- High accuracy in matching, even when there are small variations in spelling or formatting.
- Handling minor differences in year representation (e.g., "2019" vs. "19" or "2019/2020").
- Output should be the same CSV files with the Unique ID added in the first column where a correct match is found.
- A script or automated approach is preferred for efficiency, but manual validation may be required to ensure accuracy.
Ideal Freelancer:
- Strong experience in data processing, Python (Pandas), or Excel automation.
- Attention to detail to ensure correct ID assignment.
- Experience working with slightly inconsistent data formats.
If you can deliver precise and efficient results, please let us know how you plan to tackle the task!
We need an experienced freelancer to process multiple CSV files containing motorcycle data (make, model, year, etc.) and match them with a MAIN_FILE that holds the correct and standardized make/model/year information.
Task Overview:
- Each row in the MAIN_FILE has a Unique ID in column one, with verified make/model/year data.
- The other CSV files contain similar data, but the formatting, spelling, or year representation may slightly vary. Sometimes year ranges do overlapp or on entry in the other csv files can be assigend to multiple IDs from the MAIN_FILE, and os on, so its crucila you work smart and focused
- Your job is to accurately match the make/model/year information from the MAIN_FILE with the corresponding entries in the other CSV files and insert the correct Unique ID from the MAIN_FILE into column one of those files.
Requirements:
- High accuracy in matching, even when there are small variations in spelling or formatting.
- Handling minor differences in year representation (e.g., "2019" vs. "19" or "2019/2020").
- Output should be the same CSV files with the Unique ID added in the first column where a correct match is found.
- A script or automated approach is preferred for efficiency, but manual validation may be required to ensure accuracy.
Ideal Freelancer:
- Strong experience in data processing, Python (Pandas), or Excel automation.
- Attention to detail to ensure correct ID assignment.
- Experience working with slightly inconsistent data formats.
If you can deliver precise and efficient results, please let us know how you plan to tackle the task!