30:T577,viewof tbl2t3_7k_processed = tbl2t3_7k_raw_data .rename({ aggregated_label: "label" }) .derive({ label: (d) => (d.label == "IDW" ? "AW" : d.label), y: (d) => op.parse_float(d.percentge), x: (d) => op.parse_date(d.year + "-" + (d.month < 10 ? "0" + d.month : d.month)), subvalue: (d) => op.parse_int(d.counts), category: (d) => op.parse_int(d.cases) }) .select("label", "x", "y", "subvalue", "category") .groupby("label", "category") .orderby("x") .derive({ rolling_y: aq.rolling((d) => op.mean(d.y), [-2, 0]), category: (d) => d.category == 1 ? "YT Homepage" : d.category == 2 ? "Search" : d.category == 3 ? "YT Channel" : d.category == 4 ? "YT Video" : d.category == 5 ? "External URLs" : d.category == 6 ? "Other" : "ERROR: id not known" }) .orderby("x") .derive({ temporal: `d => { return {x: d.x, y: d.y, rolling_y: d.rolling_y, subvalue: d.subvalue, label: d.label, category: d.category}}` }) .groupby("label", "category") .rollup({ avg_value: op.mean("y"), avg_subvalue: op.mean("subvalue"), temporal: op.array_agg("temporal") }) .derive({ avg_value: (d) => op.round(d.avg_value * 100) / 100, avg_subvalue: (d) => op.round(d.avg_value * 100) / 100 }) .rename({ label: "y", category: "x" }) .view()31:T543,viewof tbl2t3_processed = tbl2t3_raw .derive({ label: (d) => (d.label == "IDW" ? "AW" : d.label), y: (d) => op.parse_float(d.percentge), x: (d) => op.parse_date(d.year + "-" + (d.month < 10 ? "0" + d.month : d.month)), subvalue: (d) => op.parse_int(d.counts), category: (d) => op.parse_int(d.cases) }) .select("label", "x", "y", "subvalue", "category") .groupby("label", "category") .orderby("x") .derive({ rolling_y: aq.rolling((d) => op.mean(d.y), [-2, 0]), category: (d) => d.category == 1 ? "YT Homepage" : d.category == 2 ? "Search" : d.category == 3 ? "YT Channel" : d.category == 4 ? "YT Video" : d.category == 5 ? "External URLs" : d.category == 6 ? "Other" : "ERROR: id not known" }) .orderby("x") .derive({ temporal: `d => { return {x: d.x, y: d.y, rolling_y: d.rolling_y, subvalue: d.subvalue, label: d.label, category: d.category}}` }) .groupby("label", "category") .rollup({ avg_value: op.mean("y"), avg_subvalue: op.mean("subvalue"), temporal: op.array_agg("temporal") }) .derive({ avg_value: (d) => op.round(d.avg_value * 100) / 100, avg_subvalue: (d) => op.round(d.avg_value * 100) / 100 }) .rename({ label: "y", category: "x" }) .view()32:[{"id":"072e5dbbfb06732f477b463fb77664eb71ef5d355ad1689b0649506a63ad0ea4ad919585c4ea4569b22dd67a326208e7872322a105eec5dfcf45a32d9bd2e647","href":"https://static.observableusercontent.com/files/072e5dbbfb06732f477b463fb77664eb71ef5d355ad1689b0649506a63ad0ea4ad919585c4ea4569b22dd67a326208e7872322a105eec5dfcf45a32d9bd2e647","name":"tbl2_temporal_v3.csv","type":"text/csv","lastModified":1652769440001.26,"size":116222},{"id":"feddb353f6d2f789a008d7d5252842c307ac1b7f2e8180a8f619b223c00ba459f4a50f8834833976f08bddb1719a63b08e45a328be4e2cc771a1851b33563685","href":"https://static.observableusercontent.com/files/feddb353f6d2f789a008d7d5252842c307ac1b7f2e8180a8f619b223c00ba459f4a50f8834833976f08bddb1719a63b08e45a328be4e2cc771a1851b33563685","name":"tbl2_barchart.csv","type":"text/csv","lastModified":1652770088636.954,"size":1170},{"id":"260142838d8a6c9f8074268aaca9aac216871907da46c9210aeb5641bd666c071bc759996a39c932515a9aca509bf4f2f76d59dc8db8d2d6cc20c3cba189d4b7","href":"https://static.observableusercontent.com/files/260142838d8a6c9f8074268aaca9aac216871907da46c9210aeb5641bd666c071bc759996a39c932515a9aca509bf4f2f76d59dc8db8d2d6cc20c3cba189d4b7","name":"table2_ledwich.csv","type":"text/csv","lastModified":1657304639196.49,"size":120677},{"id":"6b78ad2e3af85ceb5e1c7aa604a5fce12052c888646e477a7d85dc60045ddb06d2b3923d370b44755cd8bd878c0ccc6bea435cd9e8646b6fe51be4f8e4659878","href":"https://static.observableusercontent.com/files/6b78ad2e3af85ceb5e1c7aa604a5fce12052c888646e477a7d85dc60045ddb06d2b3923d370b44755cd8bd878c0ccc6bea435cd9e8646b6fe51be4f8e4659878","name":"table2_ledwich_tempral.csv","type":"text/csv","lastModified":1657304639196.244,"size":120592}] 2e:{"title":"Table 2: YouTube entry points for Political Content","cells":[{"id":0,"value":"# Table 2: YouTube entry points for Political Content","pinned":false,"hidden":false,"mode":"md"},{"id":49,"value":"## D3 Renders","pinned":false,"hidden":false,"mode":"md"},{"id":88,"value":"tbl2_final = html`

${viewof table2Show}

${\n table2Show == \"tem\" ? tabel2_temporal : table2\n}

`","pinned":false,"hidden":false,"mode":"ojs"},{"id":163,"value":"tbl2_final_7k = html`

${viewof table2Show_7k}

${\n table2Show == \"tem\" ? tabel2_temporal_7k : table2_7k\n}

`","pinned":true,"hidden":false,"mode":"ojs"},{"id":153,"value":"#### Selection","pinned":false,"hidden":false,"mode":"md"},{"id":100,"value":"viewof table2Show = radio({\n title: \"Table 2 Version\",\n options: [\n { label: \"Summary\", value: \"bar\" },\n { label: \"Temporal\", value: \"tem\" }\n ],\n value: \"tem\"\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":161,"value":"viewof table2Show_7k = radio({\n title: \"Table 2 Version\",\n options: [\n { label: \"Summary\", value: \"bar\" },\n { label: \"Temporal\", value: \"tem\" }\n ],\n value: \"tem\"\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":63,"value":"#### Barchart Heatmap","pinned":false,"hidden":false,"mode":"md"},{"id":81,"value":"table2 = barheatmap(\n tbl2_data.objects(),\n \"Video Location Method\",\n \"Political Label\",\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"]\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":155,"value":"table2_7k = barheatmap(\n tbl2_7k_processed_data.objects(),\n \"Video Location Method\",\n \"Political Label\",\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"]\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":59,"value":"#### Temporal Heatmap","pinned":false,"hidden":false,"mode":"md"},{"id":53,"value":"tabel2_temporal = timesHeatMap(\n tbl2t3_processed.objects(),\n \"Access Point\",\n \"Political Label\",\n \"Percent of Videos\",\n [\"#ff1100\", \"#ffe100\", \"#26ff00\", \"#0040ff\", \"#ae00ff\", \"black\"],\n [\"#2166AC\", \"#92C5DE\", \"#7FC97F\", \"gray\", \"#F4A582\", \"#B2182B\"],\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"],\n [\"Far Left\", \"Left\", \"Center\", \"Anti-Woke\", \"Right\", \"Far Right\"],\n null\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":158,"value":"tabel2_temporal_7k = timesHeatMap(\n tbl2t3_7k_processed.objects(),\n \"Access Point\",\n \"Political Label\",\n \"Percent of Videos\",\n [\"#ff1100\", \"#ffe100\", \"#26ff00\", \"#0040ff\", \"#ae00ff\", \"black\"],\n [\"#2166AC\", \"#92C5DE\", \"#7FC97F\", \"gray\", \"#F4A582\", \"#B2182B\"],\n [\"YT Homepage\", \"Search\", \"YT Channel\", \"YT Video\", \"External URLs\", \"Other\"],\n [\"fL\", \"L\", \"C\", \"AW\", \"R\", \"fR\"],\n [\"Far Left\", \"Left\", \"Center\", \"Anti-Woke\", \"Right\", \"Far Right\"],\n null\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":44,"value":"## Data Tables","pinned":false,"hidden":false,"mode":"md"},{"id":74,"value":"#### Table 2 barchart processed data","pinned":false,"hidden":false,"mode":"md"},{"id":78,"value":"viewof tbl2_data = tbl2t3_processed\n .rename({\n avg_value: \"value\",\n avg_subvalue: \"avg_subvalue\"\n })\n .select(aq.not(\"temporal\"))\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":70,"value":"#### Table 2 barchart raw data","pinned":false,"hidden":false,"mode":"md"},{"id":67,"value":"viewof tbl2_raw_data = aq\n .from(await FileAttachment(\"tbl2_barchart.csv\").csv())\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":134,"value":"#### Table 2 barchart processed new data","pinned":false,"hidden":false,"mode":"md"},{"id":136,"value":"viewof tbl2_7k_processed_data = tbl2t3_7k_processed\n .rename({\n avg_value: \"value\",\n avg_subvalue: \"subvalue\"\n })\n .select(aq.not(\"temporal\"))\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"#### Table 2 barchart new raw data","pinned":false,"hidden":false,"mode":"md"},{"id":131,"value":"viewof tbl2_7k_raw_data = aq\n .from(await FileAttachment(\"table2_ledwich.csv\").csv())\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":148,"value":"#### Table 2 temporal 7k processed data","pinned":false,"hidden":false,"mode":"md"},{"id":142,"value":"$30","pinned":false,"hidden":false,"mode":"ojs"},{"id":146,"value":"#### Table 2 temporal 7k raw data","pinned":false,"hidden":false,"mode":"md"},{"id":139,"value":"viewof tbl2t3_7k_raw_data = aq\n .from(await FileAttachment(\"table2_ledwich_tempral.csv\").csv())\n .view()","pinned":true,"hidden":false,"mode":"ojs"},{"id":30,"value":"#### Table 2 temporal processed data","pinned":false,"hidden":false,"mode":"md"},{"id":26,"value":"$31","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"#### Table 2 temporal raw data","pinned":false,"hidden":false,"mode":"md"},{"id":16,"value":"viewof tbl2t3_raw = aq\n .from(await FileAttachment(\"tbl2_temporal_v3.csv\").csv())\n .view()","pinned":false,"hidden":false,"mode":"ojs"},{"id":40,"value":"## Imports","pinned":false,"hidden":false,"mode":"md"},{"id":19,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":21,"value":"d3 = require(\"d3@v6\")","pinned":false,"hidden":false,"mode":"ojs"},{"id":56,"value":"import { barheatmap } from \"@wattslab/barheatmap\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":6,"value":"import { basicLegend } from \"@wattslab/temporal-heatmap\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":11,"value":"import { timesHeatMap } from \"@wattslab/temporal-heatmap\"","pinned":false,"hidden":false,"mode":"ojs"},{"id":103,"value":"import { radio, select, slider } from \"@jashkenas/inputs\"","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W32","stdlib":"1","titling":"auto"}