Skip to content

Instantly share code, notes, and snippets.

View suensummit's full-sized avatar
🚀
Liftoff

Summit Suen suensummit

🚀
Liftoff
View GitHub Profile
/**
* Fetching data from BigQuery and present it in our sheet
* Author: Ido Green
* Date: 14/12/2013
*
* See: http://wp.me/pB1lQ-19i
* Misc: https://developers.google.com/bigquery/
*/
//
World cup data analysis script!!
The data in cup.txt is taken from wikipedia(http://en.wikipedia.org/wiki/2014_FIFA_World_Cup_squads). the script cup.r analyses the data to create interesting charts about the 2014 world cup squads. Charts include boxplots og age, number of home/foreign based players for each country, clubs with more than 4 players in the world cup and leagues with more than 10 players in the World cup.
The data shows that the youngest team is the Netherlands(Dutch) team is the youngest. Only Mexico, Netherlands, Spain, England, Italy, Russia, germany and Iran have more home-based players than foreign based players. Most teams have less players based in their home countries. The European clubs dominate the number of clubs with the most players in the worls cup (gaian not a suprise)!! The world cup 2014 appears to be a sort of "European Cup"!!