tag:blogger.com,1999:blog-1346076462232770681.post188433340111889762..comments2023-10-29T08:14:08.778-07:00Comments on UptownMaker: Data wrangling the CurrentMike Hordhttp://www.blogger.com/profile/07456678428195589424noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-1346076462232770681.post-38542829408123041972010-10-19T09:58:23.096-07:002010-10-19T09:58:23.096-07:00It's eerie how similar this is to a project I ...It's eerie how similar this is to a project I undertook a few years back: <a href="http://blog.iangreenleaf.com/2008/12/893-current-and-mysterious-non.html" rel="nofollow">89.3 The Current and the Mysterious Non-Expanding Playlist</a>. Same motivation, same love of the Current, even the same language to do the screen scraping... convergence in action.<br /><br />I've also been scraping playlists from other TC stations (<a href="http://blog.iangreenleaf.com/2009/05/radio-sucks.html" rel="nofollow">Radio Sucks</a>). If you'd like those SQL datasets to play around with, I could send them to you.Ianhttps://www.blogger.com/profile/14922548722060582232noreply@blogger.comtag:blogger.com,1999:blog-1346076462232770681.post-24023050889362406412010-10-18T13:40:32.694-07:002010-10-18T13:40:32.694-07:00RE: Idris_Arslanian- I did the parsing with Python...RE: Idris_Arslanian- I did the parsing with Python, since a large part of this is an exercise to learn Python and how Python deals with large data sets. I will probably try to do some SQL for more advanced queries; it would be a nice skill to add to my resume, but far less important for me as an EE than it would be for other disciplines (I think).Mike Hordhttps://www.blogger.com/profile/07456678428195589424noreply@blogger.comtag:blogger.com,1999:blog-1346076462232770681.post-81552863637529530432010-10-18T13:31:49.647-07:002010-10-18T13:31:49.647-07:00So are you parsing w/ Python, or have you gone to ...So are you parsing w/ Python, or have you gone to SQL to get the metrics?Idris_Arslanianhttps://www.blogger.com/profile/15506951456784220206noreply@blogger.com