In Progress

2019-03-16 : Data Manipulation

I 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

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 Saturdays are the end of the week, so that i know you read the full post. Thanks.

Skills: Data Processing

See more: average cost data manipulation service, excel macro data manipulation, excel data manipulation, thanks reply please find proposal seo, excel assignment data manipulation, data manipulation macro, excel data manipulation outsource, php mysql data manipulation, mysql data manipulation using html, excel data manipulation sigma, aspnet webex backend database data manipulation, database development business plan data manipulation web development, php data manipulation, macros data manipulation, data entry data manipulation, php post data manipulation, data manipulation projects

About the Employer:
( 3 reviews ) Aldie, United States

Project ID: #18966786

Awarded to:

mehranica

Saturdays are the end of the week I saw your file, I can handle the project by some coding very fast. Just message me so I start and you have the result in some hour.

$20 USD in 2 days
(2 Reviews)
0.9

7 freelancers are bidding on average $36 for this job

mjanchi

Hello there. I have experience with data processing. Please share the file with me so I will give you the final price and timeline to be done. I can start working now

$30 USD in 1 day
(8 Reviews)
3.6
Rumairashraf

Hi there! I am expert in Data Entry, I will do your work with full responsibility and deliver in time, let’s talk more in chat Regards!

$25 USD in 1 day
(4 Reviews)
3.2
i0xHeX

"Saturdays are the end of the week" =) Hello, I'm java developer with 3 years experience. The way I would like to do this - write own tools to parse and process the data you have in CSV format, additionaly process More

$30 USD in 4 days
(2 Reviews)
1.2
officedesk

Hi, I can do this and offering you my services. I am able to do this in week's time. How it would be done can be discussed, I can provide you with a jist that first I would be looking for shortest steps to meet your re More

$88 USD in 5 days
(0 Reviews)
0.0
hharrati

Saturdays are the end of the week I am proficient at MS-ACCESS, I can quikly develope queries to : - Separte Business from people - Fin and remove duplicate records - identify missing adresses - and move foreign More

$25 USD in 1 day
(0 Reviews)
0.0
arvindronin

Hi, I’m a data analyst and do data cleaning activities on regular basis. I can help you with your requirements. This is how I plan to do it: 1. Separating business from person is easy and can be done with simple sort f More

$35 USD in 1 day
(0 Reviews)
0.0