Đang Thực Hiện

Do some Excel Work

I would like to merge 4 CSV files by a common identifier. In this project's .zip attachment you will find 6 files: County [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], Variable Name [url removed, login to view], Veterans.csv.

I would like to merge [url removed, login to view], [url removed, login to view], [url removed, login to view], and Veterans.csv. Each table has a column called "FIPS". The tables should merged by that column. In database terms, the FIPS value is the primary key for these 4 tables.

The resulting table should have one FIPS column and then all the aggregate columns from the 4 merged tables. Some tables may not have all of the FIPS values. So in the aggregate table, there will be rows that have empty cells for some of the columns. This is fine.

The resulting large table should be delivered as a .csv.

Thanks for considering this project.

-Sam

Kỹ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem thêm: want work arabic site ready ichoose name, contract work excel access, excel vba lookup cut cell, excel 2000 macros work excel 2007, excel vba lookup script, article submission work excel, show project work excel, work excel file, vba export excel 200000 rows, contract work excel, online contract work excel, excel visual basic worksheet name, script excel spreadsheet macro read cells, data entry work excel, excel script copy paste cells macro, work excel database, excel vba paste csv cells, convert columns excel columns rows, surf internet work excel, excel vba cut paste cells, php field name variable, excel macro fill empty cells

Mã Dự Án: #13119571

Đã trao cho:

$10 USD trong 0 ngày
(1 Đánh Giá)
0.0
rohitagarberg

Hi sir, i will merge all the four files based on the FIPS column. If any file doesnt have data for that column then will put blank. thanks

$20 USD trong 1 ngày
(131 Đánh Giá)
5.2

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

DanielVizcaya91

Hi there. My name is Daniel and I would be glad to help you out with this project. I can guarantee an excellent job and deliver as soon as possible. I know my bid is overyour budget, but handling large amount of data i Thêm

$99 USD trong 1 ngày
(78 Đánh Giá)
6.6
$30 USD trong 2 ngày
(15 Đánh Giá)
5.7
$20 USD trong 1 ngày
(19 Đánh Giá)
3.6
codetastic

Hello, I am an experienced Python developer with expertise in data processing automation. I can complete this project quickly and accurately. Regards, Erik

$25 USD trong 1 ngày
(3 Đánh Giá)
2.9
charlysalmu

Hi! I can merge your tables into one clean, correct and free of de-duplicactions CVS file. I have experience processing big sets of data and I pay a lot of attention to my work. I think you would be happy with my re Thêm

$30 USD trong 1 ngày
(1 Đánh Giá)
1.5
shaliniapr996

Expert

$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
davidesquivelde

I can do it with a macro, so you can merger files by yourself in the future. Message me if you need further explanation.

$35 USD trong 1 ngày
(0 Đánh Giá)
0.0
$111 USD trong 1 ngày
(0 Đánh Giá)
0.0
$10 USD trong 3 ngày
(0 Đánh Giá)
0.0
$20 USD trong 1 ngày
(0 Đánh Giá)
0.0
$25 USD trong 1 ngày
(0 Đánh Giá)
0.0
$222 USD trong 1 ngày
(0 Đánh Giá)
0.0
sidharth0211

Hi I am a web developer and have great hands on excel macro and vba and this task can be done hope to hear from you thanks

$55 USD trong 3 ngày
(0 Đánh Giá)
0.0
BettyTekeste

I can do this in about an hour and send it back in CSV format. Also will not have any blank rows where there is no FIPS value. I can send you a clean CSV.

$111 USD trong 1 ngày
(0 Đánh Giá)
0.0
$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
qdcs524

I can provide your need with the day. I presume the finished product is an CSV file with a first column of FIPS and followed by all columns coming from all the four CSV files. I guarantee a prompt delivery for this pro Thêm

$20 USD trong 0 ngày
(0 Đánh Giá)
0.0
macruz11

A proposal has not yet been provided

$15 USD trong 5 ngày
(0 Đánh Giá)
0.0
monoaraakther19

Hi, I will work as per your project description. I will start working right now. I want to show you sample. I am waiting for your response to show you sample and to discuss more about the project. Thanks

$20 USD trong 0 ngày
(0 Đánh Giá)
0.0
Calderonfree24H

Hola entiendo el requerimiento de su oferta, si le interesa me gustaría estar en contacto para realizar el proyecto. Un saludo, espero sus noticias.

$25 USD trong 10 ngày
(0 Đánh Giá)
0.0