Fermé

CSV spreadsheet data formatting

We have 1,053,402 lead entries in CSV files that we need formatted correctly per the following requirements.

The spreadsheets include numerous columns of data but we only want the data detailed below with only two columns required as a minimum if none of the other desired data are available.

The spreadsheets are to be formatted into the following columns:

1. lawyer.first_name, (REQUIRED)

2. lawyer.last_name, (If Available)

3. [login to view URL], (REQUIRED)

4. [login to view URL], (If Available)

5. lawyer.firm_name, (If Available)

6. [login to view URL], (If Available)

7. [login to view URL], (If Available)

8. [login to view URL], (If Available)

9. [login to view URL], (If Available)

10. lawyer.type_of_law (If Available)

- Web search may be required for unique entries that do not have the minimum required "lawyer.first_name" or "[login to view URL]" for a lead to be valid.

- Names to be formatted correctly. First names must be identified as "lawyer.first_name". Wrong data such as "initials", middle names, or "last names" must not be listed as "lawyer.first_name".

- If the name is formatted like: "Formoso Donald B" then Formoso is the last name and Donald is the first name. B is middle initial but not important.

- If the name is formatted like "John H Downs Atty" then John is first name H is middle initial and Downs is last name. "Atty" stands for Attorney and is not important to the list. They may also list Esq or spell out Attorney but we do not need that information.

- Missing "lawyer.first_name" and lawyer.last_name may be derived from the email addresses, other included data or web searching

- Merge leads with duplicate emails.

- Finished data to be separated and delivered in multiple CSV files with each having no more than 10k leads to meet our import restrictions.

- Please see the attached sample of the data to be formatted.

If you are able to complete and deliver this project this week, please submit a competitive bid for the total amount.

Compétences : Excel, Saisie de Données, Traitement de Données, Recherche sur Internet, Web Scraping

en voir plus : mysql using csv update data, excel data formatting macro, google spreadsheet data entry, difference csv csv file data java, gridview data formatting aspnet 2005, perl script insert csv file data mysql, excel spreadsheet data entry, csv form data php, csv joomla data entry, spreadsheet data entry job offering companies, php create save csv form data, excel filling spreadsheet data macro, csv inprt data virtuemart example, create csv form data, importing csv file data grid, csv product data url virtuemart, oscommerce csv file data upload, csv price data

Concernant l'employeur :
( 0 commentaires ) Nairobi, Kenya

Nº du projet : #27462413

15 freelances font une offre moyenne de 463 $ pour ce travail

SueAnayah

Hello, I have read the job description and am able to deliver the job within this week Please send me a message so that we can discuss more. Many thanks Susan.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(22 Commentaires)
6.0
MyAwesomeTeam

Hello sir, - I am confident about this project, I can start right now. Hoping that you will review my cover letter and feedback, I am looking forward to hearing from you. Kind Regards

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(26 Commentaires)
5.3
velmoorthi

I have rich experience in data mining as well as web scraping. I have done many data mining works so far.(i have worked with 8million csv file datas) I assure you i can give you high quality work. thanks in advance Re Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(24 Commentaires)
5.2
darrel131191

Hi there. I am very interested in your proposal. I can instantly help you with your starting project with a successful completion. As a professional software developer, I ensure for a perfect ongoing project. You will Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(1 Évaluation)
3.9
BemaSydykorva

Hi, employer. I have rich experience in scraping and will deliver the result as you want. I feel confident to complete this project. Thank you.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(8 Commentaires)
2.8
dileepkmr332

Hello, I am Dileep Kumar Gupta . I am well expert person to do the work like Data Entry , Copy pasting , Microsoft word work , Excel Work .I do my work with more efficiency .

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
sanjaychary1998

Hello, My name is Sanjay. I am writing to you for the position of data entry expert that you are looking for an urgent basis. Data entry job is my passion and I have 2+ years of experiences in this field that makes me Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(0 Commentaires)
0.0
sirishavenkatram

I have always enjoyed data segregation as being in hotel sales most of our data is raw and has to be converted to an excel and I was always given such data to sort as I was quick and accurate. I would like to take up t Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
dsp1333357

Sir I can do this work very easily , I got a lot of experience from my pervious company, so I can do it very well

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(0 Commentaires)
0.0
riyatandon191

I have been working on several online internships for the past few years and am proficient in data entry and research work. I have worked on creating a database of various businesses and professionals in many sectors. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0
Lekanola

Hello, I've read your project description, I have the required skill set to complete this project. I'm an experienced data analyst and I've worked on several projects similar to this. Please, I would love to work wi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
Danielslwu

I am a power user of Excel and can get this project done for you in time. I can even get it done within one day for a higher rate.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0
rojiravi

I have an excellent speed in MS Excel and have been working with excel for the past 15 years. And also have been working as a Data Analytics Manager, which involves lot of data works to be done in MS Excel.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
patrickwanjohi7

The main task will be in identifying records that need further search and verification where the first names are incomplete or missing. The conversion from CSV to Excel is straight forward and will be followed by the Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
mmakere5

I am hard worker, I will submit my document within time frame, I will use Microsoft word of 2016. I am hard worker, I will submit my document within time frame, I will use Microsoft word of 2016.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0