Normalize a Spreadsheet data set

$30-250 USD

Tamamlandı

İlan edilme:

neredeyse 11 yıl önce

$30-250 USD

Teslimde ödenir

Hello - I have a spreadsheet that has 36,000 records. Each record has 15 text fields shown below. Most of the records have the address combined in one fields such as "985 Parker [login to view URL] Clara, CA 95050" .... I need someone to do three things to the data set. 1. Break the address into the individual fields such as: Address = 985 Parker Ct. City = Santa Clara State = CA Zip = 95050 2. Convert all UPPERCASE text to Sentence Case. 3. Deduplicate the records based on the "Company" field... Deduplicate by using one address, phone and email and then combine the data from the other duplicate fields. ------------------------------------------- Company Website Address City State Zip Country Phone Email LongDescription ShortDescription Skills Logo Category Certification

PHP

Software Architecture

Proje No: 4446906

Proje hakkında

14 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 11 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

Seçilen:

@quatroo

I can do it.

$50 USD 2 gün içinde

5,0

(26 değerlendirme)

4,6

14 freelancers are bidding on average $117 USD for this job

@SigmaVisual

I can help in your project, please check PMB and our ratings/reviews to get idea of our experience. Please let me know if you have any queries.

$231 USD 5 gün içinde

4,8

(270 değerlendirme)

8,2

@wbslivera

Hello, I can help you, thanks

$84 USD 2 gün içinde

5,0

(133 değerlendirme)

5,9

@lolyee

I have considerable experience data cleansing address data for large organisations with data sets exceeding tens of millions of records.

$220 USD 3 gün içinde

5,0

(12 değerlendirme)

6,0

@caprisofts

ready to start.

$147 USD 3 gün içinde

5,0

(46 değerlendirme)

5,4

@arickbro

Hi sir i'm expert in phpexcel, please see pm for more detail

$110 USD 1 gün içinde

5,0

(13 değerlendirme)

5,1

@mfumia

Greetings, I am very interested in your data cleansing project. I have many years of data manipulation/database development experience and I am available to begin work on your project immediately. I would like to examine your data, or at least a subset of your data, prior to any work beginning to better understand the amount of effort that will be required to clean the data as detailed in your project description. Thank you for considering my bid, Matt

$137 USD 5 gün içinde

5,0

(36 değerlendirme)

4,5

@shain22

I can do this please see my private message

$66 USD 8 gün içinde

4,9

(6 değerlendirme)

4,6

@freelancer0101

Defiantly I can provide fair MYSQL/PHP solution in this reagard. thanks

$115 USD 3 gün içinde

4,9

(10 değerlendirme)

4,0

@anbkit

i can do it for you. contact me and give me more detail

$143 USD 3 gün içinde

0,0

(0 değerlendirme)

0,0

@edwardrichmond83

Please check PMB

$88 USD 10 gün içinde

0,0

(0 değerlendirme)

0,0

@mitanjos

Hi I am a new freelancer with 9+ years experience in PHP, Java, MySQL, SQLServer and Data scraping. I feel I can do this in a day or two if my understanding is correct. Rest I am putting on your PM.

$77 USD 3 gün içinde