Media Arts and Technology

For the final project, I am using a data set on MLB starting pitchers to analyze relationships between several different variables. Specifically, I am interested in the interaction between variables and ‘winning percentage’. I have recently completed a Machine Learning Final Project in which I built...

For my second project, I would like to show the relationships between the first checkout date and the last checkin date at the Seattle Public Library. Overall, this will show the “lifespan” of books at the SPL. By connecting their first checkout date to the last checkin date, the resulting vectors t...

For the first project, I will be looking at irregularities in the data set through outliers. Specifically, I will be looking at checkout time in days for the first book in the Twilight series by Stephenie Meyer, namely "Twilight". Published in 2005, the book is based in Forks, Washington around 100 ...

For my final project, I will be using Python, R, and Tableau as technologies to analyze a data set that I found online. The data set that I found is from Kaggle, and originally contained 5 different CSV files. The context of the data is Udemy Courses. Udemy is an online platform in which you can tak...

I will take a look at a random sampling of the check-ins and checkouts at the Seattle Public library. I will randomly select the month of 2% of the returns from the SPL filtering by 4 distinct item types. Following, I will compare the results of the queries and identify any possible patterns that ar...

For this assignment, I queried for outliers in two different groups of data from the SPL database: checkouts of rock CDs and horror DVDs. It is valuable to detect and find outliers within a data set because these observations differ significantly from the majority. They have a heavy impact on statis...

For this week’s assignment, I utilized the course data base and SPL data to experiment and teach myself new MySQL functions and commands. I was able to learn new aggregate, time, and string functions that furthered my knowledge of the SQL programming language while discovering new findings within th...

This week, I am focusing on the first book and movie of The Hunger Games trilogy. I have found that checkouts of both the book and DVD copy of the movie have been popular at the Seattle Public Library over time. Due to this prevalence, I will be analyzing the popularity and trends in checkouts of ea...

Abstract Introduction: For this week’s assignment, I began with a question of how library book checkouts have changed in the past 10 years. To begin, I looked at the most popular books that were checked out this year (2022) and compared it to the most popular books ten years ago (2012). I identifie...

Here is my Week 3 Assignment write up that contains the SQL code: Assignment Week 3.pdf Please describe in a short paragraph what your queries and results explore: For this week’s assignment, I explored three different topics. With each, I practiced and refined my SQL skills while querying a wide ar...