28:["$","title",null,{"children":"World Bank Gender Data Portal | Assets | Aaron Kyle Dennis | Observable"}] 2d:T553, Account ownership at a financial institution
or with a mobile-money-service provider
by sex and income group ${Plot.plot({ marginLeft: 150, width: width*0.9, height: width*0.4, color: { range: ["orange", "purple"], legend: true }, fx: { tickFormat: "d" }, x: { domain: [0, 100], ticks: 5 }, fy: {domain: ["Low income","Lower middle income", "Upper middle income", "High income"] }, marks: [ Plot.frame({ strokeOpacity: 0.2 }), Plot.ruleY( aggregated_account_ownership.filter(d => d.Year === 2017), Plot.groupZ( { x1: "min", x2: "max" }, { x1: "Value", x2: "Value", y: null, fx: "Year", fy: "Country Name" } ) ), Plot.dotX( aggregated_account_ownership.filter(d => d.Year === 2017), Plot.groupX( { x: "mean" }, { x: "Value", fill: "Sex", r: 9, fx: "Year", fy: "Country Name", tip: { format: { Sex: true, Value: true, fx: false, fy: true, } }, } ) ) ] })}
_{Source: World Bank} 2e:T903,

Saved any money
in the past year ₍₂₀₁₇₎
_{Source: World Bank}

${Plot.plot({ marginLeft: 0, marginTop: 20, height: 140, width: 500, color: { range: ["orange", "purple"], legend: true }, facet: { data: aggregated_money_savings_last_year_2017, x: (d) => !["Low income", "Upper middle income"].includes(d["Country Name"]), y: (d) => !["Low income", "Lower middle income"].includes(d["Country Name"]) }, x: {axis: null, domain: [0, 100]}, y: {axis: null}, fx: {axis: null}, fy: {axis: null, paddingInner: 0.4}, marks: [ //Plot.frame(), Plot.text(aggregated_money_savings_last_year_2017, Plot.selectFirst({ frameAnchor: "top-left", text: "Country Name", lineAnchor: "bottom", fontSize: 14, fontWeight: "bold", dy: -5 })), Plot.rectX(aggregated_money_savings_last_year_2017, { fill: "Sex", reverse: true, y1: d => d.Sex === "Male" ? 1.5 : 0, y2: d => d.Sex === "Male" ? 4 : 2.5, x2: "Value", tip:{ format: { Sex: true, Value: true, x1: false, y: false, fx: false, fy: false, } }, }), Plot.textX(aggregated_money_savings_last_year_2017, { fill: "Sex", filter: (d) => d.Sex === "Female", text: d => `${d.Value.toFixed(1)}%`, textAnchor: "start", fontSize: 14, insetTop: 10, dx: 4, frameAnchor: "bottom", fontWeight: "bold", x: "Value" }), Plot.textX(aggregated_money_savings_last_year_2017, { fill: "Sex", filter: (d) => d.Sex === "Male", text: d => `${d.Value.toFixed(1)}%`, textAnchor: "start", fontSize: 14, insetTop: 10, frameAnchor: "top", fontWeight: "bold", dx: 4, x: "Value" }) ] })}

2f:Ta22,own_house_filtered = Object.values( Object.values( //Reduce the 'own_house' array to a key-value store with unique keys based on specific properties. own_house.reduce((r, c) => { // Create a unique key based on specific properties of the object. const key = JSON.stringify({ "Country Name": c["Country Name"], "Country Code": c["Country Code"], "Year": c["Year"], "Region": c["Region"], "Income group": c["Income group"], }); // If the key does not exist in the result object, initialize it with specific properties and default values. r[key] = r[key] || { ...c, "Female Value": 0, "Male Value": 0, "Indicator Name": "Own House" }; // Check if the current entry corresponds to Female or Male Value indicator and update values accordingly. const isFemaleIndicator = ["SG.OWN.HSAL.FE.ZS", "SG.OWN.HSJT.FE.ZS", "SG.OWN.HSAJ.FE.ZS"].includes(c["Indicator Code"]); const isMaleIndicator = ["SG.OWN.HSAL.MA.ZS", "SG.OWN.HSJT.MA.ZS", "SG.OWN.HSAJ.MA.ZS"].includes(c["Indicator Code"]); // Update Female and Male Values based on the indicator type. r[key]["Female Value"] += isFemaleIndicator ? (isNaN(c["Value"]) ? 0 : c["Value"]) : 0; r[key]["Male Value"] += isMaleIndicator ? (isNaN(c["Value"]) ? 0 : c["Value"]) : 0; return r; }, {}) // Group the transformed data by unique keys (Country Name and Indicator Code) ).reduce((groups, entry) => { const key = `${entry["Country Name"]}-${entry["Indicator Code"]}`; // If the key does not exist in the groups object, initialize it as an empty array. groups[key] = groups[key] || []; // Push the current entry into the corresponding group. groups[key].push(entry); return groups; }, {}) //Extract the most recent data for Female and Male Values, filling missing Male Values with the last available value. ).flatMap(group => { // Find the most recent year in the current group. const mostRecentYear = Math.max(...group.map(entry => entry["Year"])); let lastMaleValue = null; return group // Filter the entries for the most recent year and non-zero Female and Male Values. .filter(entry => entry["Year"] === mostRecentYear && entry["Male Value"] !== 0 && entry["Female Value"] !== 0) .map(entry => { // Fill missing Male Values with the last available value. if (entry["Male Value"] === 0 && lastMaleValue !== null) { entry["Male Value"] = lastMaleValue; } else { lastMaleValue = entry["Male Value"]; } return entry; }); })30:T41b,own_land = assets.filter(asset => { const countryNameMatch = economies_renamed.some(entry => entry.Economy === asset['Country Name'] ); const indicatorCodeMatch = [ // own land alone 'SG.OWN.LDAL.FE.ZS', 'SG.OWN.LDAL.MA.ZS', // own land jointly 'SG.OWN.LDJT.FE.ZS', 'SG.OWN.LDJT.MA.ZS', // own land both alone and jointly 'SG.OWN.LDAJ.FE.ZS', 'SG.OWN.LDAJ.MA.ZS', ].includes(asset['Indicator Code']); return countryNameMatch && indicatorCodeMatch; }) .map(asset => { const isFemaleIndicator = [ 'SG.OWN.LDAL.FE.ZS', 'SG.OWN.LDJT.FE.ZS', 'SG.OWN.LDAJ.FE.ZS' ].includes(asset['Indicator Code']); const Sex = isFemaleIndicator ? 'Female' : 'Male'; const classification = economies_renamed.find(c => c.Economy === asset['Country Name'] ); if (classification) { return { ...asset, Region: classification.Region, 'Income group': classification['Income group'], Sex }; } return { ...asset, Sex }; });31:Tae3,own_land_filtered = Object.values( Object.values( //Reduce the 'own_land' array to a key-value store with unique keys based on specific properties. own_land.reduce((r, c) => { // Create a unique key based on specific properties of the object. const key = JSON.stringify({ "Country Name": c["Country Name"], "Country Code": c["Country Code"], "Year": c["Year"], "Region": c["Region"], "Income group": c["Income group"], }); // If the key does not exist in the result object, initialize it with specific properties and default values. r[key] = r[key] || { ...c, "Female Value": 0, "Male Value": 0, "Indicator Name": "Own Land" }; // Check if the current entry corresponds to Female or Male Value indicator and update values accordingly. const isFemaleIndicator = [ // own land alone 'SG.OWN.LDAL.FE.ZS', // own land jointly 'SG.OWN.LDJT.FE.ZS', // own land both alone and jointly 'SG.OWN.LDAJ.FE.ZS'].includes(c["Indicator Code"]); const isMaleIndicator = [ // own land alone 'SG.OWN.LDAL.MA.ZS', // own land jointly 'SG.OWN.LDJT.MA.ZS', // own land both alone and jointly, 'SG.OWN.LDAJ.MA.ZS'].includes(c["Indicator Code"]); // Update Female and Male Values based on the indicator type. r[key]["Female Value"] += isFemaleIndicator ? (isNaN(c["Value"]) ? 0 : c["Value"]) : 0; r[key]["Male Value"] += isMaleIndicator ? (isNaN(c["Value"]) ? 0 : c["Value"]) : 0; return r; }, {}) // Group the transformed data by unique keys (Country Name and Indicator Code) ).reduce((groups, entry) => { const key = `${entry["Country Name"]}-${entry["Indicator Code"]}`; // If the key does not exist in the groups object, initialize it as an empty array. groups[key] = groups[key] || []; // Push the current entry into the corresponding group. groups[key].push(entry); return groups; }, {}) //Extract the most recent data for Female and Male Values, filling missing Male Values with the last available value. ).flatMap(group => { // Find the most recent year in the current group. const mostRecentYear = Math.max(...group.map(entry => entry["Year"])); let lastMaleValue = null; return group // Filter the entries for the most recent year and non-zero Female and Male Values. .filter(entry => entry["Year"] === mostRecentYear && entry["Male Value"] !== 0 && entry["Female Value"] !== 0) .map(entry => { // Fill missing Male Values with the last available value. if (entry["Male Value"] === 0 && lastMaleValue !== null) { entry["Male Value"] = lastMaleValue; } else { lastMaleValue = entry["Male Value"]; } return entry; }); })32:T89e, Men and women who own a house or land by sex

${Plot.plot({ color: { legend: false, range: ["dodgerblue", "magenta", "green", "purple" , "orange", "red", "gray"], opacity : 0.8 }, insetTop: 10, insetRight: 10, insetBottom: 10, insetLeft: 10, height: 400, width: 500, y: { percent: false,domain:[0,100], grid: true }, x: { percent: false, domain:[0,100], grid: true }, caption: "Own House", marks: [ Plot.dot(own_house_filtered, { x: "Male Value", y: "Female Value", stroke: "Region", fill: "Region", opacity: 0.4, channels: {Year: "Year", Country: "Country Name"}, tip: true }), Plot.ruleX([0]), Plot.ruleY([0]), Plot.link([0], { x1: 0, y1: 0, x2: 100, y2: 100, strokeDasharray: "5,3", strokeOpacity: (k) => k === 1 ? 1 : 0.2 }), ], })}

${Plot.plot({ color: { legend: false, range: ["dodgerblue", "magenta", "green", "purple" , "orange", "red", "gray"], opacity : 0.8 }, insetTop: 10, insetRight: 10, insetBottom: 10, insetLeft: 10, height: 400, width: 500, y: { percent: false,domain:[0,80], grid: true }, x: { percent: false, domain:[0,80], grid: true }, caption: "Own Land", marks: [ Plot.dot(own_land_filtered, { x: "Male Value", y: "Female Value", stroke: "Region", fill: "Region", opacity: 0.4, channels: {Year: "Year", Country: "Country Name"}, tip: true }), Plot.ruleX([0]), Plot.ruleY([0]), Plot.link([0], { x1: 0, y1: 0, x2: 100, y2: 100, strokeDasharray: "5,3", strokeOpacity: (k) => k === 1 ? 1 : 0.2 }), ], })}

_{Source: World Bank} 33:T566,equal_authority_and_rights = assets // Filter assets based on specific indicators .filter(asset => [ // The law grants spouses equal administrative authority over assets during marriage (1=yes; 0=no) 'SG.LAW.ASST.AR', // Sons and daughters have equal rights to inherit assets from their parents (1=yes; 0=no) 'SG.IHT.ASST.PT.EQ' ].includes(asset['Indicator Code'])) // Process each filtered asset .map(asset => { // Correct country name based on a mapping const correctedCountryName = economies_name_map.find(entry => entry.includes(asset['Country Name']) ); // Find classification data based on the corrected country name const classification = country_and_lending_group_classifications.find(c => c.Economy === correctedCountryName ); // If classification data is found, add Region and Income group properties to the asset if (classification) { return { ...asset, Region: classification.Region, 'Income group': classification['Income group'], }; } // If no classification data is found, set Region and Income group properties to null return { ...asset, Region: null, 'Income group': null, }; }) // Filter out assets without complete classification information .filter(asset => asset['Region'] !== null && asset['Income group'] !== null);34:T506,Plot.plot({ color: { legend: false }, //marginRight: 160, marginLeft: 200, inset: 12, marks: [ Plot.frame({ strokeOpacity: 0.1 }), Plot.dot( equal_authority_and_rights_2021, Plot.group( { r: "count" }, { fy: "Region", x: "Country Name", y: "Indicator Code", stroke: d => { if (d["Indicator Code"] === "SG.IHT.ASST.PT.EQ") { return d.Value === 1 ? "rgb(231, 173, 0)" : "rgb(231, 219, 183)"; } else if (d["Indicator Code"] === "SG.LAW.ASST.AR") { return d.Value === 1 ? "rgb(0, 86, 231)" : "rgb(138, 161, 231)"; } }, fill: d => { if (d["Indicator Code"] === "SG.IHT.ASST.PT.EQ") { return d.Value === 1 ? "rgb(231, 173, 0)" : "rgb(231, 219, 183)"; } else if (d["Indicator Code"] === "SG.LAW.ASST.AR") { return d.Value === 1 ? "rgb(0, 86, 231)" : "rgb(138, 161, 231)"; } }, tip: { format: { fill: false, stroke: false, r: false, }, }, symbol: "square", } ) ) ], x: { axis: null }, y: { axis: null }, })35:T488,equal_authority_and_rights_2021_sorted = { // Define an array of region names in a specific order. const regions = [ "East Asia & Pacific", "Europe & Central Asia", "Latin America & Caribbean", "Middle East & North Africa", "South Asia", "Sub-Saharan Africa", "North America" ]; // Use D3.js to group the input data by "Country Name". // Then sort the groups based on the index of their corresponding region in the defined regions array. // The sorting is done in descending order (-) of the region index. // Finally, format the sorted data as `${v[1].Value} / ${v[0].Value}`. return d3 .sort( // Group the input data by "Country Name". d3 .group(equal_authority_and_rights_2021, (d) => d["Country Name"]) .values(), // Sort the groups based on the index of the region in the predefined regions array. (v) => -regions.indexOf(v[0].Region), // Format the sorted data as `${v[1].Value} / ${v[0].Value}`. (v) => `${v[1].Value} / ${v[0].Value}` ) // Reverse the sorted array. .reverse() // Flatten the array, removing nested arrays. .flat(); }36:Ta78,htl.html` Law grants spouses equal administrative authority over assets during marriage;
Sons and daughters have equal rights to inherit assets from their parents

${d3 .rollup( equal_authority_and_rights_2021_sorted, (v) => ((chart) => { d3.select(chart).on("mouseenter", function () { d3.select(this.parentElement).selectAll("svg").style("z-index", 0); d3.select(this).style("z-index", 1); // for the tooltip to be over the neighbors }); return chart; })( Plot.plot({ style: "overflow: visible; background: transparent;", width: 280, height: 100, x: { axis: null, insetLeft: 4, insetRight: 160, domain: [0, 19] }, y: { reverse: true, axis: null, inset: 3 }, fy: { paddingInner: 0, axis: null, domain: [-1, 0, 1, 2], insetBottom: 20 }, opacity: { range: [0.5, 1] }, color: { range: ["rgb(231, 173, 0)", "rgb(0, 86, 231)"] }, marks: [ Plot.text([v[0].Region], { frameAnchor: "bottom-left", fontSize: 17, facetAnchor: "top", dy: -4 }), Plot.dot(v, { x: (d, i) => Math.floor((i % 40) / 2), fy: (d, i) => Math.floor(i / 40), y: "Indicator Code", fill: "Indicator Code", fillOpacity: { value: "Value", scale: "opacity" }, symbol: "square", r: 3, channels: {"Country": "Country Name", "Equal Rights to Inherit" : (d) => { if (d["Indicator Code"] === "SG.IHT.ASST.PT.EQ") { return d.Value === 1 ? "Yes" : "No"; }}, "Spouse Equal Authority" : (d) => { if (d["Indicator Code"] === "SG.LAW.ASST.AR") { return d.Value === 1 ? "Yes" : "No"; } }, }, tip: { format: { x: false, fy: false, fill: false, fillOpacity: false, } } }) ] }) ), (d) => d.Region ) .values()}

_{Source: World Bank} `37:[{"id":"a037f47969f55547f81950daa772e4a3d7e363e01008a79f4645cd2f7a131217fc274e8b2d4a1fd75b109dcee73b772fcef3148bc18bd2c643a19ffb5ef6f4e3","href":"https://static.observableusercontent.com/files/a037f47969f55547f81950daa772e4a3d7e363e01008a79f4645cd2f7a131217fc274e8b2d4a1fd75b109dcee73b772fcef3148bc18bd2c643a19ffb5ef6f4e3","name":"own_house_or_land_by_sex.png","type":"image/png","lastModified":1686350470127.689,"size":160415},{"id":"7b50a73fe71a3c8c10955a4019a805495059dd6ce58c0d0a1024e9742a82bf2daa681c6d9601b33638fd01cc3fb431cd13c97484927fc5fad15816c72fda059a","href":"https://static.observableusercontent.com/files/7b50a73fe71a3c8c10955a4019a805495059dd6ce58c0d0a1024e9742a82bf2daa681c6d9601b33638fd01cc3fb431cd13c97484927fc5fad15816c72fda059a","name":"marriage_grants_equal_authority.png","type":"image/png","lastModified":1686350470008.147,"size":114323},{"id":"4a6c95bf0dde629433f344af88b64605a2d6c6240fb84944b6ba99743cb6a9c8f856cab0b287a7694177de4444e0f77e37a610e9d54e34d0eb272f2bbe4f1e72","href":"https://static.observableusercontent.com/files/4a6c95bf0dde629433f344af88b64605a2d6c6240fb84944b6ba99743cb6a9c8f856cab0b287a7694177de4444e0f77e37a610e9d54e34d0eb272f2bbe4f1e72","name":"mobile_money_account_by_sex.png","type":"image/png","lastModified":1686350469941.442,"size":96585},{"id":"088266d5534b53325e071e7b9377436923f04893a2fa17750ae791aabac5a566a91fb08d532f74b74b9832e16875767f481f9b3cc23410e66da26b846eb454c1","href":"https://static.observableusercontent.com/files/088266d5534b53325e071e7b9377436923f04893a2fa17750ae791aabac5a566a91fb08d532f74b74b9832e16875767f481f9b3cc23410e66da26b846eb454c1","name":"saved_money_last_year_by_sex.png","type":"image/png","lastModified":1686350469446.764,"size":75894},{"id":"d75862695f42a96b8225cc87567a0759baab33fe98089b56c47e0e777716d662a681431f10548f7a226b169247b38063f3f44653d46abc33818799ae017981b1","href":"https://static.observableusercontent.com/files/d75862695f42a96b8225cc87567a0759baab33fe98089b56c47e0e777716d662a681431f10548f7a226b169247b38063f3f44653d46abc33818799ae017981b1","name":"CLASS.xlsx","type":"application/vnd.openxmlformats-officedocument.spreadsheetml.sheet","lastModified":1679051111159.084,"size":67834},{"id":"2b6f181fe6dbd55912adf103c8d324e4c8630689fa65e4f94a7a0437a778b3b3d118cb57aba5c9374f538836c2e55fb03525af92cb3a8bb6bf708499c0ede992","href":"https://static.observableusercontent.com/files/2b6f181fe6dbd55912adf103c8d324e4c8630689fa65e4f94a7a0437a778b3b3d118cb57aba5c9374f538836c2e55fb03525af92cb3a8bb6bf708499c0ede992","name":"Assets.csv","type":"text/csv","lastModified":1678967984831.548,"size":13651519}] 2b:{"id":"7fb248de83bc0ad4","slug":"world-bank-gender-data-portal-assets","title":"World Bank Gender Data Portal | Assets","thumbnail":"7a15abc0399834ca2c82587ec6c701523dfc85a75567cbe10acb6e9c99f18324","access_level":"public","create_time":"$D2023-03-16T11:58:00.012Z","update_time":"$D2023-11-03T23:31:46.163Z","view_time":null,"first_public_time":"$D2023-10-24T13:12:01.713Z","has_unpublished_edits":null,"fork":false,"stars":13,"starred":false,"owner":{"type":"team","id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":"starter_2024"},"version":4799,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a7fa3027921865cf","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":null}],"members":[{"type":"individual","id":"a7fa3027921865cf","login":"aaronkyle","name":"Aaron Kyle Dennis","avatar_url":"https://avatars-next.observableusercontent.com/eb6d0b32ccc6c8febbf105ce4d2a938819bcbd1c6a2c108d3a9c01745d3590f2","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":11,"collection":{"id":"5d8eb3ad295b52e8","slug":"social-analysis/2","title":"Social Analysis","owner":{"id":"8d652a601386fcf4","login":"aaronkyle","name":"Aaron Kyle Dennis"}},"type":"notebook","body":{"title":"World Bank Gender Data Portal | Assets","cells":[{"id":0,"value":"# World Bank Gender Data Portal | [Assets](https://genderdata.worldbank.org/topics/assets)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1248,"value":"The World Bank's [Gender Data Portal](https://genderdata.worldbank.org/) makes the latest gender statistics accessible through compelling narratives and data visualizations to improve the understanding of gender data and facilitate analyses that inform policy choices.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1365,"value":"The complete record of Gender Data is available for download in [`.csv`](https://databank.worldbank.org/data/download/Gender_Stats_CSV.zip) and[ Excel](https://databank.worldbank.org/data/download/Gender_Stats_EXCEL.zip) formats as well as being accessible by [API](https://genderdata.worldbank.org/help#access).^{[*](https://genderdata.worldbank.org/help/#access)} Users can access the full dataset, or data for specific indicators within an indicator group, as well as for specific countries, regions, and topics.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1411,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1413,"value":"## Objective","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1367,"value":"This notebook examines the [topic](https://genderdata.worldbank.org/#explore-topics) of [Assets](https://genderdata.worldbank.org/topics/assets). We will walk through how to load in `asset` data and will reproduce the visualizations on the [topic summary page](https://genderdata.worldbank.org/topics/assets).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2980,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2988,"value":"toc(\"h2, h3\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2983,"value":"// This is a little helper function used to generate the Table of Contents\nimport {toc} from '@categorise/toc'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":777,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1415,"value":"## Data Access","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":921,"value":"The Data Portal offers users a few ways to access [Assets](https://genderdata.worldbank.org/topics/assets/) data, including a [list of all asset indicators](https://genderdata.worldbank.org/indicators/#assets), [`.csv` file downloads](https://genderdata.worldbank.org/data/download/zips/assets.zip) and API access via [Databank](https://databank.worldbank.org/source/gender-statistics). The the topic page is also available as [`.pdf`](https://genderdata.worldbank.org/data/download/pdfs/topics/assets.pdf).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1382,"value":"Let's use the [D3.js delimiter-separated value](https://github.com/d3/d3-dsv) module to load in the `.csv` file.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"assets = FileAttachment(\"Assets.csv\").csv({typed: true})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1429,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1431,"value":"## Initial Explorations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1405,"value":"Before we jump into the visualizations, let's get to know our data. A quick way to explore the dataset is to use [Observable's data table cell](https://observablehq.com/@observablehq/data-table-cell). Here it is:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1407,"value":"assets_table = assets","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"assets_table","database":"$undefined"},{"id":1453,"value":"The table view immediately shows us that each data entry consists of just ${[...new Set(assets.flatMap(obj => Object.keys(obj)))].length} variables, namely:\n\n${[...new Set(assets.flatMap(obj => Object.keys(obj)))].sort().map(key => `

${key}

`).join('')}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1513,"value":"There are ${year_group.length} years covered in the data set.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1488,"value":"year_group = [... new Set(d3.flatGroup(assets, d => d[\"Year\"]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1544,"value":"And there are ${countries_group.length} unique entries returned under the 'countries' variable. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1496,"value":"countries_group = d3.flatGroup(assets, d => d[\"Country Name\"])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1584,"value":"$${countries_group.length} sounds pretty high, so let's take a closer look by grouping first by country, and then by indicator (which has the lovely effect of also helping us discover more how indicators are reported across countries).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1580,"value":"While we aren't pulling these out programmatically, spotting the extra `country` entries is pretty quick just by reading the country grouping above. The 'extras' are higher-level aggregations offered for our convenience:\n\n```{langauge:JavaScript}\n \"Arab World\" \n \"East Asia & Pacific\" \n \"East Asia & Pacific (excluding high income)\" \n \"Euro area\" \n \"Europe & Central Asia\" \n \"Europe & Central Asia (excluding high income)\" \n \"High income\" \n \"Latin America & Caribbean \" \n \"Latin America & Caribbean (excluding high income)\"\n \"LMY\" \n \"Low income\" \n \"Lower middle income\" \n \"Middle East & North Africa\" \n \"Middle East & North Africa (excluding high income)\"\n \"MIC\" \n \"North America\" \n \"OECD members\" \n \"South Asia\" \n \"Sub-Saharan Africa \" \n \"Sub-Saharan Africa (excluding high income)\"\n \"Upper middle income\"\n \"World\"\n```","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1568,"value":"Our data are also comprised of ${indicators_group.length} unique indicators.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1515,"value":"indicators_group = [... new Set(d3.flatGroup(assets, d => d[\"Indicator Name\"]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1574,"value":"Not all indicators have values for each year, and not all countries have historically reported all values.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1598,"value":"Grouping first by indicator, then by year, we see which indicators have greater or fewer observations across time.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1528,"value":"indicators_group_year = [... new Set(d3.flatGroup(assets, d => d[\"Indicator Name\"], d => d[\"Year\"]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1640,"value":"Let's identify which indicator has the most observations for a single year:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1608,"value":"indicators_group_year_max = {\nlet maxObservations = 0;\nlet indicatorWithMostObservations;\n\nfor (const entry of indicators_group_year) {\n const observations = entry[2].length;\n if (observations > maxObservations) {\n maxObservations = observations;\n indicatorWithMostObservations = entry[0];\n }\n}\n\nreturn {\n \"Indicator with the most observations in a single year\": indicatorWithMostObservations,\n \"Greatest number of observations in a single year\": maxObservations\n}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1642,"value":"And the fewest:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1645,"value":"indicators_group_year_min = {\nlet minObservations = Infinity;\nlet indicatorWithFewestObservations;\n\nfor (const entry of indicators_group_year) {\n const observations = entry[2].length;\n if (observations < minObservations) {\n minObservations = observations;\n indicatorWithFewestObservations = entry[0];\n }\n}\n\nreturn {\n \"Indicator with the fewest observations in a single year\": indicatorWithFewestObservations,\n \"Least number of observations in a single year (>0)\": minObservations\n};\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1596,"value":"Grouping another way, first by indicator and then by country, helps us to see which indicators have been tracked most regularly across countries and regions.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1532,"value":"indicators_group_year_country = [... new Set(d3.flatGroup(assets, d => d[\"Indicator Name\"], d => d[\"Country Name\"]))]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1652,"value":"indicators_group_year_country_max = {\nlet maxObservations = 0;\nlet indicatorWithMostObservations;\n\nfor (const entry of indicators_group_year_country) {\n const observations = entry[2].length;\n if (observations > maxObservations) {\n maxObservations = observations;\n indicatorWithMostObservations = entry[0];\n }\n}\n\nreturn {\n \"Indicator with the most observations for a single country or region\": indicatorWithMostObservations,\n \"Greatest number of observations for a single country or region\": maxObservations\n}\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1650,"value":"indicators_group_year_country_min = {\nlet minObservations = Infinity;\nlet indicatorWithFewestObservations;\n\nfor (const entry of indicators_group_year_country) {\n const observations = entry[2].length;\n if (observations < minObservations) {\n minObservations = observations;\n indicatorWithFewestObservations = entry[0];\n }\n}\n\nreturn {\n \"Indicator with the fewest observations for a single country or region\": indicatorWithFewestObservations,\n \"Least number of observations for a single country or region\": minObservations\n};\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1604,"value":"Fantastic! With just a few simple pivot-style transformations, we are learning quite a lot about our data. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1524,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1534,"value":"## Reproducing Visualizations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2928,"value":"Now let's have a look at how the World Bank showcases the `assets` dataset. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":933,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2922,"value":"### Account ownership at a financial institution or with a mobile-money-service provider by sex and income group","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2108,"value":"Here's the first visualization on the [`Assets` topic summary](https://genderdata.worldbank.org/topics/assets) page:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2111,"value":"mobile_money_account_by_sex = FileAttachment(\"mobile_money_account_by_sex.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1678,"value":"This visualization shows \\``account ownership at a financial institution or with a mobile-money-service provider by sex and income group`\\`. Data are a weighted average, aggregated and faceted by economy (the income group classification for each country). The visualization helps to compare the male and female values for each region and across regions. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1922,"value":"As we discovered in reviewing the data for [`countries_group`](https://observablehq.com/d/7fb248de83bc0ad4#countries_group), above, the source [`assets`](https://observablehq.com/d/7fb248de83bc0ad4#assets) data file already contains aggregated regional vales. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1891,"value":"aggregated_economies = assets.filter(asset => [\n 'High income',\n 'Upper middle income',\n 'Lower middle income',\n 'Low income'\n].includes(asset['Country Name']))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4498,"value":"We can filter down our `assets` data to focus just on those indicators of interest for our visualization namely `FX.OWN.TOTL.FE.ZS` (Account ownership at a financial institution or with a mobile-money-service provider, female (% of population ages 15+) and `FX.OWN.TOTL.MA.ZS'` (Account ownership at a financial institution or with a mobile-money-service provider, male (% of population ages 15+). Also, because we wish to easily distinguish values by sex, we'll add an additional column to help make this distinction.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1911,"value":"aggregated_account_ownership = assets.filter(asset => {\n const countryNameMatch = [\n 'High income',\n 'Upper middle income',\n 'Lower middle income',\n 'Low income'\n]\n // This bit refines our search for specfic indicators\n .includes(asset['Country Name']);\n const indicatorCodeMatch = [\n 'FX.OWN.TOTL.FE.ZS',\n 'FX.OWN.TOTL.MA.ZS'\n].includes(asset['Indicator Code']);\n return countryNameMatch && indicatorCodeMatch;\n})\n // This bit adds an additional column as a helper, called 'Sex' (for lack of a better word)\n // We use it because it can be dizzying to look at just the indicator codes.\n .map(asset => {\n const Sex = asset['Indicator Code'] === 'FX.OWN.TOTL.FE.ZS' ? 'Female' : 'Male';\n return { Sex, ...asset };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1941,"value":"Before we plot the data, let's quickly review our filtered results and anticipate surprises. For this, let's use the data table cell.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1936,"value":"aggregated_account_ownership_table = aggregated_account_ownership","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"aggregated_account_ownership_table","database":"$undefined"},{"id":1943,"value":"The table view shows us that we have data for multiple years. As we create a dot plot similar to the one on the [Gender Portal `Assets` page](https://genderdata.worldbank.org/topics/assets), which plots values for men and women as dots along a shared access and connects them with a line between each point, we can facet by year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":870,"value":"Plot.plot({\n marginLeft: 150,\n width,\n color: { range: [\"orange\", \"purple\"] },\n fx: { tickFormat: \"d\" },\n x: { domain: [0, 100], ticks: 5 },\n fy: {domain: [\"Low income\",\"Lower middle income\", \"Upper middle income\", \"High income\"] },\n marks: [\n Plot.frame(),\n Plot.ruleY(\n aggregated_account_ownership,\n Plot.groupZ(\n { x1: \"min\", x2: \"max\" },\n { x1: \"Value\", x2: \"Value\", y: null, fx: \"Year\", fy: \"Country Name\" }\n )\n ),\n Plot.dotX(\n aggregated_account_ownership,\n Plot.groupX(\n { x: \"mean\" },\n { x: \"Value\", fill: \"Sex\", r: 5, fx: \"Year\", fy: \"Country Name\", tip: true, }\n )\n )\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1834,"value":"It looks like the visualization on the `Assets` page focuses on values from the most recent year. Here's a recreation of that chart:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2093,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1698,"value":"$2d","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3163,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1837,"value":"Splendid. We have effectively reproduced the visualization. Of course, there's still some room for improvement, but let's keep up the momentum and turn our attention to the next chart.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2100,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2047,"value":"### Saved any money in the past year by sex and income group","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2932,"value":"The second visualization on the [`Assets` topic summary](https://genderdata.worldbank.org/topics/assets) page compares the percent of population above age 15 that saved any money in the past year.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2115,"value":"saved_money_last_year_by_sex = FileAttachment(\"saved_money_last_year_by_sex.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2934,"value":"Reproducing this visualization is a very similar process to our first exercise: just focus on our target indicator and economies.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2128,"value":"aggregated_money_savings_last_year = assets.filter(asset => {\n const countryNameMatch = [\n 'High income',\n 'Upper middle income',\n 'Lower middle income',\n 'Low income'\n]\n // This bit refines our search for specfic indicators\n .includes(asset['Country Name']);\n const indicatorCodeMatch = [\n 'fin18.t.d.1',\n 'fin18.t.d.2'\n].includes(asset['Indicator Code']);\n return countryNameMatch && indicatorCodeMatch;\n})\n // This bit adds an additional column as a helper, called 'Sex' (for lack of a better word)\n // We use it because it can be dizzying to look at just the indicator codes.\n .map(asset => {\n const Sex = asset['Indicator Code'] === 'fin18.t.d.2' ? 'Female' : 'Male';\n return { Sex, ...asset };\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2937,"value":"Before visualizing, let's again have a quick review of the data.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2134,"value":"aggregated_money_savings_last_year_table = aggregated_money_savings_last_year","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"aggregated_money_savings_last_year_table","database":"$undefined"},{"id":2939,"value":"We again have data for multiple years. Let's first plot a simple stacked bar chart with facets for the two years represented in the dataset for the sake of comparison.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2154,"value":"Plot.plot({\n marginLeft: 150,\n width: width*0.9,\n height: 300,\n color: { range: [\"orange\", \"purple\", \"#ccc\"], legend: true, },\n y: {domain: [\"Low income\",\"Lower middle income\", \"Upper middle income\", \"High income\"] },\n marks: [\n Plot.frame({ strokeOpacity: 0.2 }),\n Plot.barX(aggregated_money_savings_last_year, {\n fy: \"Year\",\n x1: \"Value\",\n sort: \"Value\", reverse: true,\n y: \"Country Name\",\n fill: \"Sex\",\n tip: {\n format: {\n Sex: true,\n Value: true,\n y: false,\n x2: false,\n fy: false,\n }\n },\n }),\n Plot.ruleX([0])\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2969,"value":"The values are fairly close between 2014 and 2017, although the reported number of women saving money in 'upper middle income' countries appears to have gone down significantly. Also, the values being returned by the [`assets`](https://observablehq.com/d/7fb248de83bc0ad4#assets) dataset are not the same as those shown in the official visualizations. _This may be something to inquire into later._\n\nFor now, it's time to try to recreate the World Bank visualization.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4538,"value":"Let's first filter the data to focus on the most recent year (2017):","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1713,"value":"aggregated_money_savings_last_year_2017 = aggregated_money_savings_last_year.filter(d => d.Year === 2017);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4540,"value":"And next, let's render the chart:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3486,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3351,"value":"$2e","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3377,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3156,"value":"Excellent.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1682,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2978,"value":"### Men and women who own a house or land by sex","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2993,"value":"This third visualization from the Gender Portal [`Assets` topic summary](https://genderdata.worldbank.org/topics/assets) page is comprised of two scatter plots. The visualization shows distributions of economies by the percentage of men and women who own a house alone, jointly, or both alone and jointly. The chart on the left shows these ownership distributions for houses. The chart on the right shows distributions for land.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2122,"value":"own_house_or_land_by_sex = FileAttachment(\"own_house_or_land_by_sex.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3012,"value":"In order to create this visualization, our data must be encoded with both economy and region so that we can assign colors to the dots. As the source [`assets.csv`](https://observablehq.com/d/7fb248de83bc0ad4#assets) file does not contain this encoding (it provides only regional aggregates; it does not identify country assignments to regions), we must find a reference index. For this, we'll use the World Bank [Country and Lending Groups](https://datahelpdesk.worldbank.org/knowledgebase/articles/906519-world-bank-country-and-lending-groups) classifications.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":607,"value":"country_and_lending_group_classifications = await FileAttachment(\"CLASS.xlsx\").xlsx().then(d => d.sheet(\"List of economies\", {headers: true}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3179,"value":"Before going further, let's pause to verify whether the names of countries/economies in the `country_and_lending_group_classifications` dataset matches those we have for gender `assets`.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3237,"value":"For our comparison, we first want to filter out all the aggregation values for economies, such as '`${country_and_lending_group_classifications[220].Economy}`', so that we're with just the values for countries.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3249,"value":"These are the regional assignments:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2322,"value":"regions = Array.from(new Set(country_and_lending_group_classifications.map(d => d[\"Region\"]))).filter(function( element ) {\n return element !== undefined;\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3252,"value":"And here's the list of economies represented in the `country_and_lending_group_classifications` dataset:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2543,"value":"country_and_lending_group_classification_economies = country_and_lending_group_classifications.filter(({ Region }) => regions.includes(Region)).flatMap(({ Economy }) => Economy);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3186,"value":"The classification dataset comprises ${country_and_lending_group_classification_economies.length} economies— ${country_and_lending_group_classification_economies.length - countries_group.length} more than in our [`assets`](https://observablehq.com/d/7fb248de83bc0ad4#assets) dataset. There are also a a few economies that have slightly different names and spellings. Let's write a function to help us compare these two datasets so that we can see exactly where they differ:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2549,"value":"function compare_country_datasets(source, comparison) {\n const common_countries = Array.from(source).filter(country => comparison.has(country));\n const source_countries = Array.from(source).filter(country => !comparison.has(country));\n const comparison_countries = Array.from(comparison).filter(country => !source.has(country));\n\n return {common_values: common_countries, source_unique: source_countries, comparison_unique: comparison_countries};\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2552,"value":"country_datasets_comparison = compare_country_datasets(new Set(countries_group.map(d => d[0])), new Set(country_and_lending_group_classification_economies))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3284,"value":"Let's take a moment to re-map the names of economies in the `country_and_lending_group_classification_economies` to match those in our `assets` dataset:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3789,"value":"economies_renamed = country_and_lending_group_classifications.map(c => ({ ...c, Economy: { \"Côte d’Ivoire\": \"Cote d'Ivoire\", \"Czech Republic\": \"Czechia\", \"São Tomé and Príncipe\": \"Sao Tome and Principe\", \"Türkiye\": \"Turkiye\" }[c.Economy] || c.Economy }));","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3289,"value":"With this step accomplished, it's time to filter down to our target indicators. We'll start by focusing on house ownership:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2565,"value":"own_house = assets.filter(asset => {\n const countryNameMatch = economies_renamed.some(entry =>\n entry.Economy === asset['Country Name']\n );\n\n const indicatorCodeMatch = [\n 'SG.OWN.HSAL.FE.ZS',\n 'SG.OWN.HSAL.MA.ZS',\n 'SG.OWN.HSJT.FE.ZS',\n 'SG.OWN.HSJT.MA.ZS',\n 'SG.OWN.HSAJ.FE.ZS',\n 'SG.OWN.HSAJ.MA.ZS',\n ].includes(asset['Indicator Code']);\n\n return countryNameMatch && indicatorCodeMatch;\n})\n .map(asset => {\n const isFemaleIndicator = [\n 'SG.OWN.HSAL.FE.ZS',\n 'SG.OWN.HSJT.FE.ZS',\n 'SG.OWN.HSAJ.FE.ZS'\n ].includes(asset['Indicator Code']);\n\n const Sex = isFemaleIndicator ? 'Female' : 'Male';\n\n const classification = economies_renamed.find(c =>\n c.Economy === asset['Country Name']\n );\n\n if (classification) {\n return {\n ...asset,\n Region: classification.Region,\n 'Income group': classification['Income group'],\n Sex\n };\n }\n\n return { ...asset, Sex };\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2572,"value":"own_house_table = own_house","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"own_house_table","database":"$undefined"},{"id":4570,"value":"From the table above, we can quickly see that our filtered data comprises values from across several years—from 2010 to 2020. Some countries report more observations than other, for instance with Senegal reporting the most and Turkey the least. To recreate the World Bank visualization, we'll need to ensure that we're only looking at the most recent year where multiple years are present. We'll also need to combine the reported values for each form of ownership (alone, jointly, or both alone and jointly). \n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4589,"value":"Here's one way to accomplish this:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4574,"value":"$2f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4583,"value":"Let's plot the results and see how close we are...","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2800,"value":"Plot.plot({\n color: { legend: true, range: [\"dodgerblue\", \"magenta\", \"green\", \"purple\" , \"orange\", \"red\", \"gray\"], opacity : 0.8 },\n insetTop: 10,\n insetRight: 10,\n insetBottom: 10,\n insetLeft: 10,\n height: 400,\n width: 500,\n y: { percent: false,domain:[0,100], grid: true },\n x: { percent: false, domain:[0,100], grid: true },\n caption: \"Own House\",\n marks: [\n Plot.dot(own_house_filtered, {\n x: \"Male Value\",\n y: \"Female Value\",\n stroke: \"Region\",\n fill: \"Region\",\n opacity: 0.4,\n channels: {Year: \"Year\", Country: \"Country Name\"},\n tip: true\n }),\n Plot.ruleX([0]),\n Plot.ruleY([0]),\n Plot.link([0], {\n x1: 0,\n y1: 0,\n x2: 100,\n y2: 100,\n strokeDasharray: \"5,3\",\n strokeOpacity: (k) => k === 1 ? 1 : 0.2\n }),\n ],\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4586,"value":"Looking good! Next let's repeat this process focusing on land ownership:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4603,"value":"$30","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4591,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4599,"value":"Plot.plot({\n color: { legend: true, range: [\"dodgerblue\", \"magenta\", \"green\", \"purple\" , \"orange\", \"red\", \"gray\"], opacity : 0.8 },\n insetTop: 10,\n insetRight: 10,\n insetBottom: 10,\n insetLeft: 10,\n height: 400,\n width: 500,\n y: { percent: false,domain:[0,80], grid: true },\n x: { percent: false, domain:[0,80], grid: true },\n caption: \"Own Land\",\n marks: [\n Plot.dot(own_land_filtered, {\n x: \"Male Value\",\n y: \"Female Value\",\n stroke: \"Region\",\n fill: \"Region\",\n opacity: 0.4,\n channels: {Year: \"Year\", Country: \"Country Name\"},\n tip: true\n }),\n Plot.ruleX([0]),\n Plot.ruleY([0]),\n Plot.link([0], {\n x1: 0,\n y1: 0,\n x2: 100,\n y2: 100,\n strokeDasharray: \"5,3\",\n strokeOpacity: (k) => k === 1 ? 1 : 0.2\n }),\n ],\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":319,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4668,"value":"To bring everything together, let's quickly write out the remaining bits of code needed to create a stand-alone legend, then bundle it all up into a HTML component similar to match the World Bank's visualization:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3581,"value":"categories = [\n \"Latin America & Caribbean\",\n \"South Asia\", \n \"Sub-Saharan Africa\",\n \"Europe & Central Asia\",\n \"Middle East & North Africa\",\n \"East Asia & Pacific\",\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3585,"value":"categoricalRange = [\n \"rgba(0, 128, 0, 0.5)\", \"rgba(255, 165, 0, 0.5)\", \"rgba(255, 0, 0, 0.5)\", \"rgba(255, 0, 255, 0.5)\", \"rgba(128, 0, 128, 0.5)\", \"rgba(30, 144, 255, 0.5)\"\n//Green, Orange, Red, Magenta, Purple, Dodger Blue//\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3626,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3562,"value":"$32","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3630,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3632,"value":"And that's a wrap for this visualization.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":990,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4625,"value":"### Law grants spouses equal administrative authority over assets during marriage
& Sons and daughters have equal rights to inherit assets from their parents","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4670,"value":"The fourth and final visualization on the [Gender Data Portal](https://genderdata.worldbank.org/), [Assets topic page](https://genderdata.worldbank.org/topics/assets/), plots two different indicators next to one another as square marks with darker and lighter colors representing 'Yes' and 'No' values. This topic examines the relative equality of men and women with respect to control over family assets. Here's the target visualization:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2119,"value":"marriage_grants_equal_authority = FileAttachment(\"marriage_grants_equal_authority.png\").image()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4673,"value":"We'll start by re-mapping the [`country_and_lending_group_classification_economies`](https://observablehq.com/d/7fb248de83bc0ad4#country_and_lending_group_classification_economies) dataset to create an index of country names that aligns with those in the source `assets` dataset.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2554,"value":"economies_name_map = (() => country_and_lending_group_classification_economies.map((country) => {\n switch (country) {\n case \"Côte d’Ivoire\":\n return \"Cote d'Ivoire\";\n case \"Czech Republic\":\n return \"Czechia\";\n case \"São Tomé and Príncipe\":\n return \"Sao Tome and Principe\";\n case \"Türkiye\":\n return \"Turkiye\";\n default:\n return country;\n }\n}))();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4681,"value":"Next we'll filter the [`assets`](https://observablehq.com/d/7fb248de83bc0ad4#assets) dataset for our target indicators, `SG.LAW.ASST.AR` and `SG.IHT.ASST.PT.EQ`—equal inheritance rights for sons and daughters and equal authority over assets during marriage. For each filtered asset, we'll correct the country name using the mapping provided in `economies_name_map`, then search for the corresponding classification data in `country_and_lending_group_classifications`. If a classification is found, we'll add the 'Region' and 'Income group' properties, otherwise we'll set these properties to null. Finally, we will filtered again to exclude those objects with null 'Region' or 'Income group'. This ensures that only assets with complete classification information are included in our resulting `equal_authority_and_rights array`:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3639,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4732,"value":"Rendering the resulting array into a data table cell, we quickly see that we have data for several years—from 1970 to 2021.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3733,"value":"equal_authority_and_rights_table = equal_authority_and_rights","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"equal_authority_and_rights_table","database":"$undefined"},{"id":4737,"value":"Our target visualization focuses only on data from the most recent year. Let's add one more filter to focus on observations from 2021:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4411,"value":"equal_authority_and_rights_2021 = assets\n .filter(asset => [\n // The law grants spouses equal administrative authority over assets during marriage (1=yes; 0=no)\n 'SG.LAW.ASST.AR',\n // Sons and daughters have equal rights to inherit assets from their parents (1=yes; 0=no)\n 'SG.IHT.ASST.PT.EQ'\n ].includes(asset['Indicator Code']) && asset['Year'] === 2021)\n .map(asset => {\n const correctedCountryName = economies_name_map.find(entry =>\n entry.includes(asset['Country Name'])\n );\n\n const classification = country_and_lending_group_classifications.find(c =>\n c.Economy === correctedCountryName\n );\n\n if (classification) {\n return {\n ...asset,\n Region: classification.Region,\n 'Income group': classification['Income group'],\n };\n }\n\n return {\n ...asset,\n Region: null,\n 'Income group': null,\n };\n })\n .filter(asset => asset['Region'] !== null && asset['Income group'] !== null);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4739,"value":"Using a fairly simple plot, we can already come close to achieving our [target visualization](https://observablehq.com/d/7fb248de83bc0ad4#marriage_grants_equal_authority):","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4421,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4760,"value":"But of course we can go further! With just a bit more data wrangling and some CSS magic, we can reposition and wrap the facets. Here it goes:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4632,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4765,"value":"And now for the final visualization:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4641,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4635,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4767,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4769,"value":"Ta-da! 🎉","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4639,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4663,"value":"## Acknowledgements","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1727,"value":"Thanks to `@fil` for all the time mentoring and for the fantastic Plot demonstrations. Thanks to `@mootarti` for answering my many questions on data wrangling and for the years of encouragement. \n And thanks to `@pstuffa` for showing me many SQL equivalents to the JavaScript used in this notebook. 😊","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4660,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"}],"files":"$W37","stdlib":"1","titling":"auto"}} 2c:"$2b:body" 27:E{"digest":"NEXT_REDIRECT;replace;/@aaronkyle/world-bank-gender-data-portal-assets;307;"}