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

Skills: Cartography & Maps, Data Entry, Data Mining, Data Processing, Excel

See more: 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

About the Employer:
( 0 reviews ) Barendrecht, Netherlands

Project ID: #19349842

Awarded to:


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 More

€30 EUR in 1 day
(0 Reviews)

23 freelancers are bidding on average €165 for this job


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 More

€250 EUR in 3 days
(80 Reviews)

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 More

€250 EUR in 14 days
(53 Reviews)

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 More

€250 EUR in 3 days
(12 Reviews)

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 More

€250 EUR in 5 days
(19 Reviews)

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 in 3 days
(7 Reviews)

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 More

€90 EUR in 3 days
(5 Reviews)

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

€155 EUR in 2 days
(2 Reviews)

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 More

€150 EUR in 3 days
(1 Review)

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 in 3 days
(1 Review)

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

€111 EUR in 2 days
(1 Review)
€155 EUR in 5 days
(0 Reviews)

I complete the work with perfection.

€250 EUR in 7 days
(0 Reviews)

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

€124 EUR in 2 days
(0 Reviews)

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 in 5 days
(0 Reviews)

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 More

€161 EUR in 3 days
(0 Reviews)

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 in 7 days
(0 Reviews)

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 More

€55 EUR in 3 days
(0 Reviews)

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 More

€77 EUR in 3 days
(0 Reviews)

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

€166 EUR in 5 days
(0 Reviews)

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 in 1 day
(0 Reviews)