2b:null 2c:["$","title",null,{"children":"The Netflix Nexus | Amrutavarsh Kinagi | Observable"}] 31:T9b5,edge_combinations = ({ "Spain-United States": "While United States doesn’t significantly boost how media from Spain performs worldwide, it does aid it in Asia and South America", "United Kingdom-United States": "The United States doesn’t significantly boost how media from United Kingdom performs worldwide. The United Kingdom is a strong performer well globally as a sole producer", "China-Canada":"China gets a minor performance boost globally from Canada, trending best in Europe and Asia", "Ireland-Canada":"While Canada doesn’t significantly boost how media from Ireland performs worldwide, it does aid it in Europe", "Hong Kong-United Kingdom":"While Co-producing with United Kingdom doesn’t provide a major perforce benefit to media from Hong Kong, it does boost its presence in Europe", "Germany-United Kingdom":"Co-Producing with United Kingdom does globally boost media from Germany, but this effect is not consistent at all times", "China-Columbia":"Media solely produced by China mostly out performs co-produced content in Asia. While media co-produced with Colombia allows for Chinese media to trend in Europe.", "Hong Kong-Spain":"Media solely produced by Hong Kong mostly out performs co-produced content in Asia. While media co-produced with Spain allows for Hong Kong media to trend in Europe", "Ireland-Spain":"Co-producing with Spain provides media from Ireland no particular performance benefit. However, media co-produced with Spain allows for Irish media to trend in Asia", "Spain-Norway":"Co-producing with Spain provides media from Norway no particular performance benefit. However, media co-produced with Spain allows for Norwegian media to trend in both North and South America", "Thailand-Spain":"Co-producing with Spain provides media from Thailand no particular performance benefit. However, media co-produced with Spain allows for Thai media to trend in Europe", "Israel-Germany":"Co-producing with Germany does provide media from Israel a performance benefit, seeing as only co-produced media trends in Europe, North America, Oceania, and South America", "Norway-Germany":"Co-producing with Germany provides media from Norway no particular performance benefit. However, media co-produced with Germany allows for Norwegian media to trend in Europe", "Italy-Spain":"Co-producing with Spain does provide media from Italy a performance benefit, with an increase in performance across Europe, Africa, Oceania, and Asia", })32:T189f,arc_key_player = { d3.select("#legend1").html("") d3.select("#arc1").html("") var margin = { top: 0, right: 30, bottom: 90, left: 60 }, width = 900 - margin.left - margin.right, height = 500 - margin.top - margin.bottom; var legend = d3 .select("#legend1") .append("svg") .attr("width", 400) .attr("height", 150) .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); // append the svg object to the body of the page var svg = d3 .select("#arc1") .append("svg") .attr("width", width + margin.left + margin.right) .attr("height", height + margin.top + margin.bottom) .append("g") .attr("transform", "translate(" + margin.left + "," + margin.top + ")"); const continents = [ "Africa", "Asia", "Europe", "North America", "Oceania", "South America", ]; const key_players = ["United States", "United Kingdom", "Japan","South Korea", "Canada", "Spain", "Colombia", "Germany", "New Zealand", "Ireland", "Romania", "Sweden"] // use a color to denote continents const color = d3.scaleOrdinal().domain(continents).range(d3.schemeSet2); const widthScale = d3.scaleLinear().domain([...new Set(links_data.map(d => d.no_links))]).range([1,5]) var continentColors = legend .selectAll("colors") .data(continents) .enter() .append("circle") .attr("cx", 30) .attr("cy", (c, i) => 50 + i * 15) .attr("r", 5) .style("fill", (c) => color(c)); var continentText = legend .selectAll("text") .data(continents) .enter() .append("text") .text((c) => c) .attr("x", 37) .attr("y", (c, i) => 51 + i * 16); // sort the data var dataGroupByContinent = links_data.sort(function (a, b) { if (a.destination_continent > b.destination_continent) { return 1; } else if (a.destination_continent < b.destination_continent) { return -1; } // Else go to the 2nd item if (a.destination_country < b.destination_country) { return -1; } else if (a.destination_country > b.destination_country) { return 1; } else { // nothing to split them return 0; } }); // // List of node names var allNodes = [ ...new Set( dataGroupByContinent.map(function (d) { return d.destination_country; }) ), ]; // A linear scale to position the nodes on the X axis var x = d3.scalePoint().range([0, width]).domain(allNodes); var links = svg .selectAll("links") .data(dataGroupByContinent) .enter() .append("path") .attr("d", function (d) { var start = x(d.destination_country); // X position of start node on the X axis var end = x(d.source_country); // X position of end node return [ "M", start, height - 30, // the arc starts at the coordinate x=start, y=height-30 (where the starting node is) "A", // This means we're gonna build an elliptical arc (start - end) / 2, ",", // Next 2 lines are the coordinates of the inflexion point. Height of this point is proportional with start - end distance (start - end) / 2, 0, 0, ",", start < end ? 1 : 0, end, ",", height - 30, ] // We always want the arc on top. So if end is before start, putting 0 here turn the arc upside down. .join(" "); }) .style("fill", "none") .attr("stroke", (d) => key_players.includes(d.source_country) ? color(d.source_continent) : "#aaa") .attr("stroke-opacity", 0.3) .style("stroke-width", (d)=> widthScale(d.no_links)); // Add the circle for the nodes var nodes = svg .selectAll("mynodes") .data(dataGroupByContinent) .enter() .append("circle") .attr("cx", function (d) { return x(d.destination_country); }) .attr("cy", height - 30) .attr("r", 5) .style("fill", function (d) { return color(d.destination_continent); }) .attr("stroke", "white"); // And give them a label var labels = svg .selectAll("mylabels") .data(allNodes) .enter() .append("text") .attr("x", 0) .attr("y", 0) .text(d=>d) .style("text-anchor", "end") .attr("transform", function (d) { return ( "translate(" + x(d) + "," + (height - 15) + ")rotate(-45)" ); }) .style("font-size", 6); // node highlighting nodes .on("mouseover", function (d) { var country = invertXScale(d3.select(this).attr('cx'),x); console.log(country); nodes.style("opacity", 0.2); d3.select(this).style("opacity", 1); // Highlight the connections links .style("stroke", function (link_d) { return link_d.source_country === country ? color(link_d.source_continent) : "#aaa"; }) .style("stroke-opacity", function (link_d) { return link_d.source_country === country ? 0.7 : 0.2; }) .style("stroke-width", function (link_d) { return link_d.source_country === country ? widthScale(link_d.no_links) : 0.5; }); labels .style("font-size", function (label_d) { return label_d === country ? 10 : 4; }) }) .on("mouseout", function (d) { console.log("mouseout"); console.log(d); nodes.style("opacity", 1); links .style("stroke", (d) => key_players.includes(d.source_country) ? color(d.source_continent) : "#aaa") .style("stroke-opacity", 0.3) .style("stroke-width", (d)=> widthScale(d.no_links)); labels.style("font-size", 6); }); function invertXScale(xPos, xScale){ var domain = xScale.domain(); var range = xScale.range(); var rangePoints = d3.range(range[0], range[1], xScale.step()) var label = domain[d3.bisect(rangePoints, xPos) -1]; return label; } }33:Tc2e,classify_blurb = function(COP, switch_bool){ if(switch_bool && (key_source == vs_key_source)){ return "" } if(!switch_bool && (key_source != vs_key_source)){ return "" } if(COP == dependent_country){ return "INVALID MAP. CHOOSE DIFFERENT OPTIONS" } let combination = dependent_country+"-"+COP if(combination in edge_combinations){ return edge_combinations[combination] + "." } let SOP = dependent_country let data = [] let continents = ["Africa", "Asia", "Europe", "North America", "Oceania", "South America"] let ks = filtered_rank_data_delta.filter(d => d.key_source.match(COP)) for (const continent of continents) { let fc = ks.filter(d => d.destination_continent.match(continent)) data.push({continent: continent, positive: fc.filter(d=>d.val>0).length, negative: fc.filter(d=>d.val<0).length, zero: fc.filter(d=>d.val == 0).length}) } data = data.slice().sort((a, b) => d3.ascending(a.positive, b.positive)) let sparse_count = 0 let COP_global_boost = 0 let COP_max_val = 0 let COP_max_continent = ["",""] let SOP_global = 0 let SOP_local_max_continents = "" let SOP_local_max_sparse = 0 let SOP_local_max_continent_sparse = "" for (const d of data) { if(d.zero > d.negative + d.positive){ sparse_count += 1 } if(d.positive > d.negative){ COP_global_boost += 1 if(d.positive > COP_max_val){ COP_max_continent[1] = COP_max_continent[0] COP_max_continent[0] = d.continent COP_max_val = d.positive } } if(d.positive < d.negative){ SOP_global += 1 if(d.negative > 15){ SOP_local_max_continents += d.continent + ", " } else if (SOP_local_max_sparse < d.negative){ SOP_local_max_continent_sparse = d.continent SOP_local_max_sparse = d.negative } } } let text = "" if(COP_global_boost > 2 && sparse_count < 3){ text = SOP+' gets a performance boost globally from '+COP+', trending best in '+COP_max_continent[0]+' and '+COP_max_continent[1] + '. ' } else if((COP_global_boost > 0 && SOP_global == 0) || (COP_global_boost > 0 && sparse_count < 4)){ text = 'While '+COP+' doesn’t significantly boost how media from '+SOP+' performs worldwide, it does aid it in ' + COP_max_continent[0] + '. ' } else if(SOP_global > 2 && sparse_count < 4){ text = 'Co-producing with ' + COP + ' provides no particular performance benefit to ' + SOP + '. ' + SOP + ' performs well globally as a sole producer.' } else if(SOP_global > 0 && SOP_local_max_continents.length){ text = 'Co-producing with '+COP+' provides '+SOP+' no particular performance benefit globally. However, media solely produced by '+SOP+' mostly out performs co-produced content in ' + SOP_local_max_continents.slice(0, -2) + '. ' } else if(SOP_global > 0){ text = 'Co-producing with '+COP+' provides media from '+SOP+' no particular performance benefit. However, '+SOP+' only has a sparse presence in ' + SOP_local_max_continent_sparse + '. ' } else { text = "NO BLURB FOUND" } return text }34:T1c79,map_blurb = function(){ let blurbs = { "Malaysia": "Co-producers provide no visible “boosting” effect to Malaysian media. Purely Malaysian produced media (in red) is the only media shown trending, and only within the continent of Asia.", "Philippines": "Co-producers provide no visible “boosting” effect in this case. Purely Philippine produced media is the only media shown trending, though it has a broader reach: it trends consistently in Asia and inconsistently in North America, Europe, and Africa.", "Thailand": "Co-producers provide no visible “boosting” effect to Thai media. Purely Thai-produced media is the only media shown trending, and only within the continent of Asia.", "Turkey": "Co-producers provide no visible “boosting” effect to Turkish media. Purely Turkey-produced media is the only media shown trending, but with a broader reach: it trends consistently in Asia and inconsistently in all other continents.", "Norway": "Here we see that the US, UK, and Canada do provide some help, seeing as their co-production with Norway has led to some inconsistent trending in Africa, Asia, and Europe. That being said, however, the few numbers of trending Norwegian-produced media is purely produced by Norway, and trends only within Europe.", "South Korea": "With the overwhelming amount of red found consistently across each continent, we can see that South Korea doesn’t receive nor require co-production from any of the key players in order to trend consistently across each continent, especially within Asia, Africa, and North and South America.", "United States": "The United States doesn’t receive nor require co-production from any of the key players in order to trend globally, with its shows in the top ten nearly every single week across all continents.", "United Kingdom": "Other than the slight boost in trending media the UK receives from co-producing with the United States, the overwhelming pattern still holds that the UK is capable of trending consistently across each continent with purely UK-produced media. ", "Japan": "Other the slight boost in trending media Japan receives from co-producing with the United States (with the effect being most notable in Europe and North America), the overwhelming pattern still holds that Japan is capable of trending consistently across each continent with purely Japanese-produced media.", "Brazil": "While Brazil doesn’t require need any additional help from co-production, seeing as the overwhelming majority of trending media is Brazil-only, Brazilian media only tends to trend consistently across two continents: the home continent of South America, and Europe.", "Colombia": "While Colombia doesn’t require need any additional help from co-production, seeing as the overwhelming majority of trending media is produced by Colombia alone, Colombian media only tends to trend consistently across three continents: North and South America, as well as Europe.", "India": "While India doesn’t require need any additional help from co-production, seeing as the overwhelming majority of trending media is purely produced by India, Indian media only tends to trend consistently across two continents: the home continent of Asia, and Africa.", "Nigeria": "While Nigeria doesn’t require need any additional help from co-production, seeing as the overwhelming majority of trending media is purely produced by Nigeria, Nigerian media only tends to trend consistently across two continents: the home continent of Africa, and to a certain extent, Asia and North America.", "Israel": "Nearly every piece of trending content produced by Israel is co-produced by the United States. Other than the few Israel-only produced media that trends in the home continent of Asia alone, the boosting effect is clearly present. Israel requires the key player’s support to get any of their media trending, both globally and locally.", "New Zealand":"Nearly every piece of trending content produced by New Zealand is co-produced by the United States (and to a certain extent, the UK and Canada). Here, the boosting effect is clear, seeing as New Zealand requires these key players’ support to get any of their media trending, even if it is inconsistently.", "Canada": "Purely Canadian media trends somewhat consistently across North America and Asia. However, their performance increases significantly when co-producing media with the United States, which has allowed their media to consistently trend globally, with significant increases in Africa, Europe, Oceania, and South America.", "Germany": "Purely German-produced media only trends somewhat consistently across Europe and Asia. German media receives a significant increase in global performance when supported by the US and the UK. When co-producing with any of these key players, the media tends to trend more consistently across all six continents with a higher popularity delta.", "China": "Purely Chinese-produced media only trends somewhat consistently across Asia. Chinese media receives a significant increase in global performance when supported by the US, the UK, Canada, and Japan. When co-producing with any of these key players, the media tends to trend more consistently across all six continents.", "Hong Kong" : "Purely Hong Kong produced media only trends inconsistently across Africa and Asia, and receives a significant increase in global performance when supported by the US, the UK, or Canada, in which case the media tends to trend more consistently, reaching Europe and South America as well.", "Ireland": "Irish media rarely trend, and purely Irish-produced media only trends within the home continent of Europe. Within a global context, all trending Irish media is either co-produced by Canada, the UK, or the US.", "Australia": "While most of the trending media is produced by Australia alone, there is a significant increase in the media’s performance across all continents when looking at shows Australia has co-produced with the US.", "France":"While most of the trending media is produced by France alone, there is a significant increase in the media’s performance across all continents when looking at shows France has co-produced with the US and UK, especially across Asia and North America.", "Italy":"The majority of trending Italian media trends in Europe and Asia, and is mainly produced by Italy alone. However, the global performance significantly increases across Africa, Asia, and Europe when looking at shows Italy has co-produced with Spain and the US.", "Mexico": "Mexican-only produced media trends consistently across nearly all continents, but an increase in performance can be seen across all continents, especially Europe and Asia when looking at media co-produced with the United States.", "Spain": "Mexican-only produced media trends consistently across most continents (especially Europe and North America), but an increase in performance can be seen when Spain co-produces its media with either Colombia or the United States, where the effects are most prominent in South America." } if(dependent_country in blurbs){ return blurbs[dependent_country] } else{ return "No blurb available"; } }35:[{"id":"7ae7f6bb05950f3a5b085948dc341aeac153ebd84d42a65870a6c80f3c8d2f53aa743e264c8c817de224498810b8495f9600681b4ec0a22bbd92aa684e521c10","href":"https://static.observableusercontent.com/files/7ae7f6bb05950f3a5b085948dc341aeac153ebd84d42a65870a6c80f3c8d2f53aa743e264c8c817de224498810b8495f9600681b4ec0a22bbd92aa684e521c10","name":"mega_ultimate_god_data_arg_max_avg_weekly_rank_with_delta.csv","type":"text/csv","lastModified":1651170897799.613,"size":952693},{"id":"2778837a3ae3371561f0df498f1b3a8d20755cf8548a9458b8aed4d0ce70c2a15fc5cc197d4cae3d1321d5054afa2ab4ef53b9b139d5992e3cb9ef5b3c737925","href":"https://static.observableusercontent.com/files/2778837a3ae3371561f0df498f1b3a8d20755cf8548a9458b8aed4d0ce70c2a15fc5cc197d4cae3d1321d5054afa2ab4ef53b9b139d5992e3cb9ef5b3c737925","name":"number_links_dataset_9-26-2021@1.csv","type":"text/csv","lastModified":1651170897799.613,"size":41437},{"id":"714307ec46d0bdde61771106f9adc78553e9eef7a12732e7401646a87edcbe85f29c0bcf40017386d0d8039c36b5da5e3bbe31eb4efe5ff562f7ca680a671387","href":"https://static.observableusercontent.com/files/714307ec46d0bdde61771106f9adc78553e9eef7a12732e7401646a87edcbe85f29c0bcf40017386d0d8039c36b5da5e3bbe31eb4efe5ff562f7ca680a671387","name":"test_data.csv","type":"text/csv","lastModified":1651302012823.08,"size":558632}] 2f:{"id":"aa9aaa1a6466edb4","slug":"the-netflix-nexus","title":"The Netflix Nexus","thumbnail":"6e4b03b422b7fc6a8c36d737375c9f8a9e1707a20e77729277bd15de4fba1dd7","access_level":"public","create_time":"$D2022-04-28T18:34:57.799Z","update_time":"$D2022-05-09T21:08:33.288Z","view_time":null,"first_public_time":"$D2022-04-30T04:00:02.060Z","fork":{"id":"245fe77b339c3d44","slug":"netflix-gatekeeping-exploratory/2","title":"The Netflix Nexus - Deprecated","owner":{"id":"a0518cd4a93bd4f2","login":"205e184174312240","name":"Amrutavarsh Kinagi"}},"stars":1,"starred":false,"owner":{"type":"team","id":"a0518cd4a93bd4f2","login":"205e184174312240","name":"Amrutavarsh Kinagi","avatar_url":"https://avatars-next.observableusercontent.com/c236b7f0d2dc06594e0f3071128e7a9962367ba42205a398ddc5a14867d3e599","tier":"starter_2024"},"version":2004,"publish_version":2004,"role":null,"authored":false,"authors":[{"type":"individual","id":"205e184174312240","login":"205e184174312240","name":"Amrutavarsh Kinagi","avatar_url":"https://avatars-next.observableusercontent.com/c236b7f0d2dc06594e0f3071128e7a9962367ba42205a398ddc5a14867d3e599","tier":null}],"members":[{"type":"individual","id":"09bb7f7328cf8a74","login":"09bb7f7328cf8a74","name":"Audrey Leong","avatar_url":"https://avatars-next.observableusercontent.com/c236b7f0d2dc06594e0f3071128e7a9962367ba42205a398ddc5a14867d3e599","tier":null,"role":"editor"},{"type":"individual","id":"205e184174312240","login":"205e184174312240","name":"Amrutavarsh Kinagi","avatar_url":"https://avatars-next.observableusercontent.com/c236b7f0d2dc06594e0f3071128e7a9962367ba42205a398ddc5a14867d3e599","tier":null,"role":"editor"},{"type":"individual","id":"54999bcfeed37795","login":"jcha0621","name":"","avatar_url":"https://avatars-next.observableusercontent.com/e039a601a9d06b2180a6094ab608130b2a18a48e9adb175ca7ca92afabd8bf47","tier":null,"role":"editor"},{"type":"individual","id":"3fe772c1c0190bbd","login":"yva2002","name":"Yamini Ananth","avatar_url":"https://avatars-next.observableusercontent.com/c10c0b7518abe08dda3fa8d8075d87e76017ba08601ac9a91442fe331c86eea9","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":8,"collection":null,"type":"notebook","body":{"title":"The Netflix Nexus","cells":[{"id":0,"value":"# The Netflix Nexus\n## Discovering Key Players that influence Global Media on Netflix ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":788,"value":"Yamini Ananth, Audrey Leong, Amrutavarsh Kinagi, Jenny Cha","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":608,"value":"## What does it mean to be a key player?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":615,"value":"In the arc diagram below, we’ve visualized how countries export their media to other countries. \nKey players are the denser nodes; for example, we see tons of pink, as the US exports to almost every in the world. We can also see a lot of Japanese exports in orange, and purple from the UK. Within Latin America, \n\nColombia is a major exporter of media as well. Key players have a global impact! But, is this impact all their own?\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":629,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":403,"value":"## Case Study - Mexican Media in Europe\n\nMost weeks from July 2021 to March 2022, Mexico has produced media trending in Europe that ranked in the top 10.\nYou might not be super surprised - Spanish shows might be trending in European Spanish speaking countries.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":472,"value":"Plot.plot({\n height:350,\n width:800,\n marginBottom:100,\n y: {\n label: \"↑ Performance\",\n domain: [0,10],\n grid: true\n },\n x: {\n tickFormat: d3.utcFormat(\"%d-%b-%Y\"),\n tickRotate: -90,\n },\n marks: [\n Plot.barY(filtered_mexico_in_europe.filter(d => d.measure_name.match(\"sole_producer\")),{x: \"week\", y: d => Math.abs(d.weekly_rank), fill: \"#73d3ff\", title: (d) => `Popularity: ${Math.abs(d.weekly_rank).toFixed(2)}`}),\n ]\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1183,"value":"But, is that what’s really happening? \nPlenty of shows around the world aren’t produced in (or by) just one country. Is Mexico generating all of this media that gets super popular in Europe by itself?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":385,"value":"

Does US backing affect Mexican media performance in Europe?

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":1196,"value":"Here, we’ve split up shows that were created by Mexico from shows that were jointly created by Mexico and the US. \nWe can see that, actually, a lot of the most popular media (ranked the highest) are actually co-produced with the US!\nThough this may not be entirely surprising, it gives us this concept that our key player countries from before could, in fact, provide a boost for certain geographic regions","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":509,"value":"Purple indicates US backed Mexican media popularity in Europe.
\nBlue shows solely Mexican produced shows","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":483,"value":"Plot.plot({\n width:800,\n marginBottom:100,\n y: {\n label: \"↑ Performance\",\n domain: [-10,10],\n grid: true\n },\n x: {\n tickFormat: d3.utcFormat(\"%d-%b-%Y\"),\n tickRotate: -90,\n },\n color: {\n range: [\"#73d3ff\", \"#9173ff\"]\n },\n marks: [\n Plot.barY(filtered_mexico_in_europe,{x: \"week\", y: \"weekly_rank\", fill: d=> Math.sign(d.weekly_rank), title: (d) => `Popularity: \\n ${d.weekly_rank.toFixed(2)}`})\n ],\n tooltip: {\n fill: \"#FFBF00\",\n stroke: \"#FFBF00\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":496,"value":"

To gauge improvement in performance, we can look at a delta graph instead.

\nGreen indicates how much better US backed Mexican media performs in Europe.
\nRed shows US backed Mexican media that performed worse in Europe. In other words, shows produced only by Mexico did great by themselves.\n
\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":1226,"value":"What we’ve done here is subtract the US-backed Mexican media from the purely Mexican media to see what remains.

\n\nThe more green you see, the more a US backing makes a difference; more red, and Mexico doesn't need the US backing for its media to succeed.

\nThere are two ways to interpret a blank for a given week:
\n 1) Mexican shows didn't trend in the top ten.
\n 2) Mexican shows and US backed Mexican shows performed equally as well.\n

\n\n","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":1478,"value":"Plot.plot({\n width:800,\n marginBottom:100,\n y: {\n label: \"↑ Performance Delta\",\n domain: [-10,10],\n grid: true\n },\n x: {\n tickFormat: d3.utcFormat(\"%d-%b-%Y\"),\n tickRotate: -90,\n },\n color: {\n range: [\"#e15759\", \"#45c421\"]\n },\n marks: [\n Plot.barY(filtered_data_Mexico_US.filter(d => d.destination_continent == \"Europe\"),{x: \"week\", y: \"val\", fill: d => Math.sign(d.val), title: (d) => `Popularity Delta:\\n ${Number(d.val).toFixed(2)}`})\n ],\n tooltip: {\n fill: \"#FFBF00\",\n stroke: \"#FFBF00\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1369,"value":"You can see that, for the most part, like we saw earlier, the US-backed Mexican media is doing better in Europe, by a significant margin. But, is this effect equal across all continents? ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":409,"value":"## Does the boosting effect of US-backed Mexican media percolate to the rest of the world?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1264,"value":"We can see this effect across all continents to an extent. US-backed Mexican shows do worse compared to purely Mexican shows in North and South America. But in Europe, and to some extent Asia, having the US as a backer really improves performance.

\nThis is pretty interesting, and gives us a cool framework for understanding how a key player might boost another country’s media around the world.","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":413,"value":"Plot.plot({\n height: 650,\n width: 800,\n marginBottom:100,\n y: {\n label: \"↑ Performance Delta\",\n domain: [-10,10],\n grid: true\n },\n x: {\n tickFormat: d3.utcFormat(\"%d-%b-%Y\"),\n tickRotate: -90,\n },\n facet: {\n data: filtered_data_Mexico_US,\n y: \"destination_continent\",\n marginRight: 90 \n },\n color: {\n range: [\"#e15759\", \"#45c421\"]\n },\n marks: [\n Plot.frame(),\n Plot.barY(filtered_data_Mexico_US,{x: \"week\", y: \"val\", fill: d => Math.sign(d.val), title: (d) => `Popularity Delta:\\n ${Number(d.val).toFixed(2)}`})\n ],\n tooltip: {\n fill: \"#FFBF00\",\n stroke: \"#FFBF00\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":340,"value":"## Now let's see if this \"boosting\" effect is generalizable!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1295,"value":"In order to really compare the effects, we expand our delta graph from before for side-by-side comparison.\nThe graph allows you to select two investing sources and see how that impacts a country of interest. If you see more green, this means that the investing source helps boost a country. On the other hand, if you see more red, that means the origin country is doing well by itself.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":647,"value":"Let's take a specific example to illustrate this visualization. Mexico is producing media that goes viral around the world every week.\nBut from graph below, we can see on the left that Mexico gets a performance boost from the US in every single continent. Comparing this to South Korea as a co-producer on the right, we say that unlike the US, South-Korea doesn’t offer much help at all. Instead, purely Mexican media performs better, even in South Korea’s home continent, Asia.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1936,"value":"Now, feel free to test out different combinations of countries to see what interesting key players and co-producers you can discover!","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":1746,"value":"
\n
\n
\n
Country of Interest
${Inputs.bind(dependent_f, viewof dependent_country)}
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
${Inputs.bind(key_source_f1, viewof key_source)}
\n
Co-Producers
\n
${Inputs.bind(key_source_f2, viewof vs_key_source)}
\n
\n
","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":543,"value":"Plot.plot({\n height: 650,\n width: 1200,\n marginBottom:100,\n y: {\n label: \"↑ Performance Delta\",\n domain: [-10,10],\n grid: true\n },\n x: {\n tickFormat: d3.utcFormat(\"%d-%b-%Y\"),\n tickRotate: -90\n },\n facet: {\n data: filtered_rank_data_delta, \n y: \"destination_continent\",\n x: \"idx\",\n marginRight: 90,\n label: \"\"\n },\n color: {\n range: [\"#e15759\",\"#fff\", \"#45c421\"]\n },\n marks: [\n Plot.frame(),\n Plot.barY(filtered_rank_data_delta,{x: \"week\", y: \"val\", fill: d => threshold(d.val), title: (d) => `Popularity Delta:\\n ${Number(d.val).toFixed(2)}`})\n ],\n tooltip: {\n fill: \"#FFBF00\",\n stroke: \"#FFBF00\",\n }\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1883,"value":"
\n
\n
${classify_blurb(key_source, true)}
\n
\n
${classify_blurb(vs_key_source, true)}
\n
\n
\n
\n
\n
${classify_blurb(key_source, false)}
\n
\n
\n
","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":1325,"value":"
\n
\n
${map_blurb()}
\n
\n
\n
","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":1990,"value":"

","pinned":false,"hidden":false,"mode":"html","author":"$undefined","summary":"$undefined"},{"id":80,"value":"## Data manipulation","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":532,"value":"rank_data = FileAttachment(\"mega_ultimate_god_data_arg_max_avg_weekly_rank_with_delta.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":422,"value":"filtered_mexico_in_europe = { \n let filtered_data = rank_data.filter(function (d){\n return d.key_source.match(\"United States\") && d.dependent_country.match(\"Mexico\") && d.destination_continent.match(\"Europe\") && !(d.measure_name.match(\"delta\"))\n})\n let data = []\n for (const d of filtered_data) {\n for (const w of weeks) {\n if(d.measure_name.match(\"sole_producer\")){\n data.push({week:new Date(w), weekly_rank: d[w] - 11, measure_name: d.measure_name})\n }\n else{\n data.push({week:new Date(w), weekly_rank: 11 - d[w], measure_name: d.measure_name})\n }\n }\n }\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":567,"value":"filtered_data_Mexico_US = {\n let filtered_data = rank_data.filter(function (d){\n return d.key_source.match(\"United States\") && d.dependent_country.match(\"Mexico\") && d.measure_name.match(\"delta\")\n})\n return data_unroll(filtered_data)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":535,"value":"filtered_rank_data_delta = { \n let filtered_data = rank_data.filter(function (d){\n return (d.key_source.match(key_source) || d.key_source.match(vs_key_source)) && d.dependent_country.match(dependent_country) && d.measure_name.match(\"delta\")\n})\n return data_unroll_with_index(filtered_data)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1807,"value":"filtered_rank_data_delta_all = { \n let filtered_data = rank_data.filter(function (d){\n return d.dependent_country.match(dependent_country) && d.measure_name.match(\"delta\")\n})\n return data_unroll(filtered_data)\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":619,"value":"links_data = FileAttachment(\"number_links_dataset_9-26-2021@1.csv\").csv()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1981,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":335,"value":"## Helpers","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":9,"value":"viewof key_source = new Inputs.input(\"United States\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":288,"value":"viewof vs_key_source = new Inputs.input(\"South Korea\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":12,"value":"viewof dependent_country = new Inputs.input(\"Mexico\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":6,"value":"weeks = ['7/4/21',\n '7/11/21',\n '7/18/21',\n '7/25/21',\n '8/1/21',\n '8/8/21',\n '8/15/21',\n '8/22/21',\n '8/29/21',\n '9/5/21',\n '9/12/21',\n '9/19/21',\n '9/26/21',\n '10/3/21',\n '10/10/21',\n '10/17/21',\n '10/24/21',\n '10/31/21',\n '11/7/21',\n '11/14/21',\n '11/21/21',\n '11/28/21',\n '12/5/21',\n '12/12/21',\n '12/19/21',\n '12/26/21',\n '1/2/22',\n '1/9/22',\n '1/16/22',\n '1/23/22',\n '1/30/22',\n '2/6/22',\n '2/13/22',\n '2/20/22',\n '2/27/22',\n '3/6/22',\n '3/13/22',\n '3/20/22']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":896,"value":"all_dependent_countries =[\"Brazil\",\"Turkey\",\"Philippines\",\"Thailand\",\"Malaysia\",\"Norway\",\"Ireland\",\"Hong Kong\",\"Israel\",\"Canada\",\"Mexico\",\"Colombia\",\"Spain\",\"France\",\"Germany\",\"Italy\",\"Nigeria\",\"India\",\"China\",\"Japan\",\"New Zealand\",\"South Korea\",\"Australia\",\"United Kingdom\",\"United States\"].sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":626,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":553,"value":"data_unroll = function(dataset) {\n let data = []\n for (const d of dataset) {\n for (const w of weeks) {\n data.push({week: new Date(w), measure_name:d.measure_name, val: d[w], destination_continent: d.destination_continent, key_source: d.key_source})\n }\n }\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1732,"value":"data_unroll_with_index = function(dataset) {\n let data = []\n for (const d of dataset) {\n for (const w of weeks) {\n data.push({week: new Date(w), measure_name:d.measure_name, val: d.key_source.match(dependent_country) ? 0 : d[w], destination_continent: d.destination_continent, key_source: d.key_source, idx: (d.key_source.match(key_source) ? 0 : 1)})\n }\n }\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1706,"value":"threshold = function(d){\n if(d>0){\n return 1\n }\n else if(d<0){\n return -1\n }\n return 0\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1880,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1897,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":893,"value":"dependent_f = select({\n title: \"\",\n options: all_dependent_countries,\n selected: \"Mexico\",\n selectStyle: {\n background: \"#ff9c9d\",\n \"font-size\": \"15px\",\n height: \"30px\"\n },\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1202,"value":"key_source_f1 = select({\n title: \"\",\n options: [\"United States\", \"United Kingdom\", \"Japan\",\"South Korea\", \"Canada\", \"Spain\", \"Colombia\", \"Germany\", \"New Zealand\"],\n selected: \"United States\",\n selectStyle: {\n background: \"#b2f2a0\",\n \"font-size\": \"15px\",\n height: \"30px\"\n },\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1061,"value":"key_source_f2 = select({\n title: \"\",\n options: [\"United States\", \"United Kingdom\", \"Japan\",\"South Korea\", \"Canada\", \"Spain\", \"Colombia\", \"Germany\", \"New Zealand\"],\n selected: \"South Korea\",\n selectStyle: {\n background: \"#b2f2a0\",\n \"font-size\": \"15px\",\n height: \"30px\"\n },\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":907,"value":"## Imports","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined"},{"id":911,"value":"import { select } from \"@bartok32/diy-inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":921,"value":"import {Plot} from \"@mkfreeman/plot-tooltip\"\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1075,"value":"bootstrap = require('bootstrap')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1173,"value":"html`css `","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"