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…
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.
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?
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?
I’ll probably take a crack at this if I get a little free time.
Well, that wasn’t too hard. I’ve got all the data in MySQL, now to run some 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…