Đang Thực Hiện

Bulk Data Extraction to .CSV Files

Data Extraction

I have several data sources ranging from business databases to email lists. All of these data sources are in .csv format. For example, I have a USA business database that includes all businesses in the USA. This data is broken up into 50 individual .csv files (one .csv file per state).

I need to be able to extract and create individual .csv files based on certain filters. For example, I want to create individual .csv files for attorneys based on each zip code. I need a script that can query all the data in a directory (for example the directory that has all the .csv files) and it will output this data into multiple (in most cases thousands) of individual files.

I need to be able to select the filters and the file output needs to be named according to the content of the file.

For example, the attached data sample is a small exert from the state of Alaska. In the same directory, I have 49 other .csv files in the same format. I want to be able to select a couple criteria and run a script to create individual .csv files. For example, if I wanted file creation for Attorneys with SIC code of 811103 separated by zip codes, the script would create a unique .csv file for each zip code for attorneys. If there were 500 records for attorneys in zip code 99501 the name of the output file would be [url removed, login to view] and the next output file might be [url removed, login to view] etc. Running the query on the entire directory containing the .csv files would create tens of thousands of individual .csv files that would be named according to the contents of that file.

This script needs to be able to be loaded locally on the computer with the data. The script needs to be able to have different filters selected to determine the file output.

Kỹ năng: Khai thác dữ liệu, Xử lí dữ liệu, Excel, SQL, Web Scraping

Xem thêm: bulk data extraction, data extraction csv file, named query, excel exert, csv codes, codes sources, business attorneys, attorneys in, attorneys directory, alaska usa, attached files, query creation, files email, database extraction, data query, CSV, bulk file, alaska, csv file business directory, business wanted database, extract excel files, file multiple files, bulk unique content, businesses data, excel extract several files

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

Mã Dự Án: #1080141

Đã trao cho:

silentius

Hi, please see PM, thanks.

$250 USD trong 10 ngày
(1 Đánh Giá)
2.8

58 freelancer đang chào giá trung bình $327 cho công việc này

greggfletcher

Hello, i can help you with this project. If interested please contact me. Thanks.

$400 USD trong 7 ngày
(66 Đánh Giá)
6.7
SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

$400 USD trong 7 ngày
(56 Đánh Giá)
6.7
schandraram

Hello - Please see PMB for details of my bid. Thank you. Chandra Ram

$300 USD trong 5 ngày
(78 Đánh Giá)
6.3
bharanisrihari

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$250 USD trong 5 ngày
(60 Đánh Giá)
6.3
srinichal

I can deliver the script to your needs

$280 USD trong 4 ngày
(30 Đánh Giá)
6.1
aruhat

Dear Client, Please see PM. Regards, Chandni

$750 USD trong 7 ngày
(8 Đánh Giá)
6.0
phpXpertbd

Please see pm. Thanks

$250 USD trong 4 ngày
(19 Đánh Giá)
5.8
panfreelancer

Please check PM. Thanks

$450 USD trong 7 ngày
(50 Đánh Giá)
5.7
svteam

Hi, see PM please. Thanks.

$250 USD trong 1 ngày
(44 Đánh Giá)
5.6
ineedWorkJob

sir plz check pm !

$250 USD trong 3 ngày
(41 Đánh Giá)
5.4
thanhlongfree

Hello. Please check PM

$250 USD trong 5 ngày
(20 Đánh Giá)
5.3
rhomeu

Advanced MS Access with VBA developer here. I can create system in MS Access for you. Please check private message. Thank you!

$250 USD trong 1 ngày
(11 Đánh Giá)
5.3
soner

I can offer my high quality web scraping services to you. Please contact if interested. I am expert.

$650 USD trong 0 ngày
(10 Đánh Giá)
5.2
Krusche

Hi, we have reviewed your description and examples and prototyped the solution. Whereas it is not a too great challenge to parse and process the data and generate the output according to the given filters, it will be q Thêm

$720 USD trong 5 ngày
(21 Đánh Giá)
5.2
aoefmpes

pl check PM

$250 USD trong 5 ngày
(28 Đánh Giá)
4.9
northwolves

See PMB please

$250 USD trong 4 ngày
(40 Đánh Giá)
4.8
rodelacidera

Hi, please check PM. regards

$250 USD trong 2 ngày
(5 Đánh Giá)
4.6
ExactSystems

Please see detail on PMB. regards

$350 USD trong 7 ngày
(5 Đánh Giá)
4.6
telemarketing555

Hi, please check your PM. Thank you.

$250 USD trong 5 ngày
(22 Đánh Giá)
4.3
aptecpymefree

Hi. I Can create your Bulk Data Extraction to .CSV Files program.I have 14 Years of experience in Software development Windows and Web. Expert in Sql Server and .NET. Microsoft Certified as MCP, MCTS, MCPD, MCT. Please Thêm

$250 USD trong 7 ngày
(3 Đánh Giá)
4.1