3e:null 3f:["$","title",null,{"children":"Menciones Senadores en los medios | Tomás Gómez | Observable"}] 45:Taa41,{ let list = html` ` yield list list.addEventListener("change", ()=>{ document.querySelector("#fname").value = document.querySelector("#selnames").value }) }46:T12ad,chart = { /*** init svg plot ***/ const svg = d3.select(DOM.svg(chart_param.width, chart_param.height)), cp = chart_param; /*** draw axis lines + labels ***/ // 1. first creating array of information about where to place axis lines const d0 = new Date("03/06/2022"); let date_points = [ ]; for (let i = 3; i <= 12; i++) { const d1 = new Date(i + "/06/2022"), //const d1 = new Date("03/06/2022" + i*7), month_str = d1.toLocaleDateString("sp-SP", {month: "long"}); date_points.push({ month_str: month_str.substring(0, 3) + (month_str.length > 3 ? "." : ""), days_into_year: (d1 - d0) / (1000 * 60 * 60 * 24) }); } // but if chart is quite narrow, just use 3 set axis lines if (chart_param.width <= 750) { date_points = [ { month_str: "Mar. 6", days_into_year: 65 }, { month_str: "Jun. 31", days_into_year: 182 }, { month_str: "Dec. 30", days_into_year: 364 } ] } // 2. draw axis groups const x_date = d3.scaleLinear() .domain([0, dias]) .range(x.range()); const ag = svg.selectAll("g.axis_group") .data(date_points).enter() .append("g") .classed("axis_group", true) .attr("transform", d => `translate(${cp.margin.left + x_date(d.days_into_year)}, ${cp.margin.top})`); const container = html``; const div = d3 .select(container) .append("div") .classed("tooltip", true); const tooltip = new Tooltip(div); // function that sets the tooltip's HTML when revealed // can be passed the hovered selection's datum function tooltipContents(datum) { const { x, y } = datum; return `x: ${x}, y: ${y}`; } // 3. draw axis lines ag.append("line") .classed("axis_line", true) .attr("x1", 0) .attr("y1", 0) .attr("x2", 0) .attr("y2", cp.height - cp.margin.top - cp.margin.bottom) .style("stroke", "#c9c9c9"); // 4. draw axis labels ag.append("text") .classed("axis_text", true) .attr("x", 0) .attr("y", cp.height - cp.margin.top - cp.margin.bottom + 5) .style("font-size", "14px") .style("text-anchor", "middle") .style("alignment-baseline", "hanging") .text(d => d.month_str); // 5. create object to cover axis lines above top ridge let cover_path = [...data[0].data]; cover_path.push({week_num: 53, interest: 100}); cover_path.push({week_num: 1, interest: 100}); svg.append("path") .attr("id", "axis_line_cover") .attr("d", line2(cover_path)) .attr("transform", `translate(${cp.margin.left}, ${cp.margin.top})`) .style("fill", "white"); /*** create ridges ***/ // 1. create ridge groups in correct location with hover events const rg = svg.selectAll("g.ridge_group") .data(data).enter() .append("g") .classed("ridge_group", true) .attr("transform", d => `translate(${cp.margin.left}, ${cp.margin.top + (d.order - 1) * cp.margin.ridge})`) .on("mouseover", (e, d) => { svg.selectAll("g.ridge_group") .style("opacity", d0 => d0.search === d.search ? 1 : 0.5); }) .on("mouseout", (e, d) => { svg.selectAll("g.ridge_group") .style("opacity", 1); }); // 2. add ridge labels rg.append("text") .classed("ridge_label", true) .attr("x", -5) .attr("y", cp.ridge_height) .style("font-size", "14px") .style("text-anchor", "end") .style("alignment-baseline", "middle") .text(d => d.search); // 3. add path for ridge fill rg.append("path") .classed("ridge_fill", true) .attr("d", d => { // take original data and add points for bottom corners to create fill let path = [...d.data]; path.push({week_num: 53, interest: 0}); path.push({week_num: 1, interest: 0}); return line1(path); }) .style("fill", d => color(d.numero_de_pacto).replace(")", ", 0.35)")) .style("stroke", "none"); // 4. add path for ridge rg.append("path") .classed("ridge_path", true) .attr("d", d => line2(d.data)) .style("fill", "none") .style("stroke", d => color(d.numero_de_pacto)); // 5. add hover box (where user can hover) rg.append("rect") .attr("x", -cp.margin.left) .attr("y", cp.ridge_height * 0.65) .attr("width", width) .attr("height", cp.margin.ridge) .style("fill", "rgba(0, 0, 0, 0)"); return svg.node(); }47:[] 43:{"id":"d6d2f04bfb12e980","slug":null,"title":"Menciones Senadores en los medios","thumbnail":"acb12ac1f44077603cb22f80bf70e64671115f48930acc3f7828ea212d8cf8be","access_level":"public","create_time":"$D2022-10-14T14:37:36.394Z","update_time":"$D2022-10-14T14:37:36.394Z","view_time":null,"first_public_time":"$D2022-10-14T14:37:36.394Z","has_unpublished_edits":null,"fork":{"id":"3c2e88c8aef830b1","slug":"the-relentless-2020-news-cycle-in-one-chart","title":"Menciones Senadores en los medios","owner":{"id":"e6269dadf239c382","login":"tomas-gomez","name":"Tomás Gómez"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e6269dadf239c382","login":"tomas-gomez","name":"Tomás Gómez","avatar_url":"https://avatars-next.observableusercontent.com/3a9b789447e9a85a750a2608243f4417f0fbaf547b07b912a028646355e75189","tier":"starter_2024","bio":"","following":false},"version":1071,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"23229e463f3f537e","login":"tomas-gomez","name":"Tomás Gómez","avatar_url":"https://avatars-next.observableusercontent.com/3a9b789447e9a85a750a2608243f4417f0fbaf547b07b912a028646355e75189","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"23229e463f3f537e","login":"tomas-gomez","name":"Tomás Gómez","avatar_url":"https://avatars-next.observableusercontent.com/3a9b789447e9a85a750a2608243f4417f0fbaf547b07b912a028646355e75189","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Menciones Senadores en los medios","cells":[{"id":0,"value":"md`# Menciones Senadores en los medios\n\n***`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":355,"value":"html`\n

Height is search interest in a given topic, indexed to 100

Color is average search interest between Dec. 29, 2019 – Dec. 30, 2020

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":820,"value":"import {LineChart} from \"@d3/line-with-tooltip\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":831,"value":"import { Tooltip } from \"@clhenrick/tooltip-component\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":801,"value":"{\n let theform = html`\n

Forms look nice too!

\nName \n

( Try putting Pattaya or Dancing Script and click change - use any name from Google Fonts)

\n`\n yield theform; // this makes sure the HTML is there before we try to add event listeners\n document.querySelector(\"#change\").addEventListener(\"click\", changeFont)\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":803,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":808,"value":"mutable fontName = \"Fira Sans\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":806,"value":"changeFont = ()=>{\n console.log(\"changefont\")\n mutable fontName = document.querySelector(\"#fname\").value\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":812,"value":"","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":816,"value":"viewof dataset = Inputs.select([\"Todos\", \"Chile Podemos Más\", \"Nuevo Pacto Social\", \"Apruebo Dignidad\", \"Frente Social Cristiano\",\n \"IND\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":66,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":90,"value":"chart_param_init = ({\n width: width,\n ridge_height: 40,\n margin: {\n top: 10,\n right: 25,\n bottom: 20,\n left: 110,\n ridge: 20\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"// after manually setting parameters in chart_param_init, height will be defined based on those params\nchart_param = Object.assign(\n chart_param_init, \n {\n height: chart_param_init.margin.top + chart_param_init.margin.bottom + \n data.length * chart_param_init.margin.ridge + chart_param_init.ridge_height \n })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"// a simple line to plot to fill under the ridge (showing true data)\nline1 = d3.line()\n .x(d => x(d.week_num))\n .y(d => y(d.interest));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"// similar to line1, just with curve to enclose data with a smooth ridge\nline2 = d3.line()\n .curve(d3.curveCardinal)\n .x(d => x(d.week_num))\n .y(d => y(d.interest));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":214,"value":"color = d3.scaleLinear()\n .domain(d3.extent(data, d => d.numero_de_pacto))\n .range([\"#8bb56e\", \"#d65e9b\"])\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":120,"value":"x = d3.scaleLinear()\n .domain(d3.extent(data.map(d => d.data).flat(), d => d.week_num))\n .range([0, chart_param.width - chart_param.margin.left - chart_param.margin.right])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":144,"value":"y = d3.scaleLinear()\n .domain(d3.extent(data.map(d => d.data).flat(), d => d.interest))\n .range([chart_param.ridge_height, 0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"md` ## Data import + organization\nData originally comes from [Google Trends](https://trends.google.com/trends/), where I downloaded the interest over time data for each topic. When Google Trends had a defined topic for the particular search, I used that. Otherwise, I simply based it on the \"search term\" results. After downloading the data from Google Trends, I did some minor cleaning in R.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":747,"value":"function pacto(dataset) {\n if (dataset == \"Todos\"){\n var datas = [\"Chile Podemos Más\", \"Apruebo Dignidad\", \"Nuevo Pacto Social\", \"Frente Social Cristiano\", \"IND\"]\n return datas;\n }\n else {\n var datas = new Array(dataset)\n return datas;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":741,"value":"orden = function orden(e, dataset) {\n if (dataset == \"Todos\"){\n return e[1][0].order;\n }\n else {\n return e[1][0].order_pacto;\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":28,"value":"data = [...d3.rollup(data_raw_new, v => v, d => d.search)].map(e => ({\n search: e[0],\n interest_avg: e[1][0].interest_avg,\n order: orden(e, dataset),\n pacto_numero: e[1][0].pacto,\n numero_de_pacto: e[1][0].numero_de_pacto,\n data: e[1].map(d => (({week_num, week, interest}) => ({week_num, week, interest}))(d))\n})).filter(d => pacto(dataset).includes(d.pacto_numero)).sort((a, b) => d3.ascending(a.order, b.order))\n\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":433,"value":"//data_raw_new = FileAttachment(\"prueba_orden_pactos@1.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2,"value":"//data_raw_old = FileAttachment(\"prueba_orden_pactos.csv\").csv({typed: true})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":441,"value":"md`## Notes + Learnings\n\nSince this was an exercise to work on my D3/Observable chops, I wanted to note a few things I learned or found interest or difficult along the way.\n\n- Danielle used two different paths to generate each ridge: one for creating the fill under the ridge, which reflects the actual data with no curve and the other for creating a smooth cover over the top of the ridge. If you look closely at some of the ridges (e.g., Kim Jong-un) you can see small gaps between the stroke and the fill.\n- There are a few ways one can sort the ridges in a ridge plot (based on weighted average, based on where the peak is, etc.). For this chart, Danielle appears to have sorted it based on when the first significant bump occurs (around 50% interest or higher), which is a smart way to do it, especially since some topics had multiple bumps throughout the year.\n- The first few topics seem to be highlighted there because they are of interest throughout the year (there was no single spike for \"masks\" or \"TikTok\").\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":87,"value":"md`## Appendix`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"d3 = require(\"d3@6\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":861,"value":"function to_csv(array) {\n const data = []\n for (let i = 1; i < array.length; i++) {\n let lista = array[i].split(',')\n let dict = {\n \"\": parseInt(lista[0]),\n \"week_num\": parseInt(lista[1]),\n \"week\": lista[2],\n \"search\": lista[3],\n \"interest\": parseInt(lista[4]),\n \"interest_avg\": parseInt(lista[5]),\n \"order\": parseInt(lista[6]),\n \"pacto\": lista[7],\n \"order_pacto\": parseFloat(lista[8]),\n \"numero_de_pacto\": parseInt(lista[9])\n }\n data.push(dict)\n }\n return data;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":866,"value":"AWS = require('aws-sdk@2.794.0/dist/aws-sdk-react-native.js')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":868,"value":"accessKeyID = \"AKIAZKMMYM5JRBIQDRPB\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":870,"value":"secretAccessKey = \"JnKi2ezpw/K1hlxoxGMC4JxE/fbCTic/973hxGwE\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":873,"value":"credentials = AWS.config.credentials = \n new AWS.Credentials(\"AKIAZKMMYM5JRBIQDRPB\", \"JnKi2ezpw/K1hlxoxGMC4JxE/fbCTic/973hxGwE\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":875,"value":"region = AWS.config.region = 'us-east-1'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":877,"value":"awsConfig = AWS.config.update({\n accessKeyId: \"AKIAZKMMYM5JRBIQDRPB\",\n secretAccessKey: \"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\",\n region: region\n });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":879,"value":"s3 = {\n // call credentials and region here to make sure those are set before creating the S3 object\n credentials;\n region;\n return new AWS.S3({apiVersion: '2006-03-01'})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":883,"value":"import {Text} from \"@observablehq/inputs@426\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":881,"value":"viewof bucket = Text({label: \"Bucket name\", value: \"scanner-congreso-contenidos\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":886,"value":"viewof file = Text({label: \"File name\", value: \"prueba_orden_pactos.csv\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":901,"value":"objectParams = ({\n Bucket : bucket,\n Key : file\n });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":904,"value":"s3.getObject(objectParams)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":906,"value":"data_raw_ = s3.getObject(objectParams)\n .promise()\n .then((json) => json.Body.toString('utf-8').split('\\n'))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":910,"value":"data_raw_new = to_csv(data_raw_)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":940,"value":"function max_(data_) {\n let maximo = []\n for (let i = 0; i < data_.length; i++){\n maximo.push(data_[i][\"week_num\"])\n }\n let maxi = 0\n for (let i = 0; i < maximo.length; i++) {\n if (maximo[i] >= maxi) {\n maxi = maximo[i];\n }\n }\n return maxi;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":947,"value":"maximo = max_(data_raw_new)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":986,"value":"dias = maximo*7 - 18","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 44:"$43:body"