News for hackers. Stuff that matters.
Re:Foursquare dataset free to download and analyze by boothead on Tuesday October 08, 2013 @03:30AM (#6513497)
No mention of the data format. Is it json, csv what? I know you can always head -n the file but a little hint would be helpful!
Re:Foursquare dataset free to download and analyze by nachi on Tuesday October 08, 2013 @03:48AM (#6513537)
It looks like an ASCII-formatted table. Pretty disappointing that it isn't machine readable out of the box.
Re:Foursquare dataset free to download and analyze by timthorn on Tuesday October 08, 2013 @03:51AM (#6513543)
What's not machine readable about an ASCII table? A fixed width table has its own advantages over eg CSV - for instance, to read a specific field you can reach it by offset rather than having to count delimiters.
Re:Foursquare dataset free to download and analyze by cwmma on Tuesday October 08, 2013 @06:17AM (#6513921)
fixed width might have technical advantages but CSV has the advantage of being able to be read by a lot of things out of the box.
Re:Foursquare dataset free to download and analyze by timthorn on Tuesday October 08, 2013 @06:33AM (#6513964)
So does fixed width. Excel, MySQL, R, Perl... :)
Re:Foursquare dataset free to download and analyze by aw3c2 on Tuesday October 08, 2013 @06:39AM (#6513985)
sed 's/[[:blank:]]//g' dataset.dat | sed 's/|/\t/'