Hacker News
new
|
past
|
comments
|
ask
|
show
|
jobs
|
submit
login
boothead
on Oct 8, 2013
|
parent
|
context
|
favorite
| on:
Foursquare dataset free to download and analyze
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!
nachi
on Oct 8, 2013
[–]
It looks like an ASCII-formatted table. Pretty disappointing that it isn't machine readable out of the box.
timthorn
on Oct 8, 2013
|
parent
|
next
[–]
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.
cwmma
on Oct 8, 2013
|
root
|
parent
|
next
[–]
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.
timthorn
on Oct 8, 2013
|
root
|
parent
|
next
[–]
So does fixed width. Excel, MySQL, R, Perl... :)
aw3c2
on Oct 8, 2013
|
parent
|
prev
[–]
sed 's/[[:blank:]]//g' dataset.dat | sed 's/|/\t/'
Consider applying for YC's Fall 2025 batch! Applications are open till Aug 4
Guidelines
|
FAQ
|
Lists
|
API
|
Security
|
Legal
|
Apply to YC
|
Contact
Search:
