Kapalı

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

Beceriler: Excel, Veri Tabanı Yönetimi, Machine Learning (ML), Veri İşleme, Python

Daha fazlasını gör: 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

İşveren Hakkında:
( 13 değerlendirme ) Laurel, United States

Proje NO: #22419899

Bu iş için 34 freelancer ortalamada $582 teklif veriyor

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 Daha Fazla

$590 USD in 3 gün içinde
(730 Değerlendirme)
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 Daha Fazla

$850 USD in 5 gün içinde
(866 Değerlendirme)
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 Daha Fazla

$850 USD in 5 gün içinde
(324 Değerlendirme)
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 Daha Fazla

$600 USD in 5 gün içinde
(341 Değerlendirme)
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 gün içinde
(677 Değerlendirme)
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 Daha Fazla

$400 USD in 2 gün içinde
(149 Değerlendirme)
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 Daha Fazla

$345 USD in 2 gün içinde
(254 Değerlendirme)
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 gün içinde
(257 Değerlendirme)
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 Daha Fazla

$400 USD in 2 gün içinde
(334 Değerlendirme)
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 Daha Fazla

$500 USD in 2 gün içinde
(221 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(141 Değerlendirme)
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 Daha Fazla

$650 USD in 7 gün içinde
(54 Değerlendirme)
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 Daha Fazla

$400 USD in 2 gün içinde
(231 Değerlendirme)
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 Daha Fazla

$800 USD in 7 gün içinde
(88 Değerlendirme)
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 Daha Fazla

$700 USD in 7 gün içinde
(122 Değerlendirme)
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 gün içinde
(167 Değerlendirme)
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 Daha Fazla

$750 USD in 7 gün içinde
(82 Değerlendirme)
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 Daha Fazla

$850 USD in 7 gün içinde
(110 Değerlendirme)
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 Daha Fazla

$300 USD in 5 gün içinde
(112 Değerlendirme)
6.0
caabdul

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

$850 USD in 5 gün içinde
(56 Değerlendirme)
6.3