41:null 42:["$","title",null,{"children":"Работа с диаграммами | dmitry | Observable"}] 48:[{"id":"ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","href":"https://static.observableusercontent.com/files/ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","name":"arch_Novosib_2021_new.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1685256375890.941,"size":324115},{"id":"44f9ef8bb2f7e4c0a7855aaf0be3d88c507c8fade828c1b31d204c4788f66b68cf25c617cab872f6123961bfb2bd8d81c20d12d11a6d4807d564c0f3f1a29b82","href":"https://static.observableusercontent.com/files/44f9ef8bb2f7e4c0a7855aaf0be3d88c507c8fade828c1b31d204c4788f66b68cf25c617cab872f6123961bfb2bd8d81c20d12d11a6d4807d564c0f3f1a29b82","name":"arch_Novosib_2021.csv","type":"text/csv","lastModified":1685259063910.445,"size":1143457},{"id":"a001cdcb80e00d6336b315921e457dde00f0b4a94cb9455f5a9f47701c60d38cf1f02d3c27d2b5ba4b827e450bf24465d1ea697cb64fb1a1ab0bb127173ed571","href":"https://static.observableusercontent.com/files/a001cdcb80e00d6336b315921e457dde00f0b4a94cb9455f5a9f47701c60d38cf1f02d3c27d2b5ba4b827e450bf24465d1ea697cb64fb1a1ab0bb127173ed571","name":"arch_Novosib_2021_s.csv","type":"text/csv","lastModified":1685260109822.713,"size":1886699},{"id":"3582ff52edd24b8a847f9df27b1d422131ee516f7130d2c704be9df10c444787ea9b80daad6c7be1a9cfdf4f6afc91151359992a62d16e79687d907a2c3cd905","href":"https://static.observableusercontent.com/files/3582ff52edd24b8a847f9df27b1d422131ee516f7130d2c704be9df10c444787ea9b80daad6c7be1a9cfdf4f6afc91151359992a62d16e79687d907a2c3cd905","name":"population-by-age.csv","type":"text/csv","lastModified":1685384667472.66,"size":273},{"id":"ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","href":"https://static.observableusercontent.com/files/ebd41440d796001de3b6d5659ac0149617e38a88b686317213343580a6bc04cdc875d156b0cee341b6edeef04725c4fe79ea0240c4480fb2bb7e022272efab1d","name":"arch_Novosib_2021_new@1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1685260765785.8,"size":324115},{"id":"ed30b2cca8002c2ce12ba282408a5a9119548c98ad2ee501ac0222067a00d5282f916bb72c61980eeede04440737e267dbbba550521b7558d320bc99c42516f4","href":"https://static.observableusercontent.com/files/ed30b2cca8002c2ce12ba282408a5a9119548c98ad2ee501ac0222067a00d5282f916bb72c61980eeede04440737e267dbbba550521b7558d320bc99c42516f4","name":"Tomsk_temper.csv","type":"text/csv","lastModified":1685344540176.623,"size":597551}] 46:{"id":"2d9370c324357dc5","slug":"practica_3","title":"Работа с диаграммами ","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-05-28T06:44:17.191Z","update_time":"$D2023-05-30T14:31:58.572Z","view_time":null,"first_public_time":"$D2023-05-28T06:44:17.191Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"9b345b92aa532c92","login":"dmitry79","name":"dmitry","avatar_url":"https://avatars-next.observableusercontent.com/8ccecd1f73f443ec42ecce2443f36eedf8bbdbb041762eb1cdbb4db9583cd4af","tier":"starter_2024","bio":"","following":false},"version":548,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"20cf718d23328cbc","login":"dmitry79","name":"dmitry","avatar_url":"https://avatars-next.observableusercontent.com/8ccecd1f73f443ec42ecce2443f36eedf8bbdbb041762eb1cdbb4db9583cd4af","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"20cf718d23328cbc","login":"dmitry79","name":"dmitry","avatar_url":"https://avatars-next.observableusercontent.com/8ccecd1f73f443ec42ecce2443f36eedf8bbdbb041762eb1cdbb4db9583cd4af","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Работа с диаграммами ","cells":[{"id":0,"value":"## Лаболаторная работа 3. выполнил студент группы 4.206М-3 Хомяков Д.Г. \n# Работа с диаграммами ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":22,"value":"data_f = 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":26,"value":"data = data_f.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":31,"value":"`названия столбцов:[${data.columns}]\\n количество строк: ${data.length}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"viewof table_data = Inputs.table(data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":110,"value":"data_temper_r = data.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)\n ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":114,"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":57,"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.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":199,"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":82,"value":"#------------------------------------------------------","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":142,"value":"temperMap = new Map();\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"data_temper_r.forEach(d => {\n let month_year = `${d.date_b.getFullYear()}-${(d.date_b.getMonth()+1).toString().padStart(2, '0')}`; // Получаем месяц и год\n let temperData = temperMap.get(month_year) || {count: 0, sum: 0}; // Получаем данные для этого месяца, или начинаем с {count: 0, sum: 0}\n \n \n if(!isNaN(d.temper)) { // проверка на отсутсвующие значения (NaN)\n temperData.count++;\n temperData.sum += d.temper;\n } \n temperMap.set(month_year, temperData); // Обновляем данные в Map\n \n});\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":168,"value":"avg_temper_per_month_array = Array.from(temperMap.entries()).map(([month_year, temperData]) => ({\n date: new Date(month_year+'-01'),\n avg_temp: temperData.sum / temperData.count\n}));\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":529,"value":"## Построим столбчатую диаграмму отображающую среднемясячную температуру","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":155,"value":"// Создаем график\nPlot.plot({\n x: {\n tickFormat: d3.timeFormat(\"%Y-%m\"), // Формат даты\n label: \"Дата\"\n },\n y: {\n label: \"Средняя температура по месяцам\"\n },\n marks: [\n Plot.barY(avg_temper_per_month_array, {\n x: \"date\", \n y: \"avg_temp\", \n fill: (d) => d.avg_temp >= 0 ? \"#FF0000\" : \"#0000FF\" // Условие для заполнения столбцов\n })\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":183,"value":"#------------------------------------------------------","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":464,"value":"pressMap = new Map();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":466,"value":"data_temper_r.forEach(d => {\n let month_year = `${d.date_b.getFullYear()}-${(d.date_b.getMonth()+1).toString().padStart(2, '0')}`; // Получаем месяц и год\n let pressData = pressMap.get(month_year) || {count: 0, sum: 0}; // Получаем данные для этого месяца, или начинаем с {count: 0, sum: 0}\n \n \n if(!isNaN(d.press)) { // проверка на отсутсвующие значения (NaN)\n pressData.count++;\n pressData.sum += d.press;\n } \n pressMap.set(month_year, pressData); // Обновляем данные в Map\n \n});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":468,"value":"avg_press_per_month_array = Array.from(pressMap.entries()).map(([month_year, pressData]) => ({\n date: new Date(month_year+'-01'),\n avg_press: pressData.sum / pressData.count\n}));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":531,"value":"## Горизонтальная столбчатая диаграмма с средним атмосферным давлением по месяцам ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":430,"value":"Plot.barX(avg_press_per_month_array.slice(0,17), {x: \"avg_press\", y: \"date\", fill:\"#23af99\"}).plot({caption: `Среднее давление по месяцам`}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":271,"value":"## Температурная карта по часам в день за выбранный месяц","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":181,"value":"viewof select_month = Inputs.select(Array.from(new Array(12),(val,index)=>index + 1), {label: \"Месяц:\", width:300, value:6})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":195,"value":"monthFilteredData = data_temper_r.filter(d => d[\"date_b\"].getMonth() + 1 === select_month);","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"Plot.plot({\n caption:`Температурная карта для г.Новосибирска месяц: ${select_month}`,\n marks: [\n Plot.cell(monthFilteredData, { 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":215,"value":"## использование метода faset для отображения температурных карт по месяцам за год","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":486,"value":"Plot.plot({\n caption:`Температурная карта для г.Новосибирска за целый год`,\n facet: {\n data: data_temper_r,\n y: (d=>d[\"date_b\"].getMonth()+1),\n margin: 10\n },\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":542,"value":"## Создадим массив данных состоящий из: названия кампаниb, объема торгов акциями кампании, мин и макс цена акции во время торгов.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":494,"value":"data_a = [\n {\n \"company\": \"Company A\",\n \"trade_volume\": 3000,\n \"min_price\": 25,\n \"max_price\": 47\n },\n {\n \"company\": \"Company B\",\n \"trade_volume\": 4200,\n \"min_price\": 30,\n \"max_price\": 42\n },\n {\n \"company\": \"Company C\",\n \"trade_volume\": 2500,\n \"min_price\": 45,\n \"max_price\": 49\n },\n {\n \"company\": \"Company E\",\n \"trade_volume\": 4000,\n \"min_price\": 32,\n \"max_price\": 44\n },\n {\n \"company\": \"Ccompany D\",\n \"trade_volume\": 1000,\n \"min_price\": 27,\n \"max_price\": 41\n }\n \n]\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":522,"value":"## построим диаграмму из прямоугольников, где длинна прямоугольника (по оси х) - объем торгов акциями кампании, ширина прямоугольника (ось y) ограничена минимальной и максимальной ценой акции.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":496,"value":"Plot.rectX(data_a, {x1:0, x2:\"trade_volume\", y1:\"min_price\", y2:\"max_price\", fill:\"company\"}).plot\n (\n {color: { legend: true },\n margin: 30,\n width: 800 ,\n height: 550,\n marks: [Plot.ruleY([20, 50])]\n }\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W48","stdlib":"1"}} 47:"$46:body"