News for hackers. Stuff that matters.

A comment on NYC Taxi Trips Data from 2013. Parent comment

Re:NYC Taxi Trips Data from 2013 by livejake on Wednesday June 18, 2014 @10:56PM (#7914164)
This is great. Is there anyway you could use data types other than string? The way it's currently setup makes it hard to analyze.
[ Parent | on HN ]
Re:NYC Taxi Trips Data from 2013 by ImJasonH on Friday June 20, 2014 @03:27PM (#7922400)
Sure, it wouldn't be hard to re-load the data in a new dataset/table with more accurate types. Strings are just the default. I just wasn't sure how clean the data was and didn't want to debug bad data before loading. I was lazy basically.

But if you wanted to do it, it's pretty straightforward.

In the meantime I haven't found it to be too hard to just INTEGER(field) and FLOAT(field) wherever I need to.

[ Parent | on HN ]