Proj 1: Data Query

jmd
Posts: 5
Joined: Sat Jan 10, 2015 11:26 am

Re: Proj 1: Data Query

Post by jmd » Thu Jan 15, 2015 2:35 am

"[...] When the chips are down."

After a tragedy occurs, where do we seek answers?
Philosophy, science, religion, history?
This brief study explores four major US-related incidents and its immediate reaction based on items checked out per topic. This same data is then compared to a more 'peaceful' period of that same year.

Three main Dewey classes are searched:
  • 100 :: Philosophy
    200 :: Religion
    900 :: History
Since these categories can be too general, these additional (more specific) sub-classes were also included in the query:
  • 297 - Religion - Islam
    956 - History of Asia - Middle East
Attachments
when_the-chips-are-down CVS files.zip
CVS Files
(1.81 KiB) Downloaded 307 times
when_the_chips_are_down.pdf
PDF brief study
(149.93 KiB) Downloaded 340 times
Last edited by jmd on Sat Jan 24, 2015 9:59 am, edited 1 time in total.

james_schaffer
Posts: 5
Joined: Sat Jan 10, 2015 11:34 am

Re: Proj 1: Data Query

Post by james_schaffer » Thu Jan 15, 2015 3:13 am

Seattle Library's Most Controversial:

Mainstream is boring! Is it possible to use the information in the library database to determine which items are the most controversial? Can we implicitly discover which books or DVDs are strongly loved by few, but detested by many? Is it possible to discover subcultures and gauge people's varying passion for different topics?

I attempt to quantify the above concept by examining variations in durations of checkout, popularity, and page length to determine a 'controversy score' for each item. Then, we can plot which subjects are the most controversial, and by inspecting individual item names we can discover which items have the highest variance of interest, and are thus the most titillating items in the library.
Attachments
controversy.zip
Total query time for fetching the final list was 0.078 seconds.
(319.03 KiB) Downloaded 302 times
Last edited by james_schaffer on Thu Jan 15, 2015 12:31 pm, edited 1 time in total.

fabian.offert
Posts: 5
Joined: Sat Jan 10, 2015 11:32 am

Re: Proj 1: Data Query

Post by fabian.offert » Thu Jan 15, 2015 8:09 am

It's The Economy, Stupid!

Eventually leading into the great recession that still shapes our economy today, the 2007-2008 financial crisis was the macroeconomic event of the first decade of the 21st century. For this first assignment, I am looking at possible effects of this historic bust on the choice of books borrowed by the patrons of the Seattle public library system. Specifically, I am asking if there is a visible increase in interest in understanding the mechanisms of capitalism around the peak of the crisis.
Attachments
assignment1_data.csv
(1.96 KiB) Downloaded 336 times
assignment1.pdf
(66.32 KiB) Downloaded 341 times

rodgerljl
Posts: 5
Joined: Sat Jan 10, 2015 11:29 am

Re: Proj 1: Data Query

Post by rodgerljl » Thu Jan 15, 2015 8:20 am

Project 1: Forgotten Books

Project Description:

Every library needs to face an awkward situation that many books have been kept by audience way later than they are supposed to be. Can we just simply assume that’s because of people’s bad memory? Is it possible that there is a deeper connection between the types of books and their delayed returned date? Can we find a reasonable explanation for this phenomenon? In this project, the books which have been checked out for more than 3 years will be examined to see if any interesting patterns will be found.

Please see the attached PDF for queries and analysis.
ProjectOne_Luo.pdf
(302.87 KiB) Downloaded 324 times
Links to CSV: https://www.dropbox.com/sh/f01vdw4hmse6 ... x53Xa?dl=0

nedda.amini
Posts: 5
Joined: Tue Jan 14, 2014 11:55 am

Absence

Post by nedda.amini » Thu Jan 15, 2015 9:40 am

Looking beyond the collection as a series of data points and instead an entity marked by presence and absence, what these absences mean, and how an abstract concept can be represented visually.
Attachments
Absence 700-800 dewey.csv
(627.43 KiB) Downloaded 335 times
Absence 800-900 dewey.csv
(425.84 KiB) Downloaded 324 times
MAT259.pdf
(104.19 KiB) Downloaded 417 times

matzewagner
Posts: 5
Joined: Sat Jan 10, 2015 11:35 am

Re: Proj 1: Data Query

Post by matzewagner » Thu Jan 15, 2015 9:55 am

While doing research on different categories of the Dewey Decimal System, I found a small list of
sections, which specifically deal with women and their relation to a given field. (http://ndscs.nodak.libguides.com/conten ... sid=681502) I chose to investigate this significance by analyzing the percentage of specifically female works as part of their larger parent branch, and how this changes over time. To this end, I list the total number of checked out items per month of both the female and general categories, and the female category percentage.
Attachments
percentage_of_women_categories.csv
(2.12 KiB) Downloaded 330 times
matthias_project1.pdf
(79.38 KiB) Downloaded 336 times

checorh
Posts: 2
Joined: Sat Jan 10, 2015 11:34 am

Re: Proj 1: Data Query

Post by checorh » Thu Jan 15, 2015 1:42 pm

Exploring late return rate

According to the Seattle Public Library (SPL) policies an item that is checked-out can be returned based on the following schedule:
  • Books, magazines, pamphlets, CDs, audiocassettes, albums, videocassettes: 21 days
    DVDs: 14 Days

After identifying all items that are returned after their due date (via the difference of check-in and check-out dates), it would be interesting to explore the following aspects:
  • - Whether there is a specific month of the year with more items returned late.
    - What types of items people tend to return late.
    - Is there any specific branch with this behaviour?
    - What kind of subjects are more likely to be returned late.
For this project I will use MySQL for querying the SPL database and R (http://www.r-project.org) as interface to be able to make statistical analysis of the queried information.
Attachments
MAT259h1.pdf
(218.11 KiB) Downloaded 332 times
late.csv
(95.01 KiB) Downloaded 328 times

chicobrando
Posts: 5
Joined: Sat Jan 10, 2015 11:25 am

Re: Proj 1: Data Query

Post by chicobrando » Fri Jan 16, 2015 12:43 am

Are certain types of books more read during rainy, cloudy days?

The dataset of the Seattle Public Library offers an opportunity to verify if dark and rainy nights and days, the common scenario of Gothic books' trama, are also prefered by the public while reading these books. Most interestingly, Seattle is known as one of the most rainy capitals of the United State, among the top five cities with more cloudy days – an average of 226 per year. The months when Seattle gets more rain are between October and March.
Attachments
P1OpenQueryB.pdf
(140.98 KiB) Downloaded 309 times
gothicnovels2.csv
(7.45 KiB) Downloaded 276 times
Last edited by chicobrando on Tue Jan 27, 2015 11:53 am, edited 1 time in total.


cabaez
Posts: 1
Joined: Fri Jan 16, 2015 4:28 pm

Re: Proj 1: Data Query

Post by cabaez » Wed Jan 21, 2015 5:05 pm

Here we are attempting to measure the amount of books about Texas (in general) that are related to the topics of Geography and History. Then we look at the months in which the books are checked out in hopes of seeing a seasonal pattern for planning of travel.
Attachments
Baez_Assign1.pdf
(295.86 KiB) Downloaded 354 times
Baez_TravelingToTexas.csv
(96 Bytes) Downloaded 236 times

Post Reply