40:null 41:["$","title",null,{"children":"Катаев Дмитрий, практическая работы №2 | Dm Dm's Workspace | Observable"}] 47:[{"id":"ce12fd7933973e0a17e13c7142b3e3d9b299fc3be477cd3e82053021c63a7161db8ebe58c4a2478eb0760c74a35b481cbdc48a7df2d1a40675eaa685c6779c5a","href":"https://static.observableusercontent.com/files/ce12fd7933973e0a17e13c7142b3e3d9b299fc3be477cd3e82053021c63a7161db8ebe58c4a2478eb0760c74a35b481cbdc48a7df2d1a40675eaa685c6779c5a","name":"sport_world.csv","type":"text/csv","lastModified":1697345811208.563,"size":15029}] 45:{"id":"b9d1c84d02afcef8","slug":null,"title":"Катаев Дмитрий, практическая работы №2","thumbnail":"019a0d536bf148c75d34474b44fa8eb48fa35c0d25dd81e617be88f1a32a5f80","access_level":"public","create_time":"$D2023-10-15T04:56:51.208Z","update_time":"$D2023-10-15T10:48:30.321Z","view_time":null,"first_public_time":"$D2023-10-15T04:56:51.208Z","has_unpublished_edits":null,"fork":{"id":"dcdd7262d8ba4284","slug":null,"title":"Практическая работа №2","owner":{"id":"5f66419d05d68b0b","login":"dm-dm-ws","name":"Dm Dm's Workspace"}},"stars":0,"starred":false,"owner":{"type":"team","id":"5f66419d05d68b0b","login":"dm-dm-ws","name":"Dm Dm's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/f1dddf80f7adf600a449d4ba25a94bea6439231bd3e332811860c8fa5a5362fa","tier":"starter_2024","bio":"","following":false},"version":448,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"165b111f314153b1","login":"dm-dm","name":"Dm Dm","avatar_url":"https://avatars-next.observableusercontent.com/65215c1bdba748046abc32c2f95524a29666da2cfcd0b87a11039bb3cddcf9e6","tier":null,"bio":"","following":false}],"members":[{"type":"individual","id":"165b111f314153b1","login":"dm-dm","name":"Dm Dm","avatar_url":"https://avatars-next.observableusercontent.com/65215c1bdba748046abc32c2f95524a29666da2cfcd0b87a11039bb3cddcf9e6","tier":null,"role":"editor"},{"type":"team","id":"5f66419d05d68b0b","login":"dm-dm-ws","name":"Dm Dm's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/f1dddf80f7adf600a449d4ba25a94bea6439231bd3e332811860c8fa5a5362fa","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":"Катаев Дмитрий, практическая работы №2","cells":[{"id":4,"value":"# Катаев Дмитрий, практическая работы №2\n\nUsing [Inputs.search](https://github.com/observablehq/inputs/blob/main/README.md#search) and [Inputs.table](https://github.com/observablehq/inputs/blob/main/README.md#table). Data from CDPH.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"sport_world_data = FileAttachment(\"sport_world.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"viewof search = Inputs.search(sport_world_data)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":424,"value":"Inputs.table(search, {\n format: {\n Year: d3.format(\"d\") \n }\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"\"Всего записей о соревнованиях: \" +`${sport_world_data.length}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"Вывод столбцов \"Наименование соревнования\", \"Место проведения\", \"Ориентировочное число участников\" изменили названия столбцов и порядок","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":34,"value":"viewof table1 = Inputs.table(sport_world_data, {\n columns: [\n \"Наименование соревнования\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n \n ],\n header: {\n \"Наименование соревнования\": \"Vidsport\",\n \"Место проведения\": \"Mesto\",\n \"Ориентировочное число участников\": \"Count\"\n }, \n sort: \"Ориентировочное число участников\", reverse:true, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":91,"value":"table1","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":185,"value":"\n \n \n \n \n \n \n \n \n ${table1.map(d => htl.html`\n \n \n \n `)}\n \n

Naimenovanie	Mesto	Count
${d[\"Наименование соревнования\"]}	${d[\"Место проведения\"]}	${d[\"Сроки проведения\"]}

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":50,"value":"\nPlot.plot({\n marks: [\n Plot.barX(table1, {x: \"count\", y: \"mesto\", fill: \"#345678\", sort: {x: \"x\", reverse: true}}),\n Plot.ruleY([0]),\n Plot.ruleX([0, 200000]),\n ], marginLeft: 250\n\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":294,"value":"Изменим таблицу, выведем данные \"Место\", Наименование\" , \"к-во участников\", ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":179,"value":"viewof table2 = Inputs.table(sport_world_data, {\n columns: [\n \"Место проведения\",\n \"Наименование соревнования\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Наименование соревнования\": \"Наименование\",\n \"Место проведения\": \"Место\",\n \"Ориентировочное число участников\": \"к-во участников\"}, \n \n width: {\n \"Наименование соревнования\": 1400,\n \"Место проведения\": 170,\n \"Ориентировочное число участников\": 150\n },\n \n align: {\n \"Наименование соревнования\": \"left\",\n \"Место проведения\": \"left\",\n \"Ориентировочное число участников\": \"left\"\n },\n rows: 80, maxWidth: 1800, maxHeight: 400, sort: \"Ориентировочное число участников\", reverse:true, required: false})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":243,"value":"Построение фильтров для табличных данных на основе инструментов: select (multy), text, range;\n\nНайдем в каких городах в какие строки(месяц) пройдут соревнования","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":245,"value":"viewof text = Inputs.text({label: \"Введите месяц:\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"search_month = sport_world_data.filter( (m)=> String(m[\"Сроки проведения\"]).indexOf(text.trim()) > -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":258,"value":"function new_creat_table(name1,name2){\n return Inputs.table(search_month, {\n columns: [\n name1,\n name2,],\n header: {\n name1: name1,\n name2: name2,\n }, \n rows: 60, maxWidth: 600, sort: \"name3\", maxHeight: 200, reverse:true, required: false})\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":261,"value":"new_creat_table(\"Сроки проведения\",\"Место проведения\", search_month)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":287,"value":"\n \n \n \n \n \n \n \n \n ${sport_city2.map(spcity => htl.html`\n \n \n \n `)}\n \n

Сроки проведения	Наименование соревнования	Число участников
${spcity[\"Сроки проведения\"]}	${spcity[\"Наименование соревнования\"]}	${spcity[\"Ориентировочное число участников\"]}

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":303,"value":"Вывод таблицы для конкретного города (выбранного) или нескольких городов","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":307,"value":"regions = sport_world_data.map(d => d[\"Место проведения\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"viewof select_mult = Inputs.select(regions, {label: \"Укажите город:\", multiple: true, width:400})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":310,"value":"Inputs.table(sport_world_data.filter((x)=>select_mult.includes(String(x[\"Место проведения\"]) ) ), \n {\n columns: [\n \"Сроки проведения\",\n \"Наименование соревнования\",\n \"Ориентировочное число участников\"\n ],\n header: {\n \"Сроки проведения\": \"месяц\",\n \"Наименование соревнования\": \"вид спрота\",\n \"Ориентировочное число участников\": \"к-во участников\"}, \n \n width: {\n \"Сроки проведения\": 50,\n \"Наименование соревнования\": 400,\n \"Ориентировочное число участников\": 100\n },\n rows: 60, maxWidth: 1000, sort: \"всего 2021\", maxHeight: 400, reverse:true, required: false}) ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":329,"value":"!!!!! Задание Придумать другой способ без построения массива.\nИспользуем Math","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":334,"value":"m = sport_world_data.map( (x)=> Number(x[\"Ориентировочное число участников\"])).sort((a,b)=>(a-b))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":332,"value":"viewof range_A = Inputs.range([Math.min.apply(null,m), Math.max.apply(null,m)], {label: \"К-во участников от:\", value:Math.min.apply(null,m), step: 10, width: 300})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":342,"value":"viewof range_B = Inputs.range([range_A, Math.max.apply(null,m)], {label: \"К-во участников до:\", value: Math.max.apply(null,m), step: 10, width: 300})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"!!!!! Задание Показать с помощью bar-объекта (canvas) количество субъектов, отфильтрованных по количеству участников","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":348,"value":"canvas = {\n var width = 800;\n var height = 30;\n var max_count = sport_world_data.length;\n const context = DOM.context2d(width, height);\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n context.fillRect(range_A*(width/Math.max.apply(null,m)), 0, range_B*(width/Math.max.apply(null,m)), height);\n context.canvas.style.background = \"hsl(216deg 100% 90%)\";\n return context.canvas;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":367,"value":"sport_world_data.columns","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"s_w_mult = sport_world_data.filter( (x)=> Number(x[\"Ориентировочное число участников\"]) >= range_A && Number(x[\"Ориентировочное число участников\"])<= range_B)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"Данные в табличном виде, которые удовлетворяют выбранному диапазону","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":372,"value":"Inputs.table(s_w_mult)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":389,"value":"Построим диаграмму субъектов, отфильтрованных по условию","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":416,"value":"Соревнования в Санкт-Петербурге","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":402,"value":"piter_sport = sport_world_data.filter((x)=> String(x[\"Место проведения\"]).indexOf(\"Санкт-Петербург\") > -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"viewof table = Inputs.table(piter_sport)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":390,"value":"Plot.plot({\n width:1000,\n marks: [\n Plot.barY(piter_sport, {y: \"Ориентировочное число участников\", x: \"Наименование соревнования\", fill: \"Сроки проведения\", sort: {x: \"y\", reverse: true}}),\n Plot.ruleX([0]),\n Plot.ruleY([0, 1600]),\n ], color: { legend: true },\n marginLeft: 50\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"