Encerrado

2019-03-18 : Data Manipulation

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.

Habilidades: Processamento de dados, Python, Scripting

Veja mais: average cost data manipulation service, excel macro data manipulation, excel data manipulation, excel assignment data manipulation, data validation methods market research, data analysis findings qualitative research study, data manipulation macro, excel data manipulation outsource, php mysql data manipulation, mysql data manipulation using html, data mining sql server research, excel data manipulation sigma, aspnet webex backend database data manipulation, database development business plan data manipulation web development, php data manipulation, data manipulation in research

Acerca do Empregador:
( 4 comentários ) Aldie, United States

ID do Projeto: #18978778

9 freelancers estão ofertando em média $200 para esse trabalho

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 em 1 dia
(172 Comentários)
6.5
yesikov1224

Hello ""It's already Monday?" [login to view URL] Credit is my motto. I am expert web scraping. I can do your job with BS4 ,Perl script,Scrapy Seleinum framework of python. I can do any project in your demand completely b Mais

$222 USD in 4 dias
(22 Comentários)
5.2
muller1998926

Hello, dear! It's already Monday? I am interested in your project. I have extensive experience in data analysis such as classification and clustering, feature selection, dimensional reduction, time series analysis, Mais

$300 USD em 1 dia
(4 Comentários)
4.2
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 Mais

$150 USD in 2 dias
(12 Comentários)
3.0
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 in 3 dias
(6 Comentários)
3.0
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 em 1 dia
(5 Comentários)
2.7
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 Mais

$200 USD in 2 dias
(1 Comentário)
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 Mais

$166 USD em 1 dia
(2 Comentários)
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 Mais

$333 USD in 10 dias
(2 Comentários)
0.0