3 ms·
I uploaded these datasets to Google BigQuery in case anybody prefers to use that to go data-diving: https://bigquery.cloud.google.com/table/833682135931:nyctaxi
by ImJasonH 12y ago
I uploaded these datasets to Google BigQuery in case anybody prefers to use that to go data-diving:
https://bigquery.cloud.google.com/table/833682135931:nyctaxi.trip_data https://bigquery.cloud.google.com/table/833682135931:nyctaxi...
https://bigquery.cloud.google.com/table/833682135931:nyctaxi.trip_fare https://bigquery.cloud.google.com/table/833682135931:nyctaxi...
- livejake 12y agoThis is great. Is there anyway you could use data types other than string? The way it's currently setup makes it hard to analyze.
- ImJasonH 12y agoSure, 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.