2019-03-18 : Data Manipulation

Lezárva Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Lezárva Kiszállításkor fizetve

have an list from core logic or data tree that is exported in CSV format.

This list consists of hundreds to thousands of properties and their owners in the US.

This list consists of two types of owners

1. People

2. Businesses

A person or a business may own multiple properties , and I want to be able to send only one letter per person/business.

The letter will be created through mail merge using a google doc/ms word template.

I have one template for People and a different template for Businesses.

There are a few issues with the list that is generated.

1. It does not tell you who are people and who are businesses. You have to determine that. People tend to have First and Last Name Fields, whereas businesses tend not to.

2. There are people/businesses that own multiple properties, so i need to de-duplicate them

3 There are owners that have non-US addresses, and i want them placed into another tab in excel/google sheets.

4. There are owners with missing addresses that need to be put into another tab for a data entry VA to research/skip-trace.

5. There are addresses that are duplicates, and they need to be researched manually, so they need to be put into another tab.

The goal of the project is to take the original CSV export and clean up the data to

1. separate businesses from people

2. remove duplicate people/businesses

3. identify missing addresses and put them in another tab

4. remove foreign addresses (non-us)

5. and clean up the business names (often TR is an abbreviation for Trust, or it will say Fmly instead of Family, etc)

I am looking for some form of automation that I can run on this list as well as other lists in the future that I export.

Please respond with

1. how you plan to do this,

2. how long this will take

3. when can you start

4. when can you deliver by

To clarify, this is meant to be done with a script/automation of some form that can be handed over to me at the end, so that I can run this on future lists. I don't want this done manually.

Also, i have created this as a fixed-price bid and I have no idea what to expect on the price of this, so do not agree to my price if you can not do it at that price. If you want a higher amount, put in that bid, so that I can properly review the candidates.

I HATE, HATE, HATE when people accept my low offer and then keep begging me for a bonus, etc. Just please, please, please, put in the amount that you think is fair, and I will do my best to accommodate it within reason.

please also respond with "It's already Monday?", so that i know you read the full post. Thanks.

Adatfeldolgozás Python Scripting

Projektazonosító: #18978778

A projektről

7 ajánlat Távolról teljesíthető projekt Utoljára aktív: 4 évvel ezelőtt

7 szabadúszó tett átlagosan 183$ összegű árajánlatot erre a munkára

prameswara

Hello Sir It's already Monday? Im excel VBA macro and formula Expert :) i can do make tools for manipulation data in your csv file Sir please ping me now and im able to start discuss now Thank you Galih

$166 USD 1 napon belül
(193 vélemény)
6.8
ibrahimanjum330

Hi, I am Ibrahim and I am an excel expert, I will do it on excel and it would take 3 days on average, I can give you an exact estimate after I see the data. Regards, Ibrahim Anjum

$166 USD 3 napon belül
(18 vélemény)
4.6
gsanggara

"It's already Monday?" Hi sjva, I know advance excel very well and will complete you task on time with high accuracy. below my response on your project Q&A: 1. how you plan to do this --> I will create excel vb Továbbiak

$150 USD 2 napon belül
(14 vélemény)
3.6
nbprince

It's already Monday? Hey yes its monday and yes I will not need any bonus after work and will do in just 100. and ready to start now.

$100 USD 1 napon belül
(10 vélemény)
3.2
kuvarzf

It's already Monday? 1. Part of the formulas, part of the software. - how you plan to do this. 2. 1-2 days - how long this will take 3. now - when can you start 4. when can you deliver by Dear friend. I have all Továbbiak

$200 USD 2 napon belül
(1 Visszajelzés)
0.0
brainOmind

Hi, I am precise and accurate with the given work. I am also deadline driven and work hard to complete assignments in a timely manner. My dedication attention and organization contribute to my professionalism. I consi Továbbiak

$166 USD 1 napon belül
(2 vélemény)
0.0
tsft

Dear Sir or Madam: I am interested in doing the job. ASAP guaranteed. I will deliver in Excel all you need as well as the macro to build the Word and the Outlook mail done. I wait for your contract. Kind regar Továbbiak

$333 USD 10 napon belül
(2 vélemény)
0.0