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

First file has 5580 lines of CSV (; semicolon), Example:


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

Kemahiran: Kartografi & Peta, Pemasukan Data, Perlombongan Data, Pemprosesan Data, Excel

Lihat lagi: data transformation tools, data transformation in data science, data transformation pdf, data transformation example, data transformation ppt, data transformation steps, data transformation log, data transformation machine learning, excel data transformation assignments, data transformation ruby rails, data transformation data conversion, data transformation jobs, outsourced data transformation service providers, quickbooks data transformation, data transformation freelance, data transformation net, Data transformation, Data entry we reacherch, data entry,we, data transformation in r

Tentang Majikan:
( 0 ulasan ) Barendrecht, Netherlands

ID Projek: #19349842

Dianugerahkan kepada:


GO WITH SCIENCE AND EXPERIENCE. I'm a Master holder in computer science. FOR JUST 30 Euros and in JUST ONE DAY from awarding the project, it will be delivered to you in a HIGHER quality than expected. I'm an expert in Lagi

€30 EUR dalam sehari
(0 Ulasan)

23 pekerja bebas membida secara purata €165 untuk pekerjaan ini


Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several comp Lagi

€250 EUR dalam 3 hari
(80 Ulasan)

Hi, I'm interested to work on your project. I can split the information as per your requirement and provide you a quality results. Looks like more manual work is required to complete the task. Please let me know if yo Lagi

€250 EUR dalam 14 hari
(53 Ulasan)

Hi there I have read the job description. Now I use Godaddy([login to view URL]) and AWS. I'm a WordPress developer with 7+ years experience I have skills in HTML5 / CSS3, PHP, ja Lagi

€250 EUR dalam 3 hari
(12 Ulasan)

Greetings We have read the project description and understand the nature of work. We are experienced professionals GIS, RS, Cartography, Spatial Analysis and Python and PHP. Allow us to complete the work. Warmest Rega Lagi

€250 EUR dalam 5 hari
(19 Ulasan)

Simple for you: MSAccess database to import & transform the files. Use Google Map API to transform the Address and the queries... all that you want.

€244 EUR dalam 3 hari
(7 Ulasan)

Hi, I am Monir and it will be my pleasure to assist you with this project. I have read your project description. You can expect from me I strong commitment to a deadline, the highest quality, and a fluid/friendly com Lagi

€90 EUR dalam 3 hari
(5 Ulasan)

Hi, I can format your .csv according to your needs in 2 days. Sincerely, Dmitry

€155 EUR dalam 2 hari
(2 Ulasan)

Hello, I am a GIS Freelancer. I can definitely help you out in GIS related work and of course, I am aware about the species/birds/animals as I am a Parataxonomist too. I have an expertise and hands-on experience Lagi

€150 EUR dalam 3 hari
(1 Ulasan)

Dear Sir, I am an experienced GIS expert and could solve your problem . I have Master degree in GIS from UK, please review my profile . Many thanks Relevant Skills and Experience GIS, Excel

€155 EUR dalam 3 hari
(1 Ulasan)

I have had several such project works in my engineering career and would be apt for this task.

€111 EUR dalam 2 hari
(1 Ulasan)
€155 EUR dalam 5 hari
(0 Ulasan)

I complete the work with perfection.

€250 EUR dalam 7 hari
(0 Ulasan)

I am professional in Excel skills, especially I have working experience in the company before I apply for freelancer.com

€124 EUR dalam 2 hari
(0 Ulasan)

Seeking your support, I have total 12 years experience as a Data Analyst Typing speed 60-70 wpm I will do my best

€255 EUR dalam 5 hari
(0 Ulasan)

My promise to you is toefficient deliver efficient and praiseworthy work in as little time as humanly possible. This is one decision I promise you will not regret. Thank You. Relevant Skills and Experience I have done Lagi

€161 EUR dalam 3 hari
(0 Ulasan)

Hi, I have worked with data wrangling and transformation for ML projects. I would like to work on your project. Let me know if you want to discuss further. Regards, Monir

€200 EUR dalam 7 hari
(0 Ulasan)

Dear Hiring Manager, Thank you for posting your job opening for Data Entry. I have two years of data entry experience and I have performed all of the duties listed in your job description. I have excellent typing sp Lagi

€55 EUR dalam 3 hari
(0 Ulasan)

Hi, Greetings of the Day! Thanks for sharing your requirement and I will be more happy to assist you in this. Given a chance for an interview, I will be happy to discuss in detail about the requirement and assist y Lagi

€77 EUR dalam 3 hari
(0 Ulasan)

The files , all the information transformation and other matching details will be carefully completed on time

€166 EUR dalam 5 hari
(0 Ulasan)

Hi, I am Anthony. I can help you with the tasks you described and I have ideas for theirs further automatisations with excel macros. Regards

€111 EUR dalam sehari
(0 Ulasan)