30:Tb8b,chart = { const svgMain = d3.create("svg")//.attr("viewBox", [-margin.left, -margin.top, width, chartHeight]) ; svgMain.attr("height", chartHeight) .attr("width", width) svgMain.append("rect").attr("height", chartHeight) .attr("width", width).attr("fill","white") // x scale const xMin = d3.min(data, (d) => d.startDate) const xMax = d3.max(data, (d) => d.endDate) const x =d3.scaleTime() x.domain([xMin, xMax]).rangeRound([0, width-margin.left-margin.right]).nice() const lines = d3.sum(groups, (g) => d3.max(g[1], (d) => d.level + 1)) const heightScale = d3 .scaleBand() .domain(d3.range(lines)) .range([0, chartHeight-margin.top-margin.bottom]) .paddingInner(barPadding) .paddingOuter(barPadding / 2) .align(1) const lineHeight = heightScale.bandwidth() const lineStep = heightScale.step() const xAxis = (g) => { return g .attr('transform', `translate(0,${chartHeight-margin.top-margin.bottom})`) .call(d3.axisBottom(x)) } const svg = svgMain .append('g') .attr('transform', `translate(${margin.left},${margin.top})`) .attr('id', 'visualization') const axisLayer = svg.append('g').attr('id', 'axis') axisLayer.append('g').call(xAxis) let stack = d3 .stack() .keys(groups.map((d) => d[0])) .value((d, key) => { const a = d.filter((f) => f[0] === key)[0] return d3.max(a[1].map((c) => c.level)) + 1 }) const vizLayer = svg.append('g').attr('id', 'viz') const groupsG = vizLayer .selectAll('g') .data(stack([groups])) .join('g') .attr('id', (d) => d.key) .attr('transform', (d) => `translate(0,${d[0][0] * lineStep})`) groupsG .append('text') .attr('x', (d) => alignLabels ? x(d[0].data[d.index][1][0].startDate) - 4 : -4 ) .attr('y', lineStep / 2) .attr('text-anchor', 'end') .attr('dominant-baseline', 'middle') .attr("fill", "black") .attr("font-family", "sans-serif") .attr("font-size", "10px") .text((d) => d.key); var rects = groupsG .selectAll('rect') .data((d, i) => d[0].data[d.index][1]) .join('rect') .attr('x', (d) => x(d.startDate)) .attr('y', (d) => lineStep * d.level + (lineStep - lineHeight) / 2) .attr('width', (d) => d3.max([1, x(d.endDate) - x(d.startDate)])) .attr('height', lineHeight) .attr('fill', (d) => d.color ) rects.append("title").text(d=>d.Lote) groupsG .append('line') .attr('x1', 0) .attr('y1', 0) .attr('x2', width) .attr('y2', 0) if (showLegend) { const legendLayer = svg .append('g') .attr('id', 'legend') .attr('transform', `translate(${width},${margin.top})`) } svgMain.node().drawData = function(item) { if(item.length == 1){ rects.filter(d=>d.Lote == item[0].Lote).attr("fill","red") } else{ rects.attr("fill",(d) => d.color) } } return svgMain.node(); } 31:[{"id":"cb7e6f79690f9fe2ad81121e4d4011f1586f7eef0076523adeff371e15123138fa8c7b7fa467c61f623d94c8db1780d471a77e862da060e71b25e1061edfe7d4","href":"https://static.observableusercontent.com/files/cb7e6f79690f9fe2ad81121e4d4011f1586f7eef0076523adeff371e15123138fa8c7b7fa467c61f623d94c8db1780d471a77e862da060e71b25e1061edfe7d4","name":"Vacunas fabricadas en Arg - Detalle ingresos.csv","type":"text/csv","lastModified":1632752752805.004,"size":4080},{"id":"a93e0f1d0577e316d3d09e6c06c4c2336babe128f3352ef6e21626271f0bc7fee4813151503c87af3ea5d44192fc7b88a558364a6197fb5cf276febe22053a59","href":"https://static.observableusercontent.com/files/a93e0f1d0577e316d3d09e6c06c4c2336babe128f3352ef6e21626271f0bc7fee4813151503c87af3ea5d44192fc7b88a558364a6197fb5cf276febe22053a59","name":"Lotes@1.csv","type":"text/csv","lastModified":1645026059647.756,"size":570299}] 2e:{"title":"Lotes de vacunas","cells":[{"id":0,"value":"# Lotes de vacunas\n### ¿A que lote pertenece la vacuna que me dieron? ¿cómo se distribuyen?\n\nDatos del Ministerio de Salud (Argentina) amablemente disponibilizados por [Covidstats.com.ar](covidstats.com.ar)","pinned":false,"hidden":false,"mode":"md"},{"id":13,"value":"viewof search = Inputs.search(datosPorLote, {placeholder: \"Ingresar lote\", label: \"Ingresar el número de lote (tener en cuenta que muchas veces está mal escrito)\", columns:[\"Lote\"], datalist:lotes})","pinned":false,"hidden":false,"mode":"ojs"},{"id":131,"value":"progress = {\n const resumen = d3.select(html`

`);\n const board = resumen.html(d => {\n if(search.length==1) {\n const datosEsteLote = datosLimpios.filter(e=>e.Lote == search[0].Lote);\n const primera = d3.minIndex(datosEsteLote, f=>f[\"Primera aplicación\"]),\n ultima = d3.maxIndex(datosEsteLote, f=>f[\"Última aplicación\"]);\n var imprime =`\n

\n El lote ${search[0].Lote} de ${d3.format(\",d\")(d3.sum(datosEsteLote, d=>d.Aplicaciones))} vacunas ${search[0].Tipo} se usó por primera vez en ${datosEsteLote[primera].Provincia} el ${d3.timeFormat(\"%d de %B\")(datosEsteLote[primera][\"Primera aplicación\"])} y por última vez en ${datosEsteLote[ultima].Provincia} el ${d3.timeFormat(\"%d de %B\")(datosEsteLote[ultima][\"Última aplicación\"])}
\n`;\n imprime += search[0].loteArg?`¡Y es un lote producido en Argentina! 🇦🇷`:\"\"+`

`;\n \n \n\n return imprime\n };\n \n });\n\n return resumen.node();\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":268,"value":"{\n var plot = Plot.plot({\n width: d3.min([width,1000]),\n inset: 20,\n y: {\n label: \"Aplicaciones\",\n tickFormat: \"~s\"\n },\n color:\n {domain: tipos,\n range: d3.schemeTableau10\n },\n marks: [\n Plot.dot(datosPorLote, {x: \"Primera aplicación\", y: \"Aplicaciones\", fill: search.length==1?\"#dedede\":\"Tipo\"}),\n Plot.dot(datosPorLote, {x: \"Primera aplicación\", filter: d=>search.length==1?d.Lote==search[0].Lote?1:0:0, y: \"Aplicaciones\", fill: \"Tipo\",r:5, stroke:\"black\"})\n ]\n})\n return wrap(\n plot,\n Swatches({color: d3.scaleOrdinal(tipos, d3.schemeTableau10)})\n );\n}\n\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":493,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":534,"value":"chart.drawData(search)","pinned":true,"hidden":false,"mode":"ojs"},{"id":400,"value":"Plot.plot({\n width: 300,\n height: 660,\n padding: 0,\n x: {axis: null},\n y: {axis: null},\n color: {scheme: \"greens\"}, \n marks: cells\n});","pinned":false,"hidden":false,"mode":"ojs"},{"id":239,"value":".\n\n.............\n\n\n## Zona nerd:\n\n.............","pinned":false,"hidden":false,"mode":"md"},{"id":402,"value":"cells = {\n const extent = d3.extent(mapData.map(d => d.lotes));\n return [\n Plot.cell(mapData, {\n x: \"col\",\n y: \"row\",\n rx: 6, ry: 6,\n fill: \"lotes\",\n inset: 1,\n }),\n plotText(0, \"code\"),\n plotText(10, d => d.lotes.toLocaleString(\"es\") + \" lotes\")\n ]\n \n function plotText(dy, text) {\n return Plot.text(mapData, {\n x: \"col\",\n y: \"row\",\n dy: dy, \n fontWeight: \"bold\",\n text: text})\n }\n }","pinned":false,"hidden":false,"mode":"ojs"},{"id":408,"value":"mapData = Array.from(pos)\n .map(d=>\n {\n return {\n col:d[1][0],\n row:d[1][1],\n code: d[0],\n total : datosPorPcia.filter(e=>e.pcia == d[0])[0].Aplicaciones,\n lotes : datosPorPcia.filter(e=>e.pcia == d[0])[0].Lotes.length\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":15,"value":"viewof rows = Inputs.table(search, {columns:[\"Lote\",\"Tipo\", \"Primera aplicación\", \"Última aplicación\", \"Aplicaciones\"], format: {\n Aplicaciones: sparkbar(d3.max(search, d => d.Aplicaciones)),\n \"Primera aplicación\": d3.timeFormat(\"%d-%b-%y\"),\n \"Última aplicación\": d3.timeFormat(\"%d-%b-%y\"),\n }} )","pinned":false,"hidden":false,"mode":"ojs"},{"id":340,"value":" **Lotes por tamaño e inicio**:","pinned":false,"hidden":false,"mode":"md"},{"id":243,"value":" **Histograma de lotes**: Pareciera que la gran mayoría de lotes tienen muy pocas aplicaciones ( 1 o 2 incluso)","pinned":false,"hidden":false,"mode":"md"},{"id":233,"value":"Plot.plot({\n y: {\n grid: true\n },\n marks: [\n Plot.rectY(datosPorLote, Plot.binX({y: \"count\"}, {x: \"Aplicaciones\"})),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":59,"value":"### Extras","pinned":false,"hidden":false,"mode":"md"},{"id":54,"value":"lotes = d3.groups(datos, d=>d.Lote).map(e=>e[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":309,"value":"tipos = d3.groups(datosPorLote, d=>d.Tipo).map(d=>d[0])","pinned":false,"hidden":false,"mode":"ojs"},{"id":498,"value":"data = d3.groups(datosLimpios, d=>d.Lote)\n .map(d=>{\n return {\n Lote : d[0],\n group : d[1][0][\"Tipo de vacuna\"],\n startDate : d3.min(d[1],e=>e[\"Primera aplicación\"]),\n endDate: d3.max(d[1],e=>e[\"Última aplicación\"]),\n Aplicaciones : d3.sum(d[1], e=>e.Aplicaciones),\n color : lotesArg.map(e=>e.Lote.toLowerCase()).includes(d[0].toLowerCase())?\"DeepSkyBlue\":\"silver\"\n\n }\n })","pinned":true,"hidden":false,"mode":"ojs"},{"id":501,"value":"sortGroupsBy = \"group\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":503,"value":" groups.sort((a, b) => {\n if (!sortGroupsBy) return\n if (sortGroupsBy === 'group') {\n return d3.ascending(a[0], b[0])\n } else {\n return d3[sortGroupsBy](a[1][0].startDate, b[1][0].startDate)\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":505,"value":"function overlap(item, g) {\n if (!g) return false\n for (const i in g) {\n if (\n (item.startDate.getTime() > g[i].startDate.getTime() &&\n item.startDate.getTime() <= g[i].endDate.getTime()) ||\n (item.endDate.getTime() > g[i].startDate.getTime() &&\n item.endDate.getTime() <= g[i].endDate.getTime()) ||\n (item.startDate.getTime() < g[i].startDate.getTime() &&\n item.endDate.getTime() >= g[i].endDate.getTime())\n ) {\n return true\n }\n }\n return false\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":515,"value":"alignLabels = true","pinned":false,"hidden":false,"mode":"ojs"},{"id":509,"value":"showLegend = true;","pinned":false,"hidden":false,"mode":"ojs"},{"id":511,"value":"margin = ({top:30,right:130,bottom:30,left:230})","pinned":false,"hidden":false,"mode":"ojs"},{"id":507,"value":"chartHeight = 1400","pinned":true,"hidden":false,"mode":"ojs"},{"id":513,"value":"barPadding = 0.1","pinned":false,"hidden":false,"mode":"ojs"},{"id":496,"value":"groups = d3.rollups(\n data,\n (v) => {\n v.sort((a, b) => d3.ascending(a.startDate, b.startDate))\n\n let levels = [],\n level = 0\n v.forEach(function (item) {\n let l = 0\n while (overlap(item, levels[l])) l++\n if (!levels[l]) levels[l] = []\n levels[l].push({\n level: l + level,\n ...item,\n })\n })\n\n level++\n return levels.flat()\n },\n (d) => (d.group && d.group.length ? d.group : null)\n )","pinned":false,"hidden":false,"mode":"ojs"},{"id":82,"value":"datosPorLote = d3.groups(datosLimpios, d=>d.Lote)\n .map(d=>{\n var loteArg = lotesArg.map(e=>e.Lote.toLowerCase()).includes(d[0].toLowerCase())?lotesArg[lotesArg.map(e=>e.Lote.toLowerCase()).indexOf(d[0].toLowerCase())]:0\n return {\n Lote : d[0],\n Tipo : d[1][0][\"Tipo de vacuna\"],\n \"Primera aplicación\" : d3.min(d[1],e=>e[\"Primera aplicación\"]),\n \"Última aplicación\" : d3.max(d[1],e=>e[\"Última aplicación\"]),\n Aplicaciones : d3.sum(d[1], e=>e.Aplicaciones),\n loteArg : loteArg\n\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":430,"value":"datosPorPcia = d3.groups(datosLimpios, d=>d.Provincia)\n .map(d=>{\n return {\n pcia : d[0],\n Tipo : d[1][0][\"Tipo de vacuna\"],\n \"Primera aplicación\" : d3.min(d[1],e=>e[\"Primera aplicación\"]),\n \"Última aplicación\" : d3.max(d[1],e=>e[\"Última aplicación\"]),\n Aplicaciones : d3.sum(d[1], e=>e.Aplicaciones),\n Lotes : d[1].map(f=>f.Lote)\n\n }\n })","pinned":true,"hidden":false,"mode":"ojs"},{"id":179,"value":"datosLimpios = datos.map(d=>{\n return {\n Lote: d.Lote,\n Provincia: d.Provincia,\n \"Tipo de vacuna\": d[\"Tipo de vacuna\"],\n \"Primera aplicación\": tiempo.parse(\"%d/%m/%y\")(d[\"Primera aplicación\"]),\n \"Última aplicación\": tiempo.parse(\"%d/%m/%y\")(d[\"Última aplicación\"]),\n Aplicaciones: +d.Aplicaciones,\n }\n })","pinned":false,"hidden":false,"mode":"ojs"},{"id":164,"value":"datos = FileAttachment(\"Lotes@1.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs"},{"id":74,"value":"function sparkbar(max) {\n return x => htl.html`

${x.toLocaleString(\"es\")}`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":299,"value":"import {swatches as Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":297,"value":"import {wrap} from \"@analyzer2004/plot-powerbi\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":653,"value":"pos","pinned":true,"hidden":false,"mode":"ojs"},{"id":404,"value":"import {pos} from \"@rusosnith/flechitas-de-ritmos-de-covid19-en-argentina\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":115,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":356,"value":"tiempo = d3.timeFormatDefaultLocale(esp)","pinned":true,"hidden":false,"mode":"ojs"},{"id":480,"value":"d3.formatDefaultLocale(esp)","pinned":true,"hidden":false,"mode":"ojs"},{"id":353,"value":"esp = d3.json(\n \"https://raw.githubusercontent.com/d3/d3-time-format/master/locale/es-ES.json\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":477,"value":"esp2 = d3.json(\n \"https://raw.githubusercontent.com/d3/d3-format/master/locale/es-ES.json\"\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":571,"value":"lotesArg = FileAttachment(\"Vacunas fabricadas en Arg - Detalle ingresos.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W31","stdlib":"1","titling":"auto"}