I’ve been rating songs using an “unrated” smart playlist on my iPod since I got it. So far, I’ve gotten through a little over 2000 songs and have ~800 to go.
Now that I have all this data, I want to see some stats on it. I’d installed an old version of Goombah at one point, but recent installs had resulted in crashing. Tonight, I downloaded it again and, before launching, trashed any relevant data I could find. That seemed to work, and I’ve got it up and running again.
The thing Goombah seems to want to do most is find musical neighbors for me, but what I’m most interested in is things like:
- What artists have the higest average song ranking?
- What about a highest average rank with a weight modifier based on total number of songs rated for that artist?
- What artists should I purge entirely since I’ve never rated any of their songs at even 3 stars?
Maybe I should just dump my iTunes library into MySQL and run some queries…
Popularity: 6% [?]
Greg adds this Comment:
I’m not entirely familiar with the service, but it looks like you can go to http://www.itunesreg[...]om/index.php and upload a copy of your iTunes library XML; they will run stats for you.
August 27th, 2005 at 10:42 pm
brandon adds this Comment:
i’ve always found myself wishing that the itunes library could mimic a real database. i thought that maybe smart playlists would cover my needs, but they are still lacking in several ways. how hard *would* it be to dump the xml itunes library into mysql?
August 28th, 2005 at 5:07 am
shorty114 adds this Comment:
I’m wondering the same thing as brandon…
I’ve wondered about this before, and your post just sparked my wonderment again… how hard would it be to dump iTDB into MySQL?
August 28th, 2005 at 7:10 pm
Alex adds this Comment:
I’ll probably take a crack at this if I get a little free time.
August 28th, 2005 at 10:56 pm
Alex adds this Comment:
Well, that wasn’t too hard. I’ve got all the data in MySQL, now to run some stats.
August 29th, 2005 at 7:55 am
alexking.org: Blog adds this Trackback:
iTunes Stats
Well, I got curious so I went ahead and wrote up a little script to grab some basic stats from my iTunes data. I figured others might be interested in this as well, so I’ve packaged it up as a download.
What it does right now:
Imports a Li…
August 29th, 2005 at 4:52 pm