28:null 29:["$","title",null,{"children":"Lab3 | Кононенко Дмитрий | Observable"}] 2f:[{"id":"ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","href":"https://static.observableusercontent.com/files/ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","name":"arch_Novosib_2021_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1699190633053.552,"size":324115},{"id":"5c91bafd8f7707727d45e78448ceffe839689efaa2f4a4c8b001551b0b7298fa7e2b0b329d3e968c758c1e5f409a97e91b1aff5ac8f91f63573b1187e85d302b","href":"https://static.observableusercontent.com/files/5c91bafd8f7707727d45e78448ceffe839689efaa2f4a4c8b001551b0b7298fa7e2b0b329d3e968c758c1e5f409a97e91b1aff5ac8f91f63573b1187e85d302b","name":"comp_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1699332287321.288,"size":16545},{"id":"ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","href":"https://static.observableusercontent.com/files/ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","name":"arch_Novosib_2021_new@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1699333343123.059,"size":324115},{"id":"ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","href":"https://static.observableusercontent.com/files/ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","name":"arch_Novosib_2021_new@2.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1699364464121.248,"size":324115}] 2c:{"id":"79424c443752036e","slug":null,"title":"Lab3","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-11-05T13:23:02.733Z","update_time":"$D2023-11-07T16:12:10.571Z","view_time":null,"first_public_time":"$D2023-11-05T13:23:02.733Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"2bd7ad2d00c9eab6","login":"dmitriy4-ws","name":"Кононенко Дмитрий","avatar_url":"https://avatars-next.observableusercontent.com/6122d117f2d765c9b0a54a752a2d21469ad458c539eb88f70b0d68993cea075a","tier":"starter_2024"},"version":205,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"77f916e1eab75cb2","login":"dmitriy4","name":"Кононенко Дмитрий","avatar_url":"https://avatars-next.observableusercontent.com/69dfb77c27f8a48b70d9277ea07584573a507a7ea1723222fc1be7f6235e2c67","tier":null}],"members":[{"type":"individual","id":"77f916e1eab75cb2","login":"dmitriy4","name":"Кононенко Дмитрий","avatar_url":"https://avatars-next.observableusercontent.com/69dfb77c27f8a48b70d9277ea07584573a507a7ea1723222fc1be7f6235e2c67","tier":null,"role":"editor"},{"type":"team","id":"2bd7ad2d00c9eab6","login":"dmitriy4-ws","name":"Кононенко Дмитрий","avatar_url":"https://avatars-next.observableusercontent.com/6122d117f2d765c9b0a54a752a2d21469ad458c539eb88f70b0d68993cea075a","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Lab3","cells":[{"id":0,"value":"# Lab3","pinned":false,"hidden":false,"mode":"md"},{"id":26,"value":"work = FileAttachment(\"comp_new.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":27,"value":"work.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":28,"value":"data1 = work.sheet(0, {\n headers: false,\n // range: \"A1:J10\"\n })","pinned":true,"hidden":false,"mode":"ojs"},{"id":29,"value":"data1","pinned":true,"hidden":false,"mode":"ojs"},{"id":12,"value":"work.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"data = work.sheet(0, {\n headers: false,\n // range: \"A1:J10\"\n })","pinned":true,"hidden":false,"mode":"ojs"},{"id":18,"value":"connecting = work.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":20,"value":"`названия столбцов:[${connecting.columns}]\\n количество объектов: ${connecting.length}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":22,"value":"viewof table_connect = Inputs.table(connecting, \n{ columns: [\"#\", \"Время отправки\", \"Задача\", \"Участник\", \"Баллы\"],\n header: {\n \"#\": \"N\",\n \"Время отправки\": \"Время\",\n \"Задача\": \"Zadacha\",\n \"Участник\": \"Ychastnik\",\n \"Баллы\": \"balli\"\n }, \n width: {\n \"#\": 50,\n \"Время\": 300,\n \"Zadacha\": 100,\n \"Ychastnik\": 100,\n \"balli\": 100\n },\n maxWidth: 800, sort: \"2021\", maxHeight: 150, reverse:true, required: false\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":38,"value":"connecting.shift()","pinned":true,"hidden":false,"mode":"ojs"},{"id":40,"value":"connecting.pop()","pinned":true,"hidden":false,"mode":"ojs"},{"id":42,"value":"connecting","pinned":true,"hidden":false,"mode":"ojs"},{"id":44,"value":"`названия столбцов:[${connecting.columns}]\\n количество объектов: ${connecting.length}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":46,"value":"Plot.plot({\n marks: [\n Plot.barX(connecting.slice(10,17), {x: \"Баллы\", y: \"Участник\", fill:\"#23af99\", sort: {x: \"x\", reverse: true}}),\n Plot.ruleX([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":58,"value":"Plot.barX(connecting.slice(10,17), {x: \"Баллы\", y: \"Участник\", fill:\"#23af99\"}).plot() ","pinned":true,"hidden":false,"mode":"ojs"},{"id":60,"value":"Plot.barX(connecting.slice(10,17), {x1: \"Время выполнения\", y: \"Участник\", fill:\"#23af99\"}).plot()","pinned":true,"hidden":false,"mode":"ojs"},{"id":63,"value":"Plot.plot({\n marks: [\n Plot.barX(connecting.slice(10,18), {x: \"Баллы\", y: \"Участник\", fill:\"Участник\", sort: {x: \"x\", reverse: true}}),\n Plot.ruleX([0])\n ],\n color: { legend: true },\n marginLeft: 200\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":67,"value":"function select_colors(object) {\n if (object[\"Баллы\"] < 1800) return \"#aa8834\"\n if (object[\"Баллы\"] < 2000) return \"#889945\"\n return \"#445611\"\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":69,"value":"Plot.plot({\n marks: [\n Plot.barX(connecting.slice(10,18), {x: \"Баллы\", y: \"Участник\", fill:(d=>select_colors(d)), sort: {x: \"x\", reverse: true}}),\n Plot.ruleX([0])\n ],\n color: { legend: true },\n marginLeft: 200\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":71,"value":"function select_colors_r(object) {\n if (object[\"Время выполнения\"] > object[\"Баллы\"]) return \"#4488bb\" \n else return \"#88aabb\"\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":73,"value":"Plot.plot({\n marks: [\n Plot.barX(connecting.slice(18,30), {x: \"Баллы\", y: \"Участник\", fill:(d=>select_colors_r(d)), sort: {x: \"x\", reverse: true}}),\n Plot.ruleX([0])\n ],\n color: { legend: true },\n marginLeft: 230\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":77,"value":"data_p = [{\"name\":\"Иванов\",\"courses\":10, \"course_passed\":8, \"min_balls\": 45, \"max_balls\": 84},{\"name\":\"Петров\",\"courses\":6, \"course_passed\":5, \"min_balls\": 49, \"max_balls\": 87}, {\"name\":\"Мыров\",\"courses\":3, \"course_passed\":1, \"min_balls\": 20, \"max_balls\": 63}, {\"name\":\"Иванова\",\"courses\":4, \"course_passed\":1, \"min_balls\": 85, \"max_balls\": 98}, ]","pinned":true,"hidden":false,"mode":"ojs"},{"id":79,"value":"Plot.rectY(data_p, {x1:\"courses\", x2:\"course_passed\", y1:\"min_balls\", y2:\"max_balls\", fill:\"#23af99\"}).plot()","pinned":true,"hidden":false,"mode":"ojs"},{"id":81,"value":"Plot.rectY(data_p, {x1:\"courses\", x2:\"course_passed\", y1:\"min_balls\", y2:\"max_balls\", fill:\"name\"}).plot\n (\n {color: { legend: true },\n margin: 30,\n width: 400,\n height: 250,\n marks: [Plot.ruleY([0, 50, 90]), Plot.ruleX([0, 3, 6])]\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":83,"value":"Plot.rectX(data_p, {x1:0, x2:\"course_passed\",y1:\"min_balls\", y2:\"max_balls\", fill:\"name\"}).plot\n (\n {color: { legend: true },\n margin: 30,\n width: 400,\n height: 250,\n marks: [Plot.ruleY([0, 90]), Plot.ruleX([0, 3, 6])]\n }\n)","pinned":true,"hidden":false,"mode":"ojs"},{"id":85,"value":"Plot.plot({\n caption: `Успеваемость студентов (количество: ${data_p.length})`,\n marks: [\n Plot.rectX(data_p, {x1:0, x2:\"course_passed\",y1:\"min_balls\", y2:\"max_balls\", fill:\"name\"}),\n Plot.ruleY([0, 50]),\n Plot.ruleX([0, 3, 6])\n ],\n color: { legend: true },\n margin: 30,\n width: 400,\n height: 250\n})\n ","pinned":true,"hidden":false,"mode":"ojs"},{"id":14,"value":"data","pinned":true,"hidden":false,"mode":"ojs"},{"id":117,"value":"data_temper = FileAttachment(\"arch_Novosib_2021_new@2.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":118,"value":"data_temper.sheetNames","pinned":true,"hidden":false,"mode":"ojs"},{"id":119,"value":"temper = data_temper.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":120,"value":"temper","pinned":true,"hidden":false,"mode":"ojs"},{"id":131,"value":"data_temper_r = temper.map(function (d) {\n\t return {date_b: new Date(Date.parse(d[\"Местное время в Новосибирске\"].split('.')[2].split(' ')[0]+\"-\"+d[\"Местное время в Новосибирске\"].split('.')[1]+\"-\"+d[\"Местное время в Новосибирске\"].split('.')[0]+\"T\"+d[\"Местное время в Новосибирске\"].split('.')[2].split(' ')[1]+':00.417-07:00')),\n temper: Number(d[\"T\"]), \n press: Number(d[\"P\"]) \n }} ).sort((a, b) => a[\"date_b\"] > b[\"date_b\"] ? 1 : -1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":150,"value":"viewof table_temper = Inputs.table(data_temper_r, { sort: \"date_b\", maxHeight: 100})","pinned":true,"hidden":false,"mode":"ojs"},{"id":152,"value":"Plot.plot({\n width: 1200,\n height: 300,\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", fill:\"#2a70c3\"}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":154,"value":"Plot.plot({\n width: 1200,\n height: 300,\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", fill:\"#5a70c3\"}),\n Plot.lineY(data_temper_r, {x: \"date_b\", y: \"temper\", strokeWidth: 0.4}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":159,"value":"viewof select_mounth = Inputs.select(Array.from(new Array(12),(val,index)=>index + 1), {label: \"Месяц:\", width:300, value:5})","pinned":true,"hidden":false,"mode":"ojs"},{"id":161,"value":"Plot.plot({\n width: 1200,\n height: 300,\n x: {\n domain: [new Date(2020,select_mounth, 1), new Date(2020, select_mounth+1, 1)]\n },\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", fill:\"#2a10c3\"}),\n Plot.lineY(data_temper_r, {x: \"date_b\", y: \"temper\", strokeWidth: 0.4}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":165,"value":"Plot.plot({\n width: 1200,\n height: 300,\n x: {\n domain: [new Date(2020,select_mounth, 1), new Date(2020, select_mounth+1, 1)]\n },\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", curve:\"step\", fill:\"#8a70c3\"}),\n Plot.lineY(data_temper_r, {x: \"date_b\", y: \"temper\", strokeWidth: 0.6}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":167,"value":"function time_area(object) {\n if (object[\"date_b\"].getHours() > 10 && object[\"date_b\"].getHours()<=20) return 1 //день\n else return 2\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":169,"value":"Plot.plot({\n width: 1200,\n height: 300,\n x: {\n domain: [new Date(2020,select_mounth, 1), new Date(2020, select_mounth+1, 1)]\n },\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", z:(d=>time_area(d)), fillOpacity: 0.4, fill:\"temper\"}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":171,"value":"function colors_area(object) {\n if (object[\"date_b\"].getHours() > 10 && object[\"date_b\"].getHours()<=20) return \"#aaccbb\" //день\n else return \"#11bbbb\"\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":173,"value":"Plot.plot({\n width: 1200,\n height: 300,\n x: {\n domain: [new Date(2020,select_mounth, 1), new Date(2020, select_mounth+1, 1)]\n },\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", z:(d=>time_area(d)), fillOpacity: 0.4, fill:(d=>colors_area(d))}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":175,"value":"function time_zone(object) {\n if (5<=object[\"date_b\"].getHours() && object[\"date_b\"].getHours() < 10) return \"утро\"\n if (10<=object[\"date_b\"].getHours() && object[\"date_b\"].getHours() < 18) return \"день\"\n if (18<=object[\"date_b\"].getHours()&& object[\"date_b\"].getHours() < 22) return \"вечер\" \n return \"ночь\"\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":177,"value":"Plot.plot({\n width: 1200,\n height: 600,\n grid : true,\n \n facet: {\n data: data_temper_r,\n y: (d=>time_zone(d)),\n margin: 50\n },\n marks: [\n Plot.areaY(data_temper_r, { x: \"date_b\", y: \"temper\", curve:\"natural\", fill:\"#13aa92\"}),\n Plot.ruleY([0]),\n Plot.ruleX([new Date(2020, select_mounth, 1)]), \n Plot.frame()\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":180,"value":"viewof select_mounth_d = Inputs.select(Array.from(new Array(12),(val,index)=>index + 1), {label: \"Месяц:\", width:300, value:5})","pinned":true,"hidden":false,"mode":"ojs"},{"id":182,"value":"Plot.plot({\n width: 1200,\n height: 900,\n grid : true,\n x: {\n type: \"time\", ticks: 30, tickFormat: \"%b %d\",\n domain: [new Date(2020, select_mounth_d, 1), new Date(2020, select_mounth_d+1, 0)]\n },\n y: {\n domain: [-1, 30], ticks: 20\n },\n facet: {\n data: data_temper_r,\n y: (d=>time_zone(d)),\n margin: 50\n },\n marks: [\n Plot.areaY(data_temper_r, { x: \"date_b\", y: \"temper\", curve:\"natural\", fill:\"#13aa92\", fillOpacity: 0.5}),\n Plot.ruleY([0]),\n Plot.ruleX([new Date(2020, select_mounth_d, 1)]), \n Plot.frame()\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":184,"value":"Plot.plot({\n caption:`Температурная карта для г.Новосибирскк месяц:${select_mounth_d}`,\n marks: [\n Plot.cell(data_temper_r, { x: d => d[\"date_b\"].getDate(), y: d => d[\"date_b\"].getHours(), fill: \"temper\"})\n ],\n color: { legend: true },\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":186,"value":"Plot.plot({\n caption:`Температурная карта для г.Новосибирск месяц:${select_mounth_d}`,\n grid : true,\n facet: {\n data: data_temper_r,\n y: (d=>d[\"date_b\"].getMonth()),\n margin: 50\n },\n marks: [\n Plot.cell(data_temper_r, { x: d => d[\"date_b\"].getDate(), y: d => d[\"date_b\"].getHours(), fill: \"temper\"}),\n Plot.ruleY([0,23]),\n Plot.ruleX([0]), \n ],\n color: { legend: true, range:[\"aa8834\", \"#2a70c3\"] }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":189,"value":"Plot.plot({\n height: 100,\n marks: [\n Plot.frame(),\n Plot.text([\"Температурная карта г. Новосибирск\"], {frameAnchor: \"middle\", fontSize: 16})\n ]\n });","pinned":true,"hidden":false,"mode":"ojs"},{"id":196,"value":"Plot.plot({\n width: 1200,\n caption:`Температурная карта для г.Новосибирск месяц:${select_mounth_d}`,\n marks: [\n Plot.cell(data_temper_r, { x: d => d[\"date_b\"].getDate(), y: d => d[\"date_b\"].getHours(), fill: \"temper\",fillOpacity: 0.5}),\n //новая метка\n Plot.text(data_temper_r,{ x: d => d[\"date_b\"].getDate(), y: d => d[\"date_b\"].getHours(), text:\"temper\", \n rotate:0, fontSize:8})\n ],\n padding: 0.05,\n grid: true\n\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":200,"value":"Plot.plot({\n height: 300,\n width: 1200,\n marks: [\n Plot.cell(data_temper_r, { x: d => d[\"date_b\"].getDate(), y: d => d[\"date_b\"].getHours(), fill: \"temper\", fillOpacity: 0.5}),\n Plot.text(data_temper_r, { x: d => d[\"date_b\"].getDate(), y: d => d[\"date_b\"].getHours(), text:d=>(Math.round(d[\"press\"])), rotate:0, fontSize:9.3} )\n ],\n padding: 0.07,\n color: { legend: true, range:[\"yellow\", \"brown\"]}\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":202,"value":"Plot.plot({\n marks: [\n Plot.barX(connecting.slice(18,30), {x: \"Баллы\", y: \"Участник\", fill:(d=>select_colors_r(d)), rx:5, sort: {x: \"x\", reverse: true}}),\n Plot.text(connecting.slice(18,30), {x: \"Баллы\", y: \"Участник\", dx: 20, text: d=>d[\"2020\"]}), \n Plot.text(connecting.slice(18,30), {x: \"Баллы\", y: \"Участник\", dx: 60, text: d=>d[\"2021\"]}), \n Plot.ruleX([0])\n ],\n color: { legend: true },\n marginLeft: 230,\n marginRight: 80\n})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"