27:null 28:["$","title",null,{"children":"Численность населения Забайкальского края по возрастным группам | elizaveta's Workspace | Observable"}] 2d:T488,Plot.plot({ width: 1200, height: 500, grid: true, x: { label: "Год →" }, marks: [ //Plot.lineY(test_bd.filter(d=>d["age_group"]==80), {x: "years", y: "population", stroke: "#20B2AA"}), Plot.lineY(test_bd.filter(d=>d["age_group"]==80), Plot.groupX({y: "sum", text: "sum"}, {y: "population", x: "years", stroke:"#20B2AA"})), //Plot.lineY(alt_bd.filter(d=>d["age_group"]==80), {y: "population", x:"years", stroke:"#4682B4"}), Plot.lineY(alt_bd.filter(d=>d["age_group"]==80), Plot.groupX({y: "sum", text: "sum"}, {y: "population", x: "years", stroke:"#4682B4"})), Plot.text(alt_bd.filter(d=>d["age_group"]==80), Plot.groupX({y: "sum", text: "sum"}, {y: "population", x: "years", fill: "black" , dy:-15, text: d=>d["population"]})), Plot.text(test_bd.filter(d=>d["age_group"]==80), Plot.groupX({y: "sum", text: "sum"}, {y: "population", x: "years", fill: "black" , dy:-15, text: d=>d["population"]})), Plot.ruleY([0]), ], color: {legend: true} })2e:[{"id":"c50be67ea244e13fb86a75ed55696ec4b58a55d836d828ee7247bff2593f95839837eb8e49d7eee32e53c9df92c49151c2f3aa9c19d35df3e8704734bba48ef2","href":"https://static.observableusercontent.com/files/c50be67ea244e13fb86a75ed55696ec4b58a55d836d828ee7247bff2593f95839837eb8e49d7eee32e53c9df92c49151c2f3aa9c19d35df3e8704734bba48ef2","name":"test1.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702963399702.439,"size":85106},{"id":"f8280ee1217af24b83ab7f9e657a597b5b382169adeb9738e5b7154f67cad865583f867e6ca9a0fc5ecc043ab55920ca2c5259e49d550b4778e0f4876d976f44","href":"https://static.observableusercontent.com/files/f8280ee1217af24b83ab7f9e657a597b5b382169adeb9738e5b7154f67cad865583f867e6ca9a0fc5ecc043ab55920ca2c5259e49d550b4778e0f4876d976f44","name":"test11.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702967983100.653,"size":84998},{"id":"c00ce7415abad0e233133e4f5c41383a14cba2399c5b371418b0da858c1dcc6161797eac21237729ef8859787f8ccefa64c2d7cb20abef4f827f8a99f714c59d","href":"https://static.observableusercontent.com/files/c00ce7415abad0e233133e4f5c41383a14cba2399c5b371418b0da858c1dcc6161797eac21237729ef8859787f8ccefa64c2d7cb20abef4f827f8a99f714c59d","name":"test111.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702968132579.895,"size":84985},{"id":"c818b1dcad165f114726e7e60e8e550fc61977b1f8e3d2a415636eff5d3dd5d2ea2ade56f4a0a8a60308e95d104b913548704c2764962124744d51c7d1b12b75","href":"https://static.observableusercontent.com/files/c818b1dcad165f114726e7e60e8e550fc61977b1f8e3d2a415636eff5d3dd5d2ea2ade56f4a0a8a60308e95d104b913548704c2764962124744d51c7d1b12b75","name":"test1111.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702968531107.798,"size":84985},{"id":"406b8fc228b30cb7c164e49175fdace298e2e9c91a51913b40f5f2d848f29618ab263ddc435ebdd57fd6aa846f333edd84af33931903eaa66f3886da621f8787","href":"https://static.observableusercontent.com/files/406b8fc228b30cb7c164e49175fdace298e2e9c91a51913b40f5f2d848f29618ab263ddc435ebdd57fd6aa846f333edd84af33931903eaa66f3886da621f8787","name":"test0.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702975275198.004,"size":171327},{"id":"54da22c1552f8ab4892b7bd214c51f0ccfacc64484b6797b24af610272f901732d9af78299969982970d1e62a6779acf111442f6fd6fa71472fa6809ea991169","href":"https://static.observableusercontent.com/files/54da22c1552f8ab4892b7bd214c51f0ccfacc64484b6797b24af610272f901732d9af78299969982970d1e62a6779acf111442f6fd6fa71472fa6809ea991169","name":"Alt.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702992518809.581,"size":89464}] 2b:{"id":"3fd67f5248ecb964","slug":null,"title":"Численность населения Забайкальского края по возрастным группам","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2023-12-19T05:11:35.918Z","update_time":"$D2023-12-22T08:34:18.743Z","view_time":null,"first_public_time":"$D2023-12-19T05:11:35.918Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"28f03f6443f6e51b","login":"elizaveta-ws","name":"elizaveta's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/7f4bda36273adf14cbd033fec2ba15c0ca4920ac8bb81c5ec8b8f24ddd00bab7","tier":"starter_2024"},"version":474,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"5a156eb87e3c6fc3","login":"elizaveta","name":"elizaveta","avatar_url":"https://avatars-next.observableusercontent.com/53a2ce1831b624cce0e71cb7db271fff623dfeb58fb013adfc9da7c04d2aebde","tier":null}],"members":[{"type":"individual","id":"5a156eb87e3c6fc3","login":"elizaveta","name":"elizaveta","avatar_url":"https://avatars-next.observableusercontent.com/53a2ce1831b624cce0e71cb7db271fff623dfeb58fb013adfc9da7c04d2aebde","tier":null,"role":"editor"},{"type":"team","id":"28f03f6443f6e51b","login":"elizaveta-ws","name":"elizaveta's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/7f4bda36273adf14cbd033fec2ba15c0ca4920ac8bb81c5ec8b8f24ddd00bab7","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Численность населения Забайкальского края по возрастным группам","cells":[{"id":0,"value":"# Численность населения Забайкальского края по возрастным группам","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":231,"value":"

Данные для анализа взяты с сайта федеральной службы государственной статистики

\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"test_data= FileAttachment(\"test0.xlsx\").xlsx({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"alt_data= FileAttachment(\"Alt.xlsx\").xlsx({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"connecting = test_data.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":55,"value":"alt_connecting = alt_data.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"test_bd = connecting.filter((b)=>(b[\"Возрастная группа\"].indexOf(\"-\") == -1)).map(\n function (d) {\n\t return {years: Number(d[\"Год\"]),\n age_group: Number(String(d[\"Возрастная группа\"].substring(0,2))),\n population: Number(d[\"Всё население\"]),\n pol: d[\"Пол\"],\n urban: Number(d[\"Городское\"]),\n rural: Number(d[\"Сельское\"])\n }\n }).sort((a, b) => a[\"years\"] < b[\"years\"] ? 1 : -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":9,"value":"connecting.columns","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"viewof table_bd = Inputs.table(test_bd, {maxHeight: 150})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":30,"value":"bd_2016 = test_bd.filter(d=>d[\"years\"]==2022)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":280,"value":"

Количество человек по каждой возрастной группе за выбранный год

\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":33,"value":"Plot.plot({\n width : 1200,\n height : 400, \n grid : true,\n marks: [\n Plot.barY(bd_2016, {x: \"age_group\", y: \"population\", fill:\"pol\", sort: {x: \"x\", reverse: false}}),\n Plot.ruleY([0, 2000,3000]),\n //Plot.text(bd, {x: \"data_b\", y: \"count_b\", fill: \"age\" , dy: , text: d=>d[\"count_b\"]}), \n ], color: { legend: true, range:[\"#27496D\", \"#00909E\"]},\nmargintop: 30})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"connecting3 = alt_data.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":295,"value":"alt_bd = connecting3.filter((b)=>(b[\"Возрастная группа\"].indexOf(\"-\") == -1)).map(\n function (d) {\n\t return {years: Number(d[\"Год\"]),\n age_group: Number(String(d[\"Возрастная группа\"].substring(0,2))),\n population: Number(d[\"Всё население\"]),\n pol: d[\"Пол\"],\n urban: Number(d[\"Городское\"]),\n rural: Number(d[\"Сельское\"])\n }\n }).sort((a, b) => a[\"years\"] < b[\"years\"] ? 1 : -1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":299,"value":"viewof select_date_2 = Inputs.select(new Set(test_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"alt_bd3_filter = alt_bd.filter(x=> x.years==select_date_2)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":311,"value":"test_bd4_filter = test_bd.filter(x=> x.years==select_date_2)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":289,"value":"Plot.plot({\n width :1200,\n height : 600, \n grid : true,\n facet: {\n data: test_bd,\n x: \"pol\",\n margin: 50\n },\n // y: {\n // domain: [1, 3000]\n // },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(test_bd.filter(d=>d[\"age_group\"]==80), {x: \"years\", y: \"population\", fill: \"pol\"}),\n Plot.text(test_bd.filter(d=>d[\"age_group\"]==80), {x: \"years\", y: \"population\", fill: \"black\" , dy:-10, text: d=>d[\"population\"]})\n ],\n color: { legend: true, range:[\"#2A4480\", \"#5F9EA0\"]},\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":377,"value":"Сравнение конкретной возрастной группы (т.к. она раньше выделялась)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":319,"value":"Plot.plot({\n width: 1200,\n grid: true,\n x: {label: 'Года →'},\n y: {label: 'Население ↑'},\n marks: [\n Plot.barY(alt_bd.filter(d=>d[\"age_group\"]==80), {y: \"population\", x:\"years\", fill:\"#4682B4\", fillOpacity: 0.5}),\n Plot.barY(test_bd.filter(d=>d[\"age_group\"]==80), {y: \"population\", x:\"years\", fill:\"#20B2AA\", fillOpacity: 0.8}), \n Plot.text(alt_bd.filter(d=>d[\"age_group\"]==80),\n Plot.groupX({y: \"sum\", text: \"sum\"},\n {y: \"population\", x: \"years\", fill: \"black\" , dy:-15, text: d=>d[\"population\"]})),\n Plot.text(test_bd.filter(d=>d[\"age_group\"]==80),\n Plot.groupX({y: \"sum\", text: \"sum\"},\n {y: \"population\", x: \"years\", fill: \"black\" , dy:-15, text: d=>d[\"population\"]})),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"viewof filter_date = Scrubber(list_date, {\n delay : 500,\n alternate: true,\n loop: true,\n format: x => x.toLocaleString(\"ru\",{ years: 'numeric'})\n})\n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":389,"value":"\nlist_date = Array.from(new Set(test_bd.map(d => d[\"years\"]).sort((a, b) => a[\"years\"] < b[\"years\"] ? 1 : -1)))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"`Получили диапазон для даты: ${[list_date[0], list_date[list_date.length-1]]}`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":381,"value":"Plot.plot({\n width: 1500,\n height: 400,\n grid: true,\n x: {domain: list_date },\n y: {},\n marks: [\n //Plot.line(test_bd, { x: 'years', y: 'population', filter: ((d) => d['years'] <= filter_date)}),\n Plot.barY(test_bd, Plot.groupX({y: \"sum\"},\n {y: \"population\", x: \"years\", fill: \"red\", filter: ((d) => d['years'] <= filter_date)})),\n //Plot.circle(test_bd, Plot.groupX({y: \"sum\"},\n // { x: 'years', y: 'population', fill: \"black\", filter: ((d) => d['years'] <= filter_date)})),\n //Plot.ruleY([20000, 40000, 60000, 80000, 100000, 120000, 140000, 160000])\n Plot.ruleY([])\n ],\n color: { legend: true },\n marginLeft: 70\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":401,"value":"function f_color(obj) {\n if (obj < 50) return 0\n if (obj < 60) return 1\n if (obj < 70) return 2\n else return 3;\n }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":383,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":303,"value":"$2d","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":38,"value":"viewof select_date = Inputs.select(new Set(test_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":40,"value":"bd1 = test_bd.filter(x=> x.years==select_date)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":42,"value":"Plot.plot({\n width :1200,\n height : 400, \n grid : true,\n facet: {\n data: bd1,\n y: \"pol\",\n margin: 30\n },\n // y: {\n // domain: [1, 20000]\n // },\n marks: [\n Plot.barY(bd1 , Plot.groupX({y: \"mean\"}, {x: \"age_group\", y: \"population\", fill: \"pol\", fillOpacity: 0.5})),\n // Plot.barY(bd.filter(x=> x.years==select_date), {x: \"age_group\", y: \"population\", fill: \"grey\" , fillOpacity: 0.5}),\n Plot.ruleY([0]),\n ],color: { legend: true, range:[\"#590D82\", \"#0C056D\"]},\n marginLeft: 100})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"Plot.plot({\n width :1200,\n height : 600, \n grid : true,\n x: {domain: list_date },\n facet: {\n data: test_bd,\n x: \"pol\",\n margin: 50\n },\n // y: {\n // domain: [1, 3000]\n // },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(test_bd, Plot.groupX({y: \"mean\"}, {x: \"years\", y: \"population\", fill: \"pol\", filter: ((d) => d['years'] <= filter_date)})),\n Plot.text(test_bd, Plot.groupX({y: \"mean\", text: \"mean\"}, {x: \"years\", y: \"population\", fill: \"black\" , dy:-10, text: d=>d[\"population\"], filter: ((d) => d['years'] <= filter_date)}))\n ],\n color: { legend: true, range:[\"#2A4480\", \"#5F9EA0\"]},\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":145,"value":"Plot.plot({\n width :1200,\n height : 600, \n grid : true,\n facet: {\n data: test_bd,\n x: \"pol\",\n margin: 50\n },\n // y: {\n // domain: [1, 3000]\n // },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(test_bd, Plot.groupX({y: \"mean\"}, {x: \"years\", y: \"population\", fill: \"pol\"})),\n Plot.text(test_bd, Plot.groupX({y: \"mean\", text: \"mean\"}, {x: \"years\", y: \"population\", fill: \"black\" , dy:-10, text: d=>d[\"population\"]}))\n ],\n color: { legend: true, range:[\"#8A6ED7\", \"#5F9EA0\"]},\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":163,"value":"

Данные для анализа взяты с сайта федеральной службы государственной статистики

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":188,"value":"Plot.plot({\n marks: [\n Plot.areaY(aapl, {x: \"Date\", y: \"Close\"}),\n Plot.ruleY([0])\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":190,"value":"Plot.plot({\n marks: [\n Plot.ruleY([0]),\n Plot.lineY(aapl, {x: \"Date\", y: \"Close\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":192,"value":"Plot.plot({\n marks: [\n Plot.dot(cars, {x: \"power (hp)\", y: \"economy (mpg)\"})\n ]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":181,"value":"~~~\n\n~~~","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":67,"value":"chart = PieChart(connecting, {\n name: d => d.Городское,\n value: d => d.Сельское,\n width,\n height: 500\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":69,"value":"import {PieChart} from \"@d3/pie-chart\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W2e","stdlib":"1","titling":"auto"}} 2c:"$2b:body"