{"id":9,"date":"2022-10-31T02:43:40","date_gmt":"2022-10-31T02:43:40","guid":{"rendered":"http:\/\/midterm.heynesk.sites.carleton.edu\/blog\/?page_id=9"},"modified":"2022-10-31T02:44:43","modified_gmt":"2022-10-31T02:44:43","slug":"midterm-1900s-female-artists","status":"publish","type":"page","link":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/midterm-1900s-female-artists\/","title":{"rendered":"1900&#8217;s Female Artists"},"content":{"rendered":"\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"385\" src=\"http:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map-1024x385.jpg\" alt=\"\" class=\"wp-image-11\" srcset=\"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map-1024x385.jpg 1024w, https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map-300x113.jpg 300w, https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map-768x289.jpg 768w, https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map-1536x578.jpg 1536w, https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map-1200x451.jpg 1200w, https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-content\/uploads\/2022\/10\/palladio_map.jpg 1907w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>For my midterm project, I decided to create a map displaying where female artists found in the Tate gallery are from. The corresponding repository contains information on a vast number of artists from the 1900\u2019s, but narrowing down the data to only female artists helped make the data easier to work with. I did this by using OpenRefine\u2019s \u2018text filter\u2019 feature to target the \u2018gender\u2019 column. This brought down the file to about 100 artists.&nbsp;<\/p>\n\n\n\n<p>After exporting this file as a csv, I was able to then delete unnecessary columns that weren\u2019t relevant to the information I was plotting. I imported the spreadsheet to Palladio to create the map, but then realized that in order for the birth places and names to correspond accurately, I would need to make more spreadsheets to connect variables together. In a separate spreadsheet, I used the GeoCode extension to get the longitude and latitude of the artists\u2019 birth places. This created two new columns, so I formatted them as one column to better suit how Palladio reads coordinates. In another spreadsheet, I used more Google Spreadsheet formulas\/formatting settings to find the unique set of countries where these artists\u2019 are from. From there I was able to create another column to hold the frequency of artists who were born in a certain country.&nbsp;<\/p>\n\n\n\n<p>This is the csv that I started out with after using OpenRefine:<\/p>\n\n\n\n<iframe src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vTujRtdaeaTntkDQK5ez31UERowKKrX05_D_DyAbGEDVZ5n_hu1-OEt2fwLTILNG9j3b10XfV2GZEMQ\/pubhtml?gid=574635750&amp;single=true&amp;widget=true&amp;headers=false\"><\/iframe>\n\n\n\n<p>These are the spreadsheets I had to import into Palladio to create the graph:<\/p>\n\n\n\n<iframe src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vQ1ocNDZwlPrvLhg8r7nFbNpukXVpvYO6vSj2FS_4vDMi1S_Wk37l44cosLPBYfxorbfUMbUsWuNWXL\/pubhtml?widget=true&amp;headers=false\"><\/iframe>\n\n\n\n<iframe src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vSNqzc7KLBlZgkRwQF3cyicijbGbPxtbnh87H1SX4KI_HsJh25bBH7QXJtyE8prOgrN5Oata5QOXd7s\/pubhtml?widget=true&amp;headers=false\"><\/iframe>\n\n\n\n<iframe src=\"https:\/\/docs.google.com\/spreadsheets\/d\/e\/2PACX-1vS40IBGhaiaUAUEc8TeBvjn2-WDyw5CN8P6FAyi7ITZiW5o7nwwA2sXRQPKGtJCwv6WlxxSsS8Gfg9t\/pubhtml?widget=true&amp;headers=false\"><\/iframe>\n\n\n\n<p>Palladio currently doesn\u2019t have the option to embed visualizations, but a screenshot of the map can be found above. The red dots indicate the 100 female artists, and upon scrolling over those dots, users can see their name. The blue dots represent the unique countries which the artists are from. I used the point size feature so that larger dots represent countries where more artists are from. This allows users to gain the insight that female artists in the Tate Gallery are primarily from the United States or the United Kingdom. Users can also find artists given that they have a particular location in mind. For example, if I wanted to know about an artist from Canada, I would look in that area for any red dots.&nbsp;<\/p>\n\n\n\n<p>These insights aren\u2019t terribly remarkable and the map itself is very simple, but creating the spreadsheets and using Palladio as a whole took a fair amount of trial and error. One problem I had with Palladio was getting different parameters from different spreadsheets to essentially \u2018sync up\u2019. This took some time to get used to so I found myself making and remaking different spreadsheets with the same types of information. Another problem I had with Palladio is that moving from different tabs caused the map layers I made to get deleted, but this could be solved by improving my literacy of network analysis softwares as a whole. In the future, I\u2019d like to look into data sets that have more information about its subjects aside from place of birth\/death, and try overlaying different graphs together.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>For my midterm project, I decided to create a map displaying where female artists found in the Tate gallery are from. The corresponding repository contains information on a vast number of artists from the 1900\u2019s, but narrowing down the data to only female artists helped make the data easier to work with. I did this [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-9","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/pages\/9","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/comments?post=9"}],"version-history":[{"count":2,"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/pages\/9\/revisions"}],"predecessor-version":[{"id":13,"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/pages\/9\/revisions\/13"}],"wp:attachment":[{"href":"https:\/\/midterm.heynesk.sites.carleton.edu\/blog\/wp-json\/wp\/v2\/media?parent=9"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}