Closed

Duplicate data clean up

We have a database with two data sets

1. users which has about 14 000 users records most of which are duplicate.

2. We have contributions which has ids tired to the users database

we are looking for a freelancer who can write a script or come up with a way to

1. filter out all the duplicates so the user records only has unique records

2. merge all the contribution data from the contribution data set to the now unique record from the user table. this would mean be any contribution that has userid of a duplicate which was removed would be merged to the appreciate user .

both data set would be exported and provided as excel files

attached a samples of both data set

Skills: Excel, Database Administration, Machine Learning (ML), Data Processing, Python

See more: plotting csv files excel, plugin outlook attached files, duplicate data, excel macros create text files excel, php script send attached files, export retail pro inventory files excel, create data files excel vba, data clean excel macro, automatically import data multiple files excel, able extract data pdf files excel, excel data clean, excel script duplicate data, excel read data mdb samples, extract data pdf files excel, scrub data files excel, plot data csv files excel, vba form displays duplicate data excel, looking for duplicate data in excel, data clean-up in excel

About the Employer:
( 13 reviews ) Laurel, United States

Project ID: #22419899

34 freelancers are bidding on average $582 for this job

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community (g More

$590 USD in 3 days
(730 Reviews)
8.5
cgullapalli

HI, I am good at Excel Advanced Formulas, Data Cleaning and VBA Programming. I have reviewed both the files with the limited data. Please share the complete files. Looking forward to discuss any important points whil More

$850 USD in 5 days
(866 Reviews)
8.0
Innovative116

Hi there. Recruiter invited me to place the proposal. I am a full time spreadsheet formatting expert. I checked both the sample data sets. Removing duplicate and merging contribution data set will be done with 100% acc More

$850 USD in 5 days
(324 Reviews)
8.3
mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Web Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can data clean up for duplicates and mer More

$600 USD in 5 days
(341 Reviews)
7.9
Ibrahim185

Hi, I am a data processing expert. I can help to remove duplicates from 14 000 users records. Let's discuss and start the work. Best Regards, Ibrahim

$1000 USD in 10 days
(677 Reviews)
7.8
Eagles90

Dear Client, We are interested in your project and ready to go for it. We have read your job description carefully, checked the attached files and understood the project. We will merge both data sets and will elimina More

$400 USD in 2 days
(149 Reviews)
7.9
Webxpert4u

Hello, ***** PRICE NEGOTIABLE. ***** I am 101% sure I can do it in 24-48 hours maximum. My stragey, First I will merge both Data-sets to one master file using conman filter and then will remove duplicates. I am ready More

$345 USD in 2 days
(254 Reviews)
8.0
sergiuloghin

Hello! I can clean the 2 databases. I am available. I will use a VBA script. You will not be dissapointed, I have a big 31% rehire rate. Thank you!

$450 USD in 2 days
(257 Reviews)
7.6
P0L

Hello, I’m an Excel/VBA expert and I can filter out the duplicates and merge the data according to your instructions. I'm fully available and I can start right away. Please check my profile and contact me to discuss. R More

$400 USD in 2 days
(334 Reviews)
7.3
paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application. I plan to use a combination of formulas and VBA code to acc More

$500 USD in 2 days
(221 Reviews)
7.4
zekovicm

Hi there I have checked both type of datasets and I can create VBA script or Python script ( whatever you preffer ) to clean them and merge . I can do it within a day ! Buget is negotiable . Please feel free to More

$345 USD in 1 day
(141 Reviews)
7.4
branislavm

Hello! Is not this a repost of the project or I am wrong? If it is not, sorry, I messed two projects. What I will do here is to use a database to match records and export unique contacts. This is a lot easier to do i More

$650 USD in 7 days
(54 Reviews)
6.8
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. I can write a macro that compares both datasets and gene More

$400 USD in 2 days
(231 Reviews)
6.9
dgled

Hi, I’ve done many similar projects where the task was to extract and clean up duplicate details and rearrange content or to separate info in some columns ( such as names, addresses and products etc.). I do the project More

$800 USD in 7 days
(88 Reviews)
7.1
shoguna2m

Hi there, My name is Mauricio I'm the MS Excel -Python and SQL expert from Trascender Global Team, with 4 years of experience in developing software to manage big amounts of data. I've read the details of your proje More

$700 USD in 7 days
(122 Reviews)
7.0
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss. Thanks, Asad Khan FixIT Consultancy

$588 USD in 10 days
(167 Reviews)
6.6
etuannv

Hi there, I am interested in your project. I would approach your project by using Python to create a script to manipulate the data. I have 4+ years’ experience at Python scripting. If you'd like to view my previous wor More

$750 USD in 7 days
(82 Reviews)
6.6
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered over hundred excel vba projects in the last one year. I am planing to do it with a semi automatic script and manual inspection More

$850 USD in 7 days
(110 Reviews)
6.3
richkumar

Hello Sir, I can do this project and remove duplicate from users records and also merge contribution data from deleted users to appreciate user. I am a experienced in excel expert. I am capable of using lot of Excel f More

$300 USD in 5 days
(112 Reviews)
6.0
caabdul

Hi, I am expert in excel and can clean your data with complete accuracy. Thank

$850 USD in 5 days
(56 Reviews)
6.3