===== Analyze CORDIS data (EU-funded research projects) =====

Since 1994 several thousands of research projects have been funded by the EU. Hundreds of different institutions in many countries have collaborated on a very broad range of research topics. 

We're working on possible visualisations which should help researchers and the public see connections between the different collaborators and topics. Ultimately also showing trending research topics from FP4 until Horizon2020.

===== Raw Data =====
Provided by [[https://open-data.europa.eu]]
  * [[https://open-data.europa.eu/en/data/dataset/cordis-h2020-projects|CORDIS - EU research projects under Horizon 2020 (2014- )]]
  * [[https://open-data.europa.eu/en/data/dataset/cordisfp7projects|CORDIS - EU research projects under FP7 (2007-2013)]]
  * [[https://open-data.europa.eu/en/data/dataset/cordisfp6projects|CORDIS - EU research projects under FP6 (2002-2006)]]
  * [[https://open-data.europa.eu/en/data/dataset/cordisfp5projects|CORDIS - EU research projects under FP5 (1998-2002)]]
  * [[https://open-data.europa.eu/en/data/dataset/cordisfp4projects|CORDIS - EU research projects under FP4 (1994-1998)]]

===== Categories =====

  * Reference
  * Project Title
  * Project Acronym
  * General Information / Description
  * Objectives
  * Activity Area
  * Subject
  * Start Date
  * End Date
  * Duration
  * Status
  * Total Cost
  * Framework Programme
  * Coordinator Country / Organizing Country
  * Contractor Country
  * FPx/H2020
===== Tools =====

==== Data Wrangling ====
  * [[http://openrefine.org|OpenRefine]]
  * [[http://ipython.org|IPython]]
  * [[https://jupyter.org|Jupyter]]
==== Visualization ====
=== Software ===
  * [[https://dc-js.github.io/dc.js/|dc.js - Dimensional Charting Javascript Library]]
  * [[http://d3js.org|D3.js - A JavaScript library for manipulating documents based on data]]
  * [[http://app.raw.densitydesign.org|RAW - The missing link between spreadsheets and vector graphics.]]
=== References ===
  * [[http://solomonkahn.com/us_budget/ | US-Budget]]
  * [[http://www.nytimes.com/interactive/2010/02/01/us/budget.html?_r=0 | NY Times Obama's Budget Proposal]]
  * [[http://openbudgetoakland.org/2012-2013-sankey.html | Open Budget Oakland]] 
  * [[http://www.oecdbetterlifeindex.org/#/11111111111 | OECD Better]]
  * [[https://www.flickr.com/photos/blprnt/sets/72157627854698933/with/6281316931/|138 Years of Popular Science]]
  * [[http://visual.ly/vizbox/startup-universe/show/su/box | Startup Universe]]
  * [[https://www.behance.net/gallery/18719379/The-Life-Cycle-of-Ideas-Popular-Science-Magazine | Life Cycle of Ideas in Popular Science (print)]]
  * [[https://www.behance.net/gallery/Fiorucci-A-slice-for-everyone/14150253 | A slice for everyone (print)]]
  * [[https://www.behance.net/gallery/Selling-at-Sundance/14264353 | Selling at Sundance (Pseudo-3D, print)]]
  * [[http://www.uberresearch.com/visual-portfolios/ | Funding Portfolios (interactive)]]
  * [[http://datavisualization.ch/showcases/relationship-matters/| Relationship Matters (Mulitdimensionale Visuaisierung, print)]]
===== Storytelling =====



==== Ideation Process ====

What stories can be found in the data and how can we visualize them?

{{:project:hackdays2015_08.jpg?350|Blackboard}}
{{:project:hackdays2015_10.jpg?350|Figures Draft 1}}
{{:project:hackdays2015_11.jpg?350|Figures Draft 2}}


Wrangling stories out of chaotic data... with a little help from IPython

{{:project:hackdays2015_07.jpg?300|Cable Salad}}
{{:project:hackdays2015_09.jpg?300|IPython}}
==== Visual Stories ====

===A given set of data can be (mis-)used to tell completely opposite stories===

During FP4 Switzerland got most funding per project. It had only 8 projects in that period, but the 31st most expensive one of the 4k considered. However, only ca. 0.3% of the total funding went to Switzerland.

{{:project:fp4-ch-funding-per-project.jpg?500|}}

<GITHUB upekkha/fp4-storytelling>


===New visualisation tools can show new connections===

Looking at projects during FP4 where Switzerland was the coordinating country, the longest and highly paid projects featured collaborations with Austria and Belgium.

{{:project:duration-cost-country-2.png?900|Duration Cost Country}}

During Horizon2020 (as of June 2015) most funding went towards fusion energy research, which overshadowed other projects funding by an order of magnitude.

{{:project:duration-cost-horizon2020-2.jpg?900|Horizon2020}}
===== Team =====

  * [[user:adi_cam]]
  * [[user:ana]]
  * [[user:ataraxia]]
  * Benjamin
  * Nicole
  * [[user:tillorly]]

> Precautions when surfing in contaminated data fluids: never surf alone or when under the influence of drugs or alcohol, and never dive head first into an unfamiliar source of data. - Barbara Strebel (1997)

===== Links =====
  * [[http://blog.soda.camp/004/|SODA blogpost about the project]]


{{tag>status:concept needs:dev needs:design needs:data needs:expert tag:dataviz tag:research tag:science}}