2d:null 2e:["$","title",null,{"children":"Diving into the Waters of Shark Tank India | Akhila Sulgante | Observable"}] 33:T960,//Y : Sum function createParticipationChart({data,x,y,z,color,xLabel=" ",yLabel=" ",zLabel=" ",defaultValue="",colorLabel=" ",xtickCount=1,zCondition=[],rollupData,increasingData,decreasingData,zValue}){ const selector = vl5 .selectPoint() .on("mouseover") .nearest(true) .fields(color) .init({ [color]: defaultValue}); const chart=(data) => { const LineChart = vl5.markLine({ tooltip: true, point: true, cursor: "pointer" }) .encode( vl5.y().sum(y).title(yLabel).scale({domain:[0,45]}), vl5.x().fieldQ(x).axis({ tickCount: xtickCount }).title(xLabel), vl5.color().fieldN(color).title(colorLabel), vl5.opacity().if(selector, vl5.value(1)).value(0.2) ); const Point = vl5 .markPoint() .params(selector) .encode( vl5.y().sum(y).title(yLabel).axis({range:[0,45]}), vl5.x().fieldQ(x).axis({ tickCount: xtickCount }).title(xLabel), vl5.color().fieldN(color).title(colorLabel), vl5.opacity().if(selector, vl5.value(1)).value(0.2) ) const Label = vl5 .markText({ dx: +10, align: "left" }) .transform( vl5.filter(selector) ) .encode( vl5.y().sum(y).title(yLabel).axis({range:[0,45]}), vl5.x().fieldQ(x).axis({ tickCount: xtickCount }), vl5.color().fieldN(color), vl5.text().fieldN(color) ); return vl5.layer(LineChart,Point,Label).data(data) } //Z-axis const zTitle = vl5.markText( {dx: +40, align: "center",fontSize:20}).encode(vl5.text().value(zLabel)).data([{}]).width(width/3) const zText = vl5 .markText({ dx: +10, align: "left", cursor: "pointer", point: true }) .encode( vl5.y().fieldN(z).axis(null), vl5.text().field(zValue), vl5.color({condition:zCondition}) ).width(width/3); const zPoint = vl5.markPoint().markPoint({ cursor: "pointer" }) .encode(vl5.y().fieldN(z), vl5.text().field(zValue)).width(width/3); const zLayer = vl5.vconcat(zTitle,vl5 .layer(zText, zPoint)) .transform(vl5.filter(selector)) .data(rollupData); const increasingChart = chart(increasingData).height(500).width(width/7).title(`${colorLabel} With Increased Pitches`) const decreasingChart = chart(decreasingData).height(500).width(width/7).title(`${colorLabel} With Decreased Pitches`) return vl5.concat(increasingChart,zLayer,decreasingChart).config({ view: { stroke: null } }).render() }34:T44c,rolledUpIndustryData = { let industries_ = industries let data = rawData.map(d=>{return {...d}}) let res = [] let rollup_data = d3.rollup(data,v=>v.length,d=>d["Pitchers State"],d=>d["Industry"],d=>d["Season Number"]) for(let [state,value] of rollup_data.entries()){ for(let industry of industries_){ if (!value.has(industry)){ res.push({ "Pitchers State": state ? state: "State Unkown", "Industry":industry, diff:0, label : `${state} (No Company)`, "Season 1":0, "Season 2":0 }) } else{ const diff = (value.get(industry).get(2) || 0) - (value.get(industry).get(1) || 0) res.push({ "Pitchers State": state ? state: "State Unkown", "Industry":industry, diff, label : diff > 0 ? `${state} ⬆️ ${diff}` : (diff!=0) ?`${state} ⬇️ ${diff}` : `${state} (No difference)`, "Season 1":value.get(industry).get(1) || 0, "Season 2":value.get(industry).get(2) || 0 }) } } } return res }35:T455,rolledUpStateData = { let industries_ = industries let data = rawData.map(d=>{return {...d}}) let res = [] let rollup_data = d3.rollup(data,v=>v.length,d=>d["Pitchers State"],d=>d["Industry"],d=>d["Season Number"]) for(let [state,value] of rollup_data.entries()){ for(let industry of industries_){ if (!value.has(industry)){ res.push({ "Pitchers State": state ? state: "State Unkown", "Industry":industry, diff:0, label : `${industry} (No Company)`, "Season 1":0, "Season 2":0 }) } else{ const diff = (value.get(industry).get(2) || 0) - (value.get(industry).get(1) || 0) res.push({ "Pitchers State": state ? state: "State Unkown", "Industry":industry, diff, label : diff > 0 ? `${industry} ⬆️ ${diff}` : (diff!=0) ?`${industry} ⬇️ ${diff}` : `${industry} (No difference)`, "Season 1":value.get(industry).get(1) || 0, "Season 2":value.get(industry).get(2) || 0 }) } } } return res }36:Te53,{ const highlight = vl.selectSingle("highlight") .fields("Conditions") .on("mouseover") .init({"Conditions":[]}) .empty("none") // .nearest(true); const dealsBySharks = Array.from(dealsbyShark.entries()) .map(row => ({ "Conditions": row[0], "Count": row[1].length, "Prevalence": row[1].length / rawData.length })); const dealsByEachSharks = dealsBySharks .map(row => row["Conditions"] .split(", ") .map((s, _, all) => ({ "Condition": s, "Conditions": row["Conditions"], "Count": row.Count, "Prevalence": row.Prevalence, "Degree": all.length }) ) ).flat(); const sortAttr = sortBy === "Degree" ? vl.max().field("Degree").order("descending") : vl.fieldQ("Prevalence").order("descending"); const barChart = vl .data(dealsBySharks) .encode( vl.x().fieldN("Conditions") .sort(sortAttr) .axis(null), vl.y().fieldQ("Prevalence") .title("Prevalence of Intersection %" ) .axis({format : ".2%", orient: "right"}), vl.tooltip(["Conditions", "Prevalence", "Count", "Degree"]) ) .layer( vl.markBar({tooltip: true}) .select(highlight) .encode( vl.color().value(defaultColor) .if(highlight, vl.value("firebrick")) ), vl.markText({dy: -5, fontSize: 8}) .encode( vl.text() .fieldQ("Prevalence") .title("Prevalence of Intersection %") .format(".1%") ) ) // .width({step: 20}) .height(200); const circles = vl.markCircle({tooltip: true, size:100, opacity: 1}) .encode( vl.x().fieldN("Conditions") .sort(sortAttr) .axis(null), vl.y() .fieldN("Condition") .sort(vl.max("Prevalence").order("descending")) .title(null), vl.tooltip(["Conditions", "Condition", "Degree", "Count"]) ); const dotsIntersectionChart = vl .data(dealsByEachSharks) .layer( circles .markLine({ size: 5}) // Intersecting lines .encode( vl.y() .fieldN("Condition") .sort(vl.max("Prevalence").order("descending")), vl.y2().fieldN("Condition"), vl.color().value(defaultColor) .if(highlight, vl.value("firebrick")), vl.detail().fieldN("Conditions") ), circles .select(highlight) .encode( vl.color().fieldN("Condition") .scale({scheme: "category20"}) .legend(null) // vl.color().value(defaultColor) .if(highlight, vl.value("firebrick")) ), ); const countBySymBase = vl .markBar( { tooltip: true}) .data(dealsBySharks) .encode( vl.x().max("Prevalence").title("Prevalence of Condition %").axis({format : ".2%"}), vl.y().fieldN("Condition") .sort(vl.max("Prevalence").order("descending")) .title(null), vl.color().fieldN("Condition").scale({scheme: "category20"}).legend(null), vl.tooltip(["Condition", vl.max("Count"), vl.max("Prevalence")]) ) .width(150); return vl.vconcat( barChart, dotsIntersectionChart ) .resolve({scale: {x: "shared"}}) .spacing(0) .config( { stroke: null }) .title({ text: `Investment pattern`, subtitle: `%s out of ${rawData.length} filtered people` }) .render() }37:Tf35,sharks_total_investments = { const highlight = vl .selectSingle("highlight") .fields("Conditions") .on("mouseover") .init({ Conditions: [] }) .empty("none"); // .nearest(true); const dealsBySharks = Array.from(dealsbyShark.entries()).map((row) => ({ Conditions: row[0], Count: row[1].length, Prevalence: row[1].length })); const dealsByEachSharks = dealsBySharks .map((row) => row["Conditions"].split(", ").map((s, _, all) => ({ Condition: s, Conditions: row["Conditions"], Count: row.Count, Prevalence: row.Prevalence, Degree: all.length, url: images[s] })) ) .flat(); const sortAttr = sortBy === "Degree" ? vl.max().field("Degree").order("descending") : vl.fieldQ("Prevalence").order("descending"); const barChart = vl .data(dealsBySharks.filter(d=>d.Conditions.split(",").length === maxCount)) .encode( vl.y().fieldN("Conditions").sort(sortAttr).axis(null), vl .x() .fieldQ("Prevalence") .title("Count of companies") .axis({ orient: "top"}), vl.tooltip(["Count"]) ) .layer( vl .markBar({ tooltip: true }) .select(highlight) .encode( vl.color().value(defaultColor).if(highlight, vl.value("firebrick")) ).width(width/2.5), vl .markText({ dx: +15, fontSize: 8 }) .encode( vl .text() .fieldQ("Prevalence") .title("Count of companies") // .format(".1%") ) ); // .width({step: 20}) // .height(200); const circles = vl .markImage({ tooltip: true, size: 100, opacity: 1 }) .encode( vl.y().fieldN("Conditions").sort(sortAttr).axis(null), vl .x().axis({labelAngle:-45}) .fieldN("Condition") .sort(vl.max("Prevalence").order("descending")) .title(null), vl.url().field("url"), vl.tooltip(["Conditions", "Condition", "Degree", "Count"]) ).width(width/2); const dotsIntersectionChart = vl .data(dealsByEachSharks.filter((d) => d.Degree == maxCount)) .layer( circles .markLine({ size: 5 }) // Intersecting lines .encode( vl .x() .fieldN("Condition") .sort(vl.max("Prevalence").order("descending")) .axis({ orient: "top" }) .title(null), vl.x2().fieldN("Condition").title(null), vl.color().value(defaultColor).if(highlight, vl.value("firebrick")), vl.detail().fieldN("Conditions") ), circles.select(highlight).encode( vl .color() .fieldN("Condition") .scale({ scheme: "category20" }) .legend(null) .title(null) // vl.color().value(defaultColor) .if(highlight, vl.value("firebrick")) ) ) .width(width); // const countBySymBase = vl // .markBar({ tooltip: true }) // .data(dealsBySharks) // .encode( // vl // .y() // .max("Prevalence") // .title("Prevalence of Condition %") // .axis({ format: ".2%" }), // vl // .x() // .fieldN("Condition") // .sort(vl.max("Prevalence").order("descending")) // .title(null), // vl // .color() // .fieldN("Condition") // .scale({ scheme: "category20" }) // .legend(null), // vl.tooltip(["Condition", vl.max("Count"), vl.max("Prevalence")]) // ) // .width(width - 200); return vl .hconcat( dotsIntersectionChart.height(400).width(width * 0.3), barChart.width(width * 0.6) ) .resolve({ scale: { y: "shared" } }) .spacing(0) .config({ stroke: null }) .title({ text: `Investment Patterns`, }) .render({renderer:"svg"}); }38:[{"id":"9e857407ef46bff69fe596b07e4c3e12920c01f740d840e646bdac888ee172a1db13ae87ad0e373089b7189a2df3c8f3c41a1d8f2e8da5d0d375ce8a4714c073","href":"https://static.observableusercontent.com/files/9e857407ef46bff69fe596b07e4c3e12920c01f740d840e646bdac888ee172a1db13ae87ad0e373089b7189a2df3c8f3c41a1d8f2e8da5d0d375ce8a4714c073","name":"archive.zip","type":"application/zip","lastModified":1681171016411.994,"size":20147}] 31:{"id":"a57d156e4a45b84c","slug":"diving-into-the-waters-of-shark-tank-india","title":"Diving into the Waters of Shark Tank India","thumbnail":"6fcef9d95bc9c8f944d1efae917b21a3bd526da88afc9d31f211259b697659f4","access_level":"public","create_time":"$D2023-04-10T23:56:56.411Z","update_time":"$D2023-04-26T18:25:28.119Z","view_time":null,"first_public_time":"$D2023-04-10T23:56:56.411Z","has_unpublished_edits":null,"fork":{"id":"a860ca0bef55914e","slug":"projectprogressreport","title":"Diving into the Waters of Shark Tank India","owner":{"id":"e76678b312b62ab3","login":"akhila","name":"Akhila Sulgante"}},"stars":0,"starred":false,"owner":{"type":"team","id":"e76678b312b62ab3","login":"akhila","name":"Akhila Sulgante","avatar_url":"https://avatars-next.observableusercontent.com/2e264e285632a44937edf6eb6b531fffbd152d07233e70f4c70c2cd9a5cd9e09","tier":"starter_2024"},"version":3289,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"667daa7e86be0e8e","login":"akhila","name":"Akhila Sulgante","avatar_url":"https://avatars-next.observableusercontent.com/2e264e285632a44937edf6eb6b531fffbd152d07233e70f4c70c2cd9a5cd9e09","tier":null},{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null}],"members":[{"type":"individual","id":"667daa7e86be0e8e","login":"akhila","name":"Akhila Sulgante","avatar_url":"https://avatars-next.observableusercontent.com/2e264e285632a44937edf6eb6b531fffbd152d07233e70f4c70c2cd9a5cd9e09","tier":null,"role":"editor"},{"type":"individual","id":"be0076fec73aa550","login":"john-guerra","name":"John Alexis Guerra Gómez","avatar_url":"https://avatars-next.observableusercontent.com/21638cee44bb0ea70798da725b57111a5d3e2acebcd14524565992f7d1594aed","tier":null,"role":"editor"},{"type":"individual","id":"fcd94e1c1ca12ae9","login":"kasivisu4","name":"Kasi Viswanath","avatar_url":"https://avatars-next.observableusercontent.com/48e36723913e7e5b18b906e1d7cde12fad4146715e78bbf74d3db7969a248b56","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"title":"Diving into the Waters of Shark Tank India","cells":[{"id":0,"value":"# Diving into the Waters of Shark Tank India\n_Project Progress Report_\n- By [Akhila Sulgante](https://akhilasulgante.github.io/portfolio) and [Kasi Viswanath Vandanapu](https://kasivisu4.github.io/)\n- [Slides](https://docs.google.com/presentation/d/1oD8Y9sGY3MA2f5auiIW9Wg8trag-7jdXDDg3vzeZyGw/edit#slide=id.g22b8047b3b0_6_75)\n- Class: [CS 7295 class](https://johnguerra.co/classes/data_visualization_spring_2023/)\n- Professor: [prof. John Alexis Guerra Gómez](https://johnguerra.co/)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":932,"value":"### State-wise participation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":40,"value":"statewise_pitches = {\n let lines = vl.markLine({tooltip:true})\n .encode(vl.x().fieldN(\"Pitchers State\").title(\"State\"),\n vl.y().count().title(\"Number of Companies\"),\n vl.color().fieldN(\"Season Number\"))\n\n let circles = vl.markCircle({tooltip:true}).encode(vl.x().fieldN(\"Pitchers State\").title(\"State\"),\n vl.y().count().title(\"Number of Companies\"),vl.color().fieldN(\"Season Number\"))\n\n return vl.layer(lines,circles)\n .data(rawData.filter(d=>d[\"Pitchers State\"]))\n .render()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1269,"value":"Final Graph","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":910,"value":"state_season_wise_pitches = vl.markBar()\n.encode(vl.y().fieldN(\"Pitchers State\").title(\"State\").sort(\"-x\"),\n \n vl.x().count().title(\"Number of Companies\"),\n vl.color().fieldN(\"Season Number\"))\n.data(rawData.filter(d=>d[\"Pitchers State\"]))\n.render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":374,"value":"statewise_pitches_diff = {\n let bars = vl.markBar()\n .encode(vl.y().fieldN(\"state\"),\n vl.x().fieldQ(\"diff\").title(\"Difference in Pitches across seasons\"),\n vl.text().fieldQ(\"diff\"), vl.color().if(\"datum.diff>0\", vl.color().value('#339933')).value('#ff6666')) \n\n let zeroLine = vl.markLine().encode(vl.y().fieldN(\"state\"),\n vl.x().value(110),vl.color().value(\"#0099cc\"))\n\n return vl.layer(zeroLine,bars).data(statesDiff)\n .width(600).render()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"vl.markBar()\n.encode(vl.y().fieldN(\"Industry\").sort(\"-x\"), vl.x().count())\n .width(400)\n .height(400)\n.data(rawData)\n.render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"{\n const chart1 = vl.markBar({tooltip:true}).encode(vl.x().fieldN(\"Industry\"),vl.color().count()).data(rawData.filter(d=>d[\"Pitchers State\"]))\n \n return chart1.encode(vl.y().fieldN(\"Pitchers State\"),vl.tooltip(null)).render()\n \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":670,"value":"key = Swatches(statesDiffwithIndustryChart.scales.color)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":631,"value":"statesDiffwithIndustryChart = StackedBarChart(statesDiffwithIndustry, {\n x: d => d.diff,\n y: d => d.state,\n z: d => d.industry,\n xFormat: \"+%\",\n xLabel: \"← Reduced Pitches · Normal · Increased Pitches →\",\n yDomain: d3.groupSort(statesDiffwithIndustry, D => d3.sum(D, d => -Math.min(0, d.diff)), d => d.state),\n marginLeft: 200,\n colors: d3.schemeSet1.concat(d3.schemeSet2),\n zDomain: industries,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2654,"value":"// \n","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2929,"value":"//State\nviewof stateParticipationChart = createParticipationChart({data:updateMissingData,x:\"Season Number\",y:\"count\",z:\"Industry\",color:\"Pitchers State\",colorLabel:\"State\",xLabel:\"Season\",yLabel:\"Number of Pitches\",zLabel:\"Industry-specific State breakdown\",defaultValue:\"Karnataka\",increasingData:updateMissingData.filter(d=>rollupStateIncreasing.includes(d[\"Pitchers State\"])),decreasingData:updateMissingData.filter(d=>!rollupStateIncreasing.includes(d[\"Pitchers State\"])),rollupData:rolledUpStateData,zValue:\"label\",zCondition: [ { test: \"datum.diff>0\", value: \"green\" },\n { test: \"datum.diff===0 && datum['Season 1']===0 && datum['Season 2']===0\", value: \"grey\" },\n { test: \"datum.diff===0\", value: \"blue\" },\n\n\n { test: \"datum.diff<0\", value: \"red\" }\n ]})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3119,"value":"viewof participationChart = {\n let chart = viewof stateParticipationChart\n let btn = Inputs.select([\"StateWise\",\"IndustryWise\"],{value:\"StateWise\",label:\"Chart type\"})\n let target = html`

${btn}

`\n target.appendChild(chart)\n btn.addEventListener(\"input\",()=>{\n if(btn.value===\"StateWise\"){\n chart?.remove()\n chart = viewof stateParticipationChart\n }\n else{\n chart?.remove()\n chart = viewof IndustryParticipationChart\n }\n target.appendChild(chart)\n })\n \n return target\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3023,"value":"//Industry\nviewof IndustryParticipationChart = createParticipationChart({data:updateMissingData,x:\"Season Number\",y:\"count\",z:\"Pitchers State\",color:\"Industry\",colorLabel:\"Industry\",xLabel:\"Season\",yLabel:\"Number of Pitches\",zLabel:\"State-specific Industry breakdown\",defaultValue:\"Food\",increasingData:updateMissingData.filter(d=>rollupIndustryIncreasing.includes(d[\"Industry\"])),decreasingData:updateMissingData.filter(d=>!rollupIndustryIncreasing.includes(d[\"Industry\"])),rollupData:rolledUpIndustryData,zValue:\"label\",zCondition: [ { test: \"datum.diff>0\", value: \"green\" },\n { test: \"datum.diff===0 && datum['Season 1']===0 && datum['Season 2']===0\", value: \"grey\" },\n { test: \"datum.diff===0\", value: \"blue\" },\n\n\n { test: \"datum.diff<0\", value: \"red\" }\n ]})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2907,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2911,"value":"rollupIndustryIncreasing = {\n return d3.rollups(rolledUpStateData, v=> d3.sum(v,d=>d[\"Season 2\"]) - d3.sum(v,d=>d[\"Season 1\"]) ,d=>d[\"Industry\"]).filter(([Industry,diff]) => diff>0).map(d=>d[0])\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2881,"value":"rollupStateIncreasing = {\n return d3.rollups(rolledUpStateData, v=> d3.sum(v,d=>d[\"Season 2\"]) - d3.sum(v,d=>d[\"Season 1\"]) ,d=>d[\"Pitchers State\"]).filter(([state,diff]) => diff>0).map(d=>d[0])\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2565,"value":"// {\n\n \n// const panzoom = vl.selectInterval().bind('scales')\n// .translate('[mousedown[!event.shiftKey], window:mouseup] > window:mousemove!')\n// .zoom('wheel!').encodings(\"y\");\n \n// const line = vl\n// .markLine()\n// .encode(\n// vl.y().fieldQ(\"value\"),\n// vl.x().fieldN(\"key\"),\n// vl.color().fieldN(\"Industry\"))\n \n// return (\n// line\n// .select(panzoom)\n// .width(600)\n// .height(400)\n// .data(rolledUpData)\n// .render()\n// );\n// }","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2578,"value":"updateMissingData = {\n\n let data = []\n for(let row of rawData){\n let res = {...row,count:1}\n if(!res[\"Pitchers State\"]){\n //update here for default state label\n res[\"Pitchers State\"] = \"State Unkown\"\n }\n data.push(res)\n \n }\n\n for(let row of rolledUpStateData){\n if(row[\"Season 1\"]===0 && row[\"Season 2\"]!=0){\n data.push({\n Industry:row[\"Industry\"],\n \"Pitchers State\":row[\"Pitchers State\"] ? row[\"Pitchers State\"]: \"State Unkown\",\n \"Season Number\":1,\n count:0 \n })\n }\n else if(row[\"Season 2\"]===0 && row[\"Season 1\"]!=0){\n data.push({\n Industry:row[\"Industry\"],\n \"Pitchers State\":row[\"Pitchers State\"] ? row[\"Pitchers State\"]: \"State Unkown\",\n \"Season Number\":2,\n count:0 \n })\n }\n \n }\n return data\n \n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3036,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2497,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2464,"value":"labels= industries.map((d,i)=>{return {name:d}})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2462,"value":"rawData","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2393,"value":"import { vl as vl5 } from \"@vega/vega-lite-api-v5\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"vl.markBar({tooltip:true})\n.encode(vl.y().fieldN(\"Presenter\").sort(\"-x\"), vl.x().sum(\"count\").title(\"Number of Presenters\"))\n .width(400)\n .height(400)\n.data(presentersData)\n.render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1992,"value":"rawData","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1356,"value":"Industry_gender_presenters_chart_iter1 = {\n let malePresenters = vl.markBar({\"xOffset\": -8,\"size\": 16,tooltip:true})\n.encode(vl.x().fieldN(\"Industry\"),vl.y().sum(\"Male Presenters\").title(\"Presenters\"),vl.color({\"datum\":\"Male\"})).width(900)\n\n let femalePresenters = vl.markBar({\"xOffset\": 8,\"size\": 16,tooltip:true})\n.encode(vl.x().fieldN(\"Industry\"),vl.y().sum(\"Female Presenters\").title(\"Presenters\"),vl.color({\"datum\":\"Female\"})).width(900)\n\n let transGenderPresenters = vl.markBar({\"xOffset\": 24,\"size\": 16,tooltip:true})\n.encode(vl.x().fieldN(\"Industry\"),vl.y().sum(\"Transgender Presenters\").title(\"Presenters\"),vl.color({\"datum\":\"Trans\"})).width(900)\n \n\n return vl.layer(malePresenters,femalePresenters,transGenderPresenters)\n .data(rawData).render()\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1339,"value":"Industry_gender_presenters_chart_iter2 = GroupedBarChart(Industry_gender_presenters, {\n x: d => d.Industry.split(\"/\")[0],\n y: d => d.count,\n z: d => d.presenter,\n colors: d3.schemeSpectral[2],\n width,\n height: 500,\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1944,"value":"{\n let oa = \n vl.markPoint()\n .encode(\n vl.y().fieldN('Industry').title(\"Industry\"),\n vl.x().mean('Valuation Requested').title(\"valuation\"),\n vl.color().value(\"#669999\"),\n // vl.text().value(\"●\")\n )\n \n\n let da = \n vl.markSquare()\n .encode(\n vl.y().fieldN('Industry').title(\"Industry\"),\n vl.x().mean('Deal Valuation'),\n vl.color().value(\"firebrick\"),\n // vl.text().value(\"●\")\n )\n\n\n let final = vl.layer(oa, da)\n .data(rawData.filter(d=>d[\"Received Offer\"]))\n .width(1000)\n .height(500)\n .render({\"renderer\":\"svg\"})\n\n return final\n}\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2170,"value":"viewof orderValuation = Inputs.select([\"Valuation Requested\",\"Deal Valuation\"],{label:'Sort By',valueof :(d)=>lookupValuation[d],value:\"min\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3220,"value":"lookupValuation={\n return {\n \"Valuation Requested\":\"max\",\n \"Deal Valuation\":\"min\"\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1301,"value":"industry_valuation_legend = Swatches(industry_valuation.color, {title: \"Valuation\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1289,"value":"industry_valuation = DotPlot(industry_avg , {\n x: d => d.value/100,\n y: d => d.Industry.split(\"/\")[0],\n z: d => d.valuation,\n xLabel: \" Avg valuation (INR in CR) →\",\n height : \"600\",\n width:\"800\",\n marginLeft:70,\n marginTop:40,\n stroke1:[\"Entertainment\"]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2145,"value":"orderValuationChart = {\n orderValuation\n industry_valuation.update(d3.groupSort(industry_avg, g => d3[orderValuation](g, d => d.value), d => d.Industry.split(\"/\")[0]))\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1140,"value":"### Iteration - 1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1136,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1983,"value":"Final Graph","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1119,"value":"","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1059,"value":"#### Iteration-1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":115,"value":"shark_Investments_chart = {\n let bar = vl.markBar()\n.encode(vl.y().fieldN(\"Shark\").sort(\"-x\").axis(null), vl.x().sum(\"Shark Investment Amount\"),vl.color().fieldN(\"Season Number\")).height(300).width(600)\n \n\n\nlet images = vl.markImage().encode(vl.y().fieldN(\"Shark\").sort(\"-color\"), vl.color().sum(\"Shark Investment Amount\").legend(null),vl.url().field(\"url\"),vl.tooltip(vl.field(\"Shark\"))).height(300).width(50)\n \nreturn vl.hconcat(images,bar).data(shark_Investments).render({renderer:\"svg\"})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1040,"value":"sharkheatmap = vl.markBar({tooltip:true})\n .encode(vl.y().fieldN(\"Shark\"),\n vl.x().fieldN(\"Industry\"),\n vl.color().mean(\"Shark Investment Amount\").title(\"Investement Amount\"))\n .data(shark_Investments)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2013,"value":"Final graph","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1155,"value":" ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2024,"value":"viewof sset = {\n return Inputs.select(sharkSet,{label:\"Shark\" , value:\"Peyush\"})\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":125,"value":"indichart = { return vl.markBar()\n .data(rawData.filter((d)=> d[`${sset} Investment Equity`] > 1))\n // .transform(vl.calculate(`datum[${sset} Investment Equity]+ '% Equity'`).as(\"percent\"))\n .encode(\n vl.y().fieldN('Startup Name').title(\"Startup Name\").sort(\"-x\"),\n vl.color().fieldN(\"Industry\").scale({\n domain: industries,\n range: [\n '#866f98', '#44aa99', '#117733', '#444047', '#ddcc77', '#999933', '#332288', '#882255', '#aa4499', '#ee8866', '#ffaabb', '#4477aa', '#d55e00', '#cc79a7', '#84773a', '#918b73', '#88ccee' \n ]}).title(\"Deal amount in Lakhs(INR)\"),\n vl.tooltip().fieldN(\"Total Deal Amount\"),\n vl.x().fieldQ('Total Deal Amount').title(\"Deal amount in Lakhs(INR)\"),\n vl.href().field(\"Company Website\")\n )\n .width(600)\n .render()\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1157,"value":"viewof shark = Inputs.select(sharkSet,{label:\"shark\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1172,"value":"sharkSelectedData = shark_Investments.filter(d=>d.Shark.split(\" \")[0]===shark)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1183,"value":"shark_industry_wise_equity = {\n let layer;\n for(let industry of industries){\n let chart = vl.markBar().encode(vl.x().fieldN(\"Startup Name\"),vl.y().fieldQ(\"Total Deal Equity\")).data(sharkSelectedData.filter(d=>d.Industry===industry)).width(600)\n // let avg_line = vl.markLine().encode(vl.x().fieldN(\"Startup Name\"), vl.y().sum(\"Total Deal Equity\").aggregate(\"mean\"),vl.color().value(\"#000\"))\n\n // chart = vl.layer(chart,avg_line).data(sharkSelectedData.filter(d=>d.Industry===industry)).width(600)\n layer = layer ? vl.vconcat(layer,chart) : chart\n }\nreturn layer.render()}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1199,"value":"industries","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1178,"value":"shark_Investments","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":429,"value":"vl.markArc({tooltip : true})\n .encode(\n vl.theta().sum(\"Shark Investment Amount\"),\n vl.color().fieldN(\"Shark\"),\n vl.facet().fieldN(\"Industry\").columns(4)\n )\n .data(shark_Investments)\n .render();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2036,"value":"Final Graph","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":419,"value":"nwchart = {return html``\n }","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":689,"value":"viewof sortBy = Inputs.select([ \"Prevalence\", \"Degree\"],{label:\"sort by\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":860,"value":"viewof Season = Inputs.select([ \"1\", \"2\"],{label:\"Season\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":720,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":753,"value":"images","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":700,"value":"dealsbyShark = {let res = rawData.filter(d=>d[\"Season Number\"]===+Season).map(d=>({...d}))\n let keys = Object.keys(res[0])\n .filter((d) => d.indexOf(\"Investment Amount\") != -1 && d.indexOf(\"Guest\") === -1)\n let dealsbyShark = []\n for(let row of res){\n let investers = []\n for(let key of keys){\n if(+row[key]>0){\n investers.push(key.split(\" \")[0])\n }\n }\n if(investers.length>0){\n\n dealsbyShark.push({Investors:investers.join(\", \"),row})\n }\n }\n return d3.group(dealsbyShark,d=>d.Investors)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2284,"value":"viewof maxCount = Inputs.range([1, 5], {\n label: \"Shark partnership count\",\n value: 1, \n step: 1\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":695,"value":"$37","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3161,"value":" Array.from(dealsbyShark.entries()).map((row) => ({\n Conditions: row[0],\n Count: row[1].length,\n Prevalence: row[1].length / rawData.length\n }));","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":712,"value":"import {vl} from \"@john-guerra/vega-lite-api\" ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":709,"value":"defaultColor = \"#999\" ","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":896,"value":"rawData","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2073,"value":"## Data Exploration","pinned":true,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":211,"value":"### Finding the correlation b/w Yearly Revenue and deals not received","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":474,"value":"vl.markBar({tooltip:true})\n .data(deal_diff)\n .encode(\n vl.y().fieldN(\"Industry\").sort(\"x\"),\n vl.x().mean(\"diff\")\n) .width(800)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":509,"value":"deal_diff = {\n let deals = []\n for(let data of (rawData.filter(d=>d[\"Deal Valuation\"]))){\n let res = {}\n res [\"Industry\"] =data[\"Industry\"]\n res[\"diff\"] = (data[\"Deal Valuation\"] - data[\"Valuation Requested\"] + 1) / ( data[\"Valuation Requested\"] + 1)\n deals.push(res)\n }\n\nreturn deals \n }\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":259,"value":"Finding the average difference between equity asked and equity diluted across the industry","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":588,"value":"vl.markBar({tooltip:true})\n .data(equity_diff)\n .encode(\n vl.y().fieldN(\"Industry\").sort(\"x\"),\n vl.x().mean(\"diff\")\n) .width(800)\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":572,"value":"equity_diff = {\n let deals = []\n for(let data of (rawData.filter(d=>d[\"Deal Valuation\"]))){\n let res = {}\n res [\"Industry\"] =data[\"Industry\"]\n res[\"diff\"] = (data[\"Total Deal Equity\"] - data[\"Original Offered Equity\"] + 1) / ( data[\"Original Offered Equity\"] + 1)\n deals.push(res)\n }\n\nreturn deals \n }\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":297,"value":"### Finding the co-relation b/w Startup Start date nd deal received","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":295,"value":"vl.markBar({tooltip:true})\n .data(rawData.filter(d=>d[\"Started in\"]))\n .encode(\n vl.y().count(),\n vl.x().fieldO('Started in'),\n vl.color().fieldN(\"Received Offer\")\n )\n .width(800)\n .render()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":302,"value":"vl.markLine({tooltip:true})\n .data(rawData.filter(d=>d[\"Started in\"] && d[\"Received Offer\"]===1))\n .encode(\n vl.y().count(),\n vl.x().fieldQ('Started in'),\n vl.color().fieldN(\"Pitchers Average Age\")\n )\n .width(800)\n .render({renderer:\"svg\"})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":133,"value":"sharkSet = new Set([\"Ashneer\", \"Aman\", \"Namita\", \"Anupam\", \"Vineeta\", \"Peyush\", \"Ghazal\", \"Amit\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":33,"value":"rawData","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2197,"value":"d3.rollup(rawData,v => d3.sum(v, d => d[\"Amit Investment Amount\"]),d=>d[\"Season Number\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2210,"value":"d3.rollup(rawData,v => d3.sum(v, d => d[\"Namita Investment Amount\"]),d=>d[\"Season Number\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2199,"value":"d3.sum(rawData,d=>d[\"Nam Investment Amount\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2217,"value":"d3.rollup(shark_Investments,v => d3.sum(v, d => d[\"Shark Investment Amount\"]),d=>d[\"Shark\"],d=>d[\"Season Number\"])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":" shark_Investments = \n{\n let data = aq.from(rawData)\n.fold(Object.keys(rawData[0])\n .filter((d) => d.indexOf(\"Investment Amount\") != -1 && d.indexOf(\"Guest\") === -1), { as :[\"Shark\", \"Shark Investment Amount\"]}).objects()\n\n for(let d of data){\n d[\"url\"] = images[d[\"Shark\"].split(\" \")[0]]\n }\n\n return data\n\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":24,"value":"data = archive.file(\"Shark Tank India.csv\").csv({ typed: true })","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3151,"value":"rawData = {\n let res = data.map(d=>{return {...d}})\n for(let row of res){\n row[\"Startup Name\"] = row[\"Startup Name\"].slice(0,1).toUpperCase() + row[\"Startup Name\"].slice(1)\n }\n return res\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":26,"value":"archive = FileAttachment(\"archive.zip\").zip()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"import {aq, op} from \"@uwdata/arquero\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":672,"value":"import {Swatches} from \"@d3/color-legend\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":633,"value":"import {StackedBarChart} from \"@d3/diverging-stacked-bar-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":743,"value":"images = ({\n\"Aman\":\"https://i.postimg.cc/1XKRbWV2/Aman.jpg\",\n\"Amit\":\"https://i.postimg.cc/0yXj8HXq/amit.jpg\",\n\"Anupam\":\"https://i.postimg.cc/L6C2fgtt/Anupam.jpg\",\n\"Ashneer\":\"https://i.postimg.cc/wMxYR934/ashneer.jpg\",\n\"Ghazal\":\"https://i.postimg.cc/mDR0KT3Z/gazal.jpg\",\n\"Namita\":\"https://i.postimg.cc/NfLZ3JXX/namita.jpg\",\n\"Peyush\":\"https://i.postimg.cc/Y9psbbkh/pyeush.jpg\",\n\"Vineeta\":\"https://i.postimg.cc/c4VkVs0q/Vineeta.jpg\",\n\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1329,"value":"Industry_gender_presenters = aq.from(rawData).groupby(\"Industry\").rollup({ 'Male' : op.sum('Male Presenters'), 'Female' : op.sum('Female Presenters'),'Trans' : op.sum('Transgender Presenters')}).fold([\"Male\",\"Female\",'Trans'],{as:[\"presenter\",\"count\"]}).objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1325,"value":"import {GroupedBarChart} from \"@d3/grouped-bar-chart\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1284,"value":"import {DotPlot} from \"6885b87ef1dbd81c\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1118,"value":"industry_avg = aq.from(rawData).groupby(\"Industry\").rollup({ 'Deal Valuation' : op.mean('Deal Valuation'), 'Valuation Requested' : op.mean('Valuation Requested')}).fold([\"Deal Valuation\", \"Valuation Requested\"],{as:[\"valuation\",\"value\"]}) .objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":655,"value":"industries = Array.from(d3.group(rawData,d=>d[\"Industry\"]).keys())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":638,"value":"statesDiffwithIndustry = {\n let data = d3.groups(\n rawData.filter((d) => d[\"Pitchers State\"]),\n (d) => d[\"Pitchers State\"],\n (d) => d[\"Industry\"],\n (d) => d[\"Season Number\"]\n );\n let finalData = [];\n for (let [state, v1] of data) {\n for (let [Industry, v2] of v1) {\n let res = {};\n\n let record = { 1: 0, 2: 0 };\n for (let [season, v3] of v2) {\n record[season] = v3.length;\n }\n if (!Industry) {\n continue;\n }\n let diff = (record[2] - record[1] + 1) / (record[1] + 1);\n res[\"state\"] = state;\n res[\"industry\"] = Industry;\n res[\"diff\"] = diff;\n finalData.push(res);\n }\n }\n return finalData;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2107,"value":"statesDiffwithIndustry","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":342,"value":"statesDiff = {\n let states = {}\n for(let data of (rawData.filter(d=>d[\"Pitchers State\"]))){\n states[data[\"Pitchers State\"]] = states[data[\"Pitchers State\"]] || {}\n states[data[\"Pitchers State\"]][data[\"Season Number\"]] = states[data[\"Pitchers State\"]][data[\"Season Number\"]] || 0\n states[data[\"Pitchers State\"]][data[\"Season Number\"]] +=1\n }\n\n for(let data of Object.values(states)){\n data[\"diff\"] = ((data[2] || 0) - (data[1]|| 0)) *100 /((data[1] || 1)) \n }\n\nreturn Object.entries(states).map(d=>{return {\n state:d[0],\n diff:d[1].diff\n}\n}) \n }\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1986,"value":"presentersData = aq.from(rawData).fold([\"Male Presenters\",\"Female Presenters\",\"Transgender Presenters\"],{as:[\"Presenter\",\"count\"]}).objects()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W38","stdlib":"1","titling":"auto"}} 32:"$31:body"