Data Transformation
€30-250 EUR
Paid on delivery
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:
ID;Track;Duration;Comments
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"
Tasks:
- Get data into proper columns
- Find missing Group / Species names
- Convert DateTime to Year;Month;Day;Time
- Convert Location to WGS84 Latitude,Longitude,Elevation
Project ID: #19349842
About the project
20 freelancers are bidding on average €168 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
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
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
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.
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
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
I am professional in Excel skills, especially I have working experience in the company before I apply for freelancer.com
Seeking your support, I have total 12 years experience as a Data Analyst Typing speed 60-70 wpm I will do my best
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
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
The files , all the information transformation and other matching details will be carefully completed on time
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