Đã Đóng

CSV Spreadsheet Data Formatting

NOTICE: Please read the specification, review the provided sample then submit your TOTAL bid and time to complete. DO NOT MAKE A FAKE GENERIC BID - YOU WILL BE BLOCKED.

We have 1,053,402 lead entries (minus duplicates which we suspect will leave less than half) 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. While we expect more than half to be duplicates, we also expect many to not have an email or name that would need to be found.

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

Kĩ năng: Excel, Nhập liệu, Xử lí dữ liệu, Web Scraping, Tìm kiếm web

Xem nhiều hơn: php create table csv data, excel data formatting macro, import csv data sql server table, how to create a csv file in excel, csv files lose formatting after save, csv file example, how to save leading zeros in csv format, csv file format, csv format example, convert csv to excel, csv format excel, excel spreadsheet vba data entry form, mysql read delimited csv data, website csv data feed reader, csv data capture, create invoice import csv data, csv data compiler, csv data feed web page, excel chart provide csv data, gridview data formatting aspnet 2005

Về Bên Thuê:
( 0 nhận xét ) Dallas, United States

ID dự án: #27499554

7 freelancer chào giá trung bình $22/giờ cho công việc này


Hello, I recently did a project on freelancer which is very similar to yours so I'm sure I can finish this one as well in no more than 2 days. It would cost a total of $140. Here's a link to the aforementioned project Thêm

$20 USD / giờ
(2 Nhận xét)

Yes, I read your requirement completely I am a professional web researcher and data entry expert. I’ve been working on research, data entry and lead generation projects for the past 2 years, having good skills and know Thêm

$15 USD / giờ
(0 Nhận xét)

Nice to meet you. I have read the description of your project carefully. I am expert in php, Laravel and Codeigniter of php frameworks. As I am a professional web developer, I have lots of project in this area. So, I c Thêm

$20 USD / giờ
(0 Nhận xét)

I am an enthusiastic, self-motivated, reliable, responsible and hard working person. I have good interpersonal skills, am an excellent team worker and am keen and very willing to learn and develop new skills. I am a ma Thêm

$18 USD / giờ
(0 Nhận xét)

i am an python expert i just need the url and demo dataset intially so i can setup sample to you later you can apply the same on real database

$39 USD / giờ
(0 Nhận xét)

Hi I have a PhD in computer science specialized in data analysis. I will give you a high quality work as per your directions. Much obliged to you.

$20 USD / giờ
(0 Nhận xét)

i have done crash course in this field and will be able to handle all the things which company would like to make me do and wont mind to edit same thing serval times according to proposal and is very clam and obedient Thêm

$20 USD / giờ
(0 Nhận xét)