{"id":25,"date":"2026-11-13T23:20:05","date_gmt":"2026-11-13T23:20:05","guid":{"rendered":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/?page_id=25"},"modified":"2026-11-13T23:46:05","modified_gmt":"2026-11-13T23:46:05","slug":"process","status":"publish","type":"page","link":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/process\/","title":{"rendered":"Process"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">PROCESS<\/h2>\n\n\n\n<div style=\"height:10px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">1. Creating the Dataset<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">The majority of our time was spent creating a usable dataset for our analyses. Our main dataset provided to us by <a href=\"https:\/\/www.carleton.edu\/directory\/dbliss\/\">David Bliss<\/a>, was messy and contained information that was not relevant to our analyses. Therefore, the first step was to export the entire csv dataset to <a href=\"https:\/\/www.r-studio.com\/\">RStudio<\/a> and select the key variables of interest which were: program title, performance date, program transcript, and the identifier. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">One issue with the format was the values in the Title column. The page numbers each took an individual row and also had the variable that contained the transcribed text for the respective page, which was then followed by a row containing the actual title of the program and the respective date and identifier. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"168\" src=\"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-15.54.25-1-1024x168.png\" alt=\"A couple rows of examples of raw data with the selected columns of interest\" class=\"wp-image-56\" srcset=\"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-15.54.25-1-1024x168.png 1024w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-15.54.25-1-764x125.png 764w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-15.54.25-1-1536x251.png 1536w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-15.54.25-1-300x49.png 300w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-15.54.25-1.png 1870w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Example of Raw Data with Selected Columns<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Using online resources for help with coding in R including <a href=\"https:\/\/rstudio.github.io\/cheatsheets\/\">cheatsheets created by Posit<\/a> and Google Gemini, we were able to alter the dataset so that each program only took one row, and the page numbers became separate columns for each row.<\/p>\n\n\n\n<div class=\"wp-block-columns is-layout-flex wp-container-core-columns-is-layout-461897f4 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"151\" src=\"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.02.58-1024x151.png\" alt=\"Example of a couple rows from the semi-cleaned dataset\n\" class=\"wp-image-54\" srcset=\"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.02.58-1024x151.png 1024w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.02.58-766x113.png 766w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.02.58-1536x227.png 1536w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.02.58-300x44.png 300w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.02.58.png 1654w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Example of Semi-Cleaned Data<\/figcaption><\/figure>\n<\/div>\n<\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Then, we used R to filter for only Junior and Senior Recitals, and to extract the year from each date. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Then, using Google Sheets, we extracted all the piece titles and respective composers for each row alongside the main soloist instrument. One issue we ran into was that some of the composer names were formatted differently across programs. For example, some programs wrote &#8220;Wolfgang Amadeus Mozart&#8221; and others wrote &#8220;W.A. Mozart&#8221;, or &#8220;Debussy&#8221; vs. &#8220;Claude Debussy&#8221;. Therefore, in order to standardize the names after we finished inputting the data, we used <a href=\"https:\/\/openrefine.org\/\">OpenRefine<\/a> and its clustering function to easily fix some of these formatting issues or small spelling mistakes that showed up. We also used Google Sheets and the find and replace function to fix issues that OpenRefine could not  identify.   <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">After creating our dataset with Performance Year, Performer&#8217;s Grade, Instrument, Piece, and Composer, we then researched the composer&#8217;s respective birth country, city\/state, and birth year. We decided to manually enter this data as we could not find another method that is more efficient. After this information was input, our dataset was ready to be used for analysis.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large is-resized\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"89\" src=\"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.23.48-edited-1024x89.png\" alt=\"Example of a couple rows from the final dataset \" class=\"wp-image-61\" style=\"width:1151px;height:auto\" srcset=\"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.23.48-edited-1024x89.png 1024w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.23.48-edited-300x26.png 300w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.23.48-edited-768x67.png 768w, https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-content\/uploads\/2026\/11\/Screenshot-2026-11-13-at-16.23.48-edited.png 1424w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><figcaption class=\"wp-element-caption\">Example of Final Dataset<\/figcaption><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">2. Creating the Visualizations and Presentation Choices<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">We chose to visualize our data using <a href=\"https:\/\/flourish.studio\/\">Flourish<\/a> as we wanted to create a timeline. <strong>Add more once visualizations are created.<\/strong><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><\/h3>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PROCESS 1. Creating the Dataset The majority of our time was spent creating a usable dataset for our analyses. Our main dataset provided to us by David Bliss, was messy and contained information that was not relevant to our analyses. Therefore, the first step was to export the entire csv dataset to RStudio and select [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":52,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-25","page","type-page","status-publish","has-post-thumbnail","hentry"],"_links":{"self":[{"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/pages\/25","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/comments?post=25"}],"version-history":[{"count":15,"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/pages\/25\/revisions"}],"predecessor-version":[{"id":107,"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/pages\/25\/revisions\/107"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/media\/52"}],"wp:attachment":[{"href":"https:\/\/hhfinals.dgah.sites.carleton.edu\/carleton-music\/wp-json\/wp\/v2\/media?parent=25"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}