31:[] 2f:{"title":"summary statistics by universities","cells":[{"id":0,"value":"md`# summary statistics by universities`","pinned":true,"hidden":false,"mode":"ojs"},{"id":6,"value":"z = require('https://bundle.run/zebras@0.0.11')","pinned":true,"hidden":false,"mode":"ojs"},{"id":8,"value":"vegalite = require(\"@observablehq/vega-lite@0.1\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":109,"value":"d3 = require(\"d3-fetch@1\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":104,"value":"d3v4 = require(\"d3@4\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"inflowData=d3.csv(\"https://gist.githubusercontent.com/ycfan14/ec535938a24f11054d0e3dffee9feeb6/raw/9c6f2d2df925a6e9ea17c63e8544e4d8d70cfaf1/gistfile1.txt\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":263,"value":"outflowData=d3.csv(\"https://gist.githubusercontent.com/ycfan14/951a95637916e7f3f84f2abfb4e5f369/raw/1ce84c367984a9d7dacbec04b02e76eb66114c14/gistfile1.txthttps://gist.githubusercontent.com/ycfan14/951a95637916e7f3f84f2abfb4e5f369/raw/1ce84c367984a9d7dacbec04b02e76eb66114c14/gistfile1.txt\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":75,"value":"yearList={\n var tem= z.unique(z.getCol(\"year\",InflowParse))\n return tem\n }","pinned":true,"hidden":false,"mode":"ojs"},{"id":17,"value":"InflowParse={\n var InflowParse=inflowData\n for (var i=1; i<=20;i++){\n var variable=inflowData.columns[i]\n InflowParse=z.dropCol(\"BERKELEY\", z.parseNums(variable, InflowParse))\n }\n return InflowParse \n }","pinned":true,"hidden":false,"mode":"ojs"},{"id":266,"value":"OutflowParse={\n var OutflowParse=outflowData\n for (var i=1; i<=21;i++){\n var variable=outflowData.columns[i]\n OutflowParse=z.dropCol(\"BERKELEY\", z.parseNums(variable, OutflowParse))\n }\n return OutflowParse \n }","pinned":true,"hidden":false,"mode":"ojs"},{"id":66,"value":"InflowReshape={\n var reshape=[]\n for (var j=1;j<=21;j++){\n for (var i=0; i<=6;i++){\n var variable=inflowData.columns[j]\n reshape.push({\"University\":variable, \"year\":yearList[i],\"number\":InflowParse[i][variable]})\n }\n }\n var reshape2=z.filter(r=>r.University!=\"BERKELEY\", reshape)\n return reshape2\n }","pinned":true,"hidden":false,"mode":"ojs"},{"id":270,"value":"OutflowReshape={\n var reshape=[]\n for (var j=1;j<=21;j++){\n for (var i=0; i<=6;i++){\n var variable=outflowData.columns[j]\n reshape.push({\"University\":variable, \"year\":yearList[i],\"number\":OutflowParse[i][variable]})\n }\n }\n var reshape2=z.filter(r=>r.University!=\"BERKELEY\", reshape)\n return reshape2\n }","pinned":true,"hidden":false,"mode":"ojs"},{"id":259,"value":"selectedData = { \n switch (chartType) {\n case \"Inflow\": return InflowReshape\n case \"Outflow\": return OutflowReshape\n }\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":257,"value":"viewof chartType = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":61,"value":"vegalite({\n $schema: \"https://vega.github.io/schema/vega-lite/v3.json\",\n width: 400,\n height: 400,\n title: \"Talents Inflow\",\n data: {values: selectedData},\n mark: {type: \"line\", tooltip: {\"content\": \"data\"}},\n encoding: {\n x: {field: \"year\", type: \"temporal\",\n axis: {title: \"Year\",tickWidth: 5}}, \n y: {field: \"number\", type: \"quantitative\",\n axis: {title: \"Number of talents migrating\"}} ,\n color: {field: \"University\", type: \"nominal\"}\n }\n \n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":102,"value":"tooltip = d3_5.select(\"body\")\n .append(\"div\")\n .style(\"position\", \"absolute\")\n .style(\"font-family\", \"'Open Sans', sans-serif\")\n .style(\"font-size\", \"12px\")\n .style(\"z-index\", \"10\")\n .style(\"visibility\", \"hidden\"); ","pinned":false,"hidden":false,"mode":"ojs"},{"id":162,"value":"embed = require(\"vega-embed@3\")","pinned":true,"hidden":false,"mode":"ojs"},{"id":179,"value":"viewof chart2 = html``","pinned":false,"hidden":false,"mode":"ojs"},{"id":112,"value":"d3_5 = require(\"d3@5\")","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}