2f:T52b,plotStats = (data) => { const dateFormat = new Intl.DateTimeFormat('en', { year: 'numeric', month: 'long', day: 'numeric'}) return Plot.plot({ marginLeft: 100, marginRight: 100, marginTop: 20, width: width, color: { type: "diverging", scheme: 'BuRd', pivot: 1, domain: [0,2], }, style: { color: colors.ticks }, y: { label: '', tickSize: 0 }, x: { interval: 'day', tickSize: 0, axis: 'bottom', ticks: 4 }, marks:[ Plot.cell(data, { x: 'date', y: 'key', fill: 'relative', insetRight: -.5, insetLeft: -.5, insetTop: .5, insetBottom: .5, sort: { y: 'fill', reduce: 'last' } }), Plot.text(data, Plot.pointer({ px: 'date', py: 'key', frameAnchor: 'top', dy: -12, text: d => `${d3.format(',')(d.value)} ${d.key} on ${dateFormat.format(d.date)}` })), // Plot.tip(['Changes in their Google Analytics cookie'], { // x: new Date(2022, 4, 10), // y: ['new visits'], // dy: -15, // anchor: 'bottom', // href: "https://stackoverflow.blog/2023/08/08/insights-into-stack-overflows-traffic/" // }) ] }) }30:[{"id":"3108f40d0f3847495ab6720d8cd69dbbe56b6fdfcdf5f8ecf4faaf94a8106b25869a8da6bd9b3b380b347c3c8f3799fb372276adb16a13f296ab64f96bbe2271","href":"https://static.observableusercontent.com/files/3108f40d0f3847495ab6720d8cd69dbbe56b6fdfcdf5f8ecf4faaf94a8106b25869a8da6bd9b3b380b347c3c8f3799fb372276adb16a13f296ab64f96bbe2271","name":"traffic_2008-Jul-31_2023-Jul-23.csv","type":"text/csv","lastModified":1699882021721.434,"size":130383},{"id":"35b885fc81e9bff1181324f403e9cc4b92a7cf21a192d287e4c58ce1aae171d3d4b332edbcf1ffccc8f2f86f99e74ec1ca0f5d01726525e7a9be6430a9d2d176","href":"https://static.observableusercontent.com/files/35b885fc81e9bff1181324f403e9cc4b92a7cf21a192d287e4c58ce1aae171d3d4b332edbcf1ffccc8f2f86f99e74ec1ca0f5d01726525e7a9be6430a9d2d176","name":"posts_2008-Jul-31_2023-Jul-23.csv","type":"text/csv","lastModified":1699882021721.434,"size":53600},{"id":"ed9d6b8acc76df2c76f4c7a7770939a0f27c693ac26ef5cde94425194bb30867f00e52f7644366d6971ecc6e46d7222053f835e3d6ba1196bb4011ad3f57c092","href":"https://static.observableusercontent.com/files/ed9d6b8acc76df2c76f4c7a7770939a0f27c693ac26ef5cde94425194bb30867f00e52f7644366d6971ecc6e46d7222053f835e3d6ba1196bb4011ad3f57c092","name":"votes_2008-Jul-31_2023-Jul-23.csv","type":"text/csv","lastModified":1699882021721.434,"size":65634}] 2d:{"title":"The Fall of Stack Overflow","cells":[{"id":531,"value":"{\n const title = \"The Fall of Stack Overflow\"\n const tickFormat = {\n 0: 0,\n 1: `${baselineYear} mean`,\n 2: 'twice'\n }\n const legend = Plot.legend({\n color: {\n type: 'diverging',\n scheme: 'BuRd',\n domain: [0,2],\n pivot: 1,\n ticks: 2,\n tickFormat: d => tickFormat[d]\n }\n })\n return html`\n

${title}

\n\n

${title}

\n ${legend}\n

\n`\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":440,"value":"plotStats(statsComplete)","pinned":false,"hidden":false,"mode":"ojs"},{"id":589,"value":"html`\n

Details

${details}

\n`","pinned":false,"hidden":false,"mode":"ojs"},{"id":607,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":616,"value":"_tidy data_","pinned":false,"hidden":false,"mode":"md"},{"id":174,"value":"import { aq, op } from '@uwdata/arquero'","pinned":false,"hidden":false,"mode":"ojs"},{"id":354,"value":"FA = FileAttachment","pinned":false,"hidden":false,"mode":"ojs"},{"id":357,"value":"async function readCSV(fn){\n const df = aq.fromCSV(await FA(fn).text())\n return df.fold(aq.range(1,4))\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":173,"value":"traffic = readCSV(\"traffic_2008-Jul-31_2023-Jul-23.csv\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":232,"value":"votes = readCSV('votes_2008-Jul-31_2023-Jul-23.csv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":236,"value":"posts = readCSV('posts_2008-Jul-31_2023-Jul-23.csv')","pinned":false,"hidden":false,"mode":"ojs"},{"id":430,"value":"getStats = (baselineYear) => {\n\n const data = traffic.concat(votes, posts)\n \n const baseline = Object.fromEntries(\n data.\n filter(aq.escape(d => op.year(d.date) == baselineYear)).\n groupby('key').\n rollup({mean: op.mean('value')}).\n objects().\n map(i => {\n return [i.key, i.mean]\n }))\n \n return data.\n filter(aq.escape(d => op.year(d.date) >= baselineYear + 1)).\n derive({\n relative: aq.escape(d => d.value / baseline[d.key])\n })\n}","pinned":false,"hidden":false,"mode":"ojs"},{"id":547,"value":"baselineYear = 2018","pinned":false,"hidden":false,"mode":"ojs"},{"id":320,"value":"statsComplete = getStats(baselineYear)","pinned":false,"hidden":false,"mode":"ojs"},{"id":624,"value":"---","pinned":false,"hidden":false,"mode":"md"},{"id":622,"value":"_plot_","pinned":false,"hidden":false,"mode":"md"},{"id":555,"value":"colors = ({\n ticks: '#5b5d61',\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":171,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs"},{"id":600,"value":"details = md`- [Official Stack Overflow Analytics](https://stackoverflow.com/site-analytics) data shared by [Ayhan Fuat Çelik](https://observablehq.com/@ayhanfuat/the-fall-of-stack-overflow)\n- _What happens on early May 2022?_ Apparently the company [modifies their Google Analytics cookie](https://stackoverflow.blog/2023/08/08/insights-into-stack-overflows-traffic/).`","pinned":false,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}