summary statistics by universities
md`# summary statistics by universities`
z = require('https://bundle.run/zebras@0.0.11')
vegalite = require("@observablehq/vega-lite@0.1")
d3 = require("d3-fetch@1")
d3v4 = require("d3@4")
inflowData=d3.csv("https://gist.githubusercontent.com/ycfan14/ec535938a24f11054d0e3dffee9feeb6/raw/9c6f2d2df925a6e9ea17c63e8544e4d8d70cfaf1/gistfile1.txt")
outflowData=d3.csv("https://gist.githubusercontent.com/ycfan14/951a95637916e7f3f84f2abfb4e5f369/raw/1ce84c367984a9d7dacbec04b02e76eb66114c14/gistfile1.txthttps://gist.githubusercontent.com/ycfan14/951a95637916e7f3f84f2abfb4e5f369/raw/1ce84c367984a9d7dacbec04b02e76eb66114c14/gistfile1.txt")
yearList={
var tem= z.unique(z.getCol("year",InflowParse))
return tem
}
InflowParse={
var InflowParse=inflowData
for (var i=1; i<=20;i++){
var variable=inflowData.columns[i]
InflowParse=z.dropCol("BERKELEY", z.parseNums(variable, InflowParse))
}
return InflowParse
}
OutflowParse={
var OutflowParse=outflowData
for (var i=1; i<=21;i++){
var variable=outflowData.columns[i]
OutflowParse=z.dropCol("BERKELEY", z.parseNums(variable, OutflowParse))
}
return OutflowParse
}
InflowReshape={
var reshape=[]
for (var j=1;j<=21;j++){
for (var i=0; i<=6;i++){
var variable=inflowData.columns[j]
reshape.push({"University":variable, "year":yearList[i],"number":InflowParse[i][variable]})
}
}
var reshape2=z.filter(r=>r.University!="BERKELEY", reshape)
return reshape2
}
OutflowReshape={
var reshape=[]
for (var j=1;j<=21;j++){
for (var i=0; i<=6;i++){
var variable=outflowData.columns[j]
reshape.push({"University":variable, "year":yearList[i],"number":OutflowParse[i][variable]})
}
}
var reshape2=z.filter(r=>r.University!="BERKELEY", reshape)
return reshape2
}
selectedData = {
switch (chartType) {
case "Inflow": return InflowReshape
case "Outflow": return OutflowReshape
}
}
vegalite({
$schema: "https://vega.github.io/schema/vega-lite/v3.json",
width: 400,
height: 400,
title: "Talents Inflow",
data: {values: selectedData},
mark: {type: "line", tooltip: {"content": "data"}},
encoding: {
x: {field: "year", type: "temporal",
axis: {title: "Year",tickWidth: 5}},
y: {field: "number", type: "quantitative",
axis: {title: "Number of talents migrating"}} ,
color: {field: "University", type: "nominal"}
}
})
embed = require("vega-embed@3")
d3_5 = require("d3@5")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
