29:null 2a:["$","title",null,{"children":"Лабараторная 3 | Настя Чуракова | Observable"}] 30:[{"id":"14dd00cf171d6f01800aad31404c8756ae40817f070b6bc911ff2d2d91a5cd4383ee5c090c9cf8dc2d726a02f6a9cb835a47f042060a21e6da00177b4feb0214","href":"https://static.observableusercontent.com/files/14dd00cf171d6f01800aad31404c8756ae40817f070b6bc911ff2d2d91a5cd4383ee5c090c9cf8dc2d726a02f6a9cb835a47f042060a21e6da00177b4feb0214","name":"comp_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1666109035384.074,"size":16545},{"id":"4c530ebd7806f9dd1edc8e33a094f7373811c91a4da5896d1be772ccee2fc7623bb4f83827c8b317fc62bde08c83ba7a83b0a1a662dbc47b2eb50af0a83c8e8b","href":"https://static.observableusercontent.com/files/4c530ebd7806f9dd1edc8e33a094f7373811c91a4da5896d1be772ccee2fc7623bb4f83827c8b317fc62bde08c83ba7a83b0a1a662dbc47b2eb50af0a83c8e8b","name":"arch_Novosib_2021_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1666109036061.432,"size":324115}] 2d:{"id":"3ef70ddcfd48fbd5","slug":"lab3","title":"Лабараторная 3","thumbnail":"683dcd2a496091d34071561074fdc3b65709f86ffc289e894e0cb49d49c2a23a","access_level":"public","create_time":"$D2022-10-18T16:02:10.724Z","update_time":"$D2022-10-31T16:26:09.529Z","view_time":null,"first_public_time":"$D2022-10-31T16:27:08.865Z","fork":false,"stars":1,"starred":false,"owner":{"type":"team","id":"81806ebe8d4d80aa","login":"churakova","name":"Настя Чуракова","avatar_url":"https://avatars-next.observableusercontent.com/43cee295b9870a92f238cbfbf7e156280aa0c1fba7bb93e9ab923a56ebabc81f","tier":"starter_2024"},"version":740,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"95d4ece4bb2d6e0c","login":"churakova","name":"Настя Чуракова","avatar_url":"https://avatars-next.observableusercontent.com/43cee295b9870a92f238cbfbf7e156280aa0c1fba7bb93e9ab923a56ebabc81f","tier":null}],"members":[{"type":"individual","id":"95d4ece4bb2d6e0c","login":"churakova","name":"Настя Чуракова","avatar_url":"https://avatars-next.observableusercontent.com/43cee295b9870a92f238cbfbf7e156280aa0c1fba7bb93e9ab923a56ebabc81f","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"title":"Лабараторная 3","cells":[{"id":0,"value":"# Лабараторная 3","pinned":true,"hidden":false,"mode":"md"},{"id":5,"value":"Для предоставленных данных в новом notebook-e: \n\n1) Cоздать 5 видов диаграмм, используя метки barX, BarY, area, rect, cell) - задачи для визуализации придумать самостоятельно (написать задачу)\n\n2) Для двух диаграмм из задания выше показать способы разделения данных на группы (facet или канал z) \n\n3) В настройках диаграммы должны использоваться параметры: grid, color, margin, domain, curve, caption и другие.","pinned":false,"hidden":false,"mode":"md"},{"id":7,"value":"arch_Novosib_2021_new = FileAttachment(\"arch_Novosib_2021_new.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":9,"value":"comp_new = FileAttachment(\"comp_new.xlsx\").xlsx()","pinned":true,"hidden":false,"mode":"ojs"},{"id":11,"value":"data_Novosib = arch_Novosib_2021_new.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":15,"value":"data_comp_new = comp_new.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":18,"value":"data_Novosib.columns","pinned":true,"hidden":false,"mode":"ojs"},{"id":21,"value":"data_comp_new.columns","pinned":true,"hidden":false,"mode":"ojs"},{"id":24,"value":"viewof table1 = Inputs.table(data_Novosib,{maxHeight: 100})","pinned":true,"hidden":false,"mode":"ojs"},{"id":27,"value":"viewof table2 = Inputs.table(data_comp_new,{maxHeight: 100})","pinned":true,"hidden":false,"mode":"ojs"},{"id":566,"value":"Столбчатая диаграмма с температурой 27.12.2020 - 31.12.2020 числах с атмосферным давлением ","pinned":false,"hidden":false,"mode":"md"},{"id":463,"value":"function select_colors_r1(object) {\n if (object[\"N\"] ==\"100%.\") return \"#4488bb\" //прирост\n else return \"#88aabb\"\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":458,"value":"Plot.plot({\n \n marks: [\n Plot.barX(data_Novosib.slice(0,40), {x: \"T\", y: \"Местное время в Новосибирске\", fill:(d=>select_colors_r1(d)), sort: {x: \"y\", reverse: true}}),\n Plot.text(data_Novosib.slice(0,40), {x: \"T\", y: \"Местное время в Новосибирске\", dx: 20,text: d=>d[\"Po\"]}), \n //Plot.ruleX([0, 500, 1000])\n ],\n color: { legend: true },\n marginLeft: 230,\n marginRight: 80\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":737,"value":"Диаграмма распеделения баллов по задачам","pinned":false,"hidden":false,"mode":"md"},{"id":709,"value":"Plot.plot({\n marks: [\n Plot.barY(data_comp_new, {y: \"Баллы\", x: (d=>zzzadach(d)), fill:\"Баллы\", sort: {x: \"y\", reverse: true}}),\n //Plot.ruleX([0, 1800, 2000])\n ],\n color: { legend: true },\n marginLeft: 0\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":739,"value":"Граффик rect температуры воды (по Y) - точки росы (по X) за первые 5 месяцев","pinned":false,"hidden":false,"mode":"md"},{"id":617,"value":"\ndata_minmax = {\n ///Ff T\n var min =100;\n var max =-100;\n var minFf =100;\n var maxFf =-100;\n var l = [];\n for (var mesh = 1; mesh < 6; mesh++) {\n for (var i = 0; i < 2927; i++) {\n if (mesh<13){\n if (Number(data_Novosib[i][\"Местное время в Новосибирске\"].substring(3,5)) == mesh){\n if (min>data_Novosib[i][\"T\"]){min =data_Novosib[i][\"T\"]}\n if (maxdata_Novosib[i][\"Td\"]){minFf =data_Novosib[i][\"Td\"]}\n if (maxFf a[\"data\"] > b[\"data\"] ? 1 : -1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":89,"value":"\nfunction time_zone(object) {\n if (5<=object[\"data\"].getHours() && object[\"data\"].getHours() < 10) return \"утро\"\n if (10<=object[\"data\"].getHours() && object[\"data\"].getHours() < 18) return \"день\"\n if (18<=object[\"data\"].getHours()&& object[\"data\"].getHours() < 22) return \"вечер\" \n return \"ночь\"\n}\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":683,"value":"viewof range_A = Inputs.range([0, 12], {label: \"Месяц от :\", value:0, step: 1, width: 300})","pinned":true,"hidden":false,"mode":"ojs"},{"id":688,"value":"viewof range_B = Inputs.range([range_A, 12], {label: \"до:\", value: 12, step: 1, width: 300})","pinned":true,"hidden":false,"mode":"ojs"},{"id":648,"value":"\nPlot.plot({\n caption:`Температурная карта c заданнми месяцами`,\n grid : true,\n facet: {\n data: data_m,\n y: (d=> time_zoneV(d,range_A,range_B)),\n margin: 50\n },\n marks: [\n Plot.cell(data_m, { x: d => d[\"data\"].getDate(), y: d => d[\"data\"].getHours(), fill: \"temper\"}),\n Plot.ruleY([0,23]),\n Plot.ruleX([0]), \n ],\n color: { legend: true }\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":668,"value":"function time_zoneV(object,range_A,range_B) {\n if (object[\"data\"].getMonth() <= range_B) {\n if (object[\"data\"].getMonth() >= range_A) return object[\"data\"].getMonth()\n else return range_B\n }\n else return range_B\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":126,"value":"Используя канал z отобразим температуру днем и ночью за определенный месяц","pinned":false,"hidden":false,"mode":"md"},{"id":41,"value":"viewof select_manth = Inputs.select(Array.from(new Array(12),(val,index)=>index + 1), {label: \"Месяц:\", width:300, value:5})","pinned":true,"hidden":false,"mode":"ojs"},{"id":111,"value":"Plot.plot({\n width: 1200,\n height: 300,\n grid : true,\n x: {\n domain: [new Date(2020,select_manth, 1), new Date(2020, select_manth+1, 1)]\n },\n marks: [\n Plot.areaY(data_m, {x: \"data\", y: \"temper\", z:(d=>time_area(d)), curve : \"cardinal\", fillOpacity: 0.4, fill:\"temper\"}),\n // Plot.lineY(data_m, {x: \"data\", y: \"temper\", strokeWidth: 0.6}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":363,"value":"function time_area(object) {\n if (object[\"data\"].getHours() > 10 && object[\"data\"].getHours()<=20) return 1 \n else return 2\n}","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}} 2e:"$2d:body"