Закрыт

Data scrubbing / clean-up / data format homogenization / duplicates identification

Task Overview

Jones & Frank maintains a database of on-site, customer owned equipment (aka ‘installed products’) in our service management system.

The Installed Product dataset consists of several fields including but not limited to serial number information, make / model of equipment, location information, a warranty start date, and a warranty end date for each piece of serialized equipment.

There can be multiple serialized products tracked for each customer site.

We wish to cleanse/update our current installed product database using information supplied by our OEM partner.

Detailed task requirements

• Cross-reference OEM-supplied data set of approximately 42K records to our Service system dataset using site address, city & state. This will require data format homogenization between the addresses on both datasets to adhere to USPS address standards.

• Identify matched products at each site using serial number field from both data sources. For serial number records matched between both data sets, confirm our existing system dataset reflects the OEM-supplied warranty dates.

• Identify serial numbers in the OEM supplied data set that are missing from our service management database and create .csv file for us to upload.

• Identify duplicate serial number records within the dataset derived from our service system database and provide a .csv file of the duplicates.

Квалификация: Excel, Data Cleansing, Data Analysis

Показать больше excel data entry regular hour format, data sufficiency questions pdf format, data entry image file format, ebay data available sale csv format, clean data rewrite links correct, data base clean wordpress, data scrubbing microsoft excel sheet, free excel clean data guide, clean data macros, data uae companies excel format, microsoft access clean data, clean data excel stata, export data database fannie mae format, excel data scrubbing, clean data processing excel, convert mysql data result csv file format asp, clean data format excel, clean data format, data scrubbing vs data cleansing

О работодателе:
( 0 отзыв(-а, -ов) ) Morrisville, United States

ID проекта: #23978528

49 фрилансеров(-а) в среднем готовы выполнить эту работу за $468

Eagles90

Dear Client, We are interested in your project and ready to go for it. We have done similar projects so confident to complete this on time with accuracy. Can we discuss further if you are available? We look forward Больше

$750 USD за 10 дней(-я)
(152 отзывов(-а))
7.9
schoudhary1553

Hello, I can help you with your project - Data scrubbing / clean-up / data format homogenization / duplicates identification I have gone through your job posting and become very much interested to work with you. I am Больше

$500 USD за 7 дней(-я)
(321 отзывов(-а))
7.9
FINGERRPRINT

Hi there, We can get the missing serial information in csv and duplicate serial in another csv. We can clean and get the data. We worked in many similar work before and sharing a link https://www.freelancer.com/proje Больше

$750 USD за 10 дней(-я)
(203 отзывов(-а))
7.7
seaanddream

Hi, my name is Selim. I am from UK. I read your "Data scrubbing / clean-up / data format homogenization / duplicates identification" project descriptions carefully before bidding. I checked your requirements as well... Больше

$500 USD за 7 дней(-я)
(284 отзывов(-а))
7.8
mirniyazuddin92

Hi there, I can do data scrubbing / clean-up / data format homogenization / duplicates identification.

$750 USD за 10 дней(-я)
(332 отзывов(-а))
7.9
KulfiSoftwares

Excel expert!! I have done several similar projects to remove duplicates/merge similar data/consolidate/cross-reference data... ➤ZERO ERROR GUARANTEED!! Please read my ~400 reviews. I am here to impress you with my wo Больше

$300 USD за 7 дней(-я)
(287 отзывов(-а))
7.5
ksriniravi

Greetings! Thanks for very specific and clear requirements. I can set up formulas for identifying matching, missing and duplicate records for the various steps in the process and then generate appropriate csv files. Больше

$250 USD за 4 дней(-я)
(194 отзывов(-а))
6.8
shoguna2m

Hello, how are you? My name is Mauricio, we can use Phyton or Visual Basic for applications to perform the required task from the database in your system. You can check our profile and also with Michelle, you will se Больше

$600 USD за 15 дней(-я)
(125 отзывов(-а))
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 Больше

$500 USD за 7 дней(-я)
(88 отзывов(-а))
7.1
jkaranm

Hi Future Client, My name Janis, one of the Preferred Freelancers in which you can see a badge in my profile. My business is to make your business effective, profitable & efficient and I believe we can help you wit Больше

$750 USD за 7 дней(-я)
(38 отзывов(-а))
6.4
mateenbhatti94

Dear sir I will update your database according to information supplied by oem. I have been in this industry for 1 year and such jobs are my daily practice. I can assure you that if you work with me once, you will alwa Больше

$250 USD за 1 день
(82 отзывов(-а))
6.4
wsh2

This is difficult to quote without first seeing data. At your earliest convenience, please zip and attach your DATA (in csv, mdb, xls, or other format) to this private chat message thread so we may better analyze and Больше

$800 USD за 7 дней(-я)
(31 отзывов(-а))
6.0
razvancotofana

Hello, I have recently completed several similar excel projects involving data filtering, analysis, and cleansing, and I would be happy to assist you, as well. Please pm me so we can discuss your specific requirements. Больше

$500 USD за 7 дней(-я)
(18 отзывов(-а))
6.0
gatsu58

Hello, I am an expert in data cleansing , my price is very competitive with high quality results. Please message me the details to discuss about price and the project timing. Regards, Santos

$250 USD за 7 дней(-я)
(92 отзывов(-а))
5.8
Developer000

Feel fee to contact me for .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment only after the work [login to view URL] you

$250 USD за 7 дней(-я)
(15 отзывов(-а))
4.7
reubengi

Hi there I have very good experience working with large data sets and cleaning up them to extract the right information. I can deliver on time and quality. Regards Reuben

$250 USD за 3 дней(-я)
(9 отзывов(-а))
3.9
Naumaan

Hi, I am interested in this project. To work according you supplied four points I would like to perform QC over sample data. I will then be able to estimate the actual time period required to clean & data and supply m Больше

$250 USD за 30 дней(-я)
(8 отзывов(-а))
3.5
lual4777

To whom it may concern, Would be happy to work with you to develop a system for this by utilizing the programming language R. Data/text wrangling is definitely in my wheelhouse -My background is in comparative biolog Больше

$650 USD за 20 дней(-я)
(2 отзывов(-а))
3.0
mmointahir786

Hi, Come to chat will discuss about task. I am most experience in Web scraping | Data Mining | Email Scraping | Lead Generation | Database Creation | Excel | Web Research. Having 5 Years of experience and i can assure Больше

$500 USD за 30 дней(-я)
(6 отзывов(-а))
2.5
Norvys

Hi! My name is Norvys, I would love to help you with your project. As a detail-oriented Virtual Assistant, I can follow through tasks quickly. My proficiency in Data Processing and Microsoft Office (among many other sk Больше

$250 USD за 7 дней(-я)
(0 отзывов(-а))
0.0