Em Andamento

Excel file data cleaning

i have an excel file with 48,806 rows, with the following columns/fields: First Name, Last Name, Email, Address, City, State, Zip Code, Phone Number, Date of Birth, Gender, Date Acquired, IP address. i wish for this data to be cleaned in the way described below. for data that has been cleaned, put a copy of the raw row in a new tab called "cleaned". for the data that has been removed, put the data in a tab called "removed" 1. no all-caps for any of the fields, except the 2 character state. for names, addresses, city, etc. that have all-caps change to capital first letter, lowercase for the rest of the characters. e.g. "PAUL SMITH" = Paul Smith e.g. "NEW YORK" = New York 2. remove rows that have 4 digit zip codes 3. remove rows that have hyphens ("-") in either the first or last name 4. remove rows that have periods (".") in either the first or last name 5. remove rows that, for the address value, don't have the format "street name[space] number...." e.g. "123 Baker St." is ok "123Baker St." not ok, and should be removed 6. Remove duplicate rows that have the same value for: (a) Phone (b) Email (c) First Name, Last Name pairs (e.g. remove 1 "Peter Smith" row if there are 2 rows with that first & last name pair) (d) IP address

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

.xls

Habilidades: Reescrever Artigos, Redação Publicitária, Pesquisa de Mercado, Research Writing, Redação técnica

Ver mais: writing caps, writing email address, writing letter format, writing character letter, working first data, smith hire, new hire letter, letter writing sites, letter writing format, letter writing address, hire smith, format writing letter, first new york, first capital, cleaning web site, character writing, capital new york, t paul, request letter writing format, excel party hire, writing removed, st place, raw file, hire excel, hire letter writing

Acerca do Empregador:
( 303 comentários ) Los Altos, United States

ID do Projeto: #3065547

Premiar a:

Csha

See private message.

$21.25 USD em 2 dias
(10 Avaliações)
3.7

61 freelancers estão ofertando em média $61 para este trabalho

cybersolutionvw

See private message.

$68 USD in 2 dias
(86 Comentários)
5.7
allystudios

See private message.

$42.5 USD in 2 dias
(34 Comentários)
4.9
BrothersTeam

See private message.

$50.15 USD in 2 dias
(60 Comentários)
4.5
reliablecon

See private message.

$170 USD in 2 dias
(42 Comentários)
4.5
pmferreira

See private message.

$17 USD in 2 dias
(18 Comentários)
4.4
renardpaul

See private message.

$17 USD in 2 dias
(12 Comentários)
4.2
rishitavw

See private message.

$42.5 USD in 2 dias
(25 Comentários)
4.2
qualityprof101sl

See private message.

$85 USD in 2 dias
(8 Comentários)
3.6
xcaliberinf

See private message.

$59.5 USD in 2 dias
(13 Comentários)
3.6
SEOCoder

See private message.

$17 USD in 2 dias
(14 Comentários)
3.5
shuvrapintu

See private message.

$76.5 USD in 2 dias
(9 Comentários)
3.5
rushko

See private message.

$42.5 USD in 2 dias
(5 Comentários)
3.3
hwanghendra

See private message.

$68 USD in 2 dias
(9 Comentários)
3.1
webwiz007vw

See private message.

$84.15 USD in 2 dias
(5 Comentários)
3.0
jurassicsoftware

See private message.

$42.5 USD in 2 dias
(4 Comentários)
2.9
fredhoogstadvw

See private message.

$65.45 USD in 2 dias
(4 Comentários)
3.0
flsahsen

See private message.

$42.5 USD in 2 dias
(10 Comentários)
2.7
icharapueu

See private message.

$10.2 USD in 2 dias
(8 Comentários)
2.5
suniraj

See private message.

$59.5 USD in 2 dias
(2 Comentários)
2.2
mkamaleg2000vw

See private message.

$19.55 USD in 2 dias
(2 Comentários)
1.9