Wednesday, 7 March 2012

Phylo Table Assemble!

Phew!  It's been a while since I've updated this, partly due to the environmental stats hell I just dragged myself out of.


Anyway.
My friend Peggy has been stalwartly manipulating the data we captured and has been experimenting with ways to use the data, for now I'll be catching up with what we've done in the last couple of weeks.


After we managed to extract all that juicy data from the source paper and some minor data cleaning, we had an Excel file containing each of the 341 species and all the information relating to each one. 
This was then imported into Google Docs, giving us more ways to play around with this data using some of the techniques we'd seen during the Phyloinformatics project.


The first we tried (because it looks cool) was to use display the results on Google maps:


Zooming in on South America you can clearly see the species displayed as green dots.  


Clicking on one of these dots displays the information in a speech bubble.










So far so good, but there's more that can be done with this data than just using the coordinates.  We still have data on the family and orders of species and the locality of the discovery i.e. Continental (C), insular (I) or marine (M).


To visualise this locality and get a grasp of where the majority of discoveries where we tried to make a chart, in this case a pie chart.
Peggy worked out that you first had to aggregate the data by the locality, then simply hit the pie chart button and...










..freshly baked pie chart showing that the majority of species discovered between 1992 - 2000 were found in continental areas.










This is all quite basic stuff, so we're looking at doing something a little more challenging.
More to come.










No comments:

Post a Comment