3f:null 40:["$","title",null,{"children":"Shanghai AQI & Sleep Quality | Yu Ji's Workspace | Observable"}] 46:Tf4a,Plot.plot({ grid: true, x: { // Assuming pm25_align is your x-axis data domain: [0, 180] // Adjust this based on your actual data range }, color: { legend: true // Only if you want a legend for the snore time colors }, marks: [ // Background color based on pm2.5 range Plot.rectY(joined, { x1: "pm25_align", x2: d => d.pm25_align + 20, // Assuming a fixed range width, adjust as needed y1: 0, // Adjust this based on your y-axis range y2: 12000, fill: d => { if (d.pm25_align < 40) return "red"; else if (d.pm25_align < 60) return "orange"; else if (d.pm25_align < 80) return "yellow"; else if (d.pm25_align < 100) return "green"; else if (d.pm25_align < 120) return "blue"; else if (d.pm25_align < 140) return "indigo"; else if (d.pm25_align < 160) return "pink"; else if (d.pm25_align < 180) return "red"; // Add more conditions based on your ranges and desired colors else return "defaultColor"; }, // -------------------------------------------------------------------- // Background color based on pm2.5 range // Plot.rect(joined, { // x1: d => d.pm25_align, // x2: d => d.pm25_align + 20, // y1: 0, // y2: 11000, // Assuming Snore_time is used for the y-axis // fill: d => { // if (d.pm25_align < 20) return "orange"; // // else if (d.pm25_align < 40 & d.pm25_align > 20) return "green"; // else if (d.pm25_align < 60) return "yellow"; // // else if (d.pm25_align < 80) return "orange"; // // else if (d.pm25_align < 100) return "red"; // // else if (d.pm25_align < 120) return "purple"; // // else if (d.pm25_align < 140) return "gray"; // // else if (d.pm25_align < 160) return "pink"; // // else if (d.pm25_align < 180) return "brown"; // // Add more conditions based on your ranges and desired colors // else return "pink"; // }, // -------------------------------------------------------------------- // Background color based on pm2.5 range // Plot.rect([0], { // x1: d => d.pm25_align, // x2: d => d.pm25_align + 20, // y1: 0, // y2: 11000, // Assuming Snore_time is used for the y-axis // fill: d => { // const len = d.pm25_align; // Assigning len dynamically based on pm25_align value // if (len < 20) return "blue"; // else if (len < 40) return "green"; // else if (len < 60) return "yellow"; // else if (len < 80) return "orange"; // else if (len < 100) return "red"; // else if (len < 120) return "purple"; // else if (len < 140) return "gray"; // else if (len < 160) return "pink"; // else if (len < 180) return "brown"; // // Add more conditions based on your ranges and desired colors // else return "defaultColor"; // }, // -------------------------------------------------------------------- fillOpacity: 0.1 // set transparency }), // Dot color based on Snore_time Plot.dot(joined, { x: "pm25_align", y: "Snore_time", fill: d => { // Define color based on Snore_time // Adjust conditions and colors as per your requirement if (d.Snore_time < 2000) return "red"; else if (d.Snore_time < 4000) return "orange"; else if (d.Snore_time < 6000) return "yellow"; else if (d.Snore_time < 8000) return "green"; else if (d.Snore_time < 10000) return "blue"; else if (d.Snore_time < 12000) return "indigo"; // Add more conditions as needed else return "defaultDotColor"; }, stroke: "black", // Optional, for better dot visibility tip: true }) ] }) 47:[{"id":"0187d6642e077e35b1a1b96eeb041790d81d549aa226bf2872cf7f9662588387c7c69f5c0d9bcca284f0306a01b5bf4422d416b5002de65d091ed440752a2f1d","href":"https://static.observableusercontent.com/files/0187d6642e077e35b1a1b96eeb041790d81d549aa226bf2872cf7f9662588387c7c69f5c0d9bcca284f0306a01b5bf4422d416b5002de65d091ed440752a2f1d","name":"cycledata_parse2@3.csv","type":"text/csv","lastModified":1700535856306.151,"size":63350},{"id":"ffbba19fd54b249190e014a13f2f82b8433ca98afa9ef8099c32b679471a9440a3910419672d2ad3f7e412b4a403e9cca12a3c9ae8050a8f6ccc32840f065841","href":"https://static.observableusercontent.com/files/ffbba19fd54b249190e014a13f2f82b8433ca98afa9ef8099c32b679471a9440a3910419672d2ad3f7e412b4a403e9cca12a3c9ae8050a8f6ccc32840f065841","name":"joined_data@1.csv","type":"text/csv","lastModified":1700546357565.27,"size":153142},{"id":"e98c13af21e8311112b1b211de9bc1b27aa3514bf9b2fc2c5c98b0b40bc65868cbc12c5089618e9899ec796fc99d5086743d33caac2230e3c074022717483f0f","href":"https://static.observableusercontent.com/files/e98c13af21e8311112b1b211de9bc1b27aa3514bf9b2fc2c5c98b0b40bc65868cbc12c5089618e9899ec796fc99d5086743d33caac2230e3c074022717483f0f","name":"shanghai-air-quality@25.csv","type":"text/csv","lastModified":1700718651739.908,"size":134963},{"id":"c3d975ffad92d4adb374c28069c597d25b5ca0b62c37df86acfc0cf5b5425781ad13b827543119f01686eb162521352b3b51d90041e5a143312db4dc11089918","href":"https://static.observableusercontent.com/files/c3d975ffad92d4adb374c28069c597d25b5ca0b62c37df86acfc0cf5b5425781ad13b827543119f01686eb162521352b3b51d90041e5a143312db4dc11089918","name":"shanghai-air-quality@26.csv","type":"text/csv","lastModified":1700718822328.835,"size":138662},{"id":"21318345fa83d6b8ce177d6c8d13192c3491abf834ef220c0d1affb00bb32b7b6a76f7cf2af651842b16427c994b11a6d088126e1c1e5b5da6a489b5bacdbf64","href":"https://static.observableusercontent.com/files/21318345fa83d6b8ce177d6c8d13192c3491abf834ef220c0d1affb00bb32b7b6a76f7cf2af651842b16427c994b11a6d088126e1c1e5b5da6a489b5bacdbf64","name":"shanghai-air-quality@24.csv","type":"text/csv","lastModified":1700645191476.881,"size":100383}] 44:{"id":"6f9327661a1d7ea8","slug":"shanghai-aqi-sleep-quality","title":"Shanghai AQI & Sleep Quality","thumbnail":"af4cda0475e6f5420a53e799c11f2e805d264809249a187dd549ef980a196299","access_level":"public","create_time":"$D2023-11-21T01:24:03.439Z","update_time":"$D2023-12-29T03:47:31.960Z","view_time":null,"first_public_time":"$D2023-11-21T01:24:03.439Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"e72f027c6e802fe8","login":"thanatos1111","name":"Yu Ji's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/499e6fc1676701b9732227ce52ca9de9a5bc96e03257abb039fc598e09f0f0be","tier":"starter_2024","bio":"","following":false},"version":941,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"16ddb7facf80c061","login":"yu-ji","name":"Yu Ji","avatar_url":"https://avatars-next.observableusercontent.com/d4fa71970ba29aec9de7a1d321ca3dc33e461327e1a1dac7811a172ec18b7a0d","tier":null,"bio":"Javascript Newbie","following":false}],"members":[{"type":"team","id":"e72f027c6e802fe8","login":"thanatos1111","name":"Yu Ji's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/499e6fc1676701b9732227ce52ca9de9a5bc96e03257abb039fc598e09f0f0be","tier":"starter_2024","role":"editor"},{"type":"individual","id":"16ddb7facf80c061","login":"yu-ji","name":"Yu Ji","avatar_url":"https://avatars-next.observableusercontent.com/d4fa71970ba29aec9de7a1d321ca3dc33e461327e1a1dac7811a172ec18b7a0d","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Shanghai AQI & Sleep Quality","cells":[{"id":0,"value":"# Shanghai AQI & Sleep Quality","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":512,"value":"# 1. Data Collection","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":193,"value":"[Air quality source](https://aqicn.org/data-platform/register/#)\n\n\n[download](https://aqicn.org/historical/#!city:shanghai/jiadingjiancezhan)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":643,"value":"cycledata_parse_fileterd = await FileAttachment(\"cycledata_parse2@3.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"cycledata_parse_fileterd","database":"$undefined"},{"id":652,"value":"Plot.plot({\n marks: [\n Plot.lineY(cycledata_parse_fileterd, {\n x: \"Date\",\n y: \"Time_in_bed\",\n tip: true\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":505,"value":"Inputs.table(Sleep.filter((d) => d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"Inputs.table(AQI.filter((d) => d))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":515,"value":"# 2 Data Analysis","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":487,"value":"viewof parameter1 = Inputs.radio(\n [\n \"Snore_time\",\n \"Snore time(min)\",\n \"Regularity\",\n \"Sleep_Quality\",\n \"Movements_per_hour\",\n \"Time_in_bed\"\n ],\n {\n label: \"Select one\",\n value: \"Snore_time\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"Plot.plot({\n marks: [\n Plot.lineY(\n await FileAttachment(\"cycledata_parse2@3.csv\").csv({ typed: \"auto\" }),\n { x: \"Date\", y: parameter1, tip: true }\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"Plot.plot({\n color: {\n legend: true\n },\n marks: [\n Plot.auto(await FileAttachment(\"shanghai-air-quality@26.csv\").csv({typed: true}), {x: \"date\", y: \"pm25\", color: \"pm25\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":66,"value":"viewof weekday = Inputs.select(\n new Map([\n [\"Weekdays only\", \"weekday\"],\n [\"Sunday-based weeks\", \"sunday\"],\n [\"Monday-based weeks\", \"monday\"]\n ])\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":758,"value":"viewof parameter2 = Inputs.radio(\n [\n \"Snore time(min)\",\n \"Regularity\",\n \"Sleep_Quality\",\n \"Movements_per_hour\",\n \"Time_in_bed\"\n ],\n {\n label: \"Select one\",\n value: \"Snore_time\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"Calendar(Sleep, {\n x: (d) => d.Date,\n y: (d) => d[parameter2],\n weekday,\n width\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":157,"value":"viewof radios = Inputs.radio([\"pm25\", \"pm10\", \"o3\", \"no2\", \"so2\", \"co\"], {\n label: \"Select one\",\n value: \"pm25\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"Calendar(AQI, {\n x: (d) => d.date,\n y: (d) => d[radios],\n weekday,\n width\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":629,"value":"# 2.1 Joined Data Analysis\nNotice: Manually joined by date matching in excel with command\n\nExcel: choose Data/from table, divide by \";\", save\n\n```=VLOOKUP(I2,$A$2:$B$5000,2,FALSE)```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":940,"value":"```=DATE(YEAR(H2), MONTH(H2), DAY(H2))-1 //get date, eliminate time, minus 1 day```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":265,"value":"Plot.plot({\n grid: true,\n color: { scheme: \"Greens\", legend: true },\n marks: [\n Plot.dot(await FileAttachment(\"joined_data@1.csv\").csv({ typed: \"csv\" }), {\n x: \"Date\",\n y: \"Snore_time\",\n stroke: \"pm25_align\",\n fill: \"pm25_align\",\n tip: true\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":322,"value":"Plot.plot({\n grid: true,\n //color: { scheme: \"Greens\", legend: true },\n color: {\n type: \"threshold\",\n domain: [40, 60, 80, 100, 120, 140, 160, 180],\n range: [\n \"red\",\n \"orange\",\n \"yellow\",\n \"green\",\n \"blue\",\n \"indigo\",\n \"violet\",\n \"pink\"\n ],\n legend: true\n },\n marks: [\n Plot.dot(joined, {\n x: \"pm25_align\",\n y: \"Snore_time\",\n stroke: \"pm25_align\",\n fill: \"pm25_align\",\n tip: true\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":282,"value":"Plot.plot({\n marks: [\n Plot.lineY(joined, {\n x: \"Date\",\n y: \"Snore_time\",\n stroke: \"#999\",\n strokeWidth: 2.5,\n curve: \"linear\"\n }),\n Plot.lineY(joined, {\n x: \"Date\",\n y: \"pm25_align\",\n stroke: \"red\",\n strokeWidth: 0.5\n })\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":317,"value":"Plot.plot({\n marks: [\n dualAxisY(joined, { y: \"Snore_time\", anchor: \"left\", color: \"#4e79a7\" }),\n dualAxisY(joined, { y: \"pm25_align\", anchor: \"right\", color: \"#f28e2c\" }),\n Plot.lineY(\n joined,\n Plot.normalizeY(\"extent\", {\n x: \"Date\",\n y: \"Snore_time\",\n stroke: \"#4e79a7\"\n })\n ),\n Plot.lineY(\n joined,\n Plot.normalizeY(\"extent\", {\n x: \"Date\",\n y: \"pm25_align\",\n stroke: \"#f28e2c\"\n })\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":525,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":554,"value":"Reference:\n[2.Double Kill](https://observablehq.com/@1907040201/2-double-kill)\n\nAdded quality column based on PM2.5 value range with command:\n\n```=IF(AND(B2>=0,B2<=50),\"Good\",IF(AND(B2>50,B2<=100),\"Moderate\",IF(AND(B2>100,B2<=150),\"Mild Unhealthy\",IF(AND(B2>150,B2<=200),\"Unhealthy\",IF(AND(B2>200,B2<=300),\"Very Unhealthy\",\"unknown\")))))\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":533,"value":"viewof x = Inputs.select([\"pm25\", \"pm10\", \"o3\", \"no2\", \"so2\", \"co\"], {\n label: \"Choose x axis\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":535,"value":"viewof y = Inputs.select([\"pm25\", \"pm10\", \"o3\", \"no2\", \"so2\", \"co\"], {\n label: \"Choose y axis\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":527,"value":"quality = [\"Good\", \"Moderate\", \"Mild Unhealthy\", \"Unhealthy\", \"Very Unhealthy\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":522,"value":"{\n const selection = vl\n .selectPoint(\"Select\")\n .fields(\"quality\")\n .init({ quality: quality[1] })\n .bind(vl.radio(quality)); // added quality rank based on pm2.5 value range\n\n return vl\n .markCircle()\n .data(AQI)\n .params(selection, vl.selectInterval().bind(\"scales\"))\n .encode(\n vl.x().fieldQ(x),\n vl.y().fieldQ(y).axis({ minExtent: 100 }),\n vl.tooltip([\"date\", \"pm25\", \"pm10\"]),\n vl.color().fieldN(\"quality\"),\n vl.opacity().if(selection, vl.value(1.0)).value(0.2)\n )\n\n .width(800)\n .height(600)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":552,"value":"# 3. Interaction","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":591,"value":"viewof xx = Inputs.select([\"pm25\", \"pm10\", \"o3\", \"no2\",\"so2\",\"co\"], { label: \"Choose x axis\"}) ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":592,"value":"viewof yy = Inputs.select([\"pm25\", \"pm10\", \"o3\", \"no2\", \"so2\", \"co\"], {\n label: \"Choose y axis\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":556,"value":"{\n const brush = vl.selectInterval().encodings(\"x\");\n const x1 = vl.x().fieldT(\"date\").title(null);\n\n const base = vl //1st plot\n .markArea()\n .encode(x1, vl.y().fieldQ(\"pm25\"))\n .width(1000)\n .height(400);\n\n const ratings = vl //3rd plot\n .markCircle()\n .data(AQI)\n .encode(\n vl.x().fieldQ(xx),\n vl.y().fieldQ(yy),\n vl.tooltip([\"date\", \"pm25\", \"pm10\", \"o3\", \"no2\"]),\n vl.opacity().if(brush, vl.value(0.8)).value(0.1)\n )\n .width(1000)\n .height(400);\n\n return vl\n .data(AQI)\n .vconcat(\n base.encode(x1.scale({ domain: brush })),\n base.params(brush).height(80),\n ratings\n )\n .spacing(5)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":889,"value":"# 4. Test","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":900,"value":"Plot.plot({\n color: { scheme: \"BuYlRd\", legend: true },\n marks: [\n Plot.dot(\n await FileAttachment(\"shanghai-air-quality@26.csv\").csv({\n typed: \"auto\"\n }),\n {\n x: \"date\",\n y: \"quality\",\n stroke: \"quality\",\n fill: \"quality\",\n tip: true\n }\n )\n ],\n marginLeft: 100\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":51,"value":"import { Calendar } from \"@d3/calendar\"\n//import { Calendar } from \"@observablehq/calendar-component\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":314,"value":"import { dualAxisY } from \"@tophtucker/plot-dual-axis-line-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":870,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":58,"value":"Sleep = FileAttachment(\"cycledata_parse2@3.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":673,"value":"//AQI = FileAttachment(\"shanghai-air-quality@24.csv\").csv()\nAQI = FileAttachment(\"shanghai-air-quality@26.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":294,"value":"joined = FileAttachment(\"joined_data@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":201,"value":"//parseDate = d3.timeParse(\"%Y-%m-%d\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"//Sleep_p = Sleep.forEach((d) => (d.date = parseDate(d.date)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"value":"//AQI_p = AQI.forEach((d) => (d.date = parseDate(d.date)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"value":"//import { csv } from \"@observablehq/stdlib\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":210,"value":"joinedData = join(\n Sleep,\n AQI,\n (d) => d.date,\n (d) => d.date,\n (d1, d2) => {\n // Merge the matching records from both datasets\n return {\n date: d1.date,\n value1: d1.value,\n value2: d2.value\n };\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":228,"value":"function join(data1, data2, key1, key2, combine) {\n const map = new Map();\n\n // Build a map of key-value pairs from data2\n data2.forEach((d) => {\n const key = key2(d);\n if (!map.has(key)) {\n map.set(key, []);\n }\n map.get(key).push(d);\n });\n\n const joinedData = [];\n\n // Iterate over data1 and find matching records from data2\n data1.forEach((d) => {\n const key = key1(d);\n if (map.has(key)) {\n const matchingRecords = map.get(key);\n matchingRecords.forEach((matchingRecord) => {\n const mergedRecord = combine(d, matchingRecord);\n joinedData.push(mergedRecord);\n });\n }\n });\n\n return joinedData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 45:"$44:body"