Extract Lines/Rows of Data from CSV Based on ID Match

$10-100 USD

Completed

Posted

about 10 years ago

$10-100 USD

Paid on delivery

I need to extract complete lines of data from multiple CSV files and save the results as another CSV file. Here is What I have I have hundreds of of source CSV files all with the same formatting. And I have a list of ID's (which are domains such as; [login to view URL], [login to view URL], [login to view URL]) I want the program to 1) read the IDs/domains from a text file or CSV file and then 2) go to each of the source CSV files and match a row/line based on the ID/domain 3) and pull the information and save the data as a results.csv. Keep in mind that I need to be able to make the program scan across many CSV files within one step. (Meaning, if I have 1000 files, I do not want to run it 1000 times.) Attached are sample files. 1 - The list of domains I want data for. 2 - A small sample list of all domains. 3 - The results of the data based on the domains I wanted data for (file 1) being taken from file 2. NOTE: Please tell me how you will build this so that I know you have reviewed the requirements. There are many people who reply to projects before they look at the details. Thank you.

Perl

PHP

Software Architecture

Project ID: 5731925

About the project

14 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@aakbar81

There will be arguments of 2 files first one being the list of domains as in example and the other with the files to scan. Than the final output will be written to results.csv. Each domain will be searched and extracted from each file in the second list file. PM for details.

$100 USD in 1 day

5.0

(16 reviews)

6.8

14 freelancers are bidding on average $86 USD for this job

@rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page !!)... you can never go wrong choosing me :) I look forward to your reply. Thanks. Kind Regards, Rajesh Soni

$154 USD in 1 day

5.0

(891 reviews)

8.5

@mantislin

Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi

$250 USD in 5 days

5.0

(249 reviews)

7.3

@doublebc

Hello, If you have a PC I can create you a Windows desktop app that can do this for you. Question the hundreds of source CSV files are you constantly adding more files or are you using the same ones every time? Also what is the average amount of records in each source file? Thanks Brian

$75 USD in 1 day

5.0

(172 reviews)

6.9

@techvolcano

Hi, We are experts in perl/php/python and complete your task with optimal use of memory. Hope your source csv files are in a single directory. Ready to start now. Thanks.

$80 USD in 1 day

4.9

(278 reviews)

6.8

@CredibilityVN

Hi osensnolf. I have read your requirement, let me tell you how i will to build it :) I'm a programmers and I have experience in the field of Data Processing I look forward to working with you, thank you ! Discuss with me, let me show you my some projects on this issue

$50 USD in 1 day

4.9

(47 reviews)

6.2

@suronjit

I have 3 years experience in web developing .I have sound knowledge in php, jquery, javascript,css and html. I am ready to do this task. Pls check my previous work and hire me sir.I have completed 40 task. Thanks

$50 USD in 1 day

5.0

(14 reviews)

3.6

@sachitjani81

i can do it.............................................................................................

$48 USD in 1 day

4.6

(11 reviews)

3.7

@HeadGr

Is there reason to save result in csv? Mysql database much efficient and usable for results. Anyway, can do what you need. PM me if interested.

$80 USD in 3 days

5.0

(10 reviews)

2.8

@saeedurrasheedsl

Hi Let me do this i have already done a project for you now i am working on odesk . Thanks Saeed

$111 USD in 1 day

3.2

(2 reviews)

3.7

@devanshug

A simple cakewalk job for me, see my previous work, talk to me, I will give you my sample work. Can do it in 2-2.5 hours. Seriously would like to work on this project. Will be quick and fast in delivering accurate product without fuss.

$25 USD in 0 day