--- a/index.md +++ b/index.md @@ -19,9 +19,6 @@ # General References {#general-data-hacking-and-programming-references} - -## Who can be a hack day participant -There are many roles you can play as a hack day participant; coder, designer UX/graphics. ## The basics of being a data scientist @@ -68,13 +65,12 @@ [](http://progit.org/book/) -[http://progit.org/book/](http://progit.org/book/) - -[http://svnbook.red-bean.com/](http://svnbook.red-bean.com/) - -[http://tortoisesvn.net/](http://tortoisesvn.net/) - -[http://code.google.com/p/tortoisegit/](http://code.google.com/p/tortoisegit/) +[tutorials on git](http://progit.org/book/) and +[GUIs to help you](http://code.google.com/p/tortoisegit/) + +[manual for Subversion](http://svnbook.red-bean.com/) +and a [similar GUI for Subversion](http://tortoisesvn.net/) + ### Task Tracking @@ -123,12 +119,13 @@ Atlassian have a great page on what makes a good API https://developer.atlassian.com/display/REST/Atlassian+REST+API+Design+Guidelines+version+1) -howto.gov api resources about choosing SOAP vs. REST etc. http://www.howto.gov/mobile/apis-in-government - -API documentation is important too. - - WSDL or http://swagger.wordnik.com/ or https://github.com/mashery/iodocs - - Many web app frameworks can generate the documentation for you. For example Symfony for PHPhttp://symfony.com/ https://github.com/FriendsOfSymfony/FOSRestBundle http://williamdurand.fr/2012/08/02/rest-apis-with-symfony2-the-right-way/ https://github.com/nelmio/NelmioApiDocBundle better apis https://github.com/liip/LiipHelloBundle - - or for Rails https://github.com/elc/rapi_doc https://github.com/Pajk/apipie-rails +HowTo.gov has a bunch of api resources about choosing SOAP vs. REST etc. http://www.howto.gov/mobile/apis-in-government + +API documentation is important too! Traditionally for SOAP APIs, you use WSDL but for REST try [Swagger](http://swagger.wordnik.com/) or [iodocs](https://github.com/mashery/iodocs) +Many web app frameworks can generate the documentation for you. For example Symfony for PHP http://symfony.com/ https://github.com/FriendsOfSymfony/FOSRestBundle http://williamdurand.fr/2012/08/02/rest-apis-with-symfony2-the-right-way/ https://github.com/nelmio/NelmioApiDocBundle +Or for Ruby on Rails there is is https://github.com/elc/rapi_doc https://github.com/Pajk/apipie-rails + + better apis https://github.com/liip/LiipHelloBundle http://amberonrails.com/building-stripes-api/ @@ -152,11 +149,11 @@ - https://graphics.stanford.edu/wikis/cs448b-12-fall/ data viz theory - http://drawingbynumbers.org/toolsandresources + - http://selection.datavisualization.ch/ data viz tools catalog examples - http://sunfoundation.tumblr.com/ ### The Open Budget -tools - http://selection.datavisualization.ch/ data viz tools catalog ## Web Applications @@ -216,28 +213,30 @@ Backend frameworks http://helios.io/ https://www.parse.com/ ### Examples -bom water, - -nz gov budget +Bureau of Meteorology Water Storage App http://icelab.com.au/work/bureau-of-meteorology/ + +NZ Gov budget http://www.treasury.govt.nz/budget/app # Geographical Data Tools {#geographical-data-tools} -Check out the[ GeoRabble Boundary Mapper's Cookbook](http://georabble.org/2012/05/31/the-boundary-mappers-cookbook/) to see how you can tie all these things together! +Check out the [GeoRabble Boundary Mapper's Cookbook](http://georabble.org/2012/05/31/the-boundary-mappers-cookbook/) to see how you can tie all these things together! ## Key datasets - - base layers like agri http://agri.openstreetmap.org/, http://irs.gis-lab.info/ wms or http://www.gdal.org/frmt_wms_openstreetmap_tms.xml - ASGS including suburbs/postcodes - - andrewharvey4.wordpress.com postgis/asgs tutorial +base layers like agri http://agri.openstreetmap.org/, http://irs.gis-lab.info/ wms or http://www.gdal.org/frmt_wms_openstreetmap_tms.xml + +ASGS from ABS including suburbs/postcodes andrewharvey4.wordpress.com postgis/asgs tutorial +You can also get KML layers for various statistical measures on the ABS TableBuilder tool. + ## Wrangling ### Converting There are many spatial data formats and often the one your tool requires is not the one the dataset is provided in Online - http://converter.mygeodata.eu/vector kml exporter for shp -or locally using GDAL - -### geocoding +or locally using GDAL (better for many megabyte datasets) + +### Geocoding cloudmade, google (but you must display on a Google Map). Easiest way to do is with a Google Spreadsheet/Fusion Table http://williamparry.blogspot.com.au/2011/04/putting-data-into-google-fusion-tables.htm http://support.google.com/fusiontables/answer/1012281?hl=en&ref_topic=2592806 @@ -324,7 +323,7 @@ - http://chartsnthings.tumblr.com/post/36978271916/r-tutorial-simple-charts http://flowingdata.com/2012/12/17/getting-started-with-charts-in-r/ http://www.r-bloggers.com/to-plot-them-is-my-real-test/ - + http://blog.revolutionanalytics.com/2013/04/visualize-large-data-sets-with-the-bigvis-package.html 10 Million Points in 5 seconds. ## Visualisation @@ -332,9 +331,10 @@ Create visualisations from various data formats by dragging and dropping. Free trial available on website. [](img/Tableau-Screenshot.jpg) -### [Flotr2](http://www.humblesoftware.com/flotr2/)/[Google Chart Tools](https://developers.google.com/chart/) - +### Web page (Javascript) graphs +[Flotr2](http://www.humblesoftware.com/flotr2/)/[Google Chart Tools](https://developers.google.com/chart/) [](img/How-to-participate-in-GovHack_html_m11006fce.jpg)Javascript based charts for webpages. +http://www.polychartjs.com/ Allows facetting and easy use of JSON data sets. ### D3.js (Data-Driven Documents) @@ -349,26 +349,39 @@ ### Processing.js # Unstructured (Text) Data Tools -Most of thw world's dat isn't structured because it is contained in documents (webpages, tweets etc.). Sometimes it is possible to structure it, sometimes there are tools that are better suited it unstructured data. -## wrangling -Scraperwiki pytemplate scrapy -regex - -## analysing +Most of the world's data isn't structured because it is contained in documents (webpages, tweets etc.). Sometimes it is possible to structure it, sometimes there are tools that are better suited it unstructured data. +## Wrangling +For extracting data from webpages, checkout Scraperwiki pytemplate scrapy + +PDFs - http://source.mozillaopennews.org/en-US/articles/introducing-tabula/ for text PDFs or http://www.reporterslab.org/dochive/ for imafges + +If there is no way to form a table structure to be able to apply tabular data techniques , you need a more sophisticated analysis as detailed below. + +## Analysing +Natural Language Processing - opennlp/nltk / https://github.com/clips/pattern + +A search engine just for your dataset can also help - lucene/solr + +For light weight analysis, try R or Ruby - http://www.r-bloggers.com/simple-text-mining-with-r/ + - http://blog.josephwilk.net/ruby/latent-semantic-analysis-in-ruby.html similar terms usually found together -## visualising - -Overviewer/ Jigsaw -http://www.cc.gatech.edu/gvu/ii/jigsaw/ - -http://www.jasondavies.com/wordtree/ +## Visualising + +Make word trees of blocks of text, webpages or twitter account and share them http://www.jasondavies.com/wordtree/ + +"Overview automatically sorts thousands of documents into topics and sub-topics, by reading the full text of each one." Simply make a CSV file with two columns, id and text. 10,000 documents is a good limit for the current state of the system. https://www.overviewproject.org/ + +For larger document sets or for alternative visualisations, try Jigsaw a desktop based application. http://www.cc.gatech.edu/gvu/ii/jigsaw/ + + # Graph (relationships and networks) Data Tools {#graph-relationships-and-networks-data-tools} +Why? Find communities, hubs, connections between (the X degrees of separation) - http://www.slideshare.net/OReillyStrata/visualizing-networks-beyond-the-hairball - http://blog.sciencenet.cn/blog-554179-622011.html SNA tools catalog - https://github.com/jacomyal/osdc2012-sigmajs-demo sigmajs filtering/searching @@ -377,7 +390,7 @@ ## Analysis ### R - +http://www.slideshare.net/ianmcook/social-network-analysis-in-r - http://is-r.tumblr.com/post/38240018815/making-prettier-network-graphs-with-sna-and-igraph @@ -388,11 +401,8 @@ - http://www.slideshare.net/maxdemarzi/etl-into-neo4j http://blog.neo4j.org/2013/03/importing-data-into-neo4j-spreadsheet.html -http://www.orientdb.org/ - -http://thinkaurelius.github.com/titan/ - -Major graph databases like theese can be accessed using a common tool like Gremlin or by writing a simple Java/Python/Ruby application. Queries can be tested in the built in data browser. +There are other graph databases worth considering like [OrientDB](http://www.orientdb.org/) or [Titan](http://thinkaurelius.github.com/titan/) +Major graph databases like these can be accessed using a common syntax called Gremlin or by writing a simple Java/Python/Ruby application. Queries can be tested in the built in data browser. @@ -401,11 +411,13 @@ [](img/chess_masters.png) NetworkX is a social network analysis library for python. Many advanced analyses built in like finding communities within a graph. Also good for converting data into graphs. + +tutorial/intro http://www.cl.cam.ac.uk/~cm542/teaching/2011/stna-pdfs/stna-lecture11.pdf ## Visualisation ### Tree/Hierarchy visualisation -Sometimes what you actually have is a tree/hierarchy with no interconnections. +Sometimes what you actually have is a tree/hierarchy with no interconnections. In these cases, it's better to use a Tree visualisation. http://www.randelshofer.ch/treeviz/ http://thejit.org/demos/ http://mbostock.github.com/protovis/ex/treemap.html http://blog.pixelingene.com/2011/07/building-a-tree-diagram-in-d3-js/d3 for Trees and Hierarchies http://mbostock.github.com/d3/ex/pack.html http://mbostock.github.com/d3/ex/tree.html