Notes‎ > ‎

Easy Hans Rosling Style Charts

posted 2 Feb 2012, 06:32 by David Sherlock

PREFIX rdfs:
PREFIX jisc:
PREFIX doap:
PREFIX prod:
SELECT DISTINCT ?projectID ?Project ?Programme ?Strand ?Standards ?Comments ?StartDate ?EndDate
WHERE {
?projectID a doap:Project .
?projectID prod:programme ?Programme .
?projectID jisc:start-date ?StartDate .
?projectID jisc:end-date ?EndDate .
OPTIONAL { ?projectID prod:strand ?Strand } .
# FILTER regex(?strand, “^open education”, “i”) .
?projectID jisc:short-name ?Project .
?techRelation doap:Project ?projectID .
?techRelation prod:technology ?TechnologyID .
FILTER regex(str(?TechnologyID), “^http://prod.cetis.ac.uk/standard/”) .
?TechnologyID rdfs:label ?Standards .
OPTIONAL { ?techRelation prod:comment ?Comments } .
}

Cheated and did a pivot table in google spreadsheets, then in R

prod_csv$Date<- as.Date(prod_csv$Date, format = "%d/%m/%y/")
M = gvisMotionChart(data=prod_csv, idvar="Technologies", timevar="StartDate", chartid="Technologies")


The result is something that looks like this:

Currently lives at galadriel.cetis.ac.uk/david/tmp.html
Comments