2c:null 2d:["$","title",null,{"children":"#30DayChartChallenge D1: Part to a Whole | Tanya Shapiro | Observable"}] 32:T6c7,Highcharts.chart('container', { chart: { type: 'sunburst' }, tooltip: { formatter: function() { var value = this.point.value; var hours = Math.floor(value); var minutes = Math.round((value % 1) * 60); var tooltipText = '' + this.point.name + '
'; if (hours === 1) { tooltipText += hours + ' hour and ' + minutes + ' minutes'; } else if (hours > 1) { tooltipText += hours + ' hours and ' + minutes + ' minutes'; } else { tooltipText += minutes + ' minutes'; } return tooltipText; } }, title: { text: null }, credits: {enabled: false}, series: [{ data: chartData, cursor: 'pointer', colors: ['#00BFB2','#48EB70','#EBCD49','#FF9D13','#F95738','#7F2FFF','#4DEAFF','#DCDCDC'], name: "Global Human Day", allowDrillToNode: true, dataLabels: { format: '{point.name}', rotationMode: 'circular', style: {fontFamily: 'Roboto Condensed'} }, levels: [ { // Level 1 settings level: 1, colorByPoint: true, color: 'white', dataLabels: {style: {fontSize:30}} }, { // Level 2 settings level: 2, colorByPoint: true, dataLabels: {style: {fontSize:16}} }, { // Level 3 settings level: 3, dataLabels: {style: {fontSize:14}}, colorVariation: { key: 'brightness', to: -0.5 } } ] }] }); 33:T6bf,| Category | Description | | | |---------------------------------|---------------------------------------------------------------------------------------------------------------------------------------------------|---|---| | Food provision | Providing food to humans, including agriculture and fishing, the processing of food items, cooking, serving, and cleanup | | | | Nonfood provision | Providing raw materials and energy to the technosphere, including mining, lumber, fossil fuels, and renewable energy | | | | Technosphere modification | The construction and maintenance of buildings, infrastructure, and movable artifacts | | | | Maintenance of surroundings | Cleaning surfaces and arranging the spaces that humans inhabit, taking care of accompanying plants and animals, disposing of wastes | | | | Somatic maintenance | Caring for the cleanliness, appearance, and health of human bodies, including medical care and childcare | | | | Deliberate neural restructuring | Education, both formal and informal, research in the academic and private sector, and religious activities | | | | Experience oriented | Engaging in activities to provide desired experiences, including through use of media, interactive hobbies and sports, socializing, and meals | | |34:[{"id":"fd5b74cdd99c0c3d6d5a357cd1d51c24116453a688a1af6e346badf8e8c6ab06bec230d9fe99d5df67f70b49d19fbb310dbf2fe710ae36120e9b9ea12a479357","href":"https://static.observableusercontent.com/files/fd5b74cdd99c0c3d6d5a357cd1d51c24116453a688a1af6e346badf8e8c6ab06bec230d9fe99d5df67f70b49d19fbb310dbf2fe710ae36120e9b9ea12a479357","name":"ghd_all_countries.csv","type":"text/csv","lastModified":1711977615572.12,"size":370927},{"id":"4f0fee3fc94b1f722df0ded0db987eb89e90522b3dc7c209c52e15f3a8dfc1b2a862a67b38e80fb76014bdf0fe9576b15bca14093170ca4fdff47c70652e9528","href":"https://static.observableusercontent.com/files/4f0fee3fc94b1f722df0ded0db987eb89e90522b3dc7c209c52e15f3a8dfc1b2a862a67b38e80fb76014bdf0fe9576b15bca14093170ca4fdff47c70652e9528","name":"country_regions.csv","type":"text/csv","lastModified":1711984264375.873,"size":23179}] 30:{"id":"0644a8df66dd6bab","slug":null,"title":"#30DayChartChallenge D1: Part to a Whole","thumbnail":"482c680c919f505707402ca6bab0a87e24732d4ae1b164eff1fcde71b86aee1b","access_level":"public","create_time":"$D2024-04-01T13:15:45.167Z","update_time":"$D2024-04-23T21:12:37.641Z","view_time":null,"first_public_time":"$D2024-04-01T15:10:43.954Z","has_unpublished_edits":null,"fork":false,"stars":5,"starred":false,"owner":{"type":"team","id":"230f604926360997","login":"tashapiro","name":"Tanya Shapiro","avatar_url":"https://avatars-next.observableusercontent.com/28b8518718dc3e70bed3a8256215864c8ac22777155e21dd5564f285665f60ae","tier":"starter_2024"},"version":257,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"fccfb83ec070004a","login":"tashapiro","name":"Tanya Shapiro","avatar_url":"https://avatars-next.observableusercontent.com/28b8518718dc3e70bed3a8256215864c8ac22777155e21dd5564f285665f60ae","tier":null}],"members":[{"type":"team","id":"230f604926360997","login":"tashapiro","name":"Tanya Shapiro","avatar_url":"https://avatars-next.observableusercontent.com/28b8518718dc3e70bed3a8256215864c8ac22777155e21dd5564f285665f60ae","tier":"starter_2024","role":"editor"},{"type":"individual","id":"fccfb83ec070004a","login":"tashapiro","name":"Tanya Shapiro","avatar_url":"https://avatars-next.observableusercontent.com/28b8518718dc3e70bed3a8256215864c8ac22777155e21dd5564f285665f60ae","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":{"id":"27ed1236d65a6cee","slug":"30daychartchallenge","title":"#30DayChartChallenge","owner":{"id":"230f604926360997","login":"tashapiro","name":"Tanya Shapiro"}},"type":"notebook","body":{"title":"#30DayChartChallenge D1: Part to a Whole","cells":[{"id":0,"value":"# #30DayChartChallenge D1: Part to a Whole\n\nData uses a [#TidyTuesday](https://github.com/rfordatascience/tidytuesday/tree/master/data/2023/2023-09-12) dataset from The Global Human Day project. This project looks at how people allocate their time in a day across various activities. The sunburst chart below uses Highcharts. Click on a category to zoom into the subcategory activities.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":21,"value":"viewof selectedCountry = Inputs.select(new Map(countryList), {label: \"Select Country\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":11,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":9,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"## More on Data\n\nExcerpt from TidyTuesday:\n\nThe data this week comes from the The Human Chronome Project an initiative based at McGill University in Montreal, from their paper The global human day in PNAS and the associated dataset on Zenodo.\n\nThe daily activities of ≈8 billion people occupy exactly 24 h per day, placing a strict physical limit on what changes can be achieved in the world. These activities form the basis of human behavior, and because of the global integration of societies and economies, many of these activities interact across national borders. This project estimates how all humans spend their time using a generalized, physical outcome–based categorization that facilitates the integration of data from hundreds of diverse datasets.\n\nDefinitions for categories taken directly from the project's [research paper](https://www.pnas.org/doi/10.1073/pnas.2219564120#sec-2).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":171,"value":"### Categories","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":153,"value":"$33","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":101,"value":"## Data Wrangling\nLeveraging the power of DuckDB and SQL because I loath wrangling with JS...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":33,"value":"select * from \n(select \ncategory as id\n,${selectedCountryName} as parent\n,category as name\n,sum(hoursPerDayCombined) as value\nfrom filteredData\ngroup by category\norder by 4 desc) a\nunion all (\n select \n subcategory as id\n ,category as parent\n ,subcategory as name\n ,hoursPerDayCombined as value\n from filteredData\n order by 4 desc\n) \nunion all (\n select\n ${selectedCountryName} as id\n ,'' as parent\n ,${selectedCountryName} as name\n ,sum(hoursPerDayCombined) as value\n from filteredData\n) ","pinned":false,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"chartData","database":"var:filteredData"},{"id":27,"value":"filteredData = ghd_all_countries.filter(d=>d.country_iso3===selectedCountry)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"## Import Highcharts","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":5,"value":"Highcharts = {\n const Highcharts = await require(\"highcharts\");\n await require(\"highcharts/highcharts-more.js\");\n await require(\"highcharts/modules/sunburst.js\");\n return Highcharts;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":25,"value":"## Import Data\nData from [#TidyTuesday](https://github.com/rfordatascience/tidytuesday/tree/master/data/2023/2023-09-12)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":17,"value":"ghd_all_countries = await FileAttachment(\"ghd_all_countries.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"ghd_all_countries","database":"$undefined"},{"id":161,"value":"country_regions = await FileAttachment(\"country_regions.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"country_regions","database":"$undefined"},{"id":166,"value":"SELECT * FROM \"country_regions\"","pinned":true,"hidden":false,"mode":"sql","author":"$undefined","summary":"$undefined","output":"","database":"country_regions.csv"},{"id":121,"value":"countries = [...new Set(ghd_all_countries.map(d => d.country_iso3))].sort()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"countryList = country_regions\n .filter(d => countries.includes(d.country_iso3))\n .map(d => [d.country_name, d.country_iso3])\n .sort((a, b) => a[0].localeCompare(b[0]));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":162,"value":"selectedCountryName = country_regions.filter(d=>d.country_iso3 === selectedCountry)[0].country_name","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"","pinned":true,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W34","stdlib":"1","titling":"auto"}} 31:"$30:body"