29:null 2a:["$","title",null,{"children":"Analysing Data from Google Forms | Lucas Barcellos Oliveira | Observable"}] 2f:T8af,svg1={ let displayData=compCount.slice(0,100) let sizeMultiplier=5 let height=width/2 let svg=d3.select(DOM.svg(width,height)) //svg.append("rect").attr("width",width).attr("height",height) svg.append('defs').append('style').attr('type','text/css').text("@font-face{font-family: firstFont; src: url('https://rawcdn.githack.com/lucasbarcellosoliveira/fonts/cfc1474e90dc635492d6b540d02bece76f7a7aa4/JennaSue.ttf');} @font-face{font-family: otherFont; src: url('https://rawcdn.githack.com/lucasbarcellosoliveira/fonts/f5d3cf988a69b193de9acbe96e81500cc4d8af00/hwygnrrw.ttf');}"); let shadowFilter=svg.append("filter").attr("id","dropshadow").attr("height","130%"); shadowFilter.append("feGaussianBlur").attr("in","SourceAlpha").attr("stdDeviation",3); shadowFilter.append("feOffset").attr("dx",2).attr("dy",2).attr("result","offsetblur"); shadowFilter.append("feComponentTransfer").append("feFuncA").attr("type","linear").attr("slope",0.5); let shadowFilterMerge=shadowFilter.append("feMerge"); shadowFilterMerge.append("feMergeNode"); shadowFilterMerge.append("feMergeNode").attr("in","SourceGraphic"); let layout=d3cloud() .size([width, height]) .words(displayData) .padding(5) .text(d=>d.name) .font('otherFont') .fontSize(function(d){return d.count*sizeMultiplier;}) //.rotate(0) .on("end", draw) .start() function draw(){ let wordCloud=svg.selectAll("text") .data(displayData,d=>d.name) wordCloud.enter() .append("text") .style("filter","url(#dropshadow)") .attr("fill-opacity",d=>2*d.count/Math.max.apply(null,displayData.map(d=>d.count))) .style("font-family","otherFont") .style("fill",function(d, i){return color(Math.random());}) .attr("text-anchor","middle") .style("font-size",function(d) { return d.count*sizeMultiplier + "px"; }) .attr("transform",function(d) { return "translate(" + [width/2+d.x, height/2+d.y] + ")rotate(" + d.rotate + ")"; }) .text(function(d){return d.name;}) .append("svg:title") .text(function(d,i){return d.name+": "+d.count+" ocorrências.";}); wordCloud.exit() .remove(); } return svg.node() }30:T8b0,svg2={ let displayData=themeCount.slice(0,100) let sizeMultiplier=8 let height=width/2 let svg=d3.select(DOM.svg(width,height)) //svg.append("rect").attr("width",width).attr("height",height) svg.append('defs').append('style').attr('type','text/css').text("@font-face{font-family: firstFont; src: url('https://rawcdn.githack.com/lucasbarcellosoliveira/fonts/cfc1474e90dc635492d6b540d02bece76f7a7aa4/JennaSue.ttf');} @font-face{font-family: otherFont; src: url('https://rawcdn.githack.com/lucasbarcellosoliveira/fonts/f5d3cf988a69b193de9acbe96e81500cc4d8af00/hwygnrrw.ttf');}"); let shadowFilter=svg.append("filter").attr("id","dropshadow").attr("height","130%"); shadowFilter.append("feGaussianBlur").attr("in","SourceAlpha").attr("stdDeviation",3); shadowFilter.append("feOffset").attr("dx",2).attr("dy",2).attr("result","offsetblur"); shadowFilter.append("feComponentTransfer").append("feFuncA").attr("type","linear").attr("slope",0.5); let shadowFilterMerge=shadowFilter.append("feMerge"); shadowFilterMerge.append("feMergeNode"); shadowFilterMerge.append("feMergeNode").attr("in","SourceGraphic"); let layout=d3cloud() .size([width, height]) .words(displayData) .padding(5) .text(d=>d.name) .font('otherFont') .fontSize(function(d){return d.count*sizeMultiplier;}) //.rotate(0) .on("end", draw) .start() function draw(){ let wordCloud=svg.selectAll("text") .data(displayData,d=>d.name) wordCloud.enter() .append("text") .style("filter","url(#dropshadow)") .attr("fill-opacity",d=>3*d.count/Math.max.apply(null,displayData.map(d=>d.count))) .style("font-family","otherFont") .style("fill",function(d, i){return color(Math.random());}) .attr("text-anchor","middle") .style("font-size",function(d) { return d.count*sizeMultiplier + "px"; }) .attr("transform",function(d) { return "translate(" + [width/2+d.x, height/2+d.y] + ")rotate(" + d.rotate + ")"; }) .text(function(d){return d.name;}) .append("svg:title") .text(function(d,i){return d.name+": "+d.count+" ocorrências.";}); wordCloud.exit() .remove(); } return svg.node() }31:T8ae,svg3={ let displayData=sugCount.slice(0,100) let sizeMultiplier=3 let height=width/2 let svg=d3.select(DOM.svg(width,height)) //svg.append("rect").attr("width",width).attr("height",height) svg.append('defs').append('style').attr('type','text/css').text("@font-face{font-family: firstFont; src: url('https://rawcdn.githack.com/lucasbarcellosoliveira/fonts/cfc1474e90dc635492d6b540d02bece76f7a7aa4/JennaSue.ttf');} @font-face{font-family: otherFont; src: url('https://rawcdn.githack.com/lucasbarcellosoliveira/fonts/f5d3cf988a69b193de9acbe96e81500cc4d8af00/hwygnrrw.ttf');}"); let shadowFilter=svg.append("filter").attr("id","dropshadow").attr("height","130%"); shadowFilter.append("feGaussianBlur").attr("in","SourceAlpha").attr("stdDeviation",3); shadowFilter.append("feOffset").attr("dx",2).attr("dy",2).attr("result","offsetblur"); shadowFilter.append("feComponentTransfer").append("feFuncA").attr("type","linear").attr("slope",0.5); let shadowFilterMerge=shadowFilter.append("feMerge"); shadowFilterMerge.append("feMergeNode"); shadowFilterMerge.append("feMergeNode").attr("in","SourceGraphic"); let layout=d3cloud() .size([width, height]) .words(displayData) .padding(5) .text(d=>d.name) .font('otherFont') .fontSize(function(d){return d.count*sizeMultiplier;}) //.rotate(0) .on("end", draw) .start() function draw(){ let wordCloud=svg.selectAll("text") .data(displayData,d=>d.name) wordCloud.enter() .append("text") .style("filter","url(#dropshadow)") .attr("fill-opacity",d=>3*d.count/Math.max.apply(null,displayData.map(d=>d.count))) .style("font-family","otherFont") .style("fill",function(d, i){return color(Math.random());}) .attr("text-anchor","middle") .style("font-size",function(d) { return d.count*sizeMultiplier + "px"; }) .attr("transform",function(d) { return "translate(" + [width/2+d.x, height/2+d.y] + ")rotate(" + d.rotate + ")"; }) .text(function(d){return d.name;}) .append("svg:title") .text(function(d,i){return d.name+": "+d.count+" ocorrências.";}); wordCloud.exit() .remove(); } return svg.node() }32:T456,averages={ let questions=[4,5,6,7,8,9,10,11,93,94,95,96,97,98,99,100,101,102,103,104,17,18,19,20,21,22,23,24,25,26,30,31,32,33,34,35,36,37,38,39,40,41,42], ret=[] questions.forEach(function(qidx){ ret.push({question:q[qidx],avg: filteredData.map(d=>d[q[qidx]]).reduce(function(a,b){return parseInt(a)+parseInt(b)})/filteredData.length }) }) ret[8].question="\"Rádio educativa\" me faz querer ouvir a rádio" ret[9].question="\"Rádio universitária\" me faz querer ouvir a rádio" ret[10].question="Rádios universitárias parecem ser chatas" ret[11].question="Ser educativa" ret[12].question="Me informar sobre minha universidade" ret[13].question="Representar a diversidade" ret[14].question="Tocar apenas músicas brasileiras" ret[15].question="Apresentar todos os tipos de argumento" ret[16].question="Tocar todos os tipos de música" ret[17].question="Tocar músicas baseadas nas paradas de sucesso do momento" ret[18].question="Abrir espaço para artistas e bandas independentes" ret[19].question="Apresentar novas músicas de diversos países" return [ret] }33:Tc16,chart={ //as seen in @palewire/radar-chart let avg=[] averages.forEach(function(g){avg.push(g.slice(0,8));}); let dotRadius=4, height=600, margin=30, axisCircles=7, radius=(height-(margin*2))/2, axisLabelFactor=1.1; let axesDomain=avg[0].map(d=>d.question); let maxValue=7; //d3.max(_.flatten(avg).map(d=>d.avg)); let rScale = d3.scaleLinear() .domain([0, maxValue]) .range([0, radius]); let axesLength=axesDomain.length; let angleSlice=Math.PI * 2 / axesLength; let radarLine = d3.lineRadial() .curve(d3["curveCardinalClosed"]) .radius(d => rScale(d)) .angle((d, i) => i * angleSlice); const svg=d3.select(DOM.svg(width, height+(margin*2))); const containerWidth = width-(margin*2); const containerHeight = height-(margin*2); const container = svg.append('g') .attr("width", containerWidth) .attr("height", containerHeight) .attr('transform', `translate(${(width/2)+margin}, ${(height/2)+margin})`); var axisGrid = container.append("g") .attr("class", "axisWrapper"); axisGrid.selectAll(".levels") .data(d3.range(1,(axisCircles+1)).reverse()) .enter() .append("circle") .attr("class", "gridCircle") .attr("r", (d, i) => radius/axisCircles*d) .style("fill", "#FEC34D") //previously #CDCDCD .style("stroke", "#FEC34D") //previously #CDCDCD .style("fill-opacity", 0.1); const axis = axisGrid.selectAll(".axis") .data(axesDomain) .enter() .append("g") .attr("class", "axis"); axis.append("line") .attr("x1", 0) .attr("y1", 0) .attr("x2", (d, i) => rScale(maxValue*1.1) * Math.cos(angleSlice*i - Math.PI/2)) .attr("y2", (d, i) => rScale(maxValue*1.1) * Math.sin(angleSlice*i - Math.PI/2)) .attr("class", "line") .style("stroke", "white") .style("stroke-width", "2px"); axis.append("text") .attr("class", "legend") .style("font-size", "18px") .style("font-weight", "400") .attr("transform","rotate(0)") .attr("text-anchor", "middle") .attr("font-family", "calibri") .attr("dy", "0.35em") .attr("x", (d, i) => rScale(maxValue * axisLabelFactor) * Math.cos(angleSlice*i - Math.PI/2)) .attr("y", (d, i) => rScale(maxValue * axisLabelFactor) * Math.sin(angleSlice*i - Math.PI/2)) .text(d => d); const plots = container.append('g') .selectAll('g') .data(avg) .join('g') .attr("data-name", (d, i) => i) .attr("fill", "none") .attr("stroke", "steelblue"); plots.append('path') .attr("d", d => radarLine(d.map(v => v.avg))) .attr("fill", (d, i) => color(i)) .attr("fill-opacity", 0.1) .attr("stroke", (d, i) => color(i)) .attr("stroke-width", 2); plots.selectAll("circle") .data(d => d) .join("circle") .attr("r", dotRadius) .attr("cx", (d,i) => rScale(d.avg) * Math.cos(angleSlice*i - Math.PI/2)) .attr("cy", (d,i) => rScale(d.avg) * Math.sin(angleSlice*i - Math.PI/2)) .attr("fill","red") .style("fill-opacity", 0.8) .append("svg:title") .text(function(d,i){return "Média: "+d.avg;}); return svg.node(); }34:Tc1a,chart2={ //as seen in @palewire/radar-chart let avg=[] averages.forEach(function(g){avg.push(g.slice(8,20))}); let dotRadius=4, height=600, margin=30, axisCircles=7, radius=(height-(margin*2))/2, axisLabelFactor=1.1; let axesDomain=avg[0].map(d=>d.question); let maxValue=7; //d3.max(_.flatten(avg).map(d=>d.avg)); let rScale = d3.scaleLinear() .domain([0, maxValue]) .range([0, radius]); let axesLength=axesDomain.length; let angleSlice=Math.PI * 2 / axesLength; let radarLine = d3.lineRadial() .curve(d3["curveCardinalClosed"]) .radius(d => rScale(d)) .angle((d, i) => i * angleSlice); const svg=d3.select(DOM.svg(width, height+(margin*2))); const containerWidth = width-(margin*2); const containerHeight = height-(margin*2); const container = svg.append('g') .attr("width", containerWidth) .attr("height", containerHeight) .attr('transform', `translate(${(width/2)+margin}, ${(height/2)+margin})`); var axisGrid = container.append("g") .attr("class", "axisWrapper"); axisGrid.selectAll(".levels") .data(d3.range(1,(axisCircles+1)).reverse()) .enter() .append("circle") .attr("class", "gridCircle") .attr("r", (d, i) => radius/axisCircles*d) .style("fill", "#FEC34D") //previously #CDCDCD .style("stroke", "#FEC34D") //previously #CDCDCD .style("fill-opacity", 0.1); const axis = axisGrid.selectAll(".axis") .data(axesDomain) .enter() .append("g") .attr("class", "axis"); axis.append("line") .attr("x1", 0) .attr("y1", 0) .attr("x2", (d, i) => rScale(maxValue*1.1) * Math.cos(angleSlice*i - Math.PI/2)) .attr("y2", (d, i) => rScale(maxValue*1.1) * Math.sin(angleSlice*i - Math.PI/2)) .attr("class", "line") .style("stroke", "white") .style("stroke-width", "2px"); axis.append("text") .attr("class", "legend") .style("font-size", "12px") .style("font-weight", "700") .attr("transform","rotate(0)") .attr("text-anchor", "middle") .attr("font-family", "sans-serif") .attr("dy", "0.35em") .attr("x", (d, i) => rScale(maxValue * axisLabelFactor) * Math.cos(angleSlice*i - Math.PI/2)) .attr("y", (d, i) => rScale(maxValue * axisLabelFactor) * Math.sin(angleSlice*i - Math.PI/2)) .text(d => d); const plots = container.append('g') .selectAll('g') .data(avg) .join('g') .attr("data-name", (d, i) => i) .attr("fill", "none") .attr("stroke", "steelblue"); plots.append('path') .attr("d", d => radarLine(d.map(v => v.avg))) .attr("fill", (d, i) => color(i)) .attr("fill-opacity", 0.1) .attr("stroke", (d, i) => color(i)) .attr("stroke-width", 2); plots.selectAll("circle") .data(d => d) .join("circle") .attr("r", dotRadius) .attr("cx", (d,i) => rScale(d.avg) * Math.cos(angleSlice*i - Math.PI/2)) .attr("cy", (d,i) => rScale(d.avg) * Math.sin(angleSlice*i - Math.PI/2)) .attr("fill","red") .style("fill-opacity", 0.8) .append("svg:title") .text(function(d,i){return "Média: "+d.avg;}); return svg.node(); }35:Tc32,chart3={ //as seen in @palewire/radar-chart let avg=[] averages.forEach(function(g){avg.push(g.slice(30,43))}); let dotRadius=4, height=600, margin=30, axisCircles=5, radius=(height-(margin*2))/2, axisLabelFactor=1.1; let axesDomain=avg[0].map(d=>d.question); let maxValue=5; //d3.max(_.flatten(avg).map(d=>d.avg)); let rScale = d3.scaleLinear() .domain([0, maxValue]) .range([0, radius]); let axesLength=axesDomain.length; let angleSlice=Math.PI * 2 / axesLength; let radarLine = d3.lineRadial() .curve(d3["curveCardinalClosed"]) .radius(d => rScale(d)) .angle((d, i) => i * angleSlice); const svg=d3.select(DOM.svg(width, height+(margin*2))); const containerWidth = width-(margin*2); const containerHeight = height-(margin*2); const container = svg.append('g') .attr("width", containerWidth) .attr("height", containerHeight) .attr('transform', `translate(${(width/2)+margin}, ${(height/2)+margin})`); var axisGrid = container.append("g") .attr("class", "axisWrapper"); axisGrid.selectAll(".levels") .data(d3.range(1,(axisCircles+1)).reverse()) .enter() .append("circle") .attr("class", "gridCircle") .attr("r", (d, i) => radius/axisCircles*d) .style("fill", "#FEC34D") //previously #CDCDCD .style("stroke", "#FEC34D") //previously #CDCDCD .style("fill-opacity", 0.1); const axis = axisGrid.selectAll(".axis") .data(axesDomain) .enter() .append("g") .attr("class", "axis"); axis.append("line") .attr("x1", 0) .attr("y1", 0) .attr("x2", (d, i) => rScale(maxValue*1.1) * Math.cos(angleSlice*i - Math.PI/2)) .attr("y2", (d, i) => rScale(maxValue*1.1) * Math.sin(angleSlice*i - Math.PI/2)) .attr("class", "line") .style("stroke", "white") .style("stroke-width", "2px"); axis.append("text") .attr("class", "legend") .style("font-size", "12px") .style("font-weight", "400") .attr("transform","rotate(0)") .attr("text-anchor", "middle") .attr("font-family", "calibri") .attr("dy", "0.35em") .attr("x", (d, i) => rScale(maxValue * axisLabelFactor) * Math.cos(angleSlice*i - Math.PI/2)) .attr("y", (d, i) => rScale(maxValue * axisLabelFactor) * Math.sin(angleSlice*i - Math.PI/2)) .text(d => d.split("[")[1].slice(0,-1)); const plots = container.append('g') .selectAll('g') .data(avg) .join('g') .attr("data-name", (d, i) => i) .attr("fill", "none") .attr("stroke", "steelblue"); plots.append('path') .attr("d", d => radarLine(d.map(v => v.avg))) .attr("fill", (d, i) => color(i)) .attr("fill-opacity", 0.1) .attr("stroke", (d, i) => color(i)) .attr("stroke-width", 2); plots.selectAll("circle") .data(d => d) .join("circle") .attr("r", dotRadius) .attr("cx", (d,i) => rScale(d.avg) * Math.cos(angleSlice*i - Math.PI/2)) .attr("cy", (d,i) => rScale(d.avg) * Math.sin(angleSlice*i - Math.PI/2)) .attr("fill","red") .style("fill-opacity", 0.8) .append("svg:title") .text(function(d,i){return "Média: "+d.avg;}); return svg.node(); }36:T9e1,bars={ var margin = {top: 0, right: 0, bottom: 20, left: 35}, width2 = width - margin.left - margin.right, height = 600 - margin.top - margin.bottom; var root = d3.select(DOM.svg(width2+margin.left+margin.right,height+margin.top+margin.bottom)); let svg=root.append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); var subgroups = [0,1,2]; let labels=["Deve estar presente","Indiferente","Deve estar ausente"] var groups = musicalGenres.map(d=>d.name); var x = d3.scaleBand() .domain(groups) .range([0, width2]) .padding([0.2]) svg.append("g") .attr("transform", "translate(0," + height + ")") .style("font-size","15px") .style("font-family","sans-serif") .call(d3.axisBottom(x).tickSize(0)); var y = d3.scaleLinear() .domain([0, 0.95]) .range([ height, 0 ]); svg.append("g") .style("font-size","11px") .style("font-family","sans-serif") .call(d3.axisLeft(y).tickFormat(d3.format(".0%"))); var xSubgroup = d3.scaleBand() .domain(subgroups) .range([0, x.bandwidth()]) .padding([0.1]) var color = d3.scaleOrdinal() .domain(subgroups) .range(['#4daf4a','#377eb8','#e41a1c']) svg.append("g") .selectAll("g") .data(musicalGenres) .enter() .append("g") .attr("transform", function(d) { return "translate(" + x(d.name) + ",0)"; }) .selectAll("rect") .data(function(d) { return subgroups.map(function(key) { return {key: key, value: d.values[key]}; }); }) .enter().append("rect") .attr("x", function(d) { return xSubgroup(d.key); }) .attr("y", function(d) { return y(d.value); }) .attr("width", xSubgroup.bandwidth()) .attr("height", function(d) { return height - y(d.value); }) .attr("fill", function(d) { return color(d.key); }) .append("svg:title") .text(function(d,i){return labels[d.key]+": "+d.value+" ("+100*d.value/filteredData.length+"%) respostas.";}) svg.append("g").selectAll("g") .data(musicalGenres) .enter() .append("g") .attr("transform", function(d) { return "translate(" + x(d.name) + ",0)"; }).selectAll("text") .data(function(d) { return subgroups.map(function(key) { return {key: key, value: d.values[key]}; }); }) .enter() .append("text") .attr("x", d=>xSubgroup(d.key)) .attr("y",d=>y(d.value)-5) .style("font-size","11px") .style("font-family","sans-serif") .text(d=>(d.value*100).toFixed(1)+"%") return root.node(); }37:T432,vinheta={ let qbegin=105, qend=124 let ret=new Array(qend-qbegin+1) for (let i=0;id/filteredData.length)} ret.forEach(function(d){if (d.name=="a) o que achou da vinheta em geral") d.name="Vinheta em geral"}) ret.forEach(function(d){if (d.name=="b) o que achou da música de fundo") d.name="Música de fundo"}) ret.forEach(function(d){if (d.name=="c) o que achou da voz da locutora") d.name="Voz da locutora"}) ret.forEach(function(d){if (d.name=="d) o que achou da entonação da locutora") d.name="Entonação da locutora"}) return ret.slice(0,4) }38:Tc86,bars2={ var margin = {top: 5, right: 5, bottom: 20, left: 35}, width2 = width - margin.left - margin.right, height = 600 - margin.top - margin.bottom; var root = d3.select(DOM.svg(width2+margin.left+margin.right,height+margin.top+margin.bottom)); let svg=root.append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); var subgroups = [0,1,2,3,4]; let labels=["Ótima","Boa","Regular","Ruim","Péssima"] var groups = vinheta.map(d=>d.name); var x = d3.scaleBand() .domain(groups) .range([0, width2]) .padding([0.2]) svg.append("g") .attr("transform", "translate(0," + height + ")") .style("font-size","15px") .style("font-family","sans-serif") .call(d3.axisBottom(x).tickSize(0)); var y = d3.scaleLinear() .domain([0, 0.55]) .range([ height, 0 ]); svg.append("g") .style("font-size","11px") .style("font-family","sans-serif") .call(d3.axisLeft(y).tickFormat(d3.format(".0%"))); var xSubgroup = d3.scaleBand() .domain(subgroups) .range([0, x.bandwidth()]) .padding([0.1]) var color = d3.scaleOrdinal() .domain(subgroups) .range(["#973999","#007EFE","#00BB00","#FEF601","#DD0000"]) svg.append("g") .selectAll("g") .data(vinheta) .enter() .append("g") .attr("transform", function(d) { return "translate(" + x(d.name) + ",0)"; }) .selectAll("rect") .data(function(d) { return subgroups.map(function(key) { return {key: key, value: d.values[key]}; }); }) .enter().append("rect") .attr("x", function(d) { return xSubgroup(d.key); }) .attr("y", function(d) { return y(d.value); }) .attr("width", xSubgroup.bandwidth()) .attr("height", function(d) { return height - y(d.value); }) .attr("fill", function(d) { return color(d.key); }) .append("svg:title") .text(function(d,i){return labels[d.key]+": "+d.value+" ("+100*d.value/filteredData.length+"%) respostas.";}) svg.append("g").selectAll("g") .data(vinheta) .enter() .append("g") .attr("transform", function(d) { return "translate(" + x(d.name) + ",0)"; }).selectAll("text") .data(function(d) { return subgroups.map(function(key) { return {key: key, value: d.values[key]}; }); }) .enter() .append("text") .attr("x", d=>xSubgroup(d.key)) .attr("y",d=>y(d.value)-20) .style("font-size","12px") .style("font-family","sans-serif") .text(d=>(d.value*100).toFixed(1)+"%") svg.append("g").selectAll("g") .data(vinheta) .enter() .append("g") .attr("transform", function(d) { return "translate(" + x(d.name) + ",0)"; }).selectAll("text") .data(function(d) { return subgroups.map(function(key) { return {key: key, value: d.values[key]}; }); }) .enter() .append("text") .attr("x", d=>xSubgroup(d.key)) .attr("y",d=>y(d.value)-5) .style("font-size","12px") .style("font-family","sans-serif") .text(d=>conv(d.key)) function conv(d){ if (d==0) return "Ótima" if (d==1) return "Boa" if (d==2) return "Regular" if (d==3) return "Ruim" else return "Péssima" } return root.node(); }39:T92a,violin={ var margin = {top: 10, right: 30, bottom: 30, left: 40}, width2 = width - margin.left - margin.right, height = 600 - margin.top - margin.bottom; var root = d3.select(DOM.svg(width2 + margin.left + margin.right,height + margin.top + margin.bottom)) let svg=root .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); let questions=[4,5,6,7,8,9,10,11] let data=[] questions.forEach(idx=>filteredData.map(d=>data.push({question:q[idx],value:d[q[idx]]}))) var y = d3.scaleLinear() .domain([0,8]) .range([height, 0]) svg.append("g").call( d3.axisLeft(y) ) var x = d3.scaleBand() .range([0, width2]) .domain(questions.map(idx=>q[idx])) .padding(0.1) //0 - 1 svg.append("g") .attr("transform", "translate(0," + height + ")") .style("font-size","12px") .call(d3.axisBottom(x)) //.selectAll(".tick text") //.call(wrap, x.bandwidth()) var histogram = d3.histogram() .domain(y.domain()) .thresholds(y.ticks(20)) //maybe 10? .value(d => d) // Compute the binning for each group of the dataset var sumstat = d3.nest() // nest function allows to group the calculation per level of a factor .key(function(d) { return d.question;}) .rollup(function(d) { let input = d.map(function(g) { return g.value;}) let bins = histogram(input) return(bins) }) .entries(data) var maxNum = 0 for ( let i in sumstat ){ let allBins = sumstat[i].value let lengths = allBins.map(function(a){return a.length;}) let longuest = d3.max(lengths) if (longuest > maxNum) { maxNum = longuest } } var xNum = d3.scaleLinear() .range([0, x.bandwidth()]) .domain([-maxNum,maxNum]) svg .selectAll("myViolin") .data(sumstat) .enter() .append("g") .attr("transform", function(d){ return("translate(" + x(d.key) +" ,0)") } ) .append("path") .datum(function(d){ return(d.value)}) .style("stroke", "none") .style("fill","#FF6900") .attr("d", d3.area() .x0(function(d){ return(xNum(-d.length)) } ) .x1(function(d){ return(xNum(d.length)) } ) .y(function(d){ return(y(d.x0)) } ) .curve(d3.curveBasis) //previously curveCatmullRom ) return root.node() }3a:T94d,violin2={ var margin = {top: 10, right: 30, bottom: 30, left: 40}, width2 = width - margin.left - margin.right, height = 600 - margin.top - margin.bottom; var root = d3.select(DOM.svg(width2 + margin.left + margin.right,height + margin.top + margin.bottom)) let svg=root .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); let questions=[30,31,32,33,34,35,36,37,38,39,40,41,42] let labels=["Saúde","Educação","Direito","Economia","Política","Cidade","Mundo","Tecnologia","Ciências Humanas","Cultura","Serviço Social","Esportes","Vida Acadêmica"] let data=[] questions.forEach(function(idx,l){ filteredData.map(d=>data.push({question:labels[l],value:d[q[idx]]})) }) var y = d3.scaleLinear() .domain([0,6]) .range([height, 0]) svg.append("g").call( d3.axisLeft(y) ) var x = d3.scaleBand() .range([0, width2]) .domain(labels) .padding(0.1) //0 - 1 svg.append("g") .attr("transform", "translate(0," + height + ")") .call(d3.axisBottom(x)) var histogram = d3.histogram() .domain(y.domain()) .thresholds(y.ticks(10)) //maybe 10? .value(d => d) // Compute the binning for each group of the dataset var sumstat = d3.nest() .key(function(d) { return d.question;}) .rollup(function(d) { let input = d.map(function(g) { return g.value;}) let bins = histogram(input) return(bins) }) .entries(data) var maxNum = 0 for ( let i in sumstat ){ let allBins = sumstat[i].value let lengths = allBins.map(function(a){return a.length;}) let longuest = d3.max(lengths) if (longuest > maxNum) { maxNum = longuest } } var xNum = d3.scaleLinear() .range([0, x.bandwidth()]) .domain([-maxNum,maxNum]) svg .selectAll("myViolin") .data(sumstat) .enter() .append("g") .attr("transform", function(d){ return("translate(" + x(d.key) +" ,0)") } ) .append("path") .datum(function(d){ return(d.value)}) .style("stroke", "none") .style("fill","#FF6900") .attr("d", d3.area() .x0(function(d){ return(xNum(-d.length)) } ) .x1(function(d){ return(xNum(d.length)) } ) .y(function(d){ return(y(d.x0)) } ) .curve(d3.curveBasis) //previously curveCatmullRom ) return root.node() }3b:Tce6,generic={ var margin = {top: 10, right: 0, bottom: 0, left: 100}, width2 = width - margin.left - margin.right, height = width - margin.top - margin.bottom; var root = d3.select(DOM.svg(width2+100,height+250)) let svg=root.append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); let data=answers //let temp=[] //temp.push({name:"Demais Cursos",value:0}) //data.forEach(function(d){ // if (d.value<3) // temp[0].value+=1 // else // temp.push(d) //}) //data=temp //data.forEach(d=>d.value/=368) //data.forEach(function(d){if(d.name=="Biblioteconomia e Gestão de Unidades de Informação")d.name="Biblioteconomia"}) //data.forEach(function(d){if(d.name=="Sou servidor(a) que não trabalha em um curso específico.")d.name="Servidores não alocados em curso específico"}) //data=data.filter(d=>d.name[0]=="F"&d.name!="FM 89,5") //data=shuffleArray(data) //data=data.filter(d=>["Campus Praia Vermelha","Cidade Universitária","Instituto de Filosofia e Ciências Sociais","Não frequento a UFRJ","Faculdade Nacional de Direito","Campus Duque de Caxias","Escola de Música","Campus Macaé","Observatório do Valongo","Colégio de Aplicação da UFRJ","Hospital Escola São Francisco de Assis","Museu Nacional","Complexo Avançado de Xerém"].includes(d.name)) //data=data.filter(d=>d.name!="Pós-graduando da UFRJ, Servidor técnico-administrativo da UFRJ") //data.forEach(d=>d.name=d.name.replace(" – "," ")) //data.forEach(d=>d.name=d.name.split("- ")[1]) //data.forEach(function(d){if(d.name=="Rádio 94 FM")d.name="Rádio 94FM"}) //data.forEach(function(d){if(d.name=="Rádio 93 FM")d.name="Rádio 93FM"}) //data.forEach(function(d){if (d.name=="De 2.995,00 a R44.990,00") d.name="De R$2.995,00 a R$4.990,00"}) //data.forEach(function(d){if (d.name=="Não sei/Prefiro não responder") d.name="Não sei / Prefiro não responder"}) //data=data.filter(d=>d.value>0.003) data=data.sort(function(a,b){return b.value-a.value}) var x = d3.scaleBand() .range([ 0, width2 ]) .domain(data.map(function(d) { return d.name; })) .padding(0.2); svg.append("g") .attr("transform", "translate(0," + height + ")") .style("font-size","15px") //10 .call(d3.axisBottom(x)) .selectAll("text") .attr("transform", "translate(-10,0)rotate(-45)") .style("text-anchor", "end"); var y = d3.scaleLinear() //.domain([0, 10*Math.ceil(data.map(d=>d.value).reduce(function(a,b){return Math.max(a,b);})/10)]) .domain([0,0.5]) .range([ height, 0]); svg.append("g") .call(d3.axisLeft(y).tickFormat(d3.format(".0%"))); svg.selectAll("mybar") .data(data) .enter() .append("rect") .attr("x", function(d) { return x(d.name); }) .attr("y", function(d) { return y(d.value); }) .attr("width", x.bandwidth()) .attr("height", function(d) { return height - y(d.value); }) .attr("fill", "#FF6900") .append("svg:title") .text(function(d,i){return d.name+": "+d.value+" ("+100*d.value/filteredData.length+"%)";}); svg.selectAll("label") .data(data) .enter() .append("text") .attr("x", d=>x(d.name)+5) .attr("y",d=>y(d.value)-5) .style("font-size","15px") .style("font-family","sans-serif") .text(d=>(d.value*100).toFixed(1)+"%") return root.node() }3c:T667,genericHorizontal={ var margin = {top: 10, right: 0, bottom: 0, left: 102}, width2 = width - margin.left - margin.right, height = width - margin.top - margin.bottom; var root = d3.select(DOM.svg(width2+112,height+100)) let svg=root.append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); let data=sit data=data.sort(function(a,b){return b.value-a.value}) var x = d3.scaleBand() .range([ height, 0 ]) .domain(data.map(function(d) { return d.name; })) .padding(0.2); svg.append("g") .call(d3.axisLeft(x)) .selectAll("text") .attr("transform", "translate(-10,0)rotate(-45)") .style("text-anchor", "end"); var y = d3.scaleLinear() //.domain([0, 10*Math.ceil(data.map(d=>d.value).reduce(function(a,b){return Math.max(a,b);})/10)]) .domain([0,0.7]) .range([ 0, width2]); svg.append("g") .attr("transform", "translate(0," + height + ")") .style("font-size","10px") //15 .call(d3.axisBottom(y).tickFormat(d3.format(".0%"))); svg.selectAll("mybar") .data(data) .enter() .append("rect") .attr("y", function(d) { return x(d.name); }) .attr("width", d=>y(d.value)) .attr("height", x.bandwidth()) .attr("fill", "#FF6900") .append("svg:title") .text(function(d,i){return d.name+": "+d.value+" ("+100*d.value/filteredData.length+"%)";}); svg.selectAll("label") .data(data) .enter() .append("text") .attr("x", d=>y(d.value)+5) .attr("y",d=>x(d.name)+x.bandwidth()/2) .style("font-size","15px") .style("font-family","sans-serif") .text(d=>(d.value*100).toFixed(1)+"%") return root.node() }3d:[] 2d:{"id":"b6afbdee4b082a43","slug":"analysing-data-from-google-forms-test","title":"Analysing Data from Google Forms","thumbnail":"cf9821a1c72a1b0f300b3cb6aba51f73d01a80eac2397ca729ce13bacd87de55","access_level":"public","create_time":"$D2019-06-21T19:04:00.150Z","update_time":"$D2019-08-28T20:49:08.500Z","view_time":null,"first_public_time":"$D2019-06-21T21:10:53.366Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"78ed5d16c7b764e3","login":"lucasbarcellosoliveira","name":"Lucas Barcellos Oliveira","avatar_url":"https://avatars-next.observableusercontent.com/f666bfbf81c5ce3e07b141f9368d214d65395420ff64ff65964a78fd85ca75c2","tier":"starter_2024"},"version":1573,"publish_version":1573,"role":null,"authored":false,"authors":[{"type":"individual","id":"1f921ee8155bda89","login":"lucasbarcellosoliveira","name":"Lucas Barcellos Oliveira","avatar_url":"https://avatars-next.observableusercontent.com/f666bfbf81c5ce3e07b141f9368d214d65395420ff64ff65964a78fd85ca75c2","tier":null}],"members":[{"type":"individual","id":"1f921ee8155bda89","login":"lucasbarcellosoliveira","name":"Lucas Barcellos Oliveira","avatar_url":"https://avatars-next.observableusercontent.com/f666bfbf81c5ce3e07b141f9368d214d65395420ff64ff65964a78fd85ca75c2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Analysing Data from Google Forms","cells":[{"id":0,"value":"md`# Analysing Data from Google Forms`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"md`### All responses loaded from spreadsheet`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"data=d3.tsv(\"https://docs.google.com/spreadsheets/d/e/2PACX-1vRfvYYaust34Qiczv6s8ekMqVfS3zT3SVTqgyeym09uWoEvbpDybB75pRoZfV10ThTRBlmGMhehpkxi/pub?gid=187250421&single=true&output=tsv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":240,"value":"md`### List of questions and their indexes`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":12,"value":"q=Object.keys(data[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1096,"value":"md`### Responses after label encoding`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1085,"value":"processedData={\n let filteredData=data, questions=[4,5,6,7,8,9,10,11,16,17,18,19,20,21,22,23,24,25,26,30,31,32,33,34,35,36,37,38,39,40,41,42]\n filteredData.forEach(function(d){\n for (let i of questions){\n if (d[q[i]]==\"Muito importante\") d[q[i]]=5\n if (d[q[i]]==\"Importante\") d[q[i]]=4\n if (d[q[i]]==\"Indiferente\") d[q[i]]=3\n if (d[q[i]]==\"Pouco importante\") d[q[i]]=2\n if (d[q[i]]==\"Nada importante\") d[q[i]]=1\n if (d[q[i]]==\"Ótimo\") d[q[i]]=5\n if (d[q[i]]==\"Ótima\") d[q[i]]=5\n if (d[q[i]]==\"Bom\") d[q[i]]=4\n if (d[q[i]]==\"Boa\") d[q[i]]=4\n if (d[q[i]]==\"Regular\") d[q[i]]=3\n if (d[q[i]]==\"Ruim\") d[q[i]]=2\n if (d[q[i]]==\"Péssimo\") d[q[i]]=1\n if (d[q[i]]==\"Péssima\") d[q[i]]=1\n }\n })\n return filteredData\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":245,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"md`## Filters`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":506,"value":"viewof typeFilter = checkbox({\n title: \"Filter by type\",\n description: \"Please, select one or several types to filter results.\",\n options: [...new Set(data.map(d=>d[q[1]]))].sort(),\n value: [...new Set(data.map(d=>d[q[1]]))],\n submit: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"viewof campusFilter = checkbox({\n title: \"Filter by campus\",\n description: \"Please, select one or several campi to filter results.\",\n options: [...new Set(data.map(d=>d[q[2]]))].sort(),\n value: [...new Set(data.map(d=>d[q[2]]))],\n submit: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":514,"value":"viewof courseFilter = checkbox({\n title: \"Filter by course\",\n description: \"Please, select one or several undergraduate courses to filter results.\",\n options: [...new Set(data.map(d=>d[q[3]]))].sort(),\n value: [...new Set(data.map(d=>d[q[3]]))],\n submit: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"viewof ageFilter = checkbox({\n title: \"Filter by age\",\n description: \"Please, select one or several age groups to filter results.\",\n options: [...new Set(data.map(d=>d[q[125]]))].sort(),\n value: [...new Set(data.map(d=>d[q[125]]))],\n submit: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"viewof genderFilter = checkbox({\n title: \"Filter by gender\",\n description: \"Please, select one or several gender identities to filter results.\",\n options: [...new Set(data.map(d=>d[q[126]]))],\n value: [...new Set(data.map(d=>d[q[126]]))],\n submit: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"viewof incomeFilter = checkbox({\n title: \"Filter by monthly income\",\n description: \"Please, select one or several monthly household income bins to filter results.\",\n options: [...new Set(data.map(d=>d[q[127]]))].sort(),\n value: [...new Set(data.map(d=>d[q[127]]))],\n submit: false\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":251,"value":"md`### Filtered responses`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":57,"value":"filteredData=processedData.filter(function(d){\n return ageFilter.includes(d[q[125]])&&genderFilter.includes(d[q[126]])&&incomeFilter.includes(d[q[127]])&&typeFilter.includes(d[q[1]])&&campusFilter.includes(d[q[2]])&&courseFilter.includes(d[q[3]])\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":200,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":197,"value":"md`# Most frequent responses to\n\n### _\"Você tem outras sugestões de artistas a serem incluídos na programação musical da Rádio UFRJ?\"_`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"comp=filteredData\n .map(d=>d[q[89]].split(\",\").map(d=>d.replace(/^\\s+|\\s+$/g, '').replace(/\\./g,' ').toUpperCase().normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\")))\n .reduce((acc, val) => acc.concat(val), [])\n .filter(function(d){return d!=\"\"&&d.length<20&&d.length>3});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"compCount={\n let counted=count(comp)\n let toOrder=[]\n for (let i=0;i`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"md`## _\"Você tem outras sugestões de temas que devem ser cobertos pela Rádio UFRJ?\"_`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":124,"value":"theme=filteredData\n .map(d=>d[q[43]].split(\" \").map(d=>d\n .replace(/^\\s+|\\s+$/g,'') //remove left and right spaces\n .replace(/\\./g,'') //remove final dots\n .replace(/!/g,'') //remove final exclamation pints\n .toUpperCase() //convert to upper case\n .normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\") //remove accents\n .replace(/,/g, '') //remove commas\n .substring(0, d.length - +(d.lastIndexOf('s')==d.length-1&&d.lastIndexOf('a')==d.length-2)) //remove final s in 'as'\n .substring(0, d.length - +(d.lastIndexOf('s')==d.length-1&&d.lastIndexOf('o')==d.length-2)))) //remove final s in 'os'\n .reduce((acc, val) => acc.concat(val), [])\n .filter(function(d){return d!=\"\"&&!stopwords.map(d=>d.toUpperCase().normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\")).includes(d)});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":128,"value":"themeCount={\n let counted=count(theme)\n let toOrder=[]\n for (let i=0;i`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":267,"value":"md`## _\"Você tem alguma sugestão para a Rádio UFRJ que não tenha sido mencionada ao longo desta pesquisa?\"_`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":257,"value":"sug=filteredData\n .map(d=>d[q[128]].split(\" \").map(d=>d\n .replace(/^\\s+|\\s+$/g,'') //remove left and right spaces\n .replace(/\\./g,'') //remove final dots\n .replace(/!/g,'') //remove final exclamation pints\n .toUpperCase() //convert to upper case\n .normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\") //remove accents\n .replace(/,/g, '') //remove commas\n .substring(0, d.length - +(d.lastIndexOf('s')==d.length-1&&d.lastIndexOf('a')==d.length-2)) //remove final s in 'as'\n .substring(0, d.length - +(d.lastIndexOf('s')==d.length-1&&d.lastIndexOf('o')==d.length-2)))) //remove final s in 'os'\n .reduce((acc, val) => acc.concat(val), [])\n .filter(function(d){return d!=\"\"&&!stopwords.map(d=>d.toUpperCase().normalize(\"NFD\").replace(/[\\u0300-\\u036f]/g, \"\")).includes(d)&&d.length>2});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"sugCount={\n let counted=count(sug)\n let toOrder=[]\n for (let i=0;i`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":718,"value":"md`## Averages – Radar Charts`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":715,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":722,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":774,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1107,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":958,"value":"md`_Hover over a dot to know its exact numerical value._`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":792,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":810,"value":"md`## Musical Genres – Grouped Barplot`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":798,"value":"musicalGenres={\n let qbegin=44, qend=58\n let ret=new Array(qend-qbegin+1)\n for (let i=0;id/filteredData.length)}\n ret.forEach(function(d){if (d.name==\"Música Popular Brasileira\") d.name=\"MPB\"})\n return ret.slice(0,8)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":818,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":955,"value":"md`_Hover over a bar to know its exact numerical value._`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1497,"value":"DOM.download(() => rasterize(bars), undefined, \"Save as PNG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1517,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1567,"value":"vinhetaMedia={\n let ret=vinheta\n let average=[]\n ret.forEach(function(d){\n let mean=0\n for(let i=0;i<5;i++)\n mean+=d.values[i]*(5-i)\n average.push(mean)\n })\n return average\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1535,"value":"$38","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1554,"value":"md`_Hover over a bar to know its exact numerical value._`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1557,"value":"DOM.download(() => rasterize(bars2), undefined, \"Save as PNG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":807,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1074,"value":"md`## Media Consumption & Theme Preference – Distribution – Violin Graph`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1262,"value":"function wrap(text, width) {\n text.each(function() {\n var text = d3.select(this),\n words = text.text().split(/\\s+/).reverse(),\n word,\n line = [],\n lineNumber = 0,\n lineHeight = 1.1, // ems\n y = text.attr(\"y\"),\n dy = parseFloat(text.attr(\"dy\")),\n tspan = text.text(null).append(\"tspan\").attr(\"x\", 0).attr(\"y\", y).attr(\"dy\", dy + \"em\")\n while (word = words.pop()) {\n line.push(word)\n tspan.text(line.join(\" \"))\n if (tspan.node().getComputedTextLength() > width) {\n line.pop()\n tspan.text(line.join(\" \"))\n line = [word]\n tspan = text.append(\"tspan\").attr(\"x\", 0).attr(\"y\", y).attr(\"dy\", `${++lineNumber * lineHeight + dy}em`).text(word)\n }\n }\n })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":996,"value":"$39","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1134,"value":"$3a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1165,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1246,"value":"md`## Custom question to bar chart`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1171,"value":"viewof selected = autoSelect({\n title:\"Select a question to visualize\",\n options: q.map(function(d,i){return i;}),\n placeholder: \"Type and click a question\",\n description:\"Results will be shown in the graph below\",\n value:\"1\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1184,"value":"answers={\n let answers={}, total=0\n filteredData.map(function(d){\n total++\n if (d[q[selected]] in answers)\n answers[d[q[selected]]]+=1\n else\n answers[d[q[selected]]]=1\n })\n let ret=[]\n for (let i of Object.entries(answers))\n ret.push({name:i[0],value:i[1]/total})\n return ret\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1255,"value":"artistas={\n let qInicio=59, qFim=88\n let deveEstarPresente=[]\n for (let i=qInicio;i<=qFim;i++)\n deveEstarPresente.push({name:q[i].split(\"[\")[1].slice(0,-1),value:0})\n filteredData.forEach(function(d){\n for (let i=qInicio;i<=qFim;i++)\n if (d[q[i]]==\"Deve estar presente\")\n deveEstarPresente[i-qInicio].value+=1\n })\n return deveEstarPresente\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1305,"value":"radios={\n let temp={}, radios=[]\n filteredData.forEach(function(d){\n if (d[q[13]]){\n let lista=d[q[13]].split(\", \")\n lista.forEach(function(e){\n if (e in temp)\n temp[e]+=1\n else\n temp[e]=1\n })\n }\n })\n for (let i of Object.entries(temp))\n radios.push({name:i[0],value:i[1]})\n return radios\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1435,"value":"sit={\n let temp={}, sit=[], total=0\n filteredData.forEach(function(d){\n if (d[q[14]]){\n total++\n let lista=d[q[14]].split(\", \")\n lista.forEach(function(e){\n if (e in temp)\n temp[e]+=1\n else\n temp[e]=1\n })\n }\n })\n for (let i of Object.entries(temp))\n sit.push({name:i[0],value:i[1]/total})\n return sit\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1311,"value":"function shuffleArray(array) {\n for (var i = array.length - 1; i > 0; i--) {\n var j = Math.floor(Math.random() * (i + 1));\n var temp = array[i];\n array[i] = array[j];\n array[j] = temp;\n }\n return array;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1160,"value":"$3b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1448,"value":"DOM.download(() => rasterize(generic), undefined, \"Save as PNG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1442,"value":"$3c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1479,"value":"DOM.download(() => rasterize(genericHorizontal), undefined, \"Save as PNG\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1071,"value":"html`

`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":596,"value":"md`## Correlation Matrix – Heat Map – First 340 responses\n_Used KNIME Analytics Platform 3.7.2 to handle categorical attributes, normalize and compute the correlation matrix._`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":579,"value":"correlationMatrix=d3.csv(\"https://raw.githubusercontent.com/lucasbarcellosoliveira/fonts/master/correlationMatrix3.csv\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":614,"value":"data2={\n let attributes=Object.keys(correlationMatrix[0])\n let data2=[]\n for (let i=0;i`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":227,"value":"md`## Resources`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1445,"value":"import {rasterize} from \"@mbostock/saving-svg\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":742,"value":"_ = require(\"underscore\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"color=d3.scaleOrdinal(d3.schemeSet1) //d3.scaleSequential(d3.interpolateRainbow)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"stopwords=d3.json(\"https://raw.githubusercontent.com/6/stopwords-json/master/dist/pt.json\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"function count(arr) {\n var a = [], b = [], prev;\n\n arr.sort();\n for ( var i = 0; i < arr.length; i++ ) {\n if ( arr[i] !== prev ) {\n a.push(arr[i]);\n b.push(1);\n } else {\n b[b.length-1]++;\n }\n prev = arr[i];\n }\n\n return [a, b];\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"import {checkbox,autoSelect} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":341,"value":"d3cloud = require('d3-cloud')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":5,"value":"d3=require(\"d3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W3d","stdlib":"1","titling":"auto"}} 2e:"$2d:body"