2b:null 2c:["$","title",null,{"children":"Cape Town Water | anndawn | Observable"}] 31:T7c0,line_char={ const wrapper = html`

`; const container = html`

` wrapper.appendChild(container); yield wrapper; const dualAxes = new G2Plot.DualAxes(container, { data: [sewage, sewage], renderer:'svg', appendPadding:10, limitInPlot:false, xField: 'Year', yField: ['Cases', ' sewage spills'], yAxis: { Cases: { max:18000, min:8000 }, ' sewage spills': { max:120, min:90 } }, // meta: { // date:{ // type:"time", // max:"2022-03-01", // mask:"YY/MM", // ticks:["2017-11-01","2018-01-01","2018-03-01","2018-05-01","2018-12-01"] // }}, // xAxis:{ // type: 'time', // min:"2017-11-01", // max:"2022-03-01", // title:{ // text:"Date of order", // position:"bottom-right" // } // tickMethod:"time-pretty" // }, geometryOptions: [ { geometry: 'line', smooth: false, color: '#5B8FF9', point: { shape: 'circle', size: 4, style: { opacity: 0.5, stroke: '#5B8FF9', fill: '#fff', }, }, // label: { // formatter: (datum) => { // return `${datum.Number}个`; // }, // }, // lineStyle: { // lineWidth: 3, // lineDash: [5, 5], // }, }, { geometry: 'line', smooth: false, color: '#5AD8A6', lineStyle: { lineWidth: 4, opacity: 0.5, }, // label: { // formatter: (datum) => { // return `${datum.count}个`; // }, // }, point: { shape: 'circle', size: 4, style: { opacity: 0.5, stroke: '#5AD8A6', fill: '#fff', }, }, }, ], }); dualAxes.render(); }32:T696,line_char2={ const wrapper = html`

`; const container = html`

` wrapper.appendChild(container); yield wrapper; const dualAxes = new G2Plot.DualAxes(container, { data: [data_sew, data_sew], renderer:'svg', appendPadding:10, limitInPlot:false, connectNulls:false, xField: 'date', yField: ['Number', 'sewage_spills'], yAxis: { 'Number': { max:5000, min:0 }, 'sewage_spills': { max:120, min:90 } }, // meta: { // date:{ // type:"time", // max:"2022-03-01", // mask:"YY/MM", // ticks:["2017-11-01","2018-01-01","2018-03-01","2018-05-01","2018-12-01"] // }}, // xAxis:{ // type: 'time', // min:"2017-11-01", // max:"2022-03-01", // title:{ // text:"date", // position:"bottom-right" // } // }, geometryOptions: [ { geometry: 'line', smooth: false, color: '#5B8FF9', point: { shape: 'circle', size: 4, style: { opacity: 0.5, stroke: '#5B8FF9', fill: '#fff', }, }, // label: { // formatter: (datum) => { // return `${datum.Number}个`; // }, // }, // lineStyle: { // lineWidth: 4, // opacity: 0.5, // }, }, { geometry: 'line', smooth: false, color: '#5AD8A6', lineStyle: { lineWidth: 4, opacity: 0.5, } }, ], }); dualAxes.render(); }33:[{"id":"6c70480092d249f13ce1c77a7baf5334d5ad0a9a70f6b0e91de919cbdd791a66302b81959deed87794a50c3dc52a075595b177ab95ebda8bd199fac48005d51d","href":"https://static.observableusercontent.com/files/6c70480092d249f13ce1c77a7baf5334d5ad0a9a70f6b0e91de919cbdd791a66302b81959deed87794a50c3dc52a075595b177ab95ebda8bd199fac48005d51d","name":"sewage.csv","type":"text/csv","lastModified":1673298323696.938,"size":98},{"id":"756d53413e7943e11a114584f6bdc72407ad32ad2abdb2b10043c1825dbdb0f84bfba5c900a31b84f365a5cfb185b1d8f3ae12a1063c002d5f81a0893d749e94","href":"https://static.observableusercontent.com/files/756d53413e7943e11a114584f6bdc72407ad32ad2abdb2b10043c1825dbdb0f84bfba5c900a31b84f365a5cfb185b1d8f3ae12a1063c002d5f81a0893d749e94","name":"cases@3.csv","type":"text/csv","lastModified":1673298323696.938,"size":1285},{"id":"e8dec910a1e47631ff736b5be288ec43cb67679e7fa943c73511c460fb6766465ee65c1f3029e542d4a43760ed1dd5a329687324556e0c5a9cce324ff2d3868d","href":"https://static.observableusercontent.com/files/e8dec910a1e47631ff736b5be288ec43cb67679e7fa943c73511c460fb6766465ee65c1f3029e542d4a43760ed1dd5a329687324556e0c5a9cce324ff2d3868d","name":"count.csv","type":"text/csv","lastModified":1673298947660.523,"size":2029},{"id":"706709d5c191edcc7a9de25d2a6678953d67698441e9fbee3f5616bd746baeb10c3b1fda435ed1dbfe91eebdbcd1a6b9c564d5cbf5d1c955f456852006838110","href":"https://static.observableusercontent.com/files/706709d5c191edcc7a9de25d2a6678953d67698441e9fbee3f5616bd746baeb10c3b1fda435ed1dbfe91eebdbcd1a6b9c564d5cbf5d1c955f456852006838110","name":"count@1.csv","type":"text/csv","lastModified":1673299060398.394,"size":2014},{"id":"83729781d7ea24cf1fc0cf3a2d026098aaa80e2e43a90f6de3a2d213b2372ca8a647cfd2cda9b243aaad931b61940cba524aee9144785a7bbed5e545e316c359","href":"https://static.observableusercontent.com/files/83729781d7ea24cf1fc0cf3a2d026098aaa80e2e43a90f6de3a2d213b2372ca8a647cfd2cda9b243aaad931b61940cba524aee9144785a7bbed5e545e316c359","name":"priority.csv","type":"text/csv","lastModified":1673298378092.742,"size":24538}] 2f:{"id":"56e57f96b98a64e2","slug":null,"title":"Cape Town Water","thumbnail":"861725e64137629d377cb354483b9a54f2d608f4693f71853fc02bd3d9f90af6","access_level":"public","create_time":"$D2023-01-09T21:05:23.696Z","update_time":"$D2023-01-09T21:17:39.204Z","view_time":null,"first_public_time":"$D2023-01-09T21:05:23.696Z","has_unpublished_edits":null,"fork":{"id":"94c26942a26672a6","slug":null,"title":"Cape Town Water","owner":{"id":"08b25cc9d2cc09a6","login":"anndawn","name":""}},"stars":0,"starred":false,"owner":{"type":"team","id":"08b25cc9d2cc09a6","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":"starter_2024"},"version":148,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"b0fc265f2fad2840","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":null}],"members":[{"type":"individual","id":"b0fc265f2fad2840","login":"anndawn","name":"","avatar_url":"https://avatars-next.observableusercontent.com/a9bef462081f7a77e161e2b21c48a5ea6a7153836b0db2eb8a565396dcfc57c5","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Cape Town Water","cells":[{"id":0,"value":"# Cape Town Water","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"G2 = require(\"@antv/g2@4.0.2\");","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":8,"value":"G2Plot = require(\"@antv/g2plot\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"bar_width=width","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"bar_height=550","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3,"value":"bar_char={\n const wrapper = html`

`;\n const container = html`

`\n wrapper.appendChild(container);\n yield wrapper;\n\n\nconst stackedColumnPlot = new G2Plot.Column(container, {\n data:data_filter,\n isStack: true,\n renderer:'svg',\n xField: 'Year',\n yField: 'Number',\n seriesField: 'Month',\n label: {\n // 可手动配置 label 数据标签位置\n position: 'middle', // 'top', 'bottom', 'middle'\n // 可配置附加的布局方法\n layout: [\n // 柱形图数据标签位置自动调整\n { type: 'interval-adjust-position' },\n // 数据标签防遮挡\n { type: 'interval-hide-overlap' },\n // 数据标签文颜色自动调整\n { type: 'adjust-color' },\n ],\n },\n maxColumnWidth: 50,\n });\n\n stackedColumnPlot.render();\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"$31","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":72,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"sewage=FileAttachment(\"sewage.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":16,"value":"data=FileAttachment(\"cases@3.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":19,"value":"data_filter={\n const temp=data.filter(d=>(d.Month!=\"April\")&(d.Month!=\"May\"))\n let data_use = tidy(temp, arrange([\n T.fixedOrder('Year',[\"2017/18\",\"2018/19\",\"2019/20\",\"2020/21\",\"2021/22\"]),\n T.fixedOrder('Month',[\"March\",\"Feb\",\"Jan \",\"Dec\",\"Nov\"])\n \n ]))\n return data_use\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":88,"value":"data2=FileAttachment(\"cases@3.csv\").csv()\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"data_sew={\n const filter= data2\n filter.map(d=>{\n d.Number=Number(d.Number)\n d.sewage_spills=Number(d.sewage_spills)\n d.death=+d.death\n if(d.sewage_spills==\"\"){d.sewage_spills=null}\n \n })\n return filter}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"date_array=Array.from(new Set(data.map(d=>d.date)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":113,"value":"T = require('@tidyjs/tidy@2.4.2/dist/umd/tidy.min.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":115,"value":"import {\n tidy,\n startsWith,\n groupBy,\n summarize,\n sum,\n mutate,\n select,\n n,\n mean,\n everything,\n arrange,\n desc,\n filter,\n rate,\n TMath,\n pivotWider,\n pivotLonger,\n leftJoin,\n count,\n map,\n complete,\n fill\n} from '@pbeshai/tidyjs' // observable import","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"school=FileAttachment(\"count@1.csv\").csv({typed:true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"priority = await FileAttachment(\"priority.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"priority","database":"$undefined"},{"id":143,"value":"bar_char2={\n const wrapper = html`

`;\n const container = html`

`\n wrapper.appendChild(container);\n yield wrapper;\n\n\nconst stackedColumnPlot= new G2Plot.Bar(container, {\n data:school,\n xField: 'type',\n yField: 'education_district',\n seriesField: 'project_status',\n isPercent: true,\n isStack: true,\n /** 自定义颜色 */\n // color: ['#2582a1', '#f88c24', '#c52125', '#87f4d0'],\n label: {\n position: 'middle',\n content: (item) => {\n return item.value.toFixed(2);\n },\n style: {\n fill: '#fff',\n },\n },\n});\n\n stackedColumnPlot.render();\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"