{"id":909,"date":"2011-10-28T18:59:20","date_gmt":"2011-10-29T01:59:20","guid":{"rendered":"http:\/\/miriamposner.com\/blog\/?p=909"},"modified":"2011-11-03T19:04:01","modified_gmt":"2011-11-04T02:04:01","slug":"visualize-a-network-of-film-casts-and-crews","status":"publish","type":"post","link":"https:\/\/miriamposner.com\/blog\/visualize-a-network-of-film-casts-and-crews\/","title":{"rendered":"Visualize a network of film casts and crews"},"content":{"rendered":"<p><a href=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/Sheet1-copy1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-large wp-image-913\" title=\"Sheet1 copy\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/Sheet1-copy1-1024x591.png\" alt=\"\" width=\"512\" height=\"295\" srcset=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/Sheet1-copy1-1024x591.png 1024w, https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/Sheet1-copy1-300x173.png 300w, https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/Sheet1-copy1.png 1061w\" sizes=\"auto, (max-width: 512px) 100vw, 512px\" \/><\/a>A friend of mine wrote to me recently with a request. For his dissertation, he&#8217;s unearthing the filmmaking culture of a particular time and place. &#8220;I keep running across these names of actors and filmmakers,&#8221; he wrote, &#8220;and I know I&#8217;ve seen them before, but I can&#8217;t remember all the relationships. Is there a way I can visualize the overlapping networks of people within this culture?&#8221;<\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonSummary\">\n<p>There is! To demonstrate, I&#8217;ll use the last dozen films of one of my favorite filmmakers, Alfred Hitchcock. This is a fun way to get started making network visualizations.<\/p>\n<p><!--more--><\/p>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Get some data<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319853289300.png\" alt=\"media_1319853289300.png\" width=\"378\" height=\"369\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>First, I needed a data source. I chose <a href=\"http:\/\/www.imdb.com\/name\/nm0000033\/\">IMDB<\/a>. My friend could record his data as he unearths it over the course of his archival research.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Record your data in the form of subject-verb-object.<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319850188217.png\" alt=\"media_1319850188217.png\" width=\"470\" height=\"130\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Using Excel (or your favorite spreadsheet application), create one column for &#8220;Person,&#8221; one column for &#8220;Relationship,&#8221; and a third column for &#8220;Film.&#8221; You can choose the language you use to describe relationships, but be consistent. You&#8217;re welcome to download <a title=\"Hitchcock Film Data\" href=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/hitchcock.xls\">my spreadsheet<\/a> as an example.<\/p>\n<p>(Incidentally, there are ways to automate a process like this, though IMDB doesn&#8217;t provide an API and its TOS disallow scraping. But for our purposes, let&#8217;s assume you&#8217;re gathering your data by hand.)<\/p>\n<p>Save your spreadsheet and give it a name you&#8217;ll remember.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Download Cytoscape<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319850408334.png\" alt=\"media_1319850408334.png\" width=\"540\" height=\"419\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Head over to <a href=\"http:\/\/www.cytoscape.org\/\">http:\/\/www.cytoscape.org<\/a>. Cytoscape is a free, open-source platform that allows you to visualize network data. It works with all operating systems. Download Cytoscape as you would any program.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Open Cytoscape<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319850637381.png\" alt=\"media_1319850637381.png\" width=\"540\" height=\"440\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Double-click on the application&#8217;s icon. If a dialog box opens asking you to choose a template, just close the box by clicking on the red button. Don&#8217;t worry if the application looks baffling to begin with.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Import your spreadsheet<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319850812132.png\" alt=\"media_1319850812132.png\" width=\"540\" height=\"295\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Head to <strong>File<\/strong>, <strong>Import<\/strong>, and then <strong>Network from Table (Text\/MS Excel)&#8230;<\/strong><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Select your file and show text import options<\/span><\/h2>\n<h2 class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319850968325.png\" alt=\"media_1319850968325.png\" width=\"540\" height=\"416\" \/><\/h2>\n<div class=\"StepInstructions\">\n<ol>\n<li>Click on <strong>Select File(s) <\/strong>and choose the spreadsheet you created.<\/li>\n<li>Click on <strong>Show Text File Import Options<\/strong>.<\/li>\n<\/ol>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Tell Cytoscape how to interpret your data<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319851173591.png\" alt=\"media_1319851173591.png\" width=\"540\" height=\"445\" \/><\/div>\n<div class=\"StepInstructions\">\n<ol>\n<li>If you&#8217;ve labeled your columns in the first row of your spreadsheet (like I did), click the box next to <strong>Transfer first line as attribute<\/strong> names.<\/li>\n<li>For <strong>Source Interaction<\/strong>, choose <strong>Column 1<\/strong>.<\/li>\n<li>For <strong>Interaction Type<\/strong>, stick with <strong>Default Interaction<\/strong>.<\/li>\n<li>For <strong>Target Interaction<\/strong>, choose <strong>Column 3<\/strong>.<\/li>\n<li>Click <strong>Import<\/strong>.<\/li>\n<\/ol>\n<p>A dialog box will appear to tell you that you&#8217;ve successfully imported your data. Click <strong>Close<\/strong>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">You&#8217;ve got a (confusing) visualization!<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319851509279.png\" alt=\"media_1319851509279.png\" width=\"540\" height=\"440\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Hey, you&#8217;ve got something! But what is it? Each circle, called a <strong>node<\/strong>, represents either a film or a person. Each line, called an <strong>edge<\/strong>, represents a relationship. The whole thing \u2014 all the lines and circles \u2014 is called a <strong>network<\/strong>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Start making sense of your network<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319851669450.png\" alt=\"media_1319851669450.png\" width=\"540\" height=\"439\" \/><\/div>\n<div class=\"StepInstructions\">\n<ol>\n<li>As a start, click on the little network diagram (hover over for a tool tip) to create a force-directed layout. Already that&#8217;s much better!<\/li>\n<li>Expand the size of your sheet by clicking and dragging the corner.<\/li>\n<li>Zoom in by clicking on the magnifying glass and then clicking on the diagram.<\/li>\n<li>Magnify different parts of your network by dragging around the shaded window<\/li>\n<\/ol>\n<p>You can also change the location of individual nodes by clicking and dragging them.<\/p>\n<p>Cool, huh? Now you have a big-picture view of your network, and you can already start to ask questions. For example, why is <em>Frenzy<\/em> (up in the top right-hand corner) the only film in which no cast or crew member is connected to any of Hitchcock&#8217;s previous networks?<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Customize your visualization<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319852120117.png\" alt=\"media_1319852120117.png\" width=\"540\" height=\"440\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>Cytoscape allows you to change almost everything about your network visualization, from the color of the background to the size of the font. It comes loaded with several preexisting templates. To get access to them, click on the right-pointing arrow directly to the right of <strong>Network<\/strong> in the sidebar.<\/p>\n<p>From the dropdown menu labeled <strong>Current Visual Style<\/strong>, try selecting different options. Each one will change the look of your visualization.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Tell Cytoscape that you&#8217;d like to see relationships, too<\/span><\/h2>\n<div class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/Screen_Shot_2011-10-28_at_9.45.15_PM.png\" alt=\"Screen_Shot_2011-10-28_at_9.45.15_PM.png\" width=\"275\" height=\"503\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>You&#8217;ve got a cool network visualization, but you don&#8217;t yet know who did what. To get Cytoscape to display this information, click on the words <strong>Double-Click<\/strong> that appear to the right of <strong>Edge Label<\/strong>. From the drop-down menu, choose <strong>Relationship<\/strong>. Then click on <strong>Mapping Type<\/strong> and choose <strong>Passthrough Mapper<\/strong>.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h2 class=\"StepTitle\"><span style=\"color: #db5043;\">Now you can see who did what!<\/span><\/h2>\n<h2 class=\"StepImage\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/miriamposner.com\/blog\/wp-content\/uploads\/2011\/10\/media_1319853024939.png\" alt=\"media_1319853024939.png\" width=\"540\" height=\"437\" \/><\/h2>\n<div class=\"StepInstructions\">\n<p>OK, it&#8217;s not perfect, but you&#8217;ve got a network! In a <a href=\"https:\/\/miriamposner.com\/blog\/?p=931\">subsequent post<\/a>, I&#8217;ve shown you how to further customize the look of your network. If you&#8217;d like to save views of your network, click on the camera icon and save your view in the format of your choice. And have fun exploring the network you&#8217;ve created.<\/p>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>A friend of mine wrote to me recently with a request. For his dissertation, he&#8217;s unearthing the filmmaking culture of a particular time and place. &#8220;I keep running across these names of actors and filmmakers,&#8221; he wrote, &#8220;and I know I&#8217;ve seen them before, but I can&#8217;t remember all the relationships. Is there a way [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-909","post","type-post","status-publish","format-standard","hentry","category-tools"],"_links":{"self":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts\/909","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/comments?post=909"}],"version-history":[{"count":11,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts\/909\/revisions"}],"predecessor-version":[{"id":920,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/posts\/909\/revisions\/920"}],"wp:attachment":[{"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/media?parent=909"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/categories?post=909"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/miriamposner.com\/blog\/wp-json\/wp\/v2\/tags?post=909"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}