40:null 41:["$","title",null,{"children":"Лаб.работа 3 | kov's Workspace | Observable"}] 47:[{"id":"2a7588e31886536d9ff13c933f1bc0c44f7a4b9bf872f1da5afcaa4c167e3f166754f7bb24d32813587fac9415cb90093176c6fd18e68050df06eb629fec6fd1","href":"https://static.observableusercontent.com/files/2a7588e31886536d9ff13c933f1bc0c44f7a4b9bf872f1da5afcaa4c167e3f166754f7bb24d32813587fac9415cb90093176c6fd18e68050df06eb629fec6fd1","name":"comp_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702837410766.084,"size":16573},{"id":"ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","href":"https://static.observableusercontent.com/files/ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","name":"arch_Novosib_2021_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702837511119.853,"size":324115}] 45:{"id":"d2d2b94d61079cb0","slug":null,"title":"Лаб.работа 3","thumbnail":"09c2f60de0518791bc84e6750f9dcad7cb60b59d911d67a79cdb088aa3f00b39","access_level":"public","create_time":"$D2023-12-17T18:07:06.010Z","update_time":"$D2023-12-18T20:00:54.199Z","view_time":null,"first_public_time":"$D2023-12-17T18:07:06.010Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"ba2125407b9f3251","login":"kov2-ws","name":"kov's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/bc6cbd4ebe23f2c084f32caac66895188fd0867a66b13dab32aa5ab276fc48d1","tier":"starter_2024","bio":"","following":false},"version":273,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"ff41ab8fae6fc541","login":"kov2","name":"kov","avatar_url":"https://avatars-next.observableusercontent.com/fbdb784412f8eca8740456d35c80c156428184982b412b0d69934aba0cf9036c","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"ff41ab8fae6fc541","login":"kov2","name":"kov","avatar_url":"https://avatars-next.observableusercontent.com/fbdb784412f8eca8740456d35c80c156428184982b412b0d69934aba0cf9036c","tier":null,"role":"editor"},{"type":"team","id":"ba2125407b9f3251","login":"kov2-ws","name":"kov's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/bc6cbd4ebe23f2c084f32caac66895188fd0867a66b13dab32aa5ab276fc48d1","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Лаб.работа 3","cells":[{"id":0,"value":"\n# Лаб.работа 3","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":8,"value":"# Диаграммы","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10,"value":"Загрузим датасет ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":12,"value":"comp = FileAttachment(\"comp_new.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":15,"value":"connecting = comp.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"`названия столбцов:[${connecting.columns}]\\n количество объектов: ${connecting.length}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":77,"value":"","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"viewof tab_comp = Inputs.table(connecting, \n{ columns: [\"#\",\"Время отправки\",\"Задача\",\"Участник\",\"Баллы\",\"Время выполнения\"],\n header: {\n \"№\": \"#\",\n \"Время отправки\": \"time1\",\n \"Задача\": \"tarea\",\n \"Участник\": \"student\",\n \"Баллы\": \"bal\",\n \"Время выполнения\": \"time2\",\n }, \n width: {\n \"№\": 150,\n \"Время отправки\": 120,\n \"Задача\": 200,\n \"Участник\": 150,\n \"Баллы\": 50,\n \"Время выполнения\": 100,\n },\n maxWidth: 800, sort: \"Баллы\", maxHeight: 150, reverse:false, \n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":80,"value":"## Построение и настройка диаграмм","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":82,"value":"Построим диаграмму наибольшего количества задач участниками, получившими балл = 1 среди первых 10 строк таблицы","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":92,"value":"mm = connecting.map(d => d[\"Задача\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":112,"value":"select_mm = connecting.filter((x)=> Number(x[\"Баллы\"])== 1 )","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":94,"value":"Plot.plot({\n marks: [\n Plot.barY(select_mm.slice(1,10), {x: \"Задача\", y: \"Баллы\", fill:\"red\", sort: {x: \"y\", reverse: true}}),\n Plot.ruleX([0])\n ], marginLeft: 70\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":137,"value":"сделаем фильтр по студенту","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":139,"value":"tab_st =new Set (tab_comp.map(d => d[\"Участник\"]))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"viewof select = Inputs.select(tab_st, {label: \"Укажите фамилию:\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":160,"value":"Какие задачи решил выбранный участник и с каким баллом","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":162,"value":"tab_select = tab_comp.filter( (x)=> String(x[\"Участник\"])==select)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"function select_colors(object) {\n if (object[\"Баллы\"] < 1) return \"#aa8834\"\n if (object[\"Баллы\"] == 1) return \"#889945\"\n return \"#445611\"\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":175,"value":"Plot.plot({\n marks: [\n Plot.barX(tab_select, {x: \"Баллы\", y: \"Задача\", fill:(d=>select_colors(d)), sort: {x: \"x\", reverse: true}}),\n Plot.ruleX([0, 0.5, 1])\n ],\n color: { legend: true },\n marginLeft: 200,\n margin: 10\n \n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":248,"value":"Plot.plot({\n caption: `Задачи, которые решил участник (количество: ${tab_select.length})`,\n marks: [\n Plot.rectX(tab_select, {x1:0, x2:\"Баллы\",y1:\"Задача\", fill:\"Задача\"}),\n Plot.ruleY([0, 1]),\n Plot.ruleX([0, 0.5, 1])\n ],\n color: { legend: true },\n marginLeft: 300,\n width: 800,\n height: 400\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":179,"value":"Подгрузим другую БД, для построения других диаграмм","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":181,"value":"arch_novosib_2021_new = FileAttachment(\"arch_Novosib_2021_new.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"nsk = arch_novosib_2021_new.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":186,"value":"data_temper_r = nsk.map(function (d) {\n\t return {date_b: new Date(d[\"Местное время в Новосибирске\"].substring(6,10)+\"-\"+d[\"Местное время в Новосибирске\"].substring(3,5)+\"-\"+d[\"Местное время в Новосибирске\"].substring(0,2)+\"T\"+d[\"Местное время в Новосибирске\"].substring(11,16)),\n temper: Number(d[\"T\"]), \n press: Number(d[\"P\"]) \n } \n } ).sort((a, b) => a[\"date_b\"] > b[\"date_b\"] ? 1 : -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":188,"value":"viewof table_temper = Inputs.table(data_temper_r, { sort: \"date_b\", maxHeight: 100})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"Plot.plot({\n width: 1200,\n height: 300,\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", fill:\"#88bbbb\"}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":194,"value":"Посмотрим температуру в конкретном месяце","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":196,"value":"viewof select_manth = Inputs.select(Array.from(new Array(12),(val,index)=>index + 1), {label: \"Месяц:\", width:300, value:10})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"Plot.plot({\n width: 1200,\n height: 300,\n x: {\n domain: [new Date(2020,select_manth, 1), new Date(2020, select_manth+1, 1)]\n },\n marks: [\n Plot.areaY(data_temper_r, {x: \"date_b\", y: \"temper\", fill:\"#88bbbb\"}),\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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":203,"value":"Plot.plot({\n width: 1200,\n height: 700,\n x: {\n domain: [new Date(2020,select_manth, 1), new Date(2020, select_manth+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.lineY(data_temper_r, {x: \"date_b\", y: \"temper\", strokeWidth: 0.6}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":205,"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":209,"value":"Посмотрим изменение температур для определенного времени суток.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":211,"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":213,"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:\"#93aa92\"}),\n // Plot.lineY(data_temper_r, {x: \"date_b\", y: \"temper\", strokeWidth: 0.6}),\n Plot.ruleY([0]),\n Plot.ruleX([new Date(2020, select_manth, 1)]), \n Plot.frame()\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":216,"value":"Ячеистая диаграмма","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":218,"value":"Plot.plot({\n caption:`Температурная карта для г.Новосибирска месяц:${select_manth}`,\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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":221,"value":"Представим \"температурные карты\" сразу для нескольких месяцев.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":223,"value":"Plot.plot({\n caption:`Температурная карта для г.Томска месяц:${select_manth}`,\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:[\"lightblue\", \"#D2B48C\"] }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":225,"value":"Добавим на \"температурную карту\" температуру замеров:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":227,"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","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":233,"value":"Выберем дату наблюдений в таблице 19 декабря","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":236,"value":"Plot.rectX(nsk.slice(96, 104), {x1:'T', x2:'Td', y1:'P', y2:'Po', fill:'Местное время в Новосибирске'}).plot(\n {color: {legend: true},\n width: 800,\n height: 600}\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W47","stdlib":"1"}} 46:"$45:body"