2b:null 2c:["$","title",null,{"children":"TP final (grupo 1) | MARIA SANZ BELLONI's Workspace | Observable"}] 31:T63b,

UNIÓN POR LA PATRIA	LA LIBERTAD AVANZA	JUNTOS POR EL CAMBIO	HACEMOS POR NUESTRO PAIS	FIT - UNIDAD

UP	LLA	JxC	HACEMOS	FIT

32:T521,chart = { const partidos = argentinaPresidenteData.filter(function (dict) { return dict.eleccion_tipo === keyz; }); var grupos = {}; partidos.forEach(function groupByAgrupacionNombre(votos) { var name = votos.agrupacion_nombre; if (grupos.hasOwnProperty(name)) { grupos[name] += votos.votos_cantidad; } else { grupos[name] = votos.votos_cantidad; } return grupos; }); var data = Object.entries(grupos).map(([key, value]) => { var color = colorMap[key] || "#dddddd"; // default color if key is not found return { ["agrupacion_nombre"]: key, ["votos_cantidad"]: value, ["color"]: color }; }); data = [...data].sort((a, b) => b.votos_cantidad - a.votos_cantidad); data = [...data]; if (data.length > 5) { var sum = 0; for (var i = 3; i < data.length; i++) { sum += data[i].votos_cantidad; } var newObj = { ["agrupacion_nombre"]: "Otros", ["votos_cantidad"]: sum, ["color"]: "#dddddd" }; data.splice(3); data.push(newObj); } const colors = data.map(function (dict) { return dict.color; }); const pie = PieChart(data, { name: (d) => d.agrupacion_nombre, value: (d) => d.votos_cantidad, width, height: 500, colors: colors }); return pie; }33:T6ad,porcentajesTotal = { var porcentajes = {}; var total = {}; argentinaPresidenteData.forEach(function (data) { if (!porcentajes.hasOwnProperty(data.eleccion_tipo)) { porcentajes[data.eleccion_tipo] = { [data.distrito_nombre]: { [data.agrupacion_nombre]: { ["votos"]: data.votos_cantidad, ["cantidad"]: 1 } } }; total[data.eleccion_tipo] = { [data.distrito_nombre]: data.votos_cantidad }; } else if ( // Me fijo si esta el distrito !porcentajes[data.eleccion_tipo].hasOwnProperty(data.distrito_nombre) ) { porcentajes[data.eleccion_tipo][data.distrito_nombre] = { [data.agrupacion_nombre]: { ["votos"]: data.votos_cantidad, ["cantidad"]: 1 } }; total[data.eleccion_tipo][data.distrito_nombre] = data.votos_cantidad; } else if ( // Me fijo se esta la agrupacion !porcentajes[data.eleccion_tipo][data.distrito_nombre].hasOwnProperty( data.agrupacion_nombre ) ) { porcentajes[data.eleccion_tipo][data.distrito_nombre][ data.agrupacion_nombre ] = { ["votos"]: data.votos_cantidad, ["cantidad"]: 1 }; total[data.eleccion_tipo][data.distrito_nombre] += data.votos_cantidad; } else { porcentajes[data.eleccion_tipo][data.distrito_nombre][ data.agrupacion_nombre ]["votos"] += data.votos_cantidad; porcentajes[data.eleccion_tipo][data.distrito_nombre][ data.agrupacion_nombre ]["cantidad"] += 1; total[data.eleccion_tipo][data.distrito_nombre] += data.votos_cantidad; } }); return [porcentajes, total]; }34:[{"id":"bee78712ac78df25fe8801ccb2c55c9764fe7cc26820d17be71fd7ae8b6c11bb9e1c7658174ea5adf15b0e36551b52b0b10945e1fad79cf433140cac9e156a47","href":"https://static.observableusercontent.com/files/bee78712ac78df25fe8801ccb2c55c9764fe7cc26820d17be71fd7ae8b6c11bb9e1c7658174ea5adf15b0e36551b52b0b10945e1fad79cf433140cac9e156a47","name":"ResultadosPresidente@3.csv","type":"text/csv","lastModified":1700929496126.987,"size":58795}] 2f:{"id":"05ac47ed18ec05f6","slug":null,"title":"TP final (grupo 1)","thumbnail":"d1de5613ffce843de886b24d1f10b40d1027b80c22ea3950b63f71ec2227b038","access_level":"public","create_time":"$D2023-10-14T04:05:33.373Z","update_time":"$D2023-12-01T18:01:30.276Z","view_time":null,"first_public_time":"$D2023-10-14T04:05:33.373Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"192878ebfc74aef4","login":"maria-sanz-belloni-ws","name":"MARIA SANZ BELLONI's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/9a8e1a664a4b872571b8fc9ad57968c7e5cb294a2fe8f0e521c99b594299d9af","tier":"starter_2024"},"version":1133,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"4590126435244d8d","login":"ian-dalton","name":"IAN DALTON","avatar_url":"https://avatars-next.observableusercontent.com/3e4953d13ee9b1bea880ffdecc1757a364b7dc582e19bc9f81069b51e2fe5078","tier":null},{"type":"individual","id":"b6d4bccdb635ded0","login":"abril-schafer","name":"ABRIL SCHAFER","avatar_url":"https://avatars-next.observableusercontent.com/92e0bd8c201480eb15bc221b578da9d0bd3b6e368e6483ef880230639a173398","tier":null},{"type":"individual","id":"3cd759dd890fd6e4","login":"manuela-maria-romero","name":"MANUELA MARIA ROMERO","avatar_url":"https://avatars-next.observableusercontent.com/4d910e73e8635e41897a5fe4bb6130e7d89fdcd7ab10f88fdd06ad43fcd880c2","tier":null},{"type":"individual","id":"c03f1f47fba01d23","login":"aaizemberg","name":"Ariel Aizemberg","avatar_url":"https://avatars-next.observableusercontent.com/ed6ddd5070826f572b9138f152d0a8186bfae935f311bbf11300e1fa71eae43c","tier":null}],"members":[{"type":"individual","id":"18cda2861cccb6b0","login":"maria-sanz-belloni","name":"MARIA SANZ BELLONI","avatar_url":"https://avatars-next.observableusercontent.com/9e25ca7fcc9ee97061f5b416be6265c4985dd617ce352767af341be3850e9a7a","tier":null,"role":"editor"},{"type":"team","id":"192878ebfc74aef4","login":"maria-sanz-belloni-ws","name":"MARIA SANZ BELLONI's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/9a8e1a664a4b872571b8fc9ad57968c7e5cb294a2fe8f0e521c99b594299d9af","tier":"starter_2024","role":"editor"}],"comments":[{"id":"706c8010aa40e221","reply_to_id":null,"content":"la variable \"mesa_electores\" esta mal.\ntendrían que haber tomado un solo valor por mesa o el max, no la suma.","create_time":"$D2023-12-01T18:00:20.454Z","update_time":null,"resolved":false,"user":{"type":"individual","id":"c03f1f47fba01d23","login":"aaizemberg","name":"Ariel Aizemberg","avatar_url":"https://avatars-next.observableusercontent.com/ed6ddd5070826f572b9138f152d0a8186bfae935f311bbf11300e1fa71eae43c","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"TP final (grupo 1)","cells":[{"id":0,"value":"# TP final (grupo 1)\n\n## 2do cuatrimestre del 2023","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"1. Generar un notebook en Observable. \n2. Poner a todos los alumnos del grupo como editores de ese anotador.\n3. Agregar al docente como editor de dicho anotador.\n4. Cargar un conjunto de datos (uno o varios archivos en formato csv's o .tsv) de manera remota, los datos pueden salir del _github_ de Uds.\n5. Operaciones de data wrangling como: filtrado, generación de nuevas variables, join, etc. usando https://observablehq.com/@observablehq/data-wrangler o javascript.\n6. Realizar algunos gráficos exploratorios (EDA). \n7. Realizar una visualización interactiva, utilizando alguna de estas 3 librerías *Plot.js*, *vega-lite* o *D3* que responda alguna pregunta interesante planteada por Uds.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"## Grupo 1\n\n### Integrantes\n1. [Ian Dalton](https://observablehq.com/@ian-dalton)\n2. [Manuela María Romero](https://observablehq.com/@manuela-maria-romero)\n3. [Abril Schafer](https://observablehq.com/@abril-schafer)\n\n\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":32,"value":"# Elecciones 2023 en Argentina\n\n## Presidente y Vice","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":361,"value":"viewof keyz = {\n const form = html`

${Object.assign(\n html``,\n { value: eleccionTipos[0] }\n )} eleccion`;\n form.select.onchange = () => (\n (form.value = form.select.value),\n form.dispatchEvent(new CustomEvent(\"input\"))\n );\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1031,"value":"grafico = {\n const datos = votosPais[keyz].sort((a, b) => {\n if (a.total < b.total) {\n return 1;\n }\n return -1;\n });\n\n var colors = [];\n votosPais[keyz].forEach(function (values) {\n colors.push(colorMap[values.partido] || \"#dddddd\");\n });\n const graf = Plot.plot({\n marginLeft: 275,\n marks: [\n Plot.barX(datos, {\n x: \"total\",\n y: \"partido\",\n fill: \"color\",\n tip: true,\n sort: { y: \"-x\" }\n })\n ]\n });\n var ret = graf;\n //ret = votosPais[keyz];\n return graf;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":784,"value":"viewof keyzPartyY = {\n const form = html`${Object.assign(\n html``,\n { value: partidos[0] }\n )} Partido Y`;\n form.select.onchange = () => (\n (form.value = form.select.value),\n form.dispatchEvent(new CustomEvent(\"input\"))\n );\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":839,"value":"viewof keyzPartyX = {\n const form = html`${Object.assign(\n html``,\n { value: partidosX[0] }\n )} Partido X`;\n form.select.onchange = () => (\n (form.value = form.select.value),\n form.dispatchEvent(new CustomEvent(\"input\"))\n );\n form.select.onchange();\n return form;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":741,"value":"Plot.plot({\n // color: { legend: true },\n marks: [\n Plot.dot(porcentajes[keyz], {\n x: keyzPartyX,\n y: keyzPartyY,\n fill: \"Provincia\",\n stroke: \"white\",\n tip: true,\n r: 6\n }),\n Plot.linearRegressionY(porcentajes[keyz], {\n x: keyzPartyX,\n y: keyzPartyY,\n stroke: \"red\"\n }),\n\n Plot.ruleX({ stroke: \"grey\", strokeWidth: 0.5 }),\n Plot.ruleY({ stroke: \"grey\", strokeWidth: 0.5 })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":775,"value":"Plot.plot({\n marginLeft: 250,\n title: \"Porcentaje votos del partido \" + keyzPartyX,\n marks: [\n Plot.barX(porcentajes[keyz], {\n fill: colorMap[keyzPartyX],\n x: keyzPartyX,\n y: \"Provincia\",\n tip: true,\n sort: { y: \"-x\" }\n }),\n\n Plot.ruleX([0, 10, 20, 30, 40], { stroke: \"white\" }),\n Plot.ruleX([5, 15, 25, 35, 45], { stroke: \"white\", strokeWidth: 0.2 })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":884,"value":"Plot.plot({\n marginLeft: 250,\n title: \"Porcentaje votos del partido \" + keyzPartyY,\n marks: [\n Plot.barX(porcentajes[keyz], {\n fill: colorMap[keyzPartyY],\n x: keyzPartyY,\n y: \"Provincia\",\n tip: true,\n sort: { y: \"-x\" }\n }),\n\n Plot.ruleX([0, 10, 20, 30, 40], { stroke: \"white\" }),\n Plot.ruleX([5, 15, 25, 35, 45], { stroke: \"white\", strokeWidth: 0.2 })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":264,"value":"#### Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":143,"value":"// import { vl } from \"@vega/vega-lite-api\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":247,"value":"// import { Wrangler, op } from \"@observablehq/data-wrangler\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"import {PieChart} from \"@d3/pie-chart-component\";","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":363,"value":"eleccionTipos = [\"PASO\", \"GENERAL\", \"SEGUNDA VUELTA\"]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1130,"value":"[...new Set(argentinaPresidenteData.map((d) => d.eleccion_tipo))]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":279,"value":"argentinaPresidenteData = FileAttachment(\"ResultadosPresidente@3.csv\").csv({\n typed: true\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"select * from ResultadosPresidente","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"ResultadosPresidente@3.csv"},{"id":935,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":636,"value":"porcentajes = {\n //Mostrar evolucion del resultado del partido\n var porcentajes = porcentajesTotal[0];\n const total = porcentajesTotal[1];\n\n var data = Object.entries(porcentajes).map(([key, value]) => {\n var partidos = [];\n\n Object.entries(value).map(([provincia, valores]) => {\n //total[key][provincia] -= valores[\"Blanco/Impugnado/Nulo\"].votos;\n var votosEnProvincia = { [\"Provincia\"]: provincia };\n Object.entries(valores).map(([partido, votos]) => {\n votosEnProvincia[partido] = parseFloat(\n ((votos.votos / total[key][provincia]) * 100).toFixed(2)\n );\n });\n partidos.push(votosEnProvincia);\n });\n return partidos;\n });\n porcentajes = {\n [eleccionTipos[0]]: data[1],\n [eleccionTipos[1]]: data[0],\n [eleccionTipos[2]]: data[2]\n };\n\n return porcentajes;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":778,"value":"partidos = {\n var data = Object.keys(porcentajes[keyz][0]);\n data = data.splice(1);\n data = data.sort(function (a, b) {\n if (a < b) {\n return 1;\n }\n return -1;\n });\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":842,"value":"partidosX = {\n var parti2 = partidos;\n return [...parti2.filter((item) => item != keyzPartyY)];\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":825,"value":"colorMap = Object({\n \"UNION POR LA PATRIA\": \"#009cde\",\n \"LA LIBERTAD AVANZA\": \"#753bbd\",\n \"JUNTOS POR EL CAMBIO\": \"#fedd00\",\n \"HACEMOS POR NUESTRO PAIS\": \"#43488f\",\n \"FRENTE DE IZQUIERDA Y DE TRABAJADORES - UNIDAD\": \"#f95461\",\n Otros: \"#dddddd\"\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":910,"value":"partidos_relevantes = [\n \"UNION POR LA PATRIA\",\n \"LA LIBERTAD AVANZA\",\n \"JUNTOS POR EL CAMBIO\",\n \"HACEMOS POR NUESTRO PAIS\",\n \"FRENTE DE IZQUIERDA Y DE TRABAJADORES - UNIDAD\",\n \"Blanco/Impugnado/Nulo\"\n]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":927,"value":"votosPais = {\n var res = {};\n var totalVotos = {};\n\n Object.entries(porcentajesTotal[1]).map(([key, values]) => {\n var sum = 0;\n Object.entries(values).map(([_, votos]) => {\n sum += votos;\n });\n totalVotos[key] = sum;\n });\n\n var porcentajes = porcentajesTotal[0];\n Object.entries(porcentajes).map(([key, values]) => {\n var total = [];\n partidos.forEach(function (partido) {\n var suma = 0;\n Object.entries(values).map(([provincia, datos]) => {\n try {\n suma += datos[partido].votos;\n } catch (error) {}\n });\n if (suma > 0) {\n total.push({\n [\"partido\"]: partido,\n [\"total\"]: suma,\n [\"porcentaje\"]: parseFloat(\n ((suma / totalVotos[key]) * 100).toFixed(2)\n ),\n [\"color\"]: colorMap[partido] || \"#dddddd\"\n });\n }\n });\n total = total.sort((a, b) => {\n if (a.total < b.total) {\n return 1;\n }\n return -1;\n });\n\n res[key] = total;\n });\n return res;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W34","stdlib":"1"}} 30:"$2f:body"