28:null 29:["$","title",null,{"children":"Численность населения Забайкальского края по возрастным группам | elizaveta's Workspace | Observable"}] 2f:[{"id":"406b8fc228b30cb7c164e49175fdace298e2e9c91a51913b40f5f2d848f29618ab263ddc435ebdd57fd6aa846f333edd84af33931903eaa66f3886da621f8787","href":"https://static.observableusercontent.com/files/406b8fc228b30cb7c164e49175fdace298e2e9c91a51913b40f5f2d848f29618ab263ddc435ebdd57fd6aa846f333edd84af33931903eaa66f3886da621f8787","name":"Zab0.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1702999880727.478,"size":171327},{"id":"54da22c1552f8ab4892b7bd214c51f0ccfacc64484b6797b24af610272f901732d9af78299969982970d1e62a6779acf111442f6fd6fa71472fa6809ea991169","href":"https://static.observableusercontent.com/files/54da22c1552f8ab4892b7bd214c51f0ccfacc64484b6797b24af610272f901732d9af78299969982970d1e62a6779acf111442f6fd6fa71472fa6809ea991169","name":"Alt.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1703002035087.249,"size":89464},{"id":"c04d533eda8a7e4cbd0e3bb2af76e5981a7f6b8c1ce0e52e3177105774adc9c952c8ba25dec31b92d686ae69d376e4fa487bf8806fe64b5785de3f889596d65f","href":"https://static.observableusercontent.com/files/c04d533eda8a7e4cbd0e3bb2af76e5981a7f6b8c1ce0e52e3177105774adc9c952c8ba25dec31b92d686ae69d376e4fa487bf8806fe64b5785de3f889596d65f","name":"Zab5.csv","type":"text/csv","lastModified":1701767472581.493,"size":954},{"id":"22cb79d1e28ba37440a2a5cfe82a03a25588b61259d2f15711483e2f9f37fa7234ac396c180d942767f450ffeccaec2c55385a87d4bf30ff7e390f85059c44b7","href":"https://static.observableusercontent.com/files/22cb79d1e28ba37440a2a5cfe82a03a25588b61259d2f15711483e2f9f37fa7234ac396c180d942767f450ffeccaec2c55385a87d4bf30ff7e390f85059c44b7","name":"ZabR.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1701966702042.627,"size":61949}] 2c:{"id":"8a1b873439d4da47","slug":null,"title":"Численность населения Забайкальского края по возрастным группам","thumbnail":"519d040ed6ed90cfd5c8ea8f927249b73620b8bcfe45611a9c9e8d1ff6b9b15f","access_level":"public","create_time":"$D2023-12-05T07:49:22.615Z","update_time":"$D2023-12-22T09:54:24.394Z","view_time":null,"first_public_time":"$D2023-12-05T07:49:22.615Z","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":1014,"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,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Численность населения Забайкальского края по возрастным группам","cells":[{"id":0,"value":"# Численность населения Забайкальского края по возрастным группам","pinned":false,"hidden":false,"mode":"md"},{"id":399,"value":"

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

","pinned":false,"hidden":false,"mode":"md"},{"id":11,"value":"zab_data= FileAttachment(\"Zab0.xlsx\").xlsx({typed: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":159,"value":"connecting = zab_data.sheet(0, {headers: true})","pinned":false,"hidden":false,"mode":"ojs"},{"id":172,"value":"connecting.columns","pinned":false,"hidden":false,"mode":"ojs"},{"id":55,"value":"zab_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":false,"hidden":false,"mode":"ojs"},{"id":257,"value":"viewof table_bd = Inputs.table(zab_bd, {maxHeight: 150})","pinned":false,"hidden":false,"mode":"ojs"},{"id":381,"value":"

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

\n","pinned":false,"hidden":false,"mode":"md"},{"id":561,"value":"viewof select_years = Inputs.select(new Set(zab_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":206,"value":"Plot.plot({\n width : 1200,\n height : 400, \n grid : true,\n x: {label: 'Возрастная группа →'},\n y: {label: 'Население ↑'},\n marks: [\n Plot.barY(zab_bd.filter(x=> x.years==select_years), {x: \"age_group\", y: \"population\", fill:\"pol\", fillOpacity: 0.9, sort: {x: \"x\", reverse: false}}),\n ], color: { legend: true, range:[\"#27496D\", \"#00909E\"]},\nmargintop: 30})","pinned":false,"hidden":false,"mode":"ojs"},{"id":903,"value":"\"Всплеск\" возрастной группы \"80\" вызван тем, что в неё входят люди от 80 лет и старше. ","pinned":false,"hidden":false,"mode":"md"},{"id":383,"value":"

Численность населения по каждой возрастной группе за выбранный год (по женщинам и мужчинам)

","pinned":false,"hidden":false,"mode":"md"},{"id":245,"value":"viewof select_date = Inputs.select(new Set(zab_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":243,"value":"Plot.plot({\n width :1200,\n height : 400, \n grid : true,\n x: {label: 'Возрастная группа →'},\n y: {label: 'Население ↑'},\n facet: {\n data: zab_bd1_filter,\n y: \"pol\",\n margin: 20\n },\n marks: [\n Plot.barY(zab_bd1_filter , Plot.groupX({y: \"mean\"}, {x: \"age_group\", y: \"population\", fill: \"pol\", fillOpacity: 0.6})),\n Plot.ruleY([0]),\n ],color: { legend: true, range:[\"#590D82\", \"#008B8B\"]},\n marginLeft: 100})","pinned":false,"hidden":false,"mode":"ojs"},{"id":933,"value":"Женщин больше мужчин, особенно это заметно для возрастных групп более 60 лет","pinned":false,"hidden":false,"mode":"md"},{"id":935,"value":"zab_bd1_filter = zab_bd.filter(x=> x.years==select_date)","pinned":false,"hidden":false,"mode":"ojs"},{"id":959,"value":"viewof filter_date = Scrubber(list_date, {\n delay : 800,\n alternate: true,\n loop: true,\n format: x => x.toLocaleString(\"ru\",{ years: 'numeric'})\n})\n","pinned":false,"hidden":false,"mode":"ojs"},{"id":390,"value":"

Отношение численности населения к количеству возрастных групп

","pinned":false,"hidden":false,"mode":"md"},{"id":386,"value":"Plot.plot({\n width :1200,\n height : 600, \n grid : true,\n x: {domain: list_date, label: 'Года →' },\n\n y: {label: 'Население ↑'},\n facet: {\n data: zab_bd,\n x: \"pol\",\n margin: 50\n },\n // y: {\n // domain: [1, 3000]\n // },\n marks: [\n Plot.ruleY([0]),\n Plot.barY(zab_bd, Plot.groupX({y: \"mean\"}, {x: \"years\", y: \"population\", fill: \"pol\", filter: ((d) => d['years'] <= filter_date)})),\n Plot.text(zab_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:[\"#4682B4\", \"#5F9EA0\"]}\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":926,"value":"Численность населения как мужчин, так и женщин идёт на спад.","pinned":false,"hidden":false,"mode":"md"},{"id":510,"value":"viewof select_date_1 = Inputs.select(new Set(zab_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":587,"value":"

Сравнение городского и сельского населения Забайкальского края за выбранный год

","pinned":false,"hidden":false,"mode":"md"},{"id":454,"value":"Plot.plot({\n width: 1200,\n grid: true,\n x: {label: 'Возрастная группа →'},\n y: {label: 'Тип населения ↑'},\n marks: [\n Plot.areaY(zab_bd2_filter, Plot.groupX({y: \"sum\"}, {y: \"urban\", x:\"age_group\", fill:\"#7B68EE\", fillOpacity: 0.4})),\n Plot.areaY(zab_bd2_filter, Plot.groupX({y: \"sum\"}, {y: \"rural\", x:\"age_group\", fill:\"#00008B\", fillOpacity: 0.4})),\n \n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":928,"value":"Численность городского населения выше численности сельского.","pinned":false,"hidden":false,"mode":"md"},{"id":938,"value":"zab_bd2_filter = zab_bd.filter(x=> x.years==select_date_1)","pinned":false,"hidden":false,"mode":"ojs"},{"id":736,"value":"viewof select_date_5 = Inputs.select(new Set(zab_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":748,"value":"

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

","pinned":false,"hidden":false,"mode":"md"},{"id":741,"value":"chart = PieChart(data, {\n name: d => d.name,\n value: d => d.value,\n width,\n height: 500,\n colors: ['#4682B4', '#5F9EA0']\n \n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":941,"value":"zab_bd5_filter = zab_bd.filter(x=> x.years==select_date_5)","pinned":false,"hidden":false,"mode":"ojs"},{"id":994,"value":"

Сравнение численности населения Забайкальского и Алтайского края за выбранный год

","pinned":false,"hidden":false,"mode":"md"},{"id":996,"value":"viewof select_date_2 = Inputs.select(new Set(zab_bd.map(d => d[\"years\"])), {label: \"Год\"})","pinned":false,"hidden":false,"mode":"ojs"},{"id":998,"value":"Plot.plot({\n width: 1200,\n grid: true,\n x: {label: 'Возрастная группа →'},\n y: {label: 'Население ↑'},\n marks: [\n Plot.barY(alt_bd3_filter, {y: \"population\", x:\"age_group\", fill:\"#20B2AA\", fillOpacity: 0.5}),\n Plot.barY(zab_bd4_filter, {y: \"population\", x:\"age_group\", fill:\"#4682B4\", fillOpacity: 0.8}),\n Plot.ruleY([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs"},{"id":1002,"value":"Численность населения Алтайского края больше Забайкальского края.","pinned":false,"hidden":false,"mode":"md"},{"id":944,"value":"Категорию \"80+\" сравним между собой по двум краям: Забайкальскому и Алтайскому","pinned":false,"hidden":false,"mode":"md"},{"id":950,"value":"

Сравнение возрастной группы 80+

","pinned":false,"hidden":false,"mode":"html"},{"id":946,"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(zab_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(zab_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":false,"hidden":false,"mode":"ojs"},{"id":952,"value":"Анализируя диаграмму, можно сказать, что численность людей с возрастной группой 80+ Алтайского края значительно выше, чем численность 80+ из Забайкальского края.","pinned":false,"hidden":false,"mode":"md"},{"id":500,"value":"alt_data= FileAttachment(\"Alt.xlsx\").xlsx({typed: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":508,"value":"connecting3 = alt_data.sheet(0, {headers: true})","pinned":true,"hidden":false,"mode":"ojs"},{"id":505,"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"},{"id":520,"value":"alt_bd3_filter = alt_bd.filter(x=> x.years==select_date_2)","pinned":true,"hidden":false,"mode":"ojs"},{"id":746,"value":"

Сравнение численности населения Забайкальского и Алтайского края за выбранный год

","pinned":false,"hidden":false,"mode":"md"},{"id":930,"value":"Численность населения Забайкальского края меньше численности населения Алтайского края.","pinned":false,"hidden":false,"mode":"html"},{"id":529,"value":"zab_bd4_filter = zab_bd.filter(x=> x.years==select_date_2)","pinned":true,"hidden":false,"mode":"ojs"},{"id":674,"value":"import {PieChart} from \"@d3/pie-chart\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":964,"value":"import {Scrubber} from \"@mbostock/scrubber\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":971,"value":"\nlist_date = Array.from(new Set(zab_bd.map(d => d[\"years\"]).sort((a, b) => a[\"years\"] < b[\"years\"] ? 1 : -1)))","pinned":true,"hidden":false,"mode":"ojs"},{"id":690,"value":"sum_G= zab_bd5_filter.reduce((a, b) => a + b.urban, 0)","pinned":true,"hidden":false,"mode":"ojs"},{"id":695,"value":"sum_S= zab_bd5_filter.reduce((a, b) => a + b.rural, 0)","pinned":true,"hidden":false,"mode":"ojs"},{"id":697,"value":"data = [\n { name: \"Городское население\", value: sum_G},\n { name: \"Сельское население\", value: sum_S },\n]","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W2f","stdlib":"1","titling":"auto"}} 2d:"$2c:body"