Devam Ediyor

Normalize a Spreadsheet data set

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 [url removed, login to view] 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

Beceriler: PHP, Yazılım Mimarisi

Daha fazlasını görün: set company logo, logo company ca, ct logo, santa clara email, parker, duplicate website software, certification logo, data normalize, architecture logo company, country state city spreadsheet, logo company architecture, company logo architecture, company spreadsheet, logo phone city, data company logo, company logo architecture company, text spreadsheet, convert spreadsheet php, php data website spreadsheet, spreadsheet phone, spreadsheet convert php, city state spreadsheet, company logo set, city state country data, country city data

İşveren Hakkında:
( 14 değerlendirme ) Felton, United States

Proje NO: #4446906

Seçilen:

quatroo

I can do it.

2 gün içinde 50$ USD
(10 Değerlendirme)
3.7

15 freelancers are bidding on average $120 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.

in 5 gün içinde231$ USD
(226 Değerlendirme)
7.8
arickbro

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

1 gün içinde 110$ USD
(10 Değerlendirme)
4.7
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

in 5 gün içinde165$ USD
(8 Değerlendirme)
4.6
phpmysqlrocks

Ready to complete this task. Thanks

1 gün içinde 54$ USD
(18 Değerlendirme)
4.6
webwist

ready to start.

in 3 gün içinde147$ USD
(24 Değerlendirme)
4.4
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 t Daha fazlası

in 5 gün içinde137$ USD
(35 Değerlendirme)
4.2
freelancer0101

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

in 3 gün içinde115$ USD
(9 Değerlendirme)
4.1
northwolves

Ready to [url removed, login to view] PMB please.

1 gün içinde 88$ USD
(5 Değerlendirme)
2.6
wbslivera

Hello, I can help you, thanks

in 2 gün içinde84$ USD
(4 Değerlendirme)
2.5
shain22

I can do this please see my private message

in 8 gün içinde66$ USD
(1 Değerlendirme)
1.6
anbkit

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

in 3 gün içinde143$ USD
(0 Değerlendirme)
0.0
lolyee

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

in 3 gün içinde220$ USD
(0 Değerlendirme)
0.0
RaiFraz7

I am expert in excel and have 3 year experience in [url removed, login to view] i am doing working for a firm where i am handle 2500 worker sallary and other expense through [url removed, login to view] Give me a chance for work.

in 5 gün içinde77$ USD
(1 Değerlendirme)
0.0
edwardrichmond83

Please check PMB

in 10 gün içinde88$ USD
(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.

in 3 gün içinde77$ USD
(0 Değerlendirme)
0.0