Data Transformation

We have several CSV files with bird data (species names & groups, sound descriptions) that we want to link together but their content is not always consistent:

- different date/time notations => split into Year;Month;Day;Time (each could be empty)

- different geo location notations => convert to WGS84 Latitude;Longitude;Elevation

There are 2 CSV files (; semicolon):

- Malaysia 932 lines of CSV

- Brasil 4700 lines of CSV



0003 1;Tawny-breasted Tinamou 1 Song;00:07;Nothocercus julius (26/12/1993 , Podocarpus Cajanuma, Loja, Ecuador, 04.20S,79.10W)

0003 2;Tawny-breasted Tinamou 2 Song;00:23;Nothocercus julius (26/5/1996 06:30h, Páramo El Angel (Pacific slope), Carchi, Ecuador, 00.45N,78.03W)

0004 4;Highland Tinamou 4 Song;00:40;"Nothocercus bonapartei bonapartei. RNA Reinita Cielo Azul, San Vicente de Chucurí, Santander, Colombia, 1700m, 06:07h, 02-12-2007, N6.50'47"" W73.22'30"", song. also: Spotted Barbtail, Andean Emerald, Green Violetear"


- Get data into proper columns

- Find missing Group / Species names

- Convert DateTime to Year;Month;Day;Time

- Convert Location to WGS84 Latitude,Longitude,Elevation

Habilidades: Cartografia & Mapas, Processamento de Dados, Extração de Dados, Processamento de dados, Excel

Veja mais: data transformation tools, data transformation pdf, data transformation machine learning, data transformation example, data transformation ppt, data transformation steps, data transformation log, data transformation in data science, san juan yellow pages data, blue cross data san rafael, jonel san vicente, excel data transformation assignments, data transformation ruby rails, data transformation data conversion, data transformation jobs, outsourced data transformation service providers, data encoder san pedro laguna, data encoder san juan city november 2010, imperial village san vicente pili, quickbooks data transformation

Acerca do Empregador:
( 0 comentários ) Rotterdam, Netherlands

ID do Projeto: #19405612

3 freelancers estão ofertando em média €124 para esse trabalho


This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Mais

€150 EUR in 3 dias
(85 Comentários)

I have good experience in research and I can help you in getting requried data with deep web [login to view URL] many leads do you need?

€111 EUR in 3 dias
(95 Comentários)

I define myself as a perfectionist. Who competes to beat his very own performance and then celebrates. This is something that brings me immense pleasure in the , I used to say, "I am a business student and intend to ho Mais

€111 EUR in 3 dias
(9 Comentários)