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
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).