2b:null 2c:["$","title",null,{"children":"Credit Analysis V9 | John Hellier | Observable"}] 31:T20b7,{ const svg = d3.create('svg').attr('viewBox', [0, 0, width, 300]); svg.append('line') .attr('x1', 30) .attr('x2', 30) .attr('y1', 60) .attr('y2', 180) .attr("stroke-width", 1) .attr("stroke", "black"); svg.append('text') .attr('x', 16) .attr('y', 125) .attr("stroke-width", 1) .attr("stroke", "black") .text(mu) function createRow(data, row, y, rowTitle) { let x = -75 // let y = 0 let displayView = viewPrograms[0]; const g = svg.selectAll(row) .data(data) .join('g') .attr('class',row) .attr('transform', function(d,i) { x += 200; return 'translate(' + x + ',' + y + ')'; }) .call(dragNode) .on("click", clicked) .on("dblclick", function(d) { if (d3.select(this).selectAll('text.body-text').attr('visibility') == 'hidden') { d3.select(this).selectAll('text.body-text').attr('visibility','visible') d3.select(this).select('rect').attr('visibility','visible') } else { d3.select(this).selectAll('text.body-text').attr('visibility','hidden') d3.select(this).select('rect').attr('visibility','hidden') } }) .on("mouseenter", function(d) { d3.select(this).raise() if (d3.select(this).selectAll('text.body-text').attr('visibility') == 'hidden') { d3.select(this).selectAll('text.body-text').attr('visibility','visible') d3.select(this).selectAll('rect.color-bars').attr('visibility','visible') d3.select(this).select('rect').attr('visibility','visible') } }) .on("mouseleave", function(d) { d3.select(this).selectAll('text.body-text').attr('visibility','hidden') d3.select(this).selectAll('rect.color-bars').attr('visibility','hidden') d3.select(this).select('rect').attr('visibility','hidden') }) // Row Title g.append('text') .attr('x', -50) .attr('y', 25) .attr("class",Date.now()) .attr('stroke','black') .attr('opacity',0.9) .style('font-size',16) .style('text-anchor','middle') .style('letter-spacing',1) .text((d,i) => i == 0 ? rowTitle : '') // Node detail rect g.append('rect') .attr('class','node-body') .attr('x', 0) .attr('y', 42) .attr('width', boxWidth + 60) .attr('height',boxHeight) .attr('visibility','hidden') .style('fill','#f3f3f3') .style('stroke','lightgrey') .style('rx', 5) // Coloring for node g.append('rect') .attr('x', 0) .attr('y', 0) .attr('width', boxWidth + 60) .attr('height', 40) .style('fill','#f7f7ca') .style('stroke','lightgrey') .style('rx', 5) // Coloring for node g.append('rect') .attr('x', 0) .attr('y', 0) .attr('width', function(d) { const key = Object.keys(d)[0]; let total = parseInt(d[key][displayView][0]) + parseInt(d[key][displayView][1]); if (total === 0) return 0; let portion = d[key][displayView][0]/total; let calWidth = (boxWidth + 60) * portion; return calWidth }) .attr('height', 40) .style('fill','#cceccc') // .style('fill','#f3f3f3') .style('stroke','lightgrey') .style('rx', 5) // Text Line 1 let textLineX = 4 let textLineY = 18 // Node Credits - Yes g.append('text') .attr('x', 25) .attr('y', textLineY) .attr('stroke','black') .attr('opacity',0.9) .style('font-size',16) .style('text-anchor','middle') .style('letter-spacing',1) .style('text-shadow',"0.4px 0.4px 0.4px rgba(0,0,0,0.4)") .text(d => { const key = Object.keys(d)[0] return d[key][displayView][0] }) // Node Credits - No g.append('text') .attr('x', 160) .attr('y', textLineY) .attr('stroke','black') .attr('opacity',0.9) .style('font-size',16) .style('text-anchor','middle') .style('letter-spacing',1) .style('text-shadow',"0.4px 0.4px 0.4px rgba(0,0,0,0.4)") .text(d => { const key = Object.keys(d)[0] return d[key][displayView][1] }) textLineY += 18 g.append('text') .attr('x', 5) .attr('y', textLineY) .attr('stroke','black') .attr('opacity',0.9) .style('text-anchor','start') .style('font-size',9) .style('letter-spacing',1) .text(d => { const key = Object.keys(d)[0] return key.toUpperCase(); }) g.append('text') .attr('x', 175) .attr('y', textLineY) .attr('stroke','black') .attr('opacity',0.9) .style('text-anchor','end') .style('font-size',9) .style('letter-spacing',1) .text((d,i) => { return negativeProperties[i]; }) g.each(function(p,j) { const key = Object.keys(p)[0]; const target = p[key]; const keys = Object.keys(target); const items = keys.map(x => [x,...(target[x])]); textLineY = 40; d3.select(this).selectAll('text1') .data(items) .join('text') .attr('class','body-text') .attr('visibility','hidden') .style('text-anchor','end') .attr('x', 23) .attr('y', function(d) { textLineY += 15; return textLineY; }) .attr('stroke','black') .attr('opacity',0.7) .style('font-size',10) .style('letter-spacing', 1) .text(d => d[1]) textLineY = 30; let barWidth = 130; d3.select(this).selectAll('color-bars') .data(items) .enter() .append('rect') .attr('class','color-bars') .attr('x', 25) .attr('y', function(d) { textLineY += 15; return textLineY; }) .attr('width', barWidth) .attr('height',12) .attr('visibility','hidden') .style('fill', function(d) { if (d[1] == 0 && d[2] == 0) return 'lightgrey' else return '#F7F7CA' }) .style('opacity',0.5) .style('stroke','lightgrey') textLineY = 30; barWidth = 130; d3.select(this).selectAll('color-bars') .data(items) .enter() .append('rect') .attr('class','color-bars') .attr('x', 25) .attr('y', function(d) { textLineY += 15; return textLineY; }) .attr('width', function(d) { let total = parseInt(d[1]) + parseInt(d[2]); if (total === 0) return 0 let portion = d[1]/total; return barWidth * portion; }) .attr('height',12) .attr('visibility','hidden') .style('fill','#cceccc') .style('opacity',0.5) .style('stroke','lightgrey') textLineY = 40 // Node category like Total Credits or TX Course Count d3.select(this).selectAll('text1') .data(items) .enter() .append('text') .attr('class','body-text') .attr('visibility','hidden') .style('text-anchor','middle') .attr('x', 95) .attr('y', function(d) { textLineY += 15; return textLineY; }) .attr('stroke','black') .attr('opacity',0.5) .style('font-size',10) .style('letter-spacing', 1) .text(d => formatColumn(d[0])) textLineY = 40; d3.select(this).selectAll('text1') .data(items) .enter() .append('text') .attr('class','body-text') .attr('visibility','hidden') .style('text-anchor','end') .attr('x', 170) .attr('y', function(d) { textLineY += 15; return textLineY; }) .attr('stroke','black') .attr('opacity',0.7) .style('font-size',10) .style('letter-spacing', 1) .text(d => d[2]) }) function clicked(event, d) { if (event.defaultPrevented) return; // dragged } } createRow(combineNodes(), 'row1', 0, 'Student Z'); createRow(combineNodesAvgs(tree_data_filtered_avgs(tree_data_major())), 'row2', 50, 'Program'); createRow(combineNodesAvgs(tree_data_filtered_avgs(filtered_tree_data(total_credits_range))), 'row3', 100, 'Filtered'); createRow(combineNodesAvgs(tree_data_avgs), 'row4', 150, "All"); console.log("hit it again") return svg.node(); }32:T95f,bubbleChart = { // const svg = d3.create("svg") // .attr("viewBox", [0, 0, width, height]); const container = d3.select( html`

${tooltipTemplate}

` ); const tooltipDiv = container.select(".tooltip"); const svg = container.append('svg') .attr("viewBox", `0, 0, ${width}, ${height}`); svg.append("g") .call(xAxis); svg.append("g") .call(yAxis); svg.append("g") .selectAll("medianCircle") .data(combineMedian()) .join("circle") .attr("cx", d => x(d.xMedian)) .attr("cy", d => y(d.yMedian)) .attr("r", d => { return scaleLog(orderedBinsBySchool[d.school].flatMap(d => d[1]).length) * 20 }) .attr("visibility", d => (bubbleSelect[8].length == 0)? 'hidden' : 'visible') .style("fill",d => color(d.school)) .style("stroke","black") .style("stroke-width","2px") .call(tooltip, tooltipDiv) svg.append("g") .selectAll("meanXline") .data(combineMedian()) .join("line") .attr("x1", d => x(d.xMedian)) .attr("y1", d => 0 + margin.top) .attr("x2", d => x(d.xMedian)) .attr("y2", height - margin.bottom) .attr("visibility", d => (bubbleSelect[7].length == 0)? 'hidden' : 'visible') .style("stroke",d => color(d.school)) .style("stroke-width","2px") .call(tooltip, tooltipDiv) svg.append("g") .selectAll("meanYline") .data(combineMedian()) .join("line") .attr("x1", margin.left) .attr("y1", d => y(d.yMedian)) .attr("x2", d => width - margin.right) .attr("y2", d => y(d.yMedian)) .attr("visibility", d => (bubbleSelect[7].length == 0)? 'hidden' : 'visible') .style("stroke",d => color(d.school)) .style("stroke-width","2px") .call(tooltip, tooltipDiv) svg.append("g") .selectAll("circle") .data(treeDatafilterBySchools) .join("circle") .attr("cx", d => x(parseInt(d[bubbleSelect[0] + '_' + bubbleSelect[2]]))) .attr("cy", d => y(parseInt(d[bubbleSelect[1]+ '_' + bubbleSelect[3]]))) .attr("fill", d => color((d.program_code).slice(-2))) .attr("visibility", d => (bubbleSelect[5].length == 0)? 'hidden' : 'visible') .attr("r", 4) .call(tooltip, tooltipDiv) return container.node(); }33:T411,viewof bubbleSelect = Inputs.form( [ Inputs.select(prefixList, {label: "X Suffix", format: x => formatColumn(x), value: x => x}), Inputs.select(prefixList, {label: "Y Suffix", format: x => formatColumn(x), value: x => x}), Inputs.select(suffixList, {label: "X Prefix", format: x => formatColumn(x), value: x => x}), Inputs.select(suffixList, {label: "Y Prefix", format: x => formatColumn(x), value: x => x}), Inputs.checkbox(schools, {label: "Schools", value: schools, format: x => html`${x}` }), Inputs.checkbox([""],{label: "Show Students"}), Inputs.checkbox([""],{label: "Drop Zeros"}), Inputs.checkbox([""],{label: "Show Median Lines"}), Inputs.checkbox([""],{label: "Show Median Circles"}), ])34:Ta67,// Create array wioth objects {schoolName,percentageNonZero} percentageNonZero = function() { let allPercent = [] schools.forEach(function(school) { let orderedBinsByProgram = Object.entries(binString(treeDatafilterBySchoolsWithoutZeros)) let orderedBinsBySchool = binStringBySchool(orderedBinsByProgram) let partial = orderedBinsBySchool[school].flatMap(d => d[1]).length let orderedBinsByProgram1 = Object.entries(binString(treeDatafilterBySchoolsIncludingZeros)) let orderedBinsBySchool1 = binStringBySchool(orderedBinsByProgram1) let full = orderedBinsBySchool1[school].flatMap(d => d[1]).length console.log('All ' + full + ' Partial ' + partial) let percent = parseFloat(d3.format(".01f")((full - partial)/full * 100)) allPercent.push({series: "All", school:school, percent: percent}) }) schools.forEach(function(school) { let orderedBinsByProgram = Object.entries(binString(treeDatafilterBySchoolsExcess40WithoutZeros)) let orderedBinsBySchool = binStringBySchool(orderedBinsByProgram) let partial = orderedBinsBySchool[school].flatMap(d => d[1]).length let orderedBinsByProgram1 = Object.entries(binString(treeDatafilterBySchoolsExcess40IncludingZeros)) let orderedBinsBySchool1 = binStringBySchool(orderedBinsByProgram1) let full = orderedBinsBySchool1[school].flatMap(d => d[1]).length console.log('10% ' + full + ' Partial ' + partial) let percent1 = parseFloat(d3.format(".01f")((full - partial)/full * 100)) allPercent.push({series: "Top 10%", school:school, percent: percent1}) }) // return allPercent.sort((a,b) => d3.descending(a.percent, b.percent)) return allPercent // schools.forEach(function(school) { // let orderedBinsByProgram = Object.entries(binString(treeDataBySchools(false,20))) // let orderedBinsBySchool = binStringBySchool(orderedBinsByProgram) // let partial = orderedBinsBySchool[school].flatMap(d => d[1]).length // let orderedBinsByProgram1 = Object.entries(binString(treeDataBySchools(true,20))) // let orderedBinsBySchool1 = binStringBySchool(orderedBinsByProgram1) // // debugger; // let full = orderedBinsBySchool1[school].flatMap(d => d[1]).length // console.log('> 30 ' + full + ' Partial ' + partial) // let percent1 = parseFloat(d3.format(".01f")((full - partial)/full * 100)) // allPercent.push({series: "Greater than 30", school:school, percent: percent1}) // }) // return allPercent // // return allPercent.sort((a,b) => d3.descending(a.percent, b.percent)) }35:T244f,// Copyright 2021 Observable, Inc. // Released under the ISC license. // https://observablehq.com/@d3/sortable-bar-chart function BarChart(data, { x = (d, i) => i, // given d in data, returns the (ordinal) x-value y = d => d, // given d in data, returns the (quantitative) y-value marginTop = 20, // the top margin, in pixels marginRight = 0, // the right margin, in pixels marginBottom = 30, // the bottom margin, in pixels marginLeft = 40, // the left margin, in pixels width = 640, // the outer width of the chart, in pixels height = 400, // the outer height of the chart, in pixels xDomain, // an array of (ordinal) x-values xRange = [marginLeft, width - marginRight], // [left, right] yType = d3.scaleLinear, // type of y-scale yDomain, // [ymin, ymax] yRange = [height - marginBottom, marginTop], // [bottom, top] xPadding = 0.1, // amount of x-range to reserve to separate bars yFormat, // a format specifier string for the y-axis yLabel, // a label for the y-axis color = "currentColor", // bar fill color duration: initialDuration = 250, // transition duration, in milliseconds delay: initialDelay = (_, i) => i * 20 // per-element transition delay, in milliseconds } = {}) { // Compute values. const X = d3.map(data, x); const Y = d3.map(data, y); // Compute default domains, and unique the x-domain. if (xDomain === undefined) xDomain = X; if (yDomain === undefined) yDomain = [0, d3.max(Y)]; xDomain = new d3.InternSet(xDomain); // Omit any data not present in the x-domain. const I = d3.range(X.length).filter(i => xDomain.has(X[i])); // Construct scales, axes, and formats. const xScale = d3.scaleBand(xDomain, xRange).padding(xPadding); const yScale = yType(yDomain, yRange); const xAxis = d3.axisBottom(xScale).tickSizeOuter(0); const yAxis = d3.axisLeft(yScale).ticks(height / 40, yFormat); const format = yScale.tickFormat(100, yFormat); const svg = d3.create("svg") .attr("width", width + 20) .attr("height", height) .attr("viewBox", [0, 0, width, height]) .attr("style", "max-width: 100%; height: auto; height: intrinsic;"); const yGroup = svg.append("g") .attr("transform", `translate(${marginLeft},0)`) .call(yAxis) .call(g => g.select(".domain").remove()) .call(g => g.selectAll(".tick").call(grid)) .call(g => g.append("text") .attr("x", -marginLeft) .attr("y", 10) .attr("fill", "currentColor") .attr("text-anchor", "start") .text(yLabel)); let meanXPos = 0; let rect = svg.append("g") .attr("fill", color) .selectAll("rect") .data(I) .join("rect") .property("key", i => X[i]) // for future transitions .call(position, i => xScale(X[i]), i => yScale(Y[i])) .style("mix-blend-mode", "multiply") .on('click', (e, index) => { let avg = d3.mean(orderedBins[index], d => d[1].total_credits_excess) // d3.select('#detailsRect').text(X[index]) d3.select('#detailsRect').text(avg) }) .call(rect => rect.append("title") .text(i => [X[i], 'Filtered Count ' + format(Y[i])].join("\n"))) // Need to fix deriving the height. Now it is an arbitray x3 of whatever value you have. But need to find // the max of all the values and make that the longest one. Preferably not the full height. Then take // a ratio of it to determine the length of any one that is less then the max. let meanOneLines = svg.append("g") .selectAll("meanOneLines") .data(I) .join("rect") .call(meanTextLinePosition, i => xScale(X[i]) + xScale.bandwidth()/2, i => yScale(Y[i]), i => (d3.median(d3.filter(orderedBins[i][1], b => parseInt(b[filterViews + '_' + suffixes]) != 0), d => d[filterViews + '_' + suffixes]) / d3.max(orderedBins, p => d3.max(p[1], b => parseInt(b[filterViews + '_' + suffixes])))) * (height * .8)) .attr("fill","red") .style("opacity",0.5) // (d3.median(d3.filter(orderedBins[i][1], // b => parseInt(b[filterViews + '_' + suffixes]) != 0), // d => d[filterViews + '_' + suffixes]) / d3.max(orderedBins, // b => parseInt(b[1][filterViews + '_' + suffixes]))) * (height * .8)) // d3.median(d3.filter(orderedBins[0][1], b => parseInt(b[filterViews + '_' + suffixes]) != 0), d => d[filterViews + '_' + suffixes])/ d3.max(orderedBins[0][1], b => parseInt(b[filterViews + '_' + suffixes])) * yRange // d3.median(d3.filter(orderedBins[i][1], b => parseInt(b[filterViews + '_' + suffixes]) != 0), d => d[filterViews + '_' + suffixes]) * 3) let meanOnes = svg.append("g") .attr("fill", color) .selectAll("meanOnes") .data(I) .join("text") .call(meanTextPosition, i => xScale(X[i]) + xScale.bandwidth()/2) .attr('y', 15) .attr("fill", "currentColor") .attr('id','meanOnes') .attr("text-anchor", "end") .style('font-size','14px') .attr('dx','-3px') .text((d, index) => d3.format(".0f")( d3.median( d3.filter(orderedBins[index][1], b => parseInt(b[filterViews + '_' + suffixes]) != 0), d => d[filterViews + '_' + suffixes]))) const xGroup = svg.append("g") .attr("transform", `translate(0,${height - marginBottom})`) .call(xAxis); // A helper method for updating the position of bars. function position(rect, x, y) { return rect .attr("x", x) .attr("y", y) .attr("height", typeof y === "function" ? i => yScale(0) - y(i) : i => yScale(0) - y) .attr("width", xScale.bandwidth()); } // A helper method for updating the position of mean Text. function meanTextPosition(text, x) { return text.attr("x", x) } // A helper method for updating the position of meanTextLines. // y is i => yScale(Y[i]) function meanTextLinePosition(line, x, y, height) { return line .attr("x", x) .attr("y", typeof y === "function" ? i => yScale(0) - y(i) - height : i => yScale(0) - y) .attr("height", height) .attr("width", "4px"); } // A helper method for generating grid lines on the y-axis. function grid(tick) { return tick.append("line") .attr("class", "grid") .attr("x2", width - marginLeft - marginRight) .attr("stroke", "currentColor") .attr("stroke-opacity", 0.1); } // Call chart.update(data, options) to transition to new data. return Object.assign(svg.node(), { update(data, { xDomain, // an array of (ordinal) x-values yDomain, // [ymin, ymax] duration = initialDuration, // transition duration, in milliseconds delay = initialDelay // per-element transition delay, in milliseconds } = {}) { // Compute values. const X = d3.map(data, x); const Y = d3.map(data, y); // Compute default domains, and unique the x-domain. if (xDomain === undefined) xDomain = X; if (yDomain === undefined) yDomain = [0, d3.max(Y)]; xDomain = new d3.InternSet(xDomain); // Omit any data not present in the x-domain. const I = d3.range(X.length).filter(i => xDomain.has(X[i])); // Update scale domains. xScale.domain(xDomain); yScale.domain(yDomain); // Start a transition. const t = svg.transition().duration(duration); // Join the data, applying enter and exit. rect = rect .data(I, function(i) { return this.tagName === "rect" ? this.key : X[i]; }) .join( enter => enter.append("rect") .property("key", i => X[i]) // for future transitions .call(position, i => xScale(X[i]), yScale(0)) .style("mix-blend-mode", "multiply") .call(enter => enter.append("title")), update => update, exit => exit.transition(t) .delay(delay) .attr("y", yScale(0)) .attr("height", 0) .remove() ); // Update the title text on all entering and updating bars. rect.select("title") .text(i => [X[i], format(Y[i])].join("\n")); // Transition entering and updating bars to their new position. Note // that this assumes that the input data and the x-domain are in the // same order, or else the ticks and bars may have different delays. rect.transition(t) .delay(delay) .call(position, i => xScale(X[i]), i => yScale(Y[i])); // Transition the x-axis (using a possibly staggered delay per tick). xGroup.transition(t) .call(xAxis) .call(g => g.selectAll(".tick").delay(delay)); // Transition the y-axis, then post process for grid lines etc. yGroup.transition(t) .call(yAxis) .selection() .call(g => g.select(".domain").remove()) .call(g => g.selectAll(".tick").selectAll(".grid").data([,]).join(grid)); } }); }36:T45b,// Create a student data structure that combines each of the following into one node // Articulated and Non-articulated // Usable and Unusable // Earned and Unearned // Applied and Excess combineNodes = function() { let combineNode = []; combinedSuffixList.forEach(function(suffix) { let node = ({}); let nodeField = ({}); prefixList.forEach(function(prefix) { if (suffix === 'articulated') { // debugger; nodeField[prefix] = [student[prefix + '_articulated'],student[prefix + '_non-articulated']]; node.articulated = nodeField; } if (suffix === 'usable') { nodeField[prefix] = [student[prefix + '_usable'],student[prefix + '_unusable']]; node.usable = nodeField; } if (suffix === 'earned') { nodeField[prefix] = [student[prefix + '_earned'],student[prefix + '_unearned']]; node.earned = nodeField; } if (suffix === 'applied') { nodeField[prefix] = [student[prefix + '_applied'],student[prefix + '_excess']]; node.applied = nodeField; } }) combineNode.push(node); }) return combineNode }37:T458,// Create a student data structure that combines each of the following into one node for averages // Articulated and Non-articulated // Usable and Unusable // Earned and Unearned // Applied and Excess combineNodesAvgs = function(data) { let combineNode = []; combinedSuffixList.forEach(function(suffix) { let node = ({}); let nodeField = ({}); prefixList.forEach(function(prefix) { if (suffix === 'articulated') { // debugger; nodeField[prefix] = [data[prefix + '_articulated'],data[prefix + '_non-articulated']]; node.articulated = nodeField; } if (suffix === 'usable') { nodeField[prefix] = [data[prefix + '_usable'],data[prefix + '_unusable']]; node.usable = nodeField; } if (suffix === 'earned') { nodeField[prefix] = [data[prefix + '_earned'],data[prefix + '_unearned']]; node.earned = nodeField; } if (suffix === 'applied') { nodeField[prefix] = [data[prefix + '_applied'],data[prefix + '_excess']]; node.applied = nodeField; } }) combineNode.push(node); }) return combineNode }38:Tbd3,tooltip = (selectionGroup, tooltipDiv) => { // padding between the tooltip and mouse cursor const MOUSE_POS_OFFSET = 8; selectionGroup.each(function () { d3.select(this) .on("mouseover.tooltip", handleMouseover) .on("mousemove.tooltip", handleMousemove) .on("mouseleave.tooltip", handleMouseleave); }); function handleMouseover() { // show/reveal the tooltip, set its contents, // style the element being hovered on showTooltip(); setContents(d3.select(this).datum()); setStyle(d3.select(this)); } function handleMousemove(event) { // update the tooltip's position const [mouseX, mouseY] = d3.pointer(event, this); // add the left & top margin values to account for the SVG g element transform setPosition(mouseX + margin.left, mouseY + margin.top); } function handleMouseleave() { // do things like hide the tooltip // reset the style of the element being hovered on hideTooltip(); resetStyle(d3.select(this)); } function showTooltip() { tooltipDiv.style("display", "block"); } function hideTooltip() { tooltipDiv.style("display", "none"); } function setPosition(mouseX, mouseY) { tooltipDiv .style( "top", mouseY < height / 2 ? `${mouseY + MOUSE_POS_OFFSET}px` : "initial" ) .style( "right", mouseX > width / 2 ? `${width - mouseX + MOUSE_POS_OFFSET}px` : "initial" ) .style( "bottom", mouseY > height / 2 ? `${height - mouseY + MOUSE_POS_OFFSET}px` : "initial" ) .style( "left", mouseX < width / 2 ? `${mouseX + MOUSE_POS_OFFSET}px` : "initial" ); } function setContents(datum) { // customize this function to set the tooltip's contents however you see fit tooltipDiv .selectAll("p") .data(Object.entries(datum)) .join("p") .filter(([key, value]) => value !== null && value !== undefined) .html( function([key, value]) { if (key.indexOf("program") != -1) return formatToolTipRow(formatColumn(key), value) if (key === bubbleSelect[0] + '_' + bubbleSelect[2]) return formatToolTipRow(formatColumn(key), value) if (key === bubbleSelect[1] + '_' + bubbleSelect[3]) return formatToolTipRow(formatColumn(key), value) if (key.indexOf('xMedian') != -1) return formatToolTipRow(formatColumn(bubbleSelect[2]) + " " + formatColumn(bubbleSelect[0]) + " Median", value) if (key.indexOf('yMedian') != -1) return formatToolTipRow(formatColumn(bubbleSelect[3]) + " " + formatColumn(bubbleSelect[1]) + " Median", value) if (key.indexOf('school') != -1) return formatToolTipRow(formatColumn(key), value) + `
` + formatToolTipRow("Student Count",orderedBinsBySchool[value].flatMap(d => d[1]).length) } ); } }39:[{"id":"475b648eef270dad599bed4de1f7950fe7d7e41158256289eaf7f8d0368e87a825d8c62209738412ae658d35989aebc3354d79854a5a5b0877a366ffab3275cd","href":"https://static.observableusercontent.com/files/475b648eef270dad599bed4de1f7950fe7d7e41158256289eaf7f8d0368e87a825d8c62209738412ae658d35989aebc3354d79854a5a5b0877a366ffab3275cd","name":"studentMashup.csv","type":"text/csv","lastModified":1666188467851.014,"size":649833},{"id":"564bc6c21cdb6234b20f3eb032e3bfcb782203380a86ee1b19edd97b4cb68ab8f86d954c76238176473870a70261bdc9c590717c145334a0fd566b2b1d53240e","href":"https://static.observableusercontent.com/files/564bc6c21cdb6234b20f3eb032e3bfcb782203380a86ee1b19edd97b4cb68ab8f86d954c76238176473870a70261bdc9c590717c145334a0fd566b2b1d53240e","name":"tree_data_features_unm_post_refactor_all_08_05_2022_anonymized.csv","type":"text/csv","lastModified":1666188467851.014,"size":482984}] 2f:{"id":"78bd26f165e06fd1","slug":null,"title":"Credit Analysis V9","thumbnail":"d2a9a64eb83bfc0d304dcf8f71b3714a30e83b31303bc284f925e03b3a98d23f","access_level":"public","create_time":"$D2022-10-19T14:07:47.851Z","update_time":"$D2023-01-19T23:32:00.328Z","view_time":null,"first_public_time":"$D2022-11-03T21:33:11.160Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"c079c57df8f42a20","login":"johnhellierunm","name":"John Hellier","avatar_url":"https://avatars-next.observableusercontent.com/d6bed66b206f70403c92635b545eea98999d39fd70a8cd284e8e6a5be28e64a7","tier":"starter_2024"},"version":3317,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"92989a02199cddd7","login":"johnhellierunm","name":"John Hellier","avatar_url":"https://avatars-next.observableusercontent.com/d6bed66b206f70403c92635b545eea98999d39fd70a8cd284e8e6a5be28e64a7","tier":null}],"members":[{"type":"individual","id":"92989a02199cddd7","login":"johnhellierunm","name":"John Hellier","avatar_url":"https://avatars-next.observableusercontent.com/d6bed66b206f70403c92635b545eea98999d39fd70a8cd284e8e6a5be28e64a7","tier":null,"role":"editor"},{"type":"individual","id":"0fe220040591ce24","login":"quinmoto","name":"John Hellier","avatar_url":"https://avatars-next.observableusercontent.com/93c2f4c48c71e1654b101da7a93c014fde5b4ad06c9f523a0405d37ea3426a88","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":3,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Credit Analysis V9","cells":[{"id":0,"value":"# Credit Analysis V9\nTesting the use of join without any changes to the current code. needed to do more than just add join.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"circles","database":"$undefined"},{"id":1709,"value":"viewof viewPrograms = Inputs.form([\n Inputs.select(prefixList, {label: \"Views\", format: x => formatColumn(x), value: x => x}),\n Inputs.select(majors, {label:\"Program\"})\n])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":585,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1080,"value":"viewof filterViews = Inputs.select(prefixList, {label: \"Filter View\", format: x => formatColumn(x), value: x => x})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1202,"value":"html`Students: ${filtered_tree_data(total_credits_range).length} of ${tree_data.length}` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1033,"value":"viewof total_credits_range = Inputs.range(tree_data_total_credits_extent, {label: formatColumn(filterViews) + \" >\",step: 1})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1699,"value":"viewof suffixes = Inputs.select(suffixList, {label: \"Views\", format: x => formatColumn(x), value: x => x})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1256,"value":"chart = BarChart(orderedBins, {\n x: d => d[0],\n y: d => d[1].length,\n yFormat: \"s\",\n yLabel: \"Student #\",\n width,\n height: 400,\n color: \"#cceccc\",\n duration: 750 // slow transition for demonstration\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1944,"value":"legend = {\n const id = DOM.uid().id;\n return html`

${color.domain().map(d => html`${document.createTextNode(d)}`)}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1809,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1876,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2944,"value":"percentages(\"MG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2934,"value":"percentages = function(school) {\n let partial = orderedBinsBySchool[school].flatMap(d => d[1]).length\n let orderedBinsByProgram1 = Object.entries(binString(treeDatafilterBySchoolsIncludingZeros)) \n let orderedBinsBySchool1 = binStringBySchool(orderedBinsByProgram1)\n let full = orderedBinsBySchool1[school].flatMap(d => d[1]).length\n return d3.format(\".01f\")((full - partial)/full * 100)\n}\n\n// \n// ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2991,"value":"percentageNonZero()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2988,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2999,"value":"Plot.plot({\n x: {\n domain: d3.sort(percentageNonZero(), d => -d.percent).map(d => d.school)\n },\n facet: {\n data: percentageNonZero(),\n x: \"series\"\n },\n \n marks: [\n Plot.barY(percentageNonZero(), {\n y: \"percent\", \n x: \"school\",\n title: (d) => `${d.school}`,\n facet: true\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1258,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2909,"value":"combineMedian()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2264,"value":"// Creates an array that holds the x y pair corresponding to the selection choices for the x and y axis.\ncombineMedian = function() {\n let comb = new Array();\n let two = bubbleSelect[2];\n let zero = bubbleSelect[0];\n let three = bubbleSelect[3];\n let one = bubbleSelect[1];\n bubbleSelect[4].forEach(function(d) {\n let xMedian = fSchoolMedian(d, two, zero);\n let yMedian = fSchoolMedian(d, three, one);\n let school = d;\n comb.push({school,xMedian,yMedian});\n })\n return comb;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2023,"value":"treeDatafilterBySchools = tree_data.filter(function(d) {\n if (Array.from(bubbleSelect[4]).includes(d.program_code.slice(-2))) {\n if (bubbleSelect[6].length != 0) {\n // if the value is not equal to zero include it. Particularly important for tracking students with\n // non-zero values for things like excess credits.\n if (d[bubbleSelect[1] + '_' + bubbleSelect[3]] != 0)\n return d;\n }\n else\n return d;\n }\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3147,"value":"treeDatafilterBySchoolsWithoutZeros = tree_data_percents.filter(function(d) {\n if (Array.from(bubbleSelect[4]).includes(d.program_code.slice(-2))) {\n if (bubbleSelect[6].length != 0) {\n // if the value is not equal to zero include it. Particularly important for tracking students with\n // non-zero values for things like excess credits.\n if (d[bubbleSelect[1] + '_' + bubbleSelect[3]] != 0)\n return d;\n }\n else\n return d;\n }\n}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2938,"value":"treeDatafilterBySchoolsIncludingZeros = tree_data_percents.filter(function(d) {\n if (Array.from(bubbleSelect[4]).includes(d.program_code.slice(-2))) {\n return d;\n }\n}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3054,"value":"treeDatafilterBySchoolsExcess40WithoutZeros = tree_data.filter(function(d) {\n if (Array.from(bubbleSelect[4]).includes(d.program_code.slice(-2))) {\n if (d[bubbleSelect[1] + '_' + bubbleSelect[3]] != 0)\n if (d.unm_credits_excess > 10)\n return d;\n }\n}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3157,"value":"treeDatafilterBySchoolsExcess40IncludingZeros = tree_data.filter(function(d) {\n if (Array.from(bubbleSelect[4]).includes(d.program_code.slice(-2))) {\n if (d.unm_credits_excess > 7)\n return d;\n }\n}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3239,"value":"tree_data.filter(d => d.total_credits_excess != 0)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3166,"value":"treeDataBySchools = function(zeros, limit) {\n let results = tree_data_percents.filter(function(d) {\n if (Array.from(bubbleSelect[4]).includes(d.program_code.slice(-2))) {\n if (!zeros && d[bubbleSelect[1] + '_' + bubbleSelect[3]] != 0) {\n // console.log('Hit the non-zeros group')\n if (parseInt(d.total_credits_excess) > limit)\n return d;\n \n } else if (zeros) { \n if (parseInt(d.total_credits_excess) > limit) {\n return d;\n }\n }\n }})\n// debugger;\n return results;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1919,"value":"tree_data.map(d => d.program_code)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1815,"value":"xAxis = g => g\n .attr(\"transform\", `translate(0,${height - margin.bottom})`)\n .call(d3.axisBottom(x))\n .call(g => g.append(\"text\")\n .attr(\"x\", width)\n .attr(\"y\", margin.bottom - 4)\n .attr(\"fill\", \"currentColor\")\n .attr(\"text-anchor\", \"end\")\n .text(formatColumn(bubbleSelect[2]) + \" \" + formatColumn(bubbleSelect[0])))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1811,"value":"x = d3.scaleLinear()\n .domain(d3.extent(treeDatafilterBySchools, d => parseInt(d[bubbleSelect[0] + '_' + bubbleSelect[2]]))).nice()\n .range([margin.left, width - margin.right])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1817,"value":"yAxis = g => g\n .attr(\"transform\", `translate(${margin.left},0)`)\n .call(d3.axisLeft(y))\n .call(g => g.append(\"text\")\n .attr(\"x\", -margin.left)\n .attr(\"y\", 10)\n .attr(\"fill\", \"currentColor\")\n .attr(\"text-anchor\", \"start\")\n .text(formatColumn(bubbleSelect[3]) + \" \" + formatColumn(bubbleSelect[1])))\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1813,"value":"y = d3.scaleLinear()\n .domain(d3.extent(treeDatafilterBySchools, d => parseInt(d[bubbleSelect[1] + '_' + bubbleSelect[3]]))).nice()\n .range([height - margin.bottom, margin.top])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1774,"value":"orderedBins","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1235,"value":"filtered_tree_data(total_credits_range)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1239,"value":"orderedBins = Object.entries(binString(filtered_tree_data(total_credits_range))).sort((a,b) => b[1].length - a[1].length).splice(0,10)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2182,"value":"orderedBinsByProgram = Object.entries(binString(treeDatafilterBySchools))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2191,"value":"orderedBinsBySchool = binStringBySchool(orderedBinsByProgram)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2921,"value":"Array.from(orderedBinsBySchool, d => d)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2913,"value":"compare = function( a, b ) {\n\n \n if ( a < b ){\n return -1;\n }\n if ( a > b ){\n return 1;\n }\n return 0;\n}\n\n//objs.sort( compare );","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2619,"value":"orderedBinsBySchool1 = binStringBySchool(orderedBinsByProgram)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2199,"value":"schoolMedian = d3.median(orderedBinsBySchool[\"NU\"][0][1], d => d['total_credits_root'])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2364,"value":"fSchoolMedian = function(school, prefix, suffix) { return d3.median(orderedBinsBySchool[school].flatMap(d => d[1]), b => b[suffix + '_' + prefix])}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2622,"value":"fSchoolMedian1 = function(school, prefix, suffix) { return d3.median(orderedBinsBySchool[school].flatMap(d => d[1].filter(p => p[suffix + '_' + prefix] != 0)), b => b[suffix + '_' + prefix])}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2351,"value":"fSchoolMean = function(school, prefix, suffix) { return d3.mean(orderedBinsBySchool[school].flatMap(d => d[1]), b => b[suffix + '_' + prefix])}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2236,"value":"Array.from(schools, x => fSchoolMedian(x, bubbleSelect[2], bubbleSelect[0]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2260,"value":"Array.from(schools, x => fSchoolMean(x, bubbleSelect[2], bubbleSelect[0]))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2229,"value":"Array.from(schools).map(school => school)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2333,"value":"Array.from(orderedBinsBySchool[\"AS\"], d => d)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2339,"value":"d3.mean(orderedBinsBySchool[\"AS\"].flatMap(d => d[1]), b => b.total_credits_root)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2373,"value":"orderedBinsBySchool[\"AS\"].flatMap(d => d[1].filter(p => p['total_credits_excess'] != 0))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2188,"value":"// Create a bin array where the bin qualifer is non-numeric\n// d3.bin does not handle non-numeric bin qualifers. Had to write my own.\nbinStringBySchool = function(aList) {\n let bins = {};\n aList.forEach(function(element) { \n // The slice -2 grabs the last two characters of the program name which is the school the program is in.\n let candidate = element[0].slice(-2);\n if (bins[candidate] == undefined) {\n bins[candidate] = [];\n }\n bins[candidate].push(element);\n })\n return bins\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1237,"value":"// Create a bin array where the bin qualifer is non-numeric\n// d3.bin does not handle non-numeric bin qualifers. Had to write my own.\nbinString = function(aList) {\n let bins = {};\n aList.forEach(function(element) { \n if (bins[element.program_code] == undefined) {\n bins[element.program_code] = [];\n }\n bins[element.program_code].push(element);\n })\n return bins\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":923,"value":"negativeProperties = ['NON-ARTICULATED','UNUSABLE','UNEARNED','EXCESS']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":180,"value":"student = tree_data[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"combineNodes()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3279,"value":"combineNodes()[0].articulated","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":791,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":945,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"dropSuffix = function(string, separator) {\n return string.substring(0, string.lastIndexOf(separator))\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":174,"value":"root_tree_data[0]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"tree_data[0]\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"root_tree_data = tree_data.map(function(d) {\n let rootSet = {}\n for (const key of Object.keys(d)) {\n if (key.indexOf(\"root\") != -1)\n rootSet[key] = d[key] \n }\n return rootSet;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":930,"value":"tree_data_avg = d3.mean(tree_data, d => d.total_credits_root)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1031,"value":"tree_data_total_credits_extent = d3.extent(tree_data, d => parseInt(d[filterViews + '_root']))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":939,"value":"tree_data_avgs = {\n let avgs = ({});\n let keys = Object.keys(tree_data[0]);\n keys.forEach(key => {\n avgs[key] = d3.format(\".0f\")(d3.mean(tree_data, d => d[key]))\n })\n return avgs\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1048,"value":"tree_data_filtered_avgs = function(data) {\n let avgs = ({});\n if (data[0] != undefined) {\n let keys = Object.keys(data[0]);\n keys.forEach(key => {\n avgs[key] = d3.format(\".0f\")(d3.mean(data, d => d[key]))\n }) \n }\n return avgs\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1038,"value":"filtered_tree_data = function(target) {\n let view = filterViews;\n return tree_data.filter(d => d[view + '_root'] > target)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1042,"value":"filtered_tree_data(total_credits_range)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":127,"value":"tree_data1 = FileAttachment(\"tree_data_features_unm_post_refactor_all_08_05_2022_anonymized.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1168,"value":"majors = tree_data.map(d => d.program_code).filter(onlyUnique)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1185,"value":"// When this notebook is loaded, the element \"ALL\" is added as the first element for the Program select widget\nmajors.unshift('ALL')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1187,"value":"majors","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1171,"value":"function onlyUnique(value, index, self) {\n return self.indexOf(value) === index;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1333,"value":"tree_data_major()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1335,"value":"tree_data_filtered_avgs(tree_data_major())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1190,"value":"tree_data_major = function() {\n if (viewPrograms[1] == 'ALL')\n return tree_data\n\n return tree_data.filter(d => d.program_code === viewPrograms[1])\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1195,"value":"tree_data_major()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3299,"value":"quants25 = d3.quantile(tree_data.map(d => d['total_credits_excess']),0.25)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3311,"value":"quants50 = d3.quantile(tree_data.map(d => d['total_credits_excess']),0.5)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3313,"value":"quants75 = d3.quantile(tree_data.map(d => d['total_credits_excess']),0.75)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3303,"value":"tree_data.map(d => d['total_credits_root'])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2758,"value":"## Tooltip Support","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1959,"value":"tooltipId = DOM.uid().id","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1962,"value":"tooltipTemplate = html`

\n \n

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1964,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1966,"value":"function resetStyle(selection) {\n // selection.attr(\"fill\", \"#333\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2650,"value":"function setStyle(selection) {\n // selection.attr(\"fill\",\"magenta\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2630,"value":"## Data Files","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1163,"value":"tree_data = FileAttachment(\"studentMashup.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3206,"value":"// Use this data file for computing the percentages\ntree_data_percents = FileAttachment(\"studentMashup.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2521,"value":"## Select List Creators","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":200,"value":" prefixList = [\"total_credits\",\n \"course_count\",\n \"tx_credits\",\n \"tx_course_count\",\n \"unm_credits\",\n \"unm_course_counts\",\n \"pt_credits\",\n \"pt_course_count\"]\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"suffixList = [\"root\",\n \"articulated\",\n \"non-articulated\",\n \"usable\",\n \"unusable\",\n \"earned\",\n \"unearned\",\n \"applied\",\n \"excess\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2599,"value":"combinedSuffixList = [\n \"articulated\",\n \"usable\",\n \"earned\",\n \"applied\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2741,"value":"schools = new Set(tree_data.map(d => d.program_code.slice(-2)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3289,"value":"prefixListSelect = prefixList.map(d => new Object({text: formatColumn(d), value: d}))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2452,"value":"## Constants and Settings","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1819,"value":"margin = ({top: 25, right: 20, bottom: 35, left: 40})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"boxHeight = 130","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2503,"value":"boxWidth = 120","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2515,"value":"height = 400","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2439,"value":"## Support Stuff","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2871,"value":"scaleLog = d3.scaleLog()\n .domain([1, tree_data.length])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":301,"value":"dragNode = {\n\n function dragstarted() {\n d3.select(this).attr(\"stroke\", \"black\");\n }\n\n function dragged(event, d) {\n console.log(d)\n // debugger\n d3.select(this).raise().attr(\"transform\", d=> \"translate(\"+[event.x,event.y]+\")\" )\n }\n\n function dragended() {\n d3.select(this).attr(\"stroke\", null);\n }\n\n return d3.drag()\n .on(\"start\", dragstarted)\n .on(\"drag\", dragged)\n .on(\"end\", dragended);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2392,"value":"formatToolTipRow = function(name, value) {\n return `` + name + `: ${typeof value === \"object\" ? value.toLocaleString(\"en-US\") : value }` \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1207,"value":"mu = '\\u00B5'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1931,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2604,"value":"// Row headers for the Tree Data are underscore spaced and lower case. Replace the underscore with space and make the words camel case.\n// Make UNM strings all uppercase\nformatColumn = function(columnName) {\n let newName = \"\";\n let capTrue = true;\n for (let i = 0; i < columnName.length; i++) {\n if (columnName[i] == '_') {\n newName += \" \";\n capTrue = true;\n } else if (capTrue) {\n newName += columnName[i].toUpperCase();\n capTrue = false;\n } else {\n newName += columnName[i];\n }\n }\n return newName.replace(\"Unm\",\"UNM\");\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2609,"value":"color = d3.scaleOrdinal(tree_data.map(d => String(d.program_code).slice(-2)), d3.schemeCategory10).unknown(\"black\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2787,"value":"## Styling","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":518,"value":"style = html`\n\n\n\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2508,"value":"## How To","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2510,"value":"go = d3.format(\".0f\")(23.445)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1"}} 30:"$2f:body"