Käynnissä

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

Taidot: tiedonsyöttö, tietojenkäsittely, Excel

Näytä lisää: 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

Tietoa työnantajasta:
( 1 arvostelu ) Goleta, United States

Projektin tunnus: #13119571

Myönnetty käyttäjälle:

10 $ USD 0 päivässä
(1 arvostelu)
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 1 päivässä
(131 arvostelua)
5.2

19 freelanceria on tarjonnut keskimäärin 49 $ tähän työhön

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 Lisää

99 $ USD 1 päivässä
(78 arvostelua)
6.6
30 $ USD 2 päivässä
(15 arvostelua)
5.7
20 $ USD 1 päivässä
(19 arvostelua)
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 1 päivässä
(3 arvostelua)
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 Lisää

30 $ USD 1 päivässä
(1 arvostelu)
1.5
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 3 päivässä
(0 arvostelua)
0.0
30 $ USD 1 päivässä
(0 arvostelua)
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 Lisää

20 $ USD 0 päivässä
(0 arvostelua)
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 0 päivässä
(0 arvostelua)
0.0
macruz11

A proposal has not yet been provided

15 $ USD 5 päivässä
(0 arvostelua)
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 10 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
20 $ USD 1 päivässä
(0 arvostelua)
0.0
shaliniapr996

Expert

25 $ USD 1 päivässä
(0 arvostelua)
0.0
25 $ USD 1 päivässä
(0 arvostelua)
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 1 päivässä
(0 arvostelua)
0.0
10 $ USD 3 päivässä
(0 arvostelua)
0.0
111 $ USD 1 päivässä
(0 arvostelua)
0.0
222 $ USD 1 päivässä
(0 arvostelua)
0.0