Media Arts and Technology

Visualizing power production in Germany. Large parts of German electricity generation is traded on the European Power Exchange Day-Ahead Spot market (EPEX-Spot). Electricity producers, retailers and traders place bids here every day to sell or buy electricity for each hour of the upcoming day. Once ...

Perfect title (3d) I am interested in finding good book titles in respect to the dewey category. I tried to answer this question by first finding the two most popular first words in a book title for each dewey category. I defined the popularity of the first word as the number of checkouts of books t...

I wanted to figure out how long (in terms of number of words( a good title, respective to the discipline (dewey class), is. I was hoping to see results such as: People prefer books on religion with a title length of more than x words, while people prefer books on science with more than y words. To d...

query_1.csv ### 1. Checkouts vs seasons ### I was suspecting that there would be more checkouts during the winter. I therefore queried for the sum of all checkouts per week number (regardless of the year). SELECT WEEK(checkOut), count(itemNumber) FROM spl_2016.transactions WHERE checkOut > '2011' G...