Utilizing OpenRefine to Find Trends in Data!

One of our group’s research questions was “is there more artwork from a certain time period or culture in the collection? If so, what are the historical and social implications of this?” Using OpenRefine operations, my group can manipulate the data in the Williams college art exhibit by separating them by time period. By doing this, our group can see the clusters of art and which time period had the most artwork presented in this exhibit. Furthermore, we can use OpenRefine to manipulate the data in this dataset by sectoring each individual work of art by culture they originated from. By doing this, my group can see the trends in which culture’s art was most presented in this exhibit. The OpenRefine operations we will need to perform in order to categorize our data into culture and time period categories is the text facet operation under the year and culture category of this dataset. By doing this, we can see the number of cultures and time points represented and ultimately find the subcategory with the most artworks. We will probably also be using the edit and re-clustering options to merge the same subcategories into one. Something I would like to be able to do to my data that I am not sure how to do is find similarities between colors and medium in each art piece. I would like to do this because both my groupmates and I believe that color could have a purpose in each culture’s art, as well as an artwork’s medium. Ultimately, we think that color and the type of medium can revel historical significances from the time periods these artworks were produced.

Leave a Reply