45:["$","title",null,{"children":"🙋‍♀️ Gender bias in politics: the cases of Singapore and Mali | Charlene Chua | Observable"}] 4d:Teab,beeswarm2 = { const radius = 1; const padding = 0.5; const height = 300; const margin = ({ left: 120, right: 120, top: 100, bottom: 0 }) const xAxis = g => g .attr('transform', `translate(0,${height +30 - margin.top})`) .call(d3.axisBottom(x)) .style('font-family', 'DM Sans') const x = d3.scaleLinear() .domain([0,65]) .nice() .range([margin.left, width - margin.right]) const y = d3.scaleBand() .domain(arr) .range([height + margin.bottom -50, margin.top-50]) const svg = d3.create('svg') .attr('viewBox', [0, -30, width, height]); const tooltip = d3 .select("body") .append("div") .attr('id', 'scatterplot-tooltip') .style('position', 'absolute') .style('z-index', '1') .style('visibility', 'hidden') .style('padding', '10px') .style('background', 'rgba(0,0,0,0.6)') .style('border-radius', '4px') .style('color', '#fff'); svg.append('g').call(xAxis); svg.selectAll('.line-consumption') .data(x.ticks()) .join('line') .attr('class', 'line-consumption') .attr('x1', d => x(d)) .attr('x2', d => x(d)) .attr('y1', 10) .attr('y2', height - margin.top +35) .attr('stroke-width', .6) .attr('stroke', 'lightgray'); svg.selectAll('.label-continents') .data(arr) .join('text') .attr('class', 'label-continents') .attr('x', 0) .attr('y', d => y(d)) .style('font-family', 'DM Sans') .style('font-size', '12px') .attr('text-align', 'right') .attr('alignment-baseline', 'right') .text(d => d); const simulation = d3.forceSimulation(selectedRegion) .force('x', d3.forceX((d) => x(d["percentage-women"])).strength(0.3)) .force('y', d3.forceY((d) => y(d["quota"])).strength(0.3)) .stop(); for(let i = 0; i < 300; i++) { simulation.tick(); } simulation.stop(); svg.selectAll('circle') .data(selectedRegion) .join('circle') .attr('cx', d => d.x) .attr('cy', d => d.y) .attr('r', 8) .attr('fill', "#69b3a2") .attr('fill-opacity', 0.4) .on("mouseover", function(e,d) { const tooltipWidth = tooltip.node().offsetWidth; const tooltipHeight = tooltip.node().offsetHeight; tooltip .style("left", e.pageX - tooltipWidth/2 +'px') .style("top", e.pageY-tooltipHeight - 10+'px') .style('visibility', 'visible') .html(`Country: ${d.country}
Percentage of women: ${d["percentage-women"]}%
Total women: ${d["total-women"]}
Quota type: ${d["quota-type"]}
`); d3.select(this).attr("fill", "gray").attr("stroke", "black").attr("stroke-width", 1);}) .on('mousemove', function(e) { const tooltipWidth = tooltip.node().offsetWidth; const tooltipHeight = tooltip.node().offsetHeight; tooltip .style("left", e.pageX - tooltipWidth/2 +'px') .style("top", e.pageY-tooltipHeight - 10+'px') }) .on("mouseout", function(e,d) { tooltip .style('visibility', 'hidden') d3.select(this) .attr("fill", "#69b3a2") .attr("stroke", "none");}) // svg.append("rect") // .attr("x", 539) // .attr("width", 5) // .attr("y", margin.top - 90) // .attr("height", 220) // .attr("fill-opacity", 0.2) // .attr("fill", "#535353"); return svg.node(); }4e:T189f,function lineChart( data, { x = ([x]) => x, // given d in data, returns the (temporal) x-value y = ([, y]) => y, // given d in data, returns the (quantitative) y-value z = () => 1, // given d in data, returns the (categorical) z-value fixedZ = "Singapore", // d in data to always highlight dropdownZ, // selected input from dropdown title, // given d in data, returns the title text defined, // for gaps in data curve = d3.curveLinear, // method of interpolation between points marginTop = 20, // top margin, in pixels marginRight = 30, // right margin, in pixels marginBottom = 30, // bottom margin, in pixels marginLeft = 40, // left margin, in pixels width = 640, // outer width, in pixels height = 400, // outer height, in pixels xType = d3.scaleTime, // type of x-scale xDomain, // [xmin, xmax] xRange = [marginLeft, width - marginRight], // [left, right] yType = d3.scaleLinear, // type of y-scale yDomain, // [ymin, ymax] yRange = [height - marginBottom, marginTop], // [bottom, top] yFormat, // a format specifier string for the y-axis yLabel, // a label for the y-axis zDomain, // array of z-values color = "currentColor", // stroke color of line, as a constant or a function of *z* strokeLinecap, // stroke line cap of line strokeLinejoin, // stroke line join of line strokeWidth = 3, // stroke width of line strokeOpacity = 0.5, // stroke opacity of line mixBlendMode = "multiply", // blend mode of lines voronoi // show a Voronoi overlay? (for debugging) } = {} ) { // Compute values. const X = d3.map(data, x); const Y = d3.map(data, y); const Z = d3.map(data, z); const O = d3.map(data, (d) => d); if (defined === undefined) defined = (d, i) => !isNaN(X[i]) && !isNaN(Y[i]); const D = d3.map(data, defined); // Compute default domains, and unique the z-domain. if (xDomain === undefined) xDomain = d3.extent(X); if (yDomain === undefined) yDomain = [0, d3.max(Y, (d) => (typeof d === "string" ? +d : d))]; if (zDomain === undefined) zDomain = Z; zDomain = new d3.InternSet(zDomain); // Omit any data not present in the z-domain. const I = d3.range(X.length).filter((i) => zDomain.has(Z[i])); // Construct scales and axes. const xScale = xType(xDomain, xRange); const yScale = yType(yDomain, yRange); const xAxis = d3 .axisBottom(xScale) .ticks(width / 80) .tickSizeOuter(0); const yAxis = d3.axisLeft(yScale).ticks(height / 60, yFormat); // Compute titles. const T = title === undefined ? Z : title === null ? null : d3.map(data, title); // Construct a line generator. const line = d3 .line() .defined((i) => D[i]) .curve(curve) .x((i) => xScale(X[i])) .y((i) => yScale(Y[i])); const svg = d3 .create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [0, 0, width, height]) .attr("style", "max-width: 100%; height: auto; height: intrinsic;") .style("-webkit-tap-highlight-color", "transparent") .on("pointerenter", pointerentered) .on("pointermove", pointermoved) .on("pointerleave", pointerleft) .on("touchstart", (event) => event.preventDefault()); // An optional Voronoi display (for fun). if (voronoi) svg .append("path") .attr("fill", "none") .attr("stroke", "#ccc") .attr( "d", d3.Delaunay.from( I, (i) => xScale(X[i]), (i) => yScale(Y[i]) ) .voronoi([0, 0, width, height]) .render() ); svg .append("g") .attr("class", "axis") .attr("transform", `translate(0,${height - marginBottom})`) .call(xAxis); svg .append("g") .attr("class", "axis") .attr("transform", `translate(${marginLeft},0)`) .call(yAxis) .call((g) => g.select(".domain").remove()) .call( voronoi ? () => {} : (g) => g .selectAll(".tick line") .clone() .attr("x2", width - marginLeft - marginRight) .attr("stroke-opacity", 0.1) ) .call((g) => g.attr("class", "axis") .append("text") .attr("x", -marginLeft) .attr("y", 10) .attr("fill", "currentColor") .attr("text-anchor", "start") .text(yLabel) ); const path = svg .append("g") .attr("fill", "none") .attr("stroke", typeof color === "string" ? color : null) .attr("stroke-linecap", strokeLinecap) .attr("stroke-linejoin", strokeLinejoin) .attr("stroke-width", strokeWidth) .attr("stroke-opacity", strokeOpacity) .selectAll("path") .data(d3.group(I, (i) => Z[i])) .join("path") .style("mix-blend-mode", mixBlendMode) .attr("stroke", typeof color === "function" ? ([z]) => color(z) : null) .attr("d", ([, I]) => line(I)); const dot = svg.append("g").attr("display", "none"); dot.append("circle").attr("r", 2.5); dot .append("text") .attr("text-anchor", "middle") .attr("y", -8); function pointermoved(event) { const [xm, ym] = d3.pointer(event); const i = d3.least(I, (i) => Math.hypot(xScale(X[i]) - xm, yScale(Y[i]) - ym) ); // closest point path // .style("stroke", ([z]) => // z === dropdownZ || z === fixedZ || Z[i] === z ? null : "#ddd" // ) .style("stroke", ([z]) => (z === dropdownZ || Z[i] === z ? "grey" : null)) .filter(([z]) => Z[i] === z) .raise(); path .style("stroke-width", (z) => (z === dropdownZ ? 3 : strokeWidth)) .filter(([z]) => z === fixedZ) .raise(); path.filter(([z]) => z === dropdownZ).raise(); dot.attr("transform", `translate(${xScale(X[i])},${yScale(Y[i])})`); if (T) dot.select("text").text(T[i]); svg.property("value", O[i]).dispatch("input", { bubbles: true }); } function pointerentered() { path.style("mix-blend-mode", null).style("stroke", "#ddd"); dot.attr("display", null); } function pointerleft() { path.style("mix-blend-mode", mixBlendMode).style("stroke", null); dot.attr("display", "none"); svg.node().value = null; svg.dispatch("input", { bubbles: true }); } return Object.assign(svg.node(), { value: null }); }4f:[{"id":"2a9e400157cf7224da5fafd19e0d15f4a09deacb024f476564480f8a642b10f55c92f78d3fad40c6dd3db1540cec7e711f488e9374987302573337ab0d7a67dc","href":"https://static.observableusercontent.com/files/2a9e400157cf7224da5fafd19e0d15f4a09deacb024f476564480f8a642b10f55c92f78d3fad40c6dd3db1540cec7e711f488e9374987302573337ab0d7a67dc","name":"Numbers by Regions@3.csv","type":"text/csv","lastModified":1681867201764.2,"size":126},{"id":"fbb98f141760d5e3e4e603e93b1699f92fdfad496bcdf754977398f82cf4fd9450cd1f45d36bb2ae0097e37506ea7e3d0eb2c944f0dc6b0f82351e5e842d1fdf","href":"https://static.observableusercontent.com/files/fbb98f141760d5e3e4e603e93b1699f92fdfad496bcdf754977398f82cf4fd9450cd1f45d36bb2ae0097e37506ea7e3d0eb2c944f0dc6b0f82351e5e842d1fdf","name":"Num_Women_Regions@1.png","type":"image/png","lastModified":1681867278987.408,"size":318713},{"id":"5c2b3771dc103a030f73e48e1899e7ef8e29a07df43d50302908c240de6268301ecbd9c7d9c8ac9e2dd5672e03048b6349fbab05c89dd89f3ad55e18bc4184c9","href":"https://static.observableusercontent.com/files/5c2b3771dc103a030f73e48e1899e7ef8e29a07df43d50302908c240de6268301ecbd9c7d9c8ac9e2dd5672e03048b6349fbab05c89dd89f3ad55e18bc4184c9","name":"Legislatives in Regions@1.csv","type":"text/csv","lastModified":1681867958953.776,"size":532},{"id":"01a5ba6d4ebfacbeb6494bf7e2581b0b9d07924b1c0ae6d597696bdcc31f4095ac87dc344ce929b3ef14b53bd077e8e1e1f772f5f6e3287b697718630103d3e0","href":"https://static.observableusercontent.com/files/01a5ba6d4ebfacbeb6494bf7e2581b0b9d07924b1c0ae6d597696bdcc31f4095ac87dc344ce929b3ef14b53bd077e8e1e1f772f5f6e3287b697718630103d3e0","name":"Legislatives by parties.csv","type":"text/csv","lastModified":1681870347008.257,"size":2641},{"id":"e0262a5a1c7c277422f114810a460196310af25f21506246e5789d79c27b0029381013e4b59343db266c26fdb6cd770f47b064c03200b982a1030641b225d3fd","href":"https://static.observableusercontent.com/files/e0262a5a1c7c277422f114810a460196310af25f21506246e5789d79c27b0029381013e4b59343db266c26fdb6cd770f47b064c03200b982a1030641b225d3fd","name":"Age ranges @1.csv","type":"text/csv","lastModified":1681871230014.494,"size":178},{"id":"e0262a5a1c7c277422f114810a460196310af25f21506246e5789d79c27b0029381013e4b59343db266c26fdb6cd770f47b064c03200b982a1030641b225d3fd","href":"https://static.observableusercontent.com/files/e0262a5a1c7c277422f114810a460196310af25f21506246e5789d79c27b0029381013e4b59343db266c26fdb6cd770f47b064c03200b982a1030641b225d3fd","name":"Age ranges .csv","type":"text/csv","lastModified":1681855568333.012,"size":178},{"id":"55a9b81f449e16af0d90c9b32e490fffbc8e7ad6ca34b89fcff227826127be7279fcaf031012de15b9bf27ff00be7ce2265d7fcc9e02fa373d510a1aa85e1041","href":"https://static.observableusercontent.com/files/55a9b81f449e16af0d90c9b32e490fffbc8e7ad6ca34b89fcff227826127be7279fcaf031012de15b9bf27ff00be7ce2265d7fcc9e02fa373d510a1aa85e1041","name":"Legislatives by parties 2.csv","type":"text/csv","lastModified":1681883873751.673,"size":591},{"id":"5989156861437d7dfadbff936bfb6a18538c7e78949347a99a8e585196b4b7c44060040716b9e27bfd79ebb6cd2277c9d4905387c6f185155a98ea2007040854","href":"https://static.observableusercontent.com/files/5989156861437d7dfadbff936bfb6a18538c7e78949347a99a8e585196b4b7c44060040716b9e27bfd79ebb6cd2277c9d4905387c6f185155a98ea2007040854","name":"Numbers by Regions.csv","type":"text/csv","lastModified":1681863345618.939,"size":169},{"id":"500667d11e1ef3bb30b7032c6e1e955f39001c5e7eda0aeb8d9f35f715c1fb735d3a0acbd331b99d1d4f96fd9486ef0a79c2523d64d7a62b5e854d231decf303","href":"https://static.observableusercontent.com/files/500667d11e1ef3bb30b7032c6e1e955f39001c5e7eda0aeb8d9f35f715c1fb735d3a0acbd331b99d1d4f96fd9486ef0a79c2523d64d7a62b5e854d231decf303","name":"Legislatives by parties 2@1.csv","type":"text/csv","lastModified":1681883964853.837,"size":597},{"id":"c3fa80499640e156e56d4ef2e97f771bd1ad15c9c9685ff79aa2ded6a91e2b020f70634a50bae3689a060b24148421f429bdbbb19451d24d8989f679b93cfee6","href":"https://static.observableusercontent.com/files/c3fa80499640e156e56d4ef2e97f771bd1ad15c9c9685ff79aa2ded6a91e2b020f70634a50bae3689a060b24148421f429bdbbb19451d24d8989f679b93cfee6","name":"generalElectionCandidates20201.csv","type":"text/csv","lastModified":1681637869262.649,"size":48173},{"id":"ec0d65b965ee5a4f5da9dadd1f239bb6c9e8907155fc93bc9fd9e4fd761bd7d87bb039e9d84c8e52c208655db1cefad466d542d078eb42afe13f8085148ed9ba","href":"https://static.observableusercontent.com/files/ec0d65b965ee5a4f5da9dadd1f239bb6c9e8907155fc93bc9fd9e4fd761bd7d87bb039e9d84c8e52c208655db1cefad466d542d078eb42afe13f8085148ed9ba","name":"ipu-historical-data.csv","type":"text/csv","lastModified":1681642556253.463,"size":374209},{"id":"b76432baa054ca1ee5d6321e49ed21581c173abc88832cb4d82ce006eacf815d3e1c852fc4818bf1f9430e065d4fc5d10fb3b5de487ccef3209d219affff7ca4","href":"https://static.observableusercontent.com/files/b76432baa054ca1ee5d6321e49ed21581c173abc88832cb4d82ce006eacf815d3e1c852fc4818bf1f9430e065d4fc5d10fb3b5de487ccef3209d219affff7ca4","name":"ipu-historical-data@1.csv","type":"text/csv","lastModified":1681643117699.707,"size":371506},{"id":"5d5c093e52bed5830736953344761b1e253815cdcd1963ad8223f8122c14ea26aceda08d28f854fb8e550fdc4edeb9a6b4131f8d0005fe2db54297fa036ae467","href":"https://static.observableusercontent.com/files/5d5c093e52bed5830736953344761b1e253815cdcd1963ad8223f8122c14ea26aceda08d28f854fb8e550fdc4edeb9a6b4131f8d0005fe2db54297fa036ae467","name":"ipu-quota-lowerhouse@6.csv","type":"text/csv","lastModified":1681663177299.606,"size":16214}] 49:{"id":"fd2b4ec15b5ecc28","slug":"workshop-1-gender-bias","title":"🙋‍♀️ Gender bias in politics: the cases of Singapore and Mali","thumbnail":"a5b779c709c4631e7320c49c8fa49be3dafc9439cea2ec645a7c2c669a93a2f1","access_level":"public","create_time":"$D2023-03-24T03:23:20.877Z","update_time":"$D2023-04-20T05:27:23.551Z","view_time":null,"first_public_time":"$D2023-03-24T03:23:20.877Z","has_unpublished_edits":null,"fork":{"id":"ee9e4fb45c009de1","slug":"search-table","title":"Search + Table","owner":{"id":"f35c755083683fe5","login":"observablehq","name":"Observable"}},"stars":1,"starred":false,"owner":{"type":"team","id":"05f6a23615a11f71","login":"charlenechua","name":"Charlene Chua","avatar_url":"https://avatars-next.observableusercontent.com/3a6c0c3b7069f0c1f9273ca1a811a0c741b04c3ca9b80ea11cc543446ed8bc74","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1718,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"d376a4bd30c509eb","login":"charlenechua","name":"Charlene Chua","avatar_url":"https://avatars-next.observableusercontent.com/3a6c0c3b7069f0c1f9273ca1a811a0c741b04c3ca9b80ea11cc543446ed8bc74","tier":null,"bio":"","followed_by_you":false,"follows_you":false},{"type":"individual","id":"140f019cf58fe0a2","login":"alexviz","name":"Alex","avatar_url":"https://avatars-next.observableusercontent.com/5559d9536b842b18a62a7727df7a7055b5f49d5f6e921278ed78101ec47d41c0","tier":null,"bio":"","followed_by_you":false,"follows_you":false},{"type":"individual","id":"65453fdc60592afc","login":"makhansacko","name":"Makhan Sacko","avatar_url":"https://avatars-next.observableusercontent.com/ae5a881220581aa95a232175551aee508c2d82abca63777f899886cd6c25bad6","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"140f019cf58fe0a2","login":"alexviz","name":"Alex","avatar_url":"https://avatars-next.observableusercontent.com/5559d9536b842b18a62a7727df7a7055b5f49d5f6e921278ed78101ec47d41c0","tier":null,"role":"editor"},{"type":"individual","id":"d376a4bd30c509eb","login":"charlenechua","name":"Charlene Chua","avatar_url":"https://avatars-next.observableusercontent.com/3a6c0c3b7069f0c1f9273ca1a811a0c741b04c3ca9b80ea11cc543446ed8bc74","tier":null,"role":"editor"},{"type":"individual","id":"65453fdc60592afc","login":"makhansacko","name":"Makhan Sacko","avatar_url":"https://avatars-next.observableusercontent.com/ae5a881220581aa95a232175551aee508c2d82abca63777f899886cd6c25bad6","tier":null,"role":"editor"}],"comments":[{"id":"7a9af796838aa6b0","reply_to_id":null,"content":"need to try figure out how to add tooltips to show percentage","create_time":"$D2023-04-16T09:56:48.729Z","update_time":null,"resolved":true,"user":{"type":"individual","id":"d376a4bd30c509eb","login":"charlenechua","name":"Charlene Chua","avatar_url":"https://avatars-next.observableusercontent.com/3a6c0c3b7069f0c1f9273ca1a811a0c741b04c3ca9b80ea11cc543446ed8bc74","tier":null}},{"id":"6d23b6fce734f3ba","reply_to_id":null,"content":"add a shade for 30-40%","create_time":"$D2023-04-16T15:52:15.525Z","update_time":null,"resolved":true,"user":{"type":"individual","id":"d376a4bd30c509eb","login":"charlenechua","name":"Charlene Chua","avatar_url":"https://avatars-next.observableusercontent.com/3a6c0c3b7069f0c1f9273ca1a811a0c741b04c3ca9b80ea11cc543446ed8bc74","tier":null}}],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":7,"collection":null,"type":"notebook","body":{"titling":"auto","title":"🙋‍♀️ Gender bias in politics: the cases of Singapore and Mali","cells":[{"id":4,"value":"# 🙋‍♀️ Gender bias in politics: the cases of Singapore and Mali","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":530,"value":"This project aims to be an **explorational tool** to explore **political gender bias**. The exploration has two parts: \n1. Size of female representation (regional and international) and\n2. In-depth analysis into Singapore data and what that tells us about gender bias\n\nWe will be narrowing our focus on **active political participation**, specifically, candidates running for election to Parliament/candidates who were elected.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":551,"value":"

Caveat on missing data

\nThe initial goal was to have in-depth comparison of both Singapore and Mali. However, both countries do not have official datasets on candidates and information on candidates who ran in their latest election. This lack of data itself represents the challenges that we confront when we want to study gender bias. It is an additional barrier to studying such an issue.\n\nFor this analysis and project, the team built our own dataset for Singapore's latest elections in 2020. Some information could not be found online, and this was listed as 'unknown'. There is no counterpart dataset for Mali as much of the data couldn't be found online.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":540,"value":"

The Data

\n1. [IPU data for international countries](https://data.ipu.org/women-ranking?month=3&year=2023) & IPU [historical data](https://data.ipu.org/historical-women)\n2. [Gender quotas dataset](https://www.idea.int/data-tools/data/gender-quotas/database)\n3. Singapore 🇸🇬 [2020 elections candidates dataset](https://docs.google.com/spreadsheets/d/1JDY4aQ11uXGZtzR7HabSSoT5WuFMyk-ri80tQAs4G3k/edit#gid=1577871075) we built from scratch","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":555,"value":"await FileAttachment(\"generalElectionCandidates20201.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":569,"value":"

Part #1: Analysing female representation across regions and internationally

\n\n**Overall female representation in Parliament has improved over the years. However, the change is not even across countries** \n\nFurther in this section, we'll also see if quotas have impacted the proportion of female representation.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":579,"value":"In the charts below, Singapore and Mali will be shown in red for each of their respective region. The lines aren't the neatest as different countries have different election cycles and, sometimes, gaps in election periods.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1104,"value":"Use the dropdown option to highlight another country. Hover over to compare any country of interest.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1041,"value":"### Proportion of female Members of Parliament in **Asia**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":620,"value":"viewof countryAsia = Inputs.select([... new Set(ipuHistoricalFiltered.filter(d => d.region === \"ASIA\").map(d => d.country))], {label: \"Country\", multiple: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":736,"value":"Asia = lineChart(ipuHistoricalFiltered.filter(d => d[\"region\"] == \"ASIA\"), {\n x: d => +d.year,\n y: d => d[\"percentage-women\"],\n z: d => d.country,\n title: d => d.country + \", \"+ d[\"percentage-women\"] + \"%\",\n fixedZ: \"Singapore\",\n dropDownZ: countryAsia,\n yLabel: \"Proportion (%) - Single or Lower Chamber\",\n yDomain: [0,100],\n width,\n height: 500,\n color: (z) => z === countryAsia ? \"cyan\" : z === \"Singapore\" ? \"red\" : \"#ddd\",\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1069,"value":"### Proportion of female Members of Parliament in **Sub-Saharan Africa**","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1077,"value":"viewof countryAfrica = Inputs.select([... new Set(ipuHistoricalFiltered.filter(d => d.region === \"SUB-SAHARAN\").map(d => d.country))], {label: \"Country\", multiple: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1054,"value":"Africa = lineChart(ipuHistoricalFiltered.filter(d => d[\"region\"] == \"SUB-SAHARAN\"), {\n x: d => +d.year,\n y: d => d[\"percentage-women\"],\n z: d => d.country,\n title: d => d.country + \", \"+ d[\"percentage-women\"] + \"%\",\n fixedZ: \"Mali\",\n dropDownZ: countryAfrica,\n yLabel: \"Proportion (%) - Single or Lower Chamber\",\n yDomain: [0,100],\n width,\n height: 500,\n color: (z) => z === countryAfrica ? \"cyan\" : z === \"Mali\" ? \"red\" : \"#ddd\",\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1415,"value":"Across regions, most countries have 20% or less female representation in Parliament. The pace of progress is varied; some like Madagascar and Singapore slowly increasing their proportion, while others like Cambodia have seen a decline.\n\nThe biggest strides are seen amongst African countries, with Rwanda leading the way and even obtaining a female majority. This was brought about by a number of special measures, including a 2003 Constitution that set a 30% quota for women in elected positions.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":720,"value":"

So do quotas work?

Part #2: Guided in-depth analysis into Singapore's 🇸🇬 political gender bias

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":71,"value":"We'll be analysing the proportion of female candidates running for Singapore Parliament, the nations decision making body. For context: All genders in the database are either male (M) or female (F). Singapore has no candidate who's openly non-binary. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":74,"value":"**Female candidates are a minority, forming about a fifth of a total of 192 candidates.**
\nThe disparity is wider when we apply an intersectionality lens and filter for minority race representation i.e. non-Chinese","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":102,"value":"viewof race = Inputs.select([... new Set(gecandidates_race.map(d => d.race))], {label: \"Race\", multiple: false})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"overallProp.legend(\"color\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"overallProp = Plot.plot({\n x: {\n percent: true\n },\n marks: [\n Plot.barX(gecandidates_race.filter(d => d.race === race), Plot.stackX(Plot.groupZ({x: \"proportion\", title: (d) => `Actual count: ${d.length}`}, {fill: \"gender\"}))),\n Plot.ruleX([0, 1])\n ], color: { scheme: \"pastel2\"}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":139,"value":"Moreover, the **spread of female candidates is uneven**. Some political parties remain male-only.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":128,"value":"Plot.plot({ \n y: {\n grid: true,\n percent: true\n },\n marks: [\n Plot.barY(polParty, {y: \"genderProp\", x: \"party-2020\", title: (d) =>\n `${d[\"party-2020\"]} \\n Percentage: ${Math.round(d.genderProp*100)}% \\n Actual count: ${d.count}`, fill: \"gender\",sort:{x:\"y\", reverse:true}}),\n Plot.ruleY([0])\n ], color: { scheme: \"pastel2\"}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"Low female proportion also plays out among elected members of parliament who are also **political office holders**.\nIn fact, out of 27 female elected candidates, only 3 of them are cabinet members. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":340,"value":"Plot.plot({ marginLeft: 200,\n y: { domain: ['Prime Minister','Deputy Prime Minister','Senior Minister','Minister', 'Senior Minister of State', 'Minister of State','Senior Parliamentary Secretary'] },\n marks: [\n Plot.barX(position, {x: \"count\", y: \"highest_pos_if_pol_appointee\", title: \"count\", fill: \"gender\", }),\n Plot.ruleX([0]),\n ], color: { scheme: \"pastel2\"}, \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"**Most candidates are married and many use this martial status to show themselves as a \"family person\" in their campaigns.** However, a higher proportion of female candidates are single, relative to male candidates (even if we were to assume that those with \"unknown\" status are also legally single). This suggests that as a female, being married is something that costs them more than males.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":227,"value":"addTooltips(Plot.plot({\n x: {\n percent: true\n }, label: \"Proportion for female candidates (%)\",\n marks: [\n Plot.barX(generalElectionCandidates20201.filter(d => d.gender === \"F\"), Plot.stackX(Plot.groupZ({x: \"proportion\", title: d => `Actual count: ${d.length}`}, {fill: \"relationship-status\"}))),\n Plot.text(generalElectionCandidates20201.filter(d => d.gender === \"F\"), Plot.stackX(Plot.groupZ({x: \"proportion\", text: \"first\"}, {z: \"relationship-status\", text: \"relationship-status\"}))),\n Plot.ruleX([0, 1])\n ], color: { scheme: \"pastel2\"}\n}))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":234,"value":"Plot.plot({\n x: {\n percent: true\n }, label: \"Proportion for male candidates (%)\",\n marks: [\n Plot.barX(generalElectionCandidates20201.filter(d => d.gender === \"M\"), Plot.stackX(Plot.groupZ({x: \"proportion\", title: d => `Actual count: ${d.length}`}, {fill: \"relationship-status\"}))),\n Plot.text(generalElectionCandidates20201.filter(d => d.gender === \"M\"), Plot.stackX(Plot.groupZ({x: \"proportion\", text: \"first\"}, {z: \"relationship-status\", text: \"relationship-status\"}))),\n Plot.ruleX([0, 1])\n ], color: { scheme: \"pastel2\"}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":652,"value":"Compared to male candidates, more female candidates do not have children. This could also imply that there is gender bias as the weight/responsibility of having children for female is more than male.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":644,"value":"Plot.plot({\n x: {\n percent: true\n }, label: \"Proportion of male candidates with children (%)\",\n marks: [\n Plot.barX(generalElectionCandidates20201.filter(d => d.gender === \"M\"), Plot.stackX(Plot.groupZ({x: \"proportion\", title: d => `Actual count: ${d.length}`}, {fill: \"children\"}))),\n Plot.text(generalElectionCandidates20201.filter(d => d.gender === \"M\"), Plot.stackX(Plot.groupZ({x: \"proportion\", text: \"first\"}, {z: \"children\", text: \"children\"}))),\n Plot.ruleX([0, 1])\n ], color: { scheme: \"pastel2\"}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":646,"value":"Plot.plot({\n x: {\n percent: true\n }, label: \"Proportion of female candidates with children (%)\",\n marks: [\n Plot.barX(generalElectionCandidates20201.filter(d => d.gender === \"F\"), Plot.stackX(Plot.groupZ({x: \"proportion\", title: d => `Actual count: ${d.length}`}, {fill: \"children\"}))),\n Plot.text(generalElectionCandidates20201.filter(d => d.gender === \"F\"), Plot.stackX(Plot.groupZ({x: \"proportion\", text: \"first\"}, {z: \"children\", text: \"children\"}))),\n Plot.ruleX([0, 1])\n ], color: { scheme: \"pastel2\"}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":330,"value":"**A greater proportion of female candidates have backgrounds in charity/social service relative to male candidates.** But the top professional background is business for both male and female candidates. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":254,"value":"Plot.plot({\n marginLeft: 200,\n //facet: {data: background, y: \"gender\", marginRight: 80}, \n y: {domain: d3.sort(background, d => -d.count).map(d => d.background)},\n grid: true,\n marks: [\n Plot.barX(background, {x: \"count\", y: \"background\", title: \"count\", fill: \"gender\"}),\n Plot.ruleX([0]),\n ], color: { scheme: \"pastel2\"}, \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":78,"value":"**Ministry portfolio of members of parliament who are also political office holders**: No female representation in Defence, but a relatively higher female representation (40% vs 33%) in Home Affairs (policing and internal security), National Development (national land use planning and development), and Sustainability and the Environment (environment, and water and food supplies)\n\nJosephine Teo is the Minister-in-charge of Smart Nation and Cybersecurity, the only area that's owned by a female MP. This is related to her duties as Minister of Communications and Information.\n\nNote: Economic Policies, National Security, and Social Policies do not refer to ministries, but to areas overseen by the three Senior Ministers as part of special appointments.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":397,"value":"Plot.plot({ marginLeft: 200,\n marks: [\n Plot.barX(portfolio, {x: \"count\", y: \"portfolio\", fill: \"gender\", title:\"count\", sort:{y:\"x\", reverse:true}}),\n Plot.ruleX([0]),\n ], color: { scheme: \"pastel2\"}, \n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1313,"value":"

Part #3: Guided in-depth analysis into Mali's political gender bias

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1481,"value":"numbersByRegions3 = await FileAttachment(\"Numbers by Regions@3.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"numbersByRegions3","database":"$undefined"},{"id":1489,"value":"legislativesInRegions1 = await FileAttachment(\"Legislatives in Regions@1.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"legislativesInRegions1","database":"$undefined"},{"id":1585,"value":"legislativesByParties21 = await FileAttachment(\"Legislatives by parties 2@1.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"legislativesByParties21","database":"$undefined"},{"id":1563,"value":"ageRanges1 = await FileAttachment(\"Age ranges @1.csv\").csv({typed: \"auto\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"ageRanges1","database":"$undefined"},{"id":1645,"value":"**In this section, we analyze female participation in Mali's legislative election from 1997 to 2020**. For this period, we collected data on the number of elected PMs, their regions in Mali, their age range, and their parties.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1654,"value":"Among the 9 regions of Mali, between 1997 and 2020, **Segou is the region with the most female PMs, followed by Bamako, and Koulikoro**. The population of Timbuktu, Gao, and Kidal, in the northern region of Mali, are practically not represented by women. Kayes has emerged, in the West, after the application of the quota system (**Law 2015-052**).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1620,"value":"Plot.plot({\ny: {\n grid: true,\n},\n marks: [\n Plot.barY(numbersByRegions3, {x: \"Regions\", y: \"Number of elected Women\", fill: \"Grey\", title: \"Number of elected Women\", sort:{x:\"y\", reverse:true}}),\n Plot.ruleY([0])],\n tooltip: {\n fill: \"Green\",\n stroke: \"yellow\",\n r: 8\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1486,"value":"num_women_regions1 = FileAttachment(\"Num_Women_Regions@1.png\").image()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1657,"value":"What we found interested in the graph below is the surge in women participation in the 2020. The reason is the application of the 30% quota in Mali. In fact, between 1997 and 2018 the average female participation in the parliament was about 10%. **In the 2020 it surged to 28.5%, a record in Mali**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1498,"value":"Plot.plot({\n y: {\n grid: true\n },\n marks: [\n Plot.line(legislativesInRegions1, {x: \"Years\", y: \"Number of elected Women\", z: \"Regions\", title: \"Regions\"})\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1661,"value":"When it comes to the parties elected women belong to, we noticed that **ADEMA-PASJ, RPM, and URD are the ones that most inclusive**.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":1591,"value":"Plot.plot({\n marginLeft: 100,\n marks: [\n Plot.barX(legislativesByParties21, {x: \"Counts\", y: \"Parties\", title: \"Years\", fill: \"Years\", sort:{y:\"x\", reverse:true}})\n ],\n tooltip: {\n fill: \"red\",\n stroke: \"blue\",\n r: 8\n },\ncolor: {\n type: \"linear\", scheme: \"Blues\", legend: true\n}\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1639,"value":"Inputs.table(ageRanges1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"## Appendix (Imports)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":95,"value":"import { aq, op } from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":468,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":693,"value":"import {addTooltips} from \"@mkfreeman/plot-tooltip\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":609,"value":"ipuHistorical = FileAttachment(\"ipu-historical-data@1.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":630,"value":"ipuHistoricalFiltered = aq.from(ipuHistorical).filter(aq.escape( d => [\"Lower\", \"Single\"].includes(d[\"chamber-type\"]) ) ).derive({year: aq.escape(d => new Date(d.year,0,1))}).objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":611,"value":"ipuHistoricalbyCountry = aq.from(ipuHistorical).filter(d => d[\"chamber-type\"] == \"Lower\").groupby(\"country\").objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":747,"value":"ipuQuota = FileAttachment(\"ipu-quota-lowerhouse@6.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":756,"value":"arr = [\"Yes\", \"No\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":944,"value":"selectedRegion = ipuQuota.filter(d => d.region===Region);","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"generalElectionCandidates20201 = FileAttachment(\"generalElectionCandidates20201.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":701,"value":"gecandidates_race = aq.from(generalElectionCandidates20201).derive({race: d => d.race === \"Indo-Aryan\" ? \"Other\" : d.race === \"Indian-Chinese\" ? \"Indian\" : d.race}).objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1220,"value":"polParty = aq.from(generalElectionCandidates20201).select(\"party-2020\",\"gender\").groupby(\"party-2020\", \"gender\").count().groupby(\"party-2020\").derive({genderProp: d => d.count/op.sum(d.count)}).orderby(\"party-2020\", \"gender\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"background = aq.from(generalElectionCandidates20201).select(\"gender\", \"background\").groupby(\"background\",\"gender\").count().groupby(\"background\").pivot(\"gender\",\"count\").impute({ \"F\": () => 0 }).fold(['F', 'M'], { as: ['gender', 'count'] }).objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":336,"value":"position = aq.from(generalElectionCandidates20201).filter(d => d[\"Political-appointee\"] == \"Y\").select(\"gender\", \"highest_pos_if_pol_appointee\").groupby(\"highest_pos_if_pol_appointee\",\"gender\").count().groupby(\"highest_pos_if_pol_appointee\").pivot(\"gender\",\"count\").impute({ \"F\": () => 0 }).fold(['F', 'M'], { as: ['gender', 'count'] }).objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":387,"value":"portfolio = aq.from(generalElectionCandidates20201).filter(d => d[\"Political-appointee\"] == \"Y\").select(\"gender\", \"portfolio\").derive({ portfolio: d => op.split(d.portfolio, '_')}).unroll(\"portfolio\").derive({ portfolio: d => op.trim(d.portfolio)}).groupby(\"portfolio\",\"gender\").count().groupby(\"portfolio\").pivot(\"gender\",\"count\").impute({ \"F\": () => 0, \"M\": () => 0}).fold(['F', 'M'], { as: ['gender', 'count'] }).objects()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":734,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1328,"value":"style = html`\n\n\n\n`","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4f","stdlib":"1"}} 44:null