Merging CSV files and matching records - to be done IMMEDIATELY!
- or -
Post a project like this2178
$$
- Posted:
- Proposals: 5
- Remote
- #1966649
- Awarded
Description
Experience Level: Intermediate
I'm in a rush, so looking to get this done immediately.
I have 2 CSV files each with about 7,000 records.
Every record in each file has a serial number. One file has serial numbers and map reference data. Another has serial numbers and price data.
I need to merge the files making sure each serial number row has all the correct data on its columns.
File 1 is attached. File 2 is 30mb and can be downloaded here:
https://drive.google.com/open?id=1BSrg5gZ9H7lS5q-kDtSV3oPhybpaR-8a
The completed CSV file will be the 'MSOA Map + AHI' file with an additional column of 'Average House Price' added to it from file1.
I have 2 CSV files each with about 7,000 records.
Every record in each file has a serial number. One file has serial numbers and map reference data. Another has serial numbers and price data.
I need to merge the files making sure each serial number row has all the correct data on its columns.
File 1 is attached. File 2 is 30mb and can be downloaded here:
https://drive.google.com/open?id=1BSrg5gZ9H7lS5q-kDtSV3oPhybpaR-8a
The completed CSV file will be the 'MSOA Map + AHI' file with an additional column of 'Average House Price' added to it from file1.
Jim J.
100% (16)Projects Completed
13
Freelancers worked with
15
Projects awarded
43%
Last project
3 Mar 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
when you want the output?
622813
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies