It was time to get me a pair of new shoes. As always it was a long process to find the best solution. First there are my own needs. My personal list of problems my shoes have to solve in their life is the basis. Then a thorough market research has to be made. There are thousands if not millions of models and types of shoes which have to be taken into account here! And then there are blue Vans Sk8-High...
I like to listen to music and I like to track everything. That's why I now have 38.224 lines in a txt file representing the music I listened to over the last 22 month and it's also why most of my friends think I'm kind of weird.
The basic is Spotify as my streaming music service of choice. Spotify allows you to scrobble all the music you've listened to over to last.fm. You'll find that somewhere in your spotify settings.
Now to collect all this data for myself, to play around with it and get happy, I needed my own list. Using an IFTTT recipe, everytime a new 'scrobble' was made at last.fm, a line was added to a google spreadsheet. Unfortunately google somehow added a new file every 2000 lines so that I decided today to tinker all those files into one txt file and to change the IFTTT recipe to dropbox (Here's the recipe). While I'm writing this, the recipe creates a second file in dropbox too...
Having all those lines of pure music data as a txt file, you can easily import it into your spreadsheed.
Using a little pivot table I found out that I've been listening to 2212 different artists, Alt-J at first place, followed by Turbostaat:
My most-played song over the last 22 month was All Opportunities by Solander.
I didn't even realize that It's On is a song of both Broncho and Pins:
What I double checked is this chart: it shows songs played per day. And there are days when I listened to more than 200 songs:
By hour of day:
Now I could cluster artists by hour... or day of week ... or I could go outside, enjoy the sun, have some coffee ...
Someone gave me a "Magic Garden" as a present this Christmas! So I headed to my local dealer to get me a Pi Cam to play around with it as I now really really had a valuable yet scientific job to do!
Here's the result:
And this is what I've done:
I cut a little slot into the pi case for the flat cable. Then I found some parts of a lamp and a lighter and a film canister - screwed and glued it together to have a solid and flexible stand for it. While writing these lines I am thinking abount some buttons to start my scripts and shutdown the device ...