Do some Excel Work

$10-30 USD

Завершено

Опублікований

over 7 years ago

$10-30 USD

Оплачується при отриманні

I would like to merge 4 CSV files by a common identifier. In this project's .zip attachment you will find 6 files: County [login to view URL], [login to view URL], [login to view URL], [login to view URL], Variable Name [login to view URL], Veterans.csv. I would like to merge [login to view URL], [login to view URL], [login to view URL], 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

Data Entry

Data Processing

Excel

ID проекту: 13119571

Про проект

17 пропозицій(-ї)

Дистанційний проект

Активність 7 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@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 день

5,0

(234 відгуки(-ів))

6,0

17 фрілансерів(-и) готові виконати цю роботу у середньому за $53 USD

@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 is sometimes complicated, and requires some measures to avoid messing up the data. Thanks

$99 USD за 1 день

4,7

(93 відгуки(-ів))

6,8

@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 день

4,9

(10 відгуки(-ів))

4,4

@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 results. Feel free to contact me if you have any questions.

$30 USD за 1 день

5,0

(3 відгуки(-ів))

2,5

@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 день

0,0

(0 відгуки(-ів))

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 за 3 дні(-в)

0,0

(0 відгуки(-ів))

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

$20 USD за 0 день