28:null 29:["$","title",null,{"children":"Lab2 | Кононенко Дмитрий | Observable"}] 2f:[{"id":"ce12fd7933973e0a17e13c7142b3e3d9b299fc3be477cd3e82053021c63a7161db8ebe58c4a2478eb0760c74a35b481cbdc48a7df2d1a40675eaa685c6779c5a","href":"https://static.observableusercontent.com/files/ce12fd7933973e0a17e13c7142b3e3d9b299fc3be477cd3e82053021c63a7161db8ebe58c4a2478eb0760c74a35b481cbdc48a7df2d1a40675eaa685c6779c5a","name":"sport_world.csv","type":"text/csv","lastModified":1697177356153.159,"size":15029}] 2c:{"id":"0efa753a83aab262","slug":null,"title":"Lab2","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-10-13T06:03:32.182Z","update_time":"$D2023-10-30T16:10:29.824Z","view_time":null,"first_public_time":"$D2023-10-13T06:03:32.182Z","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":147,"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":1,"collection":null,"type":"notebook","body":{"title":"Lab2","cells":[{"id":0,"value":"# Lab2","pinned":false,"hidden":false,"mode":"md"},{"id":9,"value":"sport_data= FileAttachment(\"sport_world.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":11,"value":"viewof table = Inputs.table(sport_data)","pinned":true,"hidden":false,"mode":"ojs"},{"id":13,"value":"\"Всего записей в таблице районов Алтайского края:\"+`${sport_data.length}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":15,"value":"viewof table1 = Inputs.table(sport_data, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\"\n ],\n header: {\n \"Наименование соревнования\": \"Sorevnovania\",\n \"Сроки проведения\": \"месяц\",\n \"Место проведения\": \"город\"}, \n sort: \"Место проведения\", reverse:true, required: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":18,"value":"data = table1","pinned":true,"hidden":false,"mode":"ojs"},{"id":27,"value":"\n \n \n \n \n \n \n \n \n ${table1.map(d => htl.html`\n \n \n \n `)}\n \n

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

","pinned":false,"hidden":false,"mode":"html"},{"id":23,"value":"Plot.plot({\n marks: [\n Plot.barX(table1, {x: \"Ориентировочное число участников\", y: \"Наименование соревнования\", fill: \"#345678\", sort: {x: \"x\", reverse: true}}),\n Plot.ruleY([0]),\n Plot.ruleX([0, 1600]),\n ], marginLeft: 250\n\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":36,"value":"viewof table2 = Inputs.table(sport_data, {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\"\n ],\n header: {\n \"Наименование соревнования\": \"Sorevn\",\n \"Сроки проведения\": \"Vremya\",\n \"Место проведения\": \"Mesto\"}, \n \n width: {\n \"Наименование соревнования\": 250,\n \"Сроки проведения\": 100,\n \"Место проведения\": 100\n },\n align: {\n \"Наименование соревнования\": \"left\",\n \"Сроки проведения\": \"center\",\n \"Место проведения\": \"right\"\n },\n maxWidth: 600, sort: \"всего 2021\", maxHeight: 300, reverse:true, required: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":43,"value":"{var a = sport_data.filter( (x)=> x[\"Сроки проведения\"] == \"июнь\" && x[\"Ориентировочное число участников\"] > 300);\n return `Количество таких соревнований ${a.length}, всего соревнований ${sport_data.length}`;}","pinned":true,"hidden":false,"mode":"ojs"},{"id":53,"value":"viewof text = Inputs.text({label: \"Сроки проведения\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":56,"value":"sport_data_by_search = sport_data.filter( (x)=> String(x[\"Место проведения\"]).indexOf(text.trim())> -1)","pinned":true,"hidden":false,"mode":"ojs"},{"id":60,"value":"Inputs.table(sport_data_by_search, \n {\n columns: [\n \"Наименование соревнования\",\n \"Сроки проведения\",\n \"Место проведения\"\n ], \n width: {\n \"Наименование соревнования\": 250,\n \"Сроки проведения\": 100,\n \"Место проведения\": 100\n },\n sort: \"Место проведения\", maxHeight: 150, maxWidth: 550, reverse:true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":73,"value":"goroda = new Set(sport_data.map(d => d[\"Место проведения\"]))","pinned":true,"hidden":false,"mode":"ojs"},{"id":76,"value":"viewof select = Inputs.select(goroda, {label: \"Укажите город:\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":78,"value":"`Выбранный город: ${select}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":80,"value":"sport_data_short = sport_data.filter( (x)=> String(x[\"Место проведения\"])==select)","pinned":true,"hidden":false,"mode":"ojs"},{"id":83,"value":"Inputs.table(sport_data_short, \n {\n columns: [\n \"Место проведения\",\n \"Сроки проведения\",\n \"Наименование соревнования\"\n ],\n header: {\n \"Место проведения\": \"Mesto\",\n \"Сроки проведения\": \"Sroki\",\n \"Наименование соревнования\": \"Sorevn\"}, \n \n width: {\n \"Место проведения\": 250,\n \"Сроки проведения\": 100,\n \"Наименование соревнования\": 100\n },\n rows: 60, maxWidth: 600, sort: \"всего 2021\", maxHeight: 400, reverse:true, required: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":91,"value":"viewof select_mult = Inputs.select(goroda, {label: \"Укажите города:\", multiple: true, width:300})","pinned":true,"hidden":false,"mode":"ojs"},{"id":93,"value":"Inputs.table(sport_data.filter((x)=>select_mult.includes(String(x[\"Место проведения\"]) ) ),\n {\n columns: [\n \"Место проведения\",\n \"Сроки проведения\",\n \"Наименование соревнования\"\n ],\n header: {\n \"Место проведения\": \"Mesto\",\n \"Сроки проведения\": \"Sroki\",\n \"Наименование соревнования\": \"Sorevn\"}, \n \n width: {\n \"Место проведения\": 250,\n \"Сроки проведения\": 100,\n \"Наименование соревнования\": 100\n },\n rows: 60, maxWidth: 600, sort: \"всего 2021\", maxHeight: 400, reverse:true, required: false})","pinned":false,"hidden":false,"mode":"ojs"},{"id":100,"value":"m = sport_data.map( (x)=> Number(x[\"Ориентировочное число участников\"])).sort((a,b)=>(a-b))","pinned":true,"hidden":false,"mode":"ojs"},{"id":102,"value":"function max_min() {\n var arr = sport_data.map( (x)=> Number(x[\"Ориентировочное число участников\"])).sort((a,b)=>(a-b));\n return [arr[0], arr[arr.length-1]];\n} ","pinned":true,"hidden":false,"mode":"ojs"},{"id":104,"value":"arr_max_min = max_min()","pinned":true,"hidden":false,"mode":"ojs"},{"id":107,"value":"`результат: минимальное - ${arr_max_min[0]}, максимальное - ${arr_max_min[1]}`","pinned":true,"hidden":false,"mode":"ojs"},{"id":126,"value":"min_value = Math.min.apply(null, m)","pinned":true,"hidden":false,"mode":"ojs"},{"id":128,"value":"max_value = Math.max.apply(null, m)","pinned":true,"hidden":false,"mode":"ojs"},{"id":109,"value":"max_count = sport_data.length","pinned":true,"hidden":false,"mode":"ojs"},{"id":111,"value":"width = 700","pinned":true,"hidden":false,"mode":"ojs"},{"id":113,"value":"height = 50","pinned":true,"hidden":false,"mode":"ojs"},{"id":124,"value":"viewof range_A = Inputs.range([min_value, max_value, {label: \"Население от:\", value:min_value, step: 10, width: 400}])","pinned":true,"hidden":false,"mode":"ojs"},{"id":130,"value":"viewof range_B = Inputs.range([range_A, max_value, {label: \"до:\", value: max_value, step: 10, width: 400}])","pinned":true,"hidden":false,"mode":"ojs"},{"id":132,"value":"viewof count = Inputs.range([0, max_value], {label: \"Количество участников\", step: 1, width: 300})","pinned":true,"hidden":false,"mode":"ojs"},{"id":146,"value":"canvas = {\n const context = DOM.context2d(width, height);\n context.fillStyle = \"hsl(216deg 100% 13%)\";\n context.fillRect(0, 0, count*(width/max_count), height);\n context.canvas.style.background = \"hsl(216deg 25% 90%)\";\n return context.canvas;\n}","pinned":true,"hidden":false,"mode":"ojs"},{"id":134,"value":"Inputs.table(sport_data.filter( (x)=> Number(x[\"Ориентировочное число участников\"]) >= range_A && Number(x[\"Ориентировочное число участников\"])<= range_B), \n {\n columns: [\n \"Наименование соревнования\",\n \"Место проведения\",\n \"Ориентировочное число участников\"\n ], \n width: {\n \"Наименование соревнования\": 250,\n \"Место проведения\": 100,\n \"Ориентировочное число участников\": 100\n },\n sort: \"всего 2021\", maxHeight: 150, maxWidth: 700, reverse:true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":136,"value":"Plot.plot({\n width:1000,\n marks: [\n Plot.barY(sport_data_mult, {y: \"Ориентировочное число участников\", x: \"Наименование соревнования\", fill: \"#341678\", sort: {x: \"y\", reverse: true}}),\n Plot.ruleX([0]),\n Plot.ruleY(1500),\n ], marginLeft: 50\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":119,"value":"sport_data.columns","pinned":true,"hidden":false,"mode":"ojs"},{"id":121,"value":"sport_data_mult = sport_data.filter( (x)=> Number(x[\"Ориентировочное число участников\"]) >= range_A && Number(x[\"Ориентировочное число участников\"])<= range_B)","pinned":true,"hidden":false,"mode":"ojs"},{"id":8,"value":"sport_world = await FileAttachment(\"sport_world.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"