2f:Tf56,// Copyright 2021-2023 Observable, Inc. // Released under the ISC license. // https://observablehq.com/@d3/bubble-chart function BubbleChart(data, { name = ([x]) => x, // alias for label label = name, // given d in data, returns text to display on the bubble value = ([, y]) => y, // given d in data, returns a quantitative size group, // given d in data, returns a categorical value for color title, // given d in data, returns text to show on hover link, // given a node d, its link (if any) linkTarget = "_blank", // the target attribute for links, if any width = 640, // outer width, in pixels height = width, // outer height, in pixels padding = 3, // padding between circles margin = 1, // default margins marginTop = margin, // top margin, in pixels marginRight = margin, // right margin, in pixels marginBottom = margin, // bottom margin, in pixels marginLeft = margin, // left margin, in pixels groups, // array of group names (the domain of the color scale) colors = d3.schemeTableau10, // an array of colors (for groups) fill = "#ccc", // a static fill color, if no group channel is specified fillOpacity = 0.7, // the fill opacity of the bubbles stroke, // a static stroke around the bubbles strokeWidth, // the stroke width around the bubbles, if any strokeOpacity, // the stroke opacity around the bubbles, if any } = {}) { // Compute the values. const D = d3.map(data, d => d); const V = d3.map(data, value); const G = group == null ? null : d3.map(data, group); const I = d3.range(V.length).filter(i => V[i] > 0); // Unique the groups. if (G && groups === undefined) groups = I.map(i => G[i]); groups = G && new d3.InternSet(groups); // Construct scales. const color = G && d3.scaleOrdinal(groups, colors); // Compute labels and titles. const L = label == null ? null : d3.map(data, label); const T = title === undefined ? L : title == null ? null : d3.map(data, title); // Compute layout: create a 1-deep hierarchy, and pack it. const root = d3.pack() .size([width - marginLeft - marginRight, height - marginTop - marginBottom]) .padding(padding) (d3.hierarchy({children: I}) .sum(i => V[i])); const svg = d3.create("svg") .attr("width", width) .attr("height", height) .attr("viewBox", [-marginLeft, -marginTop, width, height]) .attr("style", "max-width: 100%; height: auto; height: intrinsic;") .attr("fill", "currentColor") .attr("font-size", 10) .attr("font-family", "sans-serif") .attr("text-anchor", "middle"); const leaf = svg.selectAll("a") .data(root.leaves()) .join("a") .attr("xlink:href", link == null ? null : (d, i) => link(D[d.data], i, data)) .attr("target", link == null ? null : linkTarget) .attr("transform", d => `translate(${d.x},${d.y})`); leaf.append("circle") .attr("stroke", stroke) .attr("stroke-width", strokeWidth) .attr("stroke-opacity", strokeOpacity) .attr("fill", G ? d => color(G[d.data]) : fill == null ? "none" : fill) .attr("fill-opacity", fillOpacity) .attr("r", d => d.r); if (T) leaf.append("title") .text(d => T[d.data]); if (L) { // A unique identifier for clip paths (to avoid conflicts). const uid = `O-${Math.random().toString(16).slice(2)}`; leaf.append("clipPath") .attr("id", d => `${uid}-clip-${d.data}`) .append("circle") .attr("r", d => d.r); leaf.append("text") .attr("clip-path", d => `url(${new URL(`#${uid}-clip-${d.data}`, location)})`) .selectAll("tspan") .data(d => `${L[d.data]}`.split(/\n/g)) .join("tspan") .attr("x", 0) .attr("y", (d, i, D) => `${i - D.length / 2 + 0.85}em`) .attr("fill-opacity", (d, i, D) => i === D.length - 1 ? 0.7 : null) .text(d => d); } return Object.assign(svg.node(), {scales: {color}}); }30:[{"id":"3f84439469039a7c6a0555253783e1afcabb24aaa107eebfae36e2efa5de1b0a6f4745674e998b5de2a98ef839c4ff1aa24855c0786ce694722d05d00e9ffb3a","href":"https://static.observableusercontent.com/files/3f84439469039a7c6a0555253783e1afcabb24aaa107eebfae36e2efa5de1b0a6f4745674e998b5de2a98ef839c4ff1aa24855c0786ce694722d05d00e9ffb3a","name":"movie_titles_imdbid_characters_metadata.csv","type":"text/csv","lastModified":1706979825727.995,"size":1029906},{"id":"c7d6af8a2e30406b3ff4b452ffa886084209a31a4fa181e9b41104d8d57539518904a7e76c5d0495f7d761288d22158ef36d8843fa9cd5cb0725a9698cf914a6","href":"https://static.observableusercontent.com/files/c7d6af8a2e30406b3ff4b452ffa886084209a31a4fa181e9b41104d8d57539518904a7e76c5d0495f7d761288d22158ef36d8843fa9cd5cb0725a9698cf914a6","name":"cast.csv","type":"text/csv","lastModified":1706980761447.539,"size":28038725},{"id":"f65553d014f9eaa7a69d6c5e323b461be8357723f9d11e66247ac90ea68bb07824d1b0d20c380ca89e0eecc555a50ecbccb7f961f03e4729a19c502eb17e6b2a","href":"https://static.observableusercontent.com/files/f65553d014f9eaa7a69d6c5e323b461be8357723f9d11e66247ac90ea68bb07824d1b0d20c380ca89e0eecc555a50ecbccb7f961f03e4729a19c502eb17e6b2a","name":"crew.csv","type":"text/csv","lastModified":1706980773359.95,"size":25730875},{"id":"cfbcaffe15ca409f060de8b6a1495b6852765cbd32656d06179a7ab446c607b5ccb5f52c7e50ed29791771332e8bc4a864e45ff75e67d53c6047fd5cb0133869","href":"https://static.observableusercontent.com/files/cfbcaffe15ca409f060de8b6a1495b6852765cbd32656d06179a7ab446c607b5ccb5f52c7e50ed29791771332e8bc4a864e45ff75e67d53c6047fd5cb0133869","name":"ethnics_actor.csv","type":"text/csv","lastModified":1706983444868.8,"size":4242815}] 2d:{"title":"Pandas","cells":[{"id":0,"value":"# Pandas","pinned":false,"hidden":false,"mode":"md"},{"id":210,"value":"## TEAM RETROSPECTIVE\n----\n#### - PLAN\n#### - EXECUTION\n#### - THINGS TO IMPROVE\n\n\n\n\n\n\n\n\n\n\n\n\n\n--","pinned":false,"hidden":false,"mode":"md"},{"id":233,"value":"## ETL & EDA","pinned":false,"hidden":false,"mode":"md"},{"id":245,"value":"SELECT * FROM crew;","pinned":true,"hidden":false,"mode":"sql","output":"","database":"var:crew"},{"id":237,"value":"## RESULTS","pinned":false,"hidden":false,"mode":"md"},{"id":176,"value":"Before:\n - ~600 movies\n - Cast gender\n - Cast credits position\n\nAfter:\n - +45k movies\n - Cast gender\n - Cast credits position\n - Crew gender\n - Ethnicity of the character.\n - Ethnicity of the actor or actress.\n - LGTB related movies","pinned":false,"hidden":false,"mode":"md"},{"id":151,"value":"\n \n \n \n

Metadata Comparison

Before:

\n ${beforeBubbleChart}\n

After:

\n ${afterBubbleChart}\n

\n \n","pinned":false,"hidden":false,"mode":"html"},{"id":184,"value":"ethnics_actor = await FileAttachment(\"ethnics_actor.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":28,"value":"beforeBubbleChart = BubbleChart(Files, {\n label: d => d.id,\n value: d => d.value,\n width: 300,\n //group: d => d.id,\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":127,"value":"afterBubbleChart = BubbleChart(afterdata2, {\n label: d => d.name,\n value: d => d.value,\n width: 300,\n group: d => d.group,\n})","pinned":true,"hidden":false,"mode":"ojs"},{"id":33,"value":"movie_titles_imdbid_characters_metadata = await FileAttachment(\"movie_titles_imdbid_characters_metadata.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":23,"value":"cast = await FileAttachment(\"cast.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":229,"value":"Files = Genero.map((row, index) => {\n return {\n id: row.gender,\n value: row.count }; });","pinned":true,"hidden":false,"mode":"ojs"},{"id":85,"value":"count_gender_cast = cast.reduce((acc, current) => {\n if (current.gender === 2) {\n acc.cast_male = (acc.cast_male || 0) + 1;\n } else if (current.gender === 1) {\n acc.cast_female = (acc.cast_female || 0) + 1;\n } else if (current.gender === 0) {\n acc.cast_unknown = (acc.cast_unknown || 0) + 1;\n }\n return acc;\n}, {});","pinned":true,"hidden":false,"mode":"ojs"},{"id":101,"value":"count_gender_crew = crew.reduce((acc, current) => {\n if (current.gender === 2) {\n acc.crew_male = (acc.crew_male || 0) + 1;\n } else if (current.gender === 1) {\n acc.crew_female = (acc.crew_female || 0) + 1;\n } else if (current.gender === 0) {\n acc.crew_unknown = (acc.crew_unknown || 0) + 1;\n }\n return acc;\n}, {});","pinned":true,"hidden":false,"mode":"ojs"},{"id":116,"value":"count_gender_cast['cast_male']","pinned":true,"hidden":false,"mode":"ojs"},{"id":109,"value":"afterData = [\n {group: \"Cast\", name: \"Cast male\", value: count_gender_cast['cast_male']},\n {group: \"Cast\", name: \"Cast female\", value: count_gender_cast['cast_female']},\n {group: \"Cast\", name: \"Cast ?\", value: count_gender_cast['cast_unknown']},\n {group: \"Crew\", name: \"Crew male\", value: count_gender_crew['crew_male']},\n {group: \"Crew\", name: \"Crew female\", value: count_gender_crew['crew_female']},\n {group: \"Crew\", name: \"Crew ?\", value: count_gender_crew['crew_unknown']}\n]","pinned":true,"hidden":false,"mode":"ojs"},{"id":25,"value":"crew = await FileAttachment(\"crew.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs"},{"id":220,"value":"SELECT \n CASE \n WHEN UPPER(gender) = 'F' THEN 'Female'\n WHEN UPPER(gender) = 'M' THEN 'Male'\n ELSE '?'\n END as gender,\n COUNT(*) as count\nFROM \n movie_titles_imdbid_characters_metadata\nGROUP BY \n UPPER(gender);","pinned":true,"hidden":false,"mode":"sql","output":"Genero","database":"var:movie_titles_imdbid_characters_metadata"},{"id":34,"value":"$2f","pinned":true,"hidden":false,"mode":"ojs"},{"id":128,"value":"import {Swatches} from \"@d3/color-legend\"","pinned":true,"hidden":false,"mode":"ojs"},{"id":187,"value":"afterData","pinned":true,"hidden":false,"mode":"ojs"},{"id":196,"value":"afterdata2=[...afterData]","pinned":true,"hidden":false,"mode":"ojs"},{"id":191,"value":"newObjects = [\n {group: \"Cast\", name: \"White\", value: 245000},\n {group: \"Cast\", name: \"Hispanic\", value: 25000},\n {group: \"Cast\", name: \"Asian\", value: 10000},\n {group: \"Cast\", name: \"Black\", value: 35000},\n {group: \"Cast\", name: \"Other\", value: 15000}\n];\n\n","pinned":true,"hidden":false,"mode":"ojs"},{"id":193,"value":"// Append new objects to the existing array\nafterdata2.push(...newObjects);","pinned":true,"hidden":false,"mode":"ojs"},{"id":201,"value":"afterdata2","pinned":true,"hidden":false,"mode":"ojs"}],"files":"$W30","stdlib":"1","titling":"auto"}