31:[] 2f:{"title":"TidyTuesday | Simpsons Guests | 2019-08-27","cells":[{"id":0,"value":"# TidyTuesday | Simpsons Guests | 2019-08-27","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"// leyendo los datos de una URL \n//\ndata = {\n let url =\n \"https://raw.githubusercontent.com/rfordatascience/tidytuesday/main/data/2019/2019-08-27/simpsons-guests.csv\";\n return d3.dsv(\"|\", url, d3.autoType);\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":122,"value":"// leyendo los datos de una URL (y agregando un atributo nuevo)\n//\ndata_with_year = {\n let url =\n \"https://raw.githubusercontent.com/rfordatascience/tidytuesday/main/data/2019/2019-08-27/simpsons-guests.csv\";\n return d3.dsv(\"|\", url, (d) => ({\n ...d3.autoType(d),\n year: new Date(+d.season + 1988, 0, 1) // season 1 --> 1989\n }));\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":75,"value":"data[0]","pinned":true,"hidden":false,"mode":"ojs"},{"id":77,"value":"d3.extent(data, (d) => d.season)","pinned":true,"hidden":false,"mode":"ojs"},{"id":60,"value":"data.filter((d) => d.role.includes(\";\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":28,"value":"viewof topN = Inputs.range([10, 100], { label: \"top\", step: 1, value: 10 })","pinned":false,"hidden":false,"mode":"ojs"},{"id":12,"value":"Plot.plot({\n style: { fontFamily: \"Waiting for the Sunrise\", fontSize: 16 },\n title: html`

Episode Count by Guest Star

`,\n rough: {\n // fillStyle: \"zigzag\"\n // roughness: 2\n // hachureGap: 1,\n // fillWeight: 0.1\n },\n y: {\n label: null\n },\n marginLeft: 170,\n marks: [\n Plot.barX(\n data,\n Plot.groupY(\n { x: \"count\" },\n {\n y: \"guest_star\",\n tip: true,\n sort: { y: \"x\", reverse: true, limit: topN }\n }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":38,"value":"// En que episodios, el invitado tiene varios roles\n//\nmas_de_un_rol = data.filter((d) => d.role.includes(\";\"))","pinned":true,"hidden":false,"mode":"ojs"},{"id":73,"value":"mas_de_un_rol","pinned":true,"hidden":false,"mode":"ojs"},{"id":21,"value":"d3.group(data, (d) => d.guest_star)","pinned":true,"hidden":false,"mode":"ojs"},{"id":82,"value":"guest_role = data.flatMap((d) => {\n const roles = d.role.split(\";\").map((r) => r.trim());\n return roles.map((role) => ({\n source: d.guest_star,\n target: role,\n count: 1\n }));\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":84,"value":"// Cuantas veces el guest_star hizo cierto rol (vanilla JS)\n//\nObject.values(\n guest_role.reduce((acc, curr) => {\n const key = `${curr.source}|||${curr.target}`;\n if (!acc[key]) {\n acc[key] = { source: curr.source, target: curr.target, count: 0 };\n }\n acc[key].count += curr.count;\n return acc;\n }, {})\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":89,"value":"// Cuantas veces el guest_star hizo cierto rol (mas claro, con d3.rollup)\n//\nguestStar_role = d3\n .rollups(\n data.flatMap((d) => {\n const roles = d.role.split(\";\").map((r) => r.trim());\n return roles.map((role) => ({\n source: d.guest_star,\n target: role\n }));\n }),\n (v) => v.length,\n (d) => d.source,\n (d) => d.target\n )\n .flatMap(([source, targets]) =>\n targets.map(([target, count]) => ({ source, target, count }))\n )","pinned":true,"hidden":false,"mode":"ojs"},{"id":94,"value":"guestStar_role.filter((d) => d.count >= max)","pinned":true,"hidden":false,"mode":"ojs"},{"id":96,"value":"viewof max = Inputs.range([1, d3.max(guestStar_role, (d) => d.count)], {\n label: \"count\",\n step: 1,\n value: 10\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":103,"value":"d3.extent(guestStar_role, (d) => d.count)","pinned":true,"hidden":false,"mode":"ojs"},{"id":107,"value":"d3.max(guestStar_role, (d) => d.count)","pinned":true,"hidden":false,"mode":"ojs"},{"id":149,"value":"Invitados por año","pinned":false,"hidden":false,"mode":"md"},{"id":125,"value":"guest_by_year = d3\n .rollups(\n data_with_year,\n (v) => v.length,\n (d) => d.year\n )\n .map(([year, count]) => ({ year, count }))","pinned":true,"hidden":false,"mode":"ojs"},{"id":141,"value":"Plot.plot({\n style: { fontFamily: \"Waiting for the Sunrise\", fontSize: 16 },\n rough: {\n fillStyle: \"zigzag\", // [\"solid\",\"hachure\",\"zigzag\",\"cross-hatch\",\"dots\",\"dashed\",\"zigzag-line\"]\n roughness: 1, // 0 .. 10\n bowing: 3, // 0 .. 25\n hachureGap: 5, // 0.5 .. 25\n hachureAngle: -41, // -180 .. 180\n fillWeight: 0.1, // 0 .. 4\n strokeWidth: 1 // 0 .. 4\n },\n marks: [\n Plot.areaY(guest_by_year, { x: \"year\", y: \"count\", interval: d3.utcYear }),\n Plot.ruleY([0], {})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":251,"value":"## Quien hizo mas personajes","pinned":false,"hidden":false,"mode":"md"},{"id":254,"value":"guest_roles = d3.sort(\n d3\n .rollups(\n guestStar_role,\n (v) => v.length,\n (d) => d.source\n )\n .map(([source, count]) => ({ source, count })),\n (d) => -d.count\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":306,"value":"

","pinned":false,"hidden":false,"mode":"html"},{"id":270,"value":"Plot.plot({\n title: html`

Guest Stars with Multiple Characters

`,\n style: { fontFamily: \"Waiting for the Sunrise\", fontSize: 16 },\n rough: {\n fillStyle: \"solid\", // [\"solid\",\"hachure\",\"zigzag\",\"cross-hatch\",\"dots\",\"dashed\",\"zigzag-line\"]\n roughness: 1, // 0 .. 10\n bowing: 1, // 0 .. 25\n hachureGap: 5, // 0.5 .. 25\n hachureAngle: -41, // -180 .. 180\n fillWeight: 0.1, // 0 .. 4\n strokeWidth: 1 // 0 .. 4\n },\n y: {\n label: null\n },\n marginLeft: 190,\n marks: [\n Plot.barX(\n guest_roles.filter((d) => d.count > 2),\n {\n x: \"count\",\n y: \"source\",\n tip: true,\n sort: { y: \"x\", reverse: true },\n fill: d3.rgb(255, 222, 4).hex(),\n stroke: \"black\"\n }\n )\n // Plot.ruleX([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":353,"value":"d3.rgb(255, 222, 4).hex()","pinned":true,"hidden":false,"mode":"ojs"},{"id":111,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":189,"value":"","pinned":false,"hidden":false,"mode":"html"},{"id":157,"value":"import { Plot } from \"@jwolondon/making-plot-sketchy\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":172,"value":"more info about _sketchy rendering_ and _rough.js_ --> https://observablehq.com/@jwolondon/making-plot-sketchy","pinned":false,"hidden":false,"mode":"md"}],"files":"$W31","stdlib":"1","titling":"auto"}