2b:null 2c:["$","title",null,{"children":"Where the Stories Happen: Exploring San Francisco Through Its On-Screen Locations | SHUFANFAN's Wonderland | Observable"}] 31:T5e0,vl.markBar() .data(filmLocationData) .transform( vl.filter('datum["Analysis Neighborhood"] != null && datum["Analysis Neighborhood"] !== ""'), vl.groupby('Analysis Neighborhood') .aggregate(vl.distinct('Title').as('Total Movies Shot')), vl.window(vl.rank().as('Rank')).sort(vl.field('Total Movies Shot').order('descending')), vl.filter('datum.Rank <= 10') ) .encode( vl.x().fieldQ('Total Movies Shot'), vl.y().fieldN('Analysis Neighborhood').sort(vl.sum('Total Movies Shot').order('descending')).title('Neighborhood'), vl.tooltip(["Total Movies Shot"]), vl.color().fieldN('Analysis Neighborhood') .title('Neighborhood') .scale({ domain: [ "Financial District/South Beach", "North Beach", "Nob Hill", "Tenderloin", "Chinatown", "Mission", "Russian Hill", "South of Market", "Hayes Valley", "Potrero Hill" ], range: [ "#2C4C78", // Financial District/South Beach "#874C62", // North Beach "#FFD700", // Nob Hill "#bab0ab", // Tenderloin "#f28e2b", // Chinatown "#AD5D9B", // Mission "#FCC9B9", // Russian Hill "#9C755F", // South of Market "#A8C686", // Hayes Valley "#F6BD60" // Potrero Hill ] }) ) .title("Top 10 shoting neighborhoods in San Francisco(1915-2023)") .height(300) .width(800) .render()32:T6af,vl.markBar() .data(filmLocationData) .transform( vl.filter('datum.Locations != null && datum.Locations !== ""'), vl.groupby('Locations') .aggregate(vl.distinct('Title').as('Total Movies Shot')), vl.window(vl.rank().as('Rank')).sort(vl.field('Total Movies Shot').order('descending')), vl.filter('datum.Rank <= 10') ) .encode( vl.x().fieldQ('Total Movies Shot'), vl.y().fieldN('Locations').sort(vl.sum('Total Movies Shot').order('descending')).title('Location'), vl.tooltip(["Total Movies Shot"]), vl.color().fieldN('Locations').legend({ title: 'Location', labelLimit: 300 }) .scale({ domain: [ 'Golden Gate Bridge', 'City Hall', 'Fairmont Hotel (950 Mason Street, Nob Hill)', 'Treasure Island', 'Coit Tower', 'Palace of Fine Arts (3301 Lyon Street)', "St. Peter & Paul's Church (666 Filbert Street, Washington Square)", 'Chinatown', 'Golden Gate Park', 'Bay Bridge' ], range: [ '#E15759', // Golden Gate Bridge → Presidio '#bab0ab', // City Hall → Tenderloin '#FFD700', // Fairmont Hotel → Nob Hill '#4C9FBF', // Treasure Island → Other '#874C62', // Coit Tower → North Beach '#E4B07B', // Palace of Fine Arts → Marina '#874C62', // St. Peter's Church → North Beach '#f28e2b', // Chinatown '#4C9141', // Golden Gate Park '#9C755F' // Bay Bridge → South of Market ] }) ) .title("Top 10 shoting Locations in San Francisco(1915-2023)") .height(200) .width(500) .render()33:T52d,vl.markRect({ tooltip: true, stroke: "white",strokeWidth: 1 }) .data(filmLocationData) .transform( vl.filter('datum["Locations"] != null && datum["Release Year"] != null && datum["Title"] != null'), vl.filter('datum["Locations"] === "Golden Gate Bridge" || ' + 'datum["Locations"] === "City Hall" || ' + 'datum["Locations"] === "Fairmont Hotel (950 Mason Street, Nob Hill)" || ' + 'datum["Locations"] === "Treasure Island" || ' + 'datum["Locations"] === "Coit Tower" || ' + 'datum["Locations"] === "Palace of Fine Arts (3301 Lyon Street)" || ' + 'datum["Locations"] === "St. Peter & Paul\'s Church (666 Filbert Street, Washington Square)" || ' + 'datum["Locations"] === "Chinatown" || ' + 'datum["Locations"] === "Golden Gate Park" || ' + 'datum["Locations"] === "Bay Bridge"'), vl.groupby(["Release Year", "Locations"]) .aggregate(vl.distinct("Title").as("Unique Movies")) ) .encode( vl.x().fieldO("Release Year").title("Year"), vl.y().fieldN("Locations").title("Location"), vl.color().fieldQ("Unique Movies").title("Number of Movies") ) .title("Heatmap of Top 10 Shooting Locations by Year(1915-2023)") .width(1000) .height(200) .render() 34:Te71,svg = { let height = 500; let width = 600; let radius = Math.min(width, height) / 2.5; let svg = d3.select(DOM.svg(width + 200, height + 200)); let g = svg.append("g") .attr("transform", `translate(${(width + 200)/2}, ${(height + 200)/2})`); let colorScale = d3.scaleOrdinal() .domain(["Masterpiece", "Good", "Average", "Below Average", "Poor", "Not Rated"]) .range([ "#C2A0FF", "#FF9CEE", "#85FFCA", "#5BCEFA", "#FF7A93", "#FFDE59" ]); let pie = d3.pie() .sort(null) .value(d => d.value); let arc = d3.arc() .outerRadius(radius) .innerRadius(0); let labelArc = d3.arc() .outerRadius(radius * 0.8) .innerRadius(radius * 0.8); let outerLabelArc = d3.arc() .outerRadius(radius * 1.4) .innerRadius(radius * 1.4); const smallSectorThreshold = 7; let arcs = g.selectAll(".arc") .data(pie(chartData.data)) .enter().append("g") .attr("class", "arc"); arcs.append("path") .attr("d", arc) .style("fill", d => colorScale(d.data.category)) .style("stroke", "white") .style("stroke-width", 2); let total = chartData.data.reduce((sum, d) => sum + d.value, 0); arcs.filter(d => (d.data.value / total * 100) < smallSectorThreshold) .append("polyline") .attr("points", function(d) { let centroid = arc.centroid(d); let midAngle = Math.atan2(centroid[1], centroid[0]); let x1 = Math.cos(midAngle) * radius; let y1 = Math.sin(midAngle) * radius; let x2 = Math.cos(midAngle) * (radius * 1.2); let y2 = Math.sin(midAngle) * (radius * 1.2); let x3 = Math.cos(midAngle) * (radius * 1.4); let y3 = Math.sin(midAngle) * (radius * 1.4); x3 = x3 + (x3 > 0 ? 20 : -20); return [x1, y1, x2, y2, x3, y3].join(","); }) .style("fill", "none") .style("stroke", "#666") .style("stroke-width", 1); arcs.filter(d => (d.data.value / total * 100) >= smallSectorThreshold) .append("text") .attr("transform", d => `translate(${labelArc.centroid(d)})`) .attr("dy", ".35em") .style("text-anchor", "middle") .style("font-size", "14px") .style("font-weight", "bold") .style("fill", "white") .text(d => `${(d.data.value / total * 100).toFixed(2)}%`); arcs.filter(d => (d.data.value / total * 100) < smallSectorThreshold) .append("text") .attr("transform", function(d) { let centroid = arc.centroid(d); let midAngle = Math.atan2(centroid[1], centroid[0]); let x = Math.cos(midAngle) * (radius * 1.4); let y = Math.sin(midAngle) * (radius * 1.4); x = x + (x > 0 ? 25 : -25); return `translate(${x},${y})`; }) .attr("dy", ".35em") .style("text-anchor", d => { let centroid = arc.centroid(d); let midAngle = Math.atan2(centroid[1], centroid[0]); let x = Math.cos(midAngle); return x > 0 ? "start" : "end"; }) .style("font-size", "12px") .style("font-weight", "bold") .text(d => `${(d.data.value / total * 100).toFixed(2)}%`); let legend = svg.append("g") .attr("transform", `translate(${width + 50}, ${height/2 - 60})`) .selectAll(".legend") .data(chartData.data) .enter().append("g") .attr("class", "legend") .attr("transform", (d, i) => `translate(0,${i * 25})`); legend.append("rect") .attr("width", 18) .attr("height", 18) .style("fill", d => colorScale(d.category)); legend.append("text") .attr("x", 24) .attr("y", 9) .attr("dy", ".35em") .style("font-size", "14px") .text(d => d.category); return svg.node(); }35:T62f,chart1 = { const links = data4.links.map(d => Object.create(d)); const nodes = data4.nodes.map(d => Object.create(d)); const simulation = d3.forceSimulation(nodes) .force("link", d3.forceLink(links).id(d => d.id).distance(80).strength(0.8)) .force("charge", d3.forceManyBody().strength(d => -45*d.weight)) .force("center", d3.forceCenter(width /2, height / 2)); const svg = d3.create("svg") .attr("viewBox", [0, 0, width, height]); const link = svg.append("g") .attr("stroke", "#999") .selectAll("line") .data(links) .join("line") .attr("stroke-opacity", opacity) .attr("stroke-width", d => Math.sqrt(d.value)); const node = svg.append("g") .attr("stroke", "#fff") .attr("stroke-width", .5) .selectAll("circle") .data(nodes) .join("circle") .attr("r", size) .attr("fill", color) .call(drag(simulation)); node.append("title") .text(d => d.id); const label = svg.append("g") .attr("font-family", "sans-serif") .attr("font-size", 10) .attr("fill", "#333") .selectAll("text") .data(nodes) .join("text") .text(d => d.id); simulation.on("tick", () => { link .attr("x1", d => d.source.x) .attr("y1", d => d.source.y) .attr("x2", d => d.target.x) .attr("y2", d => d.target.y); node .attr("cx", d => d.x) .attr("cy", d => d.y); label .attr("x", d => d.x + 6) .attr("y", d => d.y + 3); }); invalidation.then(() => simulation.stop()); return svg.node(); }36:T6bf,function swatches({ color, columns = null, format = x => x, swatchSize = 15, swatchWidth = swatchSize, swatchHeight = swatchSize, marginLeft = 0 }) { const id = DOM.uid().id; function entity(character) { return `&#${character.charCodeAt(0).toString()};`; } if (columns !== null) return html`

${color.domain().map(value => { const label = format(value); return html`

${document.createTextNode(label)}

`; })}

`; return html`

${color.domain().map(value => html`${document.createTextNode(format(value))}`)}

`; }37:T42a,genreNeighborhoodCounts = { const titleToGenres = new Map(); imdb.forEach(d => { if (d.primaryTitle && d.genres && d.genres !== "\\N") { const genres = d.genres.split(',').map(g => g.trim()); titleToGenres.set(d.primaryTitle.toLowerCase(), genres); } }); const genreNeighborhoodSet = new Set(); filmLocationData.forEach(d => { const title = d.Title?.toLowerCase(); const neighborhood = d["Analysis Neighborhood"]; if (title && neighborhood && titleToGenres.has(title)) { const genres = titleToGenres.get(title); genres.forEach(genre => { genreNeighborhoodSet.add(JSON.stringify({ genre, neighborhood })); }); } }); const pairs = Array.from(genreNeighborhoodSet).map(d => JSON.parse(d)); const grouped = d3.rollups( pairs, v => v.length, d => d.genre, d => d.neighborhood ); return grouped.flatMap(([genre, groups]) => groups.map(([neighborhood, count]) => ({ genre, "Analysis Neighborhood": neighborhood, "Genre Presence": count })) ); }38:T66d,genreNeighborhoodCountsbyYear = { const titleToGenres = new Map(); const titleToYear = new Map(); imdb.forEach(d => { if (d.primaryTitle && d.genres && d.genres !== "\\N") { const genres = d.genres.split(',').map(g => g.trim()); titleToGenres.set(d.primaryTitle.toLowerCase(), genres); if (d.startYear && d.startYear !== "\\N") { const year = parseInt(d.startYear); if (!isNaN(year)) { titleToYear.set(d.primaryTitle.toLowerCase(), year); } } } }); const genreNeighborhoodYearSet = new Set(); filmLocationData.forEach(d => { const title = d.Title?.toLowerCase(); const neighborhood = d["Analysis Neighborhood"]; if (title && neighborhood && titleToGenres.has(title)) { const genres = titleToGenres.get(title); const year = titleToYear.has(title) ? titleToYear.get(title) : null; genres.forEach(genre => { genreNeighborhoodYearSet.add(JSON.stringify({ genre, neighborhood, year })); }); } }); const triplets = Array.from(genreNeighborhoodYearSet).map(d => JSON.parse(d)); const grouped = d3.rollups( triplets, v => v.length, d => d.genre, d => d.neighborhood, d => d.year ); return grouped.flatMap(([genre, neighborhoodGroups]) => neighborhoodGroups.flatMap(([neighborhood, yearGroups]) => yearGroups.map(([year, count]) => ({ genre, "Analysis Neighborhood": neighborhood, "year": year, "Genre Presence": count })) ) ); }39:[{"id":"57e6636c375322d077e58d5fba346d237c34391f108ec499c52f842eddfedf6a6a3e3158df982d6b9d273ff08b2a6893ddcfa6d2876f41086ba38c77638a4635","href":"https://static.observableusercontent.com/files/57e6636c375322d077e58d5fba346d237c34391f108ec499c52f842eddfedf6a6a3e3158df982d6b9d273ff08b2a6893ddcfa6d2876f41086ba38c77638a4635","name":"SF_movie_IMDBratings@4.csv","type":"text/csv","lastModified":1744829556715.604,"size":16736},{"id":"f76e459e34b73a2b4258cff62389f697e11342f4e5cee5f655f5d1b048f356c26f78f56e2993e0e59445f63bf97f75cbdc69c861d8ef79630ad65df7076c0ae2","href":"https://static.observableusercontent.com/files/f76e459e34b73a2b4258cff62389f697e11342f4e5cee5f655f5d1b048f356c26f78f56e2993e0e59445f63bf97f75cbdc69c861d8ef79630ad65df7076c0ae2","name":"genres@1.json","type":"application/json","lastModified":1744829854136.042,"size":14801},{"id":"842ac914d19788087faed9f50b6d9d7941d32812ea3075c479ac281fce55bed870b693c25063d176d50eb9a2d0923cf43c5825851c8c252510e6fc2ec5fdc7db","href":"https://static.observableusercontent.com/files/842ac914d19788087faed9f50b6d9d7941d32812ea3075c479ac281fce55bed870b693c25063d176d50eb9a2d0923cf43c5825851c8c252510e6fc2ec5fdc7db","name":"merged_dataset.csv","type":"text/csv","lastModified":1745017555740.009,"size":651605},{"id":"abd2d7479fcd69467e53fdded1c1a82da9b7af06774f6bccc091d9513c9adff9dfb07f2a023dfa5c816b9f1786e0ee985de39c4d3d3e10107df5b5aeb94f58df","href":"https://static.observableusercontent.com/files/abd2d7479fcd69467e53fdded1c1a82da9b7af06774f6bccc091d9513c9adff9dfb07f2a023dfa5c816b9f1786e0ee985de39c4d3d3e10107df5b5aeb94f58df","name":"imdb_movie_rating.csv","type":"text/csv","lastModified":1744509885625.283,"size":13866767}] 2f:{"id":"a5712431cedf88c1","slug":null,"title":"Where the Stories Happen: Exploring San Francisco Through Its On-Screen Locations","thumbnail":"56199a9ce0353fdac0b829bc2d4c557316d8698c562809ba48be92a842eafa57","access_level":"public","create_time":"$D2025-04-02T02:45:27.772Z","update_time":"$D2025-04-20T02:55:45.722Z","view_time":null,"first_public_time":"$D2025-04-20T16:07:14.487Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"1ad99fb155196e53","login":"shufanfans-wonderland","name":"SHUFANFAN's Wonderland","avatar_url":"https://avatars-next.observableusercontent.com/17f5ed3e20c171843fb00c257befd5e673b26865608efcf85db98be7174cb621","tier":"starter_2024","bio":""},"version":958,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"a66d9c6f7c527559","login":"shufan-chai","name":"Shufan Chai","avatar_url":"https://avatars-next.observableusercontent.com/c9b39c358d361b518562d961d655caa1a16cee2580758c0c44efaf089197ceda","tier":null,"bio":"Thou art more lovely and more temperate."}],"members":[{"type":"individual","id":"a66d9c6f7c527559","login":"shufan-chai","name":"Shufan Chai","avatar_url":"https://avatars-next.observableusercontent.com/c9b39c358d361b518562d961d655caa1a16cee2580758c0c44efaf089197ceda","tier":null,"role":"editor"},{"type":"team","id":"1ad99fb155196e53","login":"shufanfans-wonderland","name":"SHUFANFAN's Wonderland","avatar_url":"https://avatars-next.observableusercontent.com/17f5ed3e20c171843fb00c257befd5e673b26865608efcf85db98be7174cb621","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Where the Stories Happen: Exploring San Francisco Through Its On-Screen Locations","cells":[{"id":0,"value":"# Where the Stories Happen: Exploring San Francisco Through Its On-Screen Locations","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":121,"value":"## Idiom 3: Is there an upward or downward trend in the number of movie shoots over the years?\n\nNote: Due to data limitations, the release year is used as a proxy for filming year. This may introduce a delay of 1–2 years between actual production and release.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":123,"value":"linechart = vl.markLine({tooltip: true, stroke: '#ff7f0e'})\n .data(filmLocationData)\n .transform(\n vl.filter('datum[\"Release Year\"] != null && datum[\"Title\"] != null'),\n vl.groupby('Release Year')\n .aggregate(vl.distinct('Title').as('Unique Movies'))\n \n )\n .encode(\n vl.x().fieldT('Release Year'),\n vl.y().fieldQ('Unique Movies').title('Number of movies'),\n )\n .title('Number of Movies Released that Were Filmed in San Francisco Over Time(1915 - 2023)')\n .width(700)\n .height(400)\n .render()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":450,"value":"data3 = FileAttachment(\"imdb_movie_rating.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":892,"value":"vl.markBar({tooltip: true})\n .data(imdb) \n .transform(\n vl.filter('datum.Type != null'), \n vl.groupby('Type')\n .aggregate(vl.sum('Number of Locations').as('Total Locations')) \n )\n .encode(\n vl.x().fieldN('Type').axis({ labelAngle: 45 }),\n vl.y().fieldQ('Total Locations').title('Total Number of Locations'), \n vl.tooltip(['Type', 'Total Locations']),\n vl.color().fieldN('Type')\n .scale({\n domain: [\n \"movie\", \"tvSeries\", \"short\", \"tvMovie\", \"tvEpisode\", \"video\"\n ],\n range: [\n \"#C2A0FF\", \n \"#FF9CEE\", \n \"#85FFCA\", \n \"#FF7A93\", \n \"#FFDE59\", \n \"#5BCEFA\" \n ]\n }))\n \n .width(500)\n .height(300)\n .title('Total Number of Filming Locations by Type')\n \n .render();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":903,"value":" The “movie” category refers to feature-length films released in theaters or on streaming platforms. “Short” includes short films, usually under 40 minutes, often created by independent or student filmmakers. “tvEpisode” represents individual episodes within a television series, while “tvMovie” refers to full-length movies made specifically for television broadcast. “tvSeries” captures productions at the series level, indicating that at least part of the show was filmed in San Francisco, without specifying individual episodes. Lastly, “video” includes other media types such as music videos, reality TV segments, promotional content, or online-only releases.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":27,"value":"## Overview of the film locations in San Francisco(1914-2023)\nEach dot on the map represents a filming location","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":87,"value":"The areas with the highest concentration of film shooting locations are in the northeastern part of San Francisco, particularly the following neighborhoods:\n\nNear Chinatown\n\nUnion Square and the Financial District\n\nNorth Beach\n\nNob Hill\n\nAlong the Market Street Corridor\n\nThe waterfront area, including Fisherman's Wharf","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":929,"value":"swatches({\n color: d3.scaleOrdinal([\"movie\", \"tvSeries\", \"short\", \"tvMovie\", \"tvEpisode\", \"video\"], colors1)\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":54,"value":"chart = { \n const svg = d3.select(DOM.svg(width, height))\n .style(\"width\", \"100%\")\n .style(\"height\", \"auto\")\n \n svg.append(\"g\")\n .selectAll(\"path\")\n .data(mapData.features)\n .enter().append(\"path\")\n .attr(\"d\", path)\n .style(\"stroke\", \"#ddd\")\n .style(\"fill\", \"none\")\n \n svg.append(\"g\")\n \t.selectAll(\"circle\")\n \t.data(filmsLocationDataCoords)\n \t.enter().append(\"circle\")\n .attr(\"cx\", d => projection(d)[0])\n .attr(\"cy\", d => projection(d)[1])\n .attr(\"r\", 2.5)\n .style(\"fill\", d => typeColors(d[2]))\n \n return svg.node();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"## Idiom 2: Which neighborhood has the most shoots?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":99,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":206,"value":"## Idiom 5 & 6: Which location has the most shoots?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":208,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":217,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"### Idiom 4: Were certain neighborhoods especially popular for movie shoots in specific years?\n\nNote: Release year is used as a proxy for shooting year due to data limitations.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":131,"value":"vl.markRect({tooltip: true, stroke: \"white\",strokeWidth: 1 })\n .data(filmLocationData)\n .transform(\n vl.filter('datum[\"Analysis Neighborhood\"] != null && datum[\"Analysis Neighborhood\"] !== \"\" && datum[\"Release Year\"] != null && datum[\"Title\"] != null'),\n vl.groupby(['Release Year', 'Analysis Neighborhood'])\n .aggregate(vl.distinct('Title').as('Unique Movies'))\n )\n .encode(\n vl.x().fieldO('Release Year'),\n vl.y().fieldN('Analysis Neighborhood').title('Neighborhood'),\n vl.color().fieldQ('Unique Movies').title('Number of Movies')\n )\n .title('Heatmap of Shoot Counts by Neighborhood and Year (1915-2023)')\n .width(1000)\n .height(600)\n .render()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":945,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":947,"value":"margin = {\n return {top: 10, right: 10, bottom: 10, left: 10}\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":943,"value":"chartData = {\n return {\n title: \" \",\n data: [\n { category: \"Masterpiece\", value: 8 },\n { category: \"Good\", value: 114 },\n { category: \"Average\", value: 114 },\n { category: \"Below Average\", value: 55 },\n { category: \"Poor\", value: 19 },\n { category: \"Not Rated\", value: 2 },\n \n ]\n }\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":643,"value":"vl.markRect({tooltip: true, stroke: \"white\",strokeWidth: 1 })\n .params(\n vl.param('Year').value(2023).bind(vl.slider(1914, 2023, 1))\n )\n .data(filmLocationData)\n .transform(\n vl.filter('datum[\"Analysis Neighborhood\"] != null && datum[\"Analysis Neighborhood\"] !== \"\" && datum[\"Release Year\"] != null && datum[\"Title\"] != null'),\n vl.filter('datum[\"Release Year\"] == Year'),\n vl.groupby(['Release Year', 'Analysis Neighborhood'])\n .aggregate(vl.distinct('Title').as('Unique Movies'))\n )\n .encode(\n vl.y().fieldO('Release Year'),\n vl.x().fieldN('Analysis Neighborhood').axis({ title: \"Neighborhood\", labelAngle: 45 }),\n vl.color().fieldQ('Unique Movies').title('Number of Movies')\n )\n .title('Heatmap of Shoot Counts by Neighborhood (Year Selected)')\n .width(700)\n .height(100)\n .render()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":252,"value":"## Idiom 7: Which movie has the most filming locations in San Francisco? ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":824,"value":"Please enter the number(1-312) of works you want to check in the box below:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":807,"value":"viewof inputNumber1 = html``;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":803,"value":"bartchart0 = vl\n .markBar()\n .encode(\n vl.y().fieldN(\"primaryTitle\").sort(\"-x\").axis({ title: \"Title\"}),\n vl.x().fieldQ(\"Number of Locations\"),\n vl.tooltip([\"primaryTitle\", \"averageRating\", \"genres\", \"Type\", \"Number of Locations\"]),\n vl.color().value(\"#87CEEB\")\n \n )\n.data(top_locationsAmount_Movies)\n .title(\"IMDb Top locationsAmount works shot in San Francisco\")\n .width(700)\n \n.render();\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":276,"value":"## Idiom 8: Which movies shot in San Francisco have the highest ratings?\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":299,"value":"Please enter the number(0-312) of works you want to check in the box below:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":301,"value":"viewof inputNumber = html``;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":305,"value":"barchart = vl\n .markBar()\n .encode(\n vl.y().fieldN(\"primaryTitle\").sort(\"-x\").axis({ title: \"Title\"}),\n vl.x().fieldQ(\"averageRating\").axis({ title: \"IMDb Rating Score\" }).scale({domain: [0,10]}),\n vl.tooltip([\"primaryTitle\", \"averageRating\", \"genres\", \"Type\"]),\n vl.color().value(\"#D8BFD8\")\n \n \n )\n.data(top_Rating_Movies)\n .title(\"IMDb Top Rating works shot in San Francisco\")\n \n.render();","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":436,"value":"Note: IMDb ratings range from 0 to 10, where 0 is the lowest and 10 is the highest.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":141,"value":"## Idiom 9: Are certain genres more commonly filmed in certain neighborhoods?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":203,"value":"stackbarchart = vl.markBar()\n .data(genreNeighborhoodCounts)\n .encode(\n vl.y().fieldN(\"Analysis Neighborhood\").sort('-x').title(\"Neighborhood\"),\n vl.x().fieldQ(\"Genre Presence\").title(\"Number of genre \"),\n vl.tooltip([\"genre\"]),\n vl.color().fieldN(\"genre\").scale({\n domain: [\"Comedy\", \"Drama\", \"Romance\", \"Thriller\", \"Mystery\", \"Crime\", \"Sci-Fi\", \"Suspense\", \"Action\", \"Short\", \"Horror\", \"Documentary\", \"Adventure\", \"Fantasy\", \"Family\", \"Game-Show\", \"Talk-Show\", \"Biography\", \"Film-Noir\", \"Animation\", \"Sport\", \"Music\", \"Reality-TV\", \"History\", \"Musical\", \"Western\", \"War\"],\n range: colors\n}).title(\"Genre\")\n )\n .width(800)\n .height(700)\n .title(\"Genres by Neighborhood\")\n .render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":323,"value":"## Idiom 10 & 11: What relationships exist between movie genres in films shot in San Francisco?","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":364,"value":"viewof selectedGenres = searchCheckbox(Genres, {label: \"Select genres\", value: [\"Comedy\"], height: 100})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":407,"value":"networkchart2 = {\n const base = vl.markRect({ tooltip: true, stroke: \"white\", strokeWidth: 0.3 }).encode(\n vl.x().fieldO('source').title(null).axis({ orient: 'top' }),\n vl.y().fieldO('target').title(null),\n vl.color().value('#D5B2E5')\n );\n\n const reverse = base.encode(\n vl.x().fieldO('target'),\n vl.y().fieldO('source')\n );\n\n return vl\n .layer(base, reverse)\n .data(network.links)\n .width(600)\n .height(600)\n .render();\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":539,"value":"## Another version of network visualization","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":561,"value":"swatches({\n color: d3.scaleOrdinal([\"Comedy\", \"Drama\", \"Romance\", \"Thriller\", \"Mystery\", \"Crime\", \"Sci-Fi\", \"Suspense\", \"Action\", \"Short\", \"Horror\", \"Documentary\", \"Adventure\", \"Fantasy\", \"Family\", \"Game-Show\", \"Talk-Show\", \"Biography\", \"Film-Noir\", \"Animation\", \"Sport\", \"Music\", \"Reality-TV\", \"History\", \"Musical\", \"Western\", \"War\"], colors)\n})\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":564,"value":"$35","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":541,"value":"data4 = FileAttachment(\"genres@1.json\").json()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":547,"value":"colors = [\n \"#f4a261\", // Comedy\n \"#a0522d\", // Drama\n \"#f4978e\", // Romance\n \"#d7263d\", // Thriller\n \"#4b0082\", // Mystery\n \"#b22222\", // Crime\n \"#5e60ce\", // Sci-Fi\n \"#f4a9a8\", // Suspense\n \"#ff4500\", // Action\n \"#c0c0c0\", // Short\n \"#8b0000\", // Horror\n \"#9e9e9e\", // Documentary\n \"#00bfff\", // Adventure\n \"#7fc8a9\", // Fantasy\n \"#ffeb3b\", // Family\n \"#ff69b4\", // Game-Show\n \"#9370db\", // Talk-Show\n \"#e6b422\", // Biography\n \"#2f4f4f\", // Film-Noir\n \"#00d2d3\", // Animation\n \"#f9c74f\", // Sport\n \"#a95aa1\", // Music\n \"#90ee90\", // Reality-TV\n \"#deb887\", // History\n \"#ffd700\", // Musical\n \"#708090\", // Western\n \"#6a994e\" // War\n]\n\n\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":549,"value":"color = {\n const scale = d3.scaleOrdinal(colors);\n return d => scale(d.group);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":551,"value":"size = {\n const scale = d3.scaleSqrt()\n .domain([1, 456])\n .range([5, 25]);\n return d => scale(d.weight);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":553,"value":"opacity = {\n const scale = d3.scaleSqrt()\n .domain([1, 200])\n .range([.2, .6]);\n return d => scale(d.value);\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":555,"value":"drag = simulation => {\n \n function dragstarted(event) {\n if (!event.active) simulation.alphaTarget(0.3).restart();\n event.subject.fx = event.subject.x;\n event.subject.fy = event.subject.y;\n }\n \n function dragged(event) {\n event.subject.fx = event.x;\n event.subject.fy = event.y;\n }\n \n function dragended(event) {\n if (!event.active) simulation.alphaTarget(0);\n event.subject.fx = null;\n event.subject.fy = null;\n }\n \n return d3.drag()\n .on(\"start\", dragstarted)\n .on(\"drag\", dragged)\n .on(\"end\", dragended);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":558,"value":"$36","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":577,"value":"## From Thrills to Laughs: How Movie Genres Score in San Francisco","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":580,"value":"### Data Processing","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":582,"value":"expandedIMDb = imdb.flatMap(record => {\n if (!record.averageRating || record.averageRating === \"\\\\N\") return []; \n\n return record.genres.split(\",\")\n .map(genre => genre.trim())\n .filter(genre => genre && genre !== \"\\\\N\") \n .map(genre => ({\n Title: record.primaryTitle,\n RatingScore: record.averageRating,\n Genre: genre\n }));\n});\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":610,"value":"vl.layer(\n vl.markBoxplot({ tooltip: true})\n .encode(\n vl.x().fieldN(\"Genre\").axis({ title: \"Movie genre\", labelAngle: 45 }),\n vl.y().fieldQ(\"RatingScore\").scale({ zero: false, domain: [0, 10] }).title(\"Average IMDB Rating Score\"),\n vl.color().fieldN(\"Genre\")\n ),\n \n \n vl.markPoint({ size: 30, filled: true })\n .encode(\n vl.x().fieldN(\"Genre\"),\n vl.y().fieldQ(\"RatingScore\"),\n vl.color().fieldN(\"Genre\").scale({\n domain: [\"Comedy\", \"Drama\", \"Romance\", \"Thriller\", \"Mystery\", \"Crime\", \"Sci-Fi\", \"Suspense\", \"Action\", \"Short\", \"Horror\", \"Documentary\", \"Adventure\", \"Fantasy\", \"Family\", \"Game-Show\", \"Talk-Show\", \"Biography\", \"Film-Noir\", \"Animation\", \"Sport\", \"Music\", \"Reality-TV\", \"History\", \"Musical\", \"Western\", \"War\"],\n range: colors\n})\n )\n)\n.width(800)\n.height(300)\n.data(expandedIMDb)\n.title(\"IMDb Ratings by Genre for Shot in San Francisco (1915–2023)\")\n.render()\n","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":92,"value":"## Process of idiom 1","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":932,"value":"colors1 = [\"#C2A0FF\", \n \"#FF9CEE\", \n \"#85FFCA\", \n \"#FF7A93\", \n \"#FFDE59\", \n \"#5BCEFA\" ]","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":907,"value":"typeColors = d3.scaleOrdinal()\n .domain([\"movie\", \"tvSeries\", \"short\", \"tvMovie\", \"tvEpisode\", \"video\"])\n .range(colors1)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":51,"value":"filmsLocationDataCoords = filmLocationData.map( function (d) {\n \treturn [+d.Longitude,+d.Latitude, d.Type]\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":49,"value":"path = d3.geoPath().projection(projection)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":47,"value":"projection = d3.geoMercator().fitSize([width,height], mapData)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":45,"value":"height=800","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":43,"value":"width = 850","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"filmLocationData = FileAttachment(\"merged_dataset.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"mapData = d3.json(\"https://gist.githubusercontent.com/caseylabrack/aa9d0ca1b50290b21e6f743be2f56001/raw/2759f8cfb683ae3ad2ab2b35fb9cc52d3c78723c/Streets%2520of%2520San%2520Francisco.geojson\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":176,"value":"imdb = FileAttachment(\"SF_movie_IMDBratings@4.csv\").csv()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":293,"value":"## Data process for idiom 8","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":296,"value":"top_Rating_Movies = imdb.sort((a, b) => parseFloat(b.averageRating) - parseFloat(a.averageRating)).slice(0, inputNumber)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":805,"value":"top_locationsAmount_Movies = imdb.sort((a, b) => parseFloat(b['Number of Locations']) - parseFloat(a['Number of Locations'])).slice(0, inputNumber1)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":199,"value":"## Data process for idiom 9","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":201,"value":"$37","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":830,"value":"$38","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":326,"value":"## Data process for idiom 10 & 11","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":360,"value":"viewof dataUnrolled = aq\n .from(imdb)\n .select([\"primaryTitle\",\"genres\"])\n .derive({\n fromList: (d) => op.split(d.genres, \",\"),\n toList: (d) => op.split(d.genres, \",\")\n })\n .unroll(\"fromList\")\n .unroll(\"toList\")\n.view();","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"value":"Genres = new Set(dataUnrolled\n .groupby(\"fromList\")\n .count()\n .filter((d) => d.count > 1 && d.fromList !== \"\\\\N\")\n .objects()\n .map((d) => d.fromList.trim()))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":362,"value":"viewof dataUnrolledSampled = dataUnrolled\n .filter(\n aq.escape(\n (d) =>\n selectedGenres.includes(d.fromList) ||\n selectedGenres.includes(d.toList)\n )\n )\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":371,"value":"### Links","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":373,"value":"viewof groupedGenres = dataUnrolledSampled\n .join(dataUnrolledSampled, (a, b) => op.equal(a.primaryTitle, b.primaryTitle))\n .groupby([\"fromList_1\", \"toList_2\"])\n .rollup({\n count: d => op.distinct(d.primaryTitle_1)\n })\n .rename({ \"fromList_1\": \"source\", \"toList_2\": \"target\"})\n.filter(d => d.count> 0)\n .view()","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":369,"value":"### nodes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":377,"value":"nodes = [\n ...new Set(\n groupedGenres\n .groupby(\"source\")\n .count()\n .objects()\n .map((d) => d.source)\n .concat(\n groupedGenres\n .groupby(\"target\")\n .count()\n .objects()\n .map((d) => d.target)\n )\n )\n].map((d) => ({ id: d }))","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":379,"value":"### Network","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":383,"value":"network = ({\n nodes: nodes,\n links: groupedGenres.objects()\n})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":328,"value":"import {aq, op} from \"@uwdata/arquero\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":331,"value":"forceBoundary = require(\"d3-force-boundary@0.0.3\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":333,"value":"forceInABox = require(\"force-in-a-box\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":391,"value":"lo = d3.scaleLinear().domain([0, d3.max(network.links, l => l.value)]).range([0.1, 0.7])","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":335,"value":"import {ForceGraph} from \"@john-guerra/force-directed-graph\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":351,"value":"import {searchCheckbox} from \"@john-guerra/search-checkbox\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":354,"value":"import {edgeBundling} from \"@john-guerra/force-edge-bundling\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":356,"value":"import {howto} from \"@d3/example-components\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":358,"value":"import {forceTransport, forceExtent} from \"21d2053b3bc85bce\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":20,"value":"## Data Abstraction","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":12,"value":"data source 1: \nhttps://data.sfgov.org/Culture-and-Recreation/Film-Locations-in-San-Francisco/yitu-d5am/about_data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":38,"value":"await FileAttachment(\"merged_dataset.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":15,"value":"data source 2: https://developer.imdb.com/non-commercial-datasets/\n\nI used the original title.basics.tsv.gz and title.ratings.tsv.gz files and performed data processing to create the dataset used in this project.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":24,"value":"data processing steps:\nhttps://github.com/shufanfan/Film-Locations-In-SF-Project","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":10,"value":"await FileAttachment(\"SF_movie_IMDBratings@4.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":104,"value":"import { vl } from \"@vega/vega-lite-api-v5\"","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":153,"value":"d3 = require(\"d3@7\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"d3sankey = require(\"d3-sankey@0.12.3\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W39","stdlib":"1"}} 30:"$2f:body"