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

Cerrado Publicado hace 4 años Pagado a la entrega
Cerrado Pagado a la entrega

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

Nº del proyecto: #23978528

Sobre el proyecto

47 propuestas Proyecto remoto Activo hace 4 años

47 freelancers están ofertando un promedio de $462 por este trabajo

mirniyazuddin92

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

$750 USD en 10 días
(338 comentarios)
7.9
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 Más

$750 USD en 10 días
(161 comentarios)
8.0
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 Más

$500 USD en 7 días
(366 comentarios)
8.1
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 Más

$750 USD en 10 días
(222 comentarios)
7.8
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... Más

$500 USD en 7 días
(285 comentarios)
7.9
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 Más

$600 USD en 15 días
(145 comentarios)
7.2
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. Más

$250 USD en 4 días
(215 comentarios)
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 Más

$500 USD en 7 días
(90 comentarios)
7.2
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 Más

$250 USD en 1 día
(101 comentarios)
6.6
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 Más

$750 USD en 7 días
(41 comentarios)
6.5
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 en 7 días
(92 comentarios)
5.9
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. Más

$500 USD en 7 días
(18 comentarios)
6.0
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 en 3 días
(19 comentarios)
4.9
Servicehour24

Hello Dear, Happy to inform you that I'm an efficient Web Researcher and Data Entry Worker. I've reviewed your project's current project. I am able to visit the Organization’s website and research them. After all that Más

$700 USD en 15 días
(6 comentarios)
4.6
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 Más

$500 USD en 30 días
(6 comentarios)
2.5
CHEMELLE

I might be able to complete the job in 2 days but bidded on 4 days, just to be safe, as I haven't seen the document as yet. Relevant Skills and Experience I'm Excellent in Excel and can even write macros.

$300 USD en 4 días
(1 comentario)
1.0
efedriko1234

Hello from Australia. Honest and reliable company delivering on-time and at a low cost. Why us? 1) Same or lower prices than individual developers. 2) Quality service and great communication skills 3) Large pool of hum Más

$500 USD en 7 días
(0 comentarios)
0.0
Danielhev

I have extensive knowledge in the tabulation of information in excel sheets for databases, I can help you with your project in an easy and fast way. Awaiting your comments.

$500 USD en 7 días
(0 comentarios)
0.0
gahtori29

I am a hardworking person punctual and loyal to my work because whatever task is assigned to me. I just get into it. I don't ever see the time. Thankyou Relevant Skills and Experience I have 3 year experience in Natio Más

$555 USD en 10 días
(0 comentarios)
0.0
pythonworkforay

Hi, I am a python data analyst with over 5 years' experience. I have worked on a lot of data pre-processing and cleansing project in the past and presented the output either as a graphical presentation, insertion int Más

$600 USD en 7 días
(0 comentarios)
0.0