Search found 11 matches
- Thu Mar 02, 2023 2:56 pm
- Forum: Winter 2023
- Topic: Proj 3 - Student Defined Visualization Project
- Replies: 8
- Views: 30603
Re: Proj 3 - Student Defined Visualization Project
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...
- Thu Feb 16, 2023 1:31 pm
- Forum: Winter 2023
- Topic: Proj 2 - 3D Visualization
- Replies: 8
- Views: 9537
Re: Proj 2 - 3D Visualization
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...
- Mon Jan 23, 2023 1:39 pm
- Forum: Winter 2023
- Topic: Proj 1 - Data Exploration Concept & MySQL Query
- Replies: 9
- Views: 12193
Re: Proj 1 - Data Exploration Concept & MySQL Query
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 ...
- Tue Nov 29, 2022 11:37 am
- Forum: Fall 2022
- Topic: wk10 - 11.29.22 Final Project
- Replies: 4
- Views: 15648
Re: wk10 - 11.29.22 Final Project
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...
- Fri Nov 25, 2022 1:22 pm
- Forum: Fall 2022
- Topic: wk9 - 11.22.22 Random Sampling
- Replies: 4
- Views: 4353
Re: wk9 - 11.22.22 Random Sampling
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...
- Tue Nov 15, 2022 11:23 am
- Forum: Fall 2022
- Topic: wk8 - 11.15.22 Outliers
- Replies: 4
- Views: 5234
Re: wk8 - 11.15.22 Outliers
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...
- Mon Nov 07, 2022 4:40 pm
- Forum: Fall 2022
- Topic: wk7 - 11.8.22 4 MySQL commands new to you
- Replies: 4
- Views: 5082
Re: wk7 - 11.8.22 4 MySQL commands new to you
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...
- Tue Nov 01, 2022 10:48 am
- Forum: Fall 2022
- Topic: wk6 - 11.01.22 MidTerm Presentation
- Replies: 4
- Views: 5059
Re: wk6 - 11.01.22 MidTerm Presentation
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...
- Tue Oct 18, 2022 11:59 am
- Forum: Fall 2022
- Topic: wk4 - 10.18.22 Discover Patterns with MySQL
- Replies: 4
- Views: 4847
Re: wk4 - 10.18.22 Discover Patterns with MySQL
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...
- Tue Oct 11, 2022 11:05 am
- Forum: Fall 2022
- Topic: wk3 - 10.11 .22 2nd Project in MySQL
- Replies: 4
- Views: 5297
Re: wk3 - 10.06 .22 MySQL queries studies
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...