Skip to content

Instantly share code, notes, and snippets.

View Chicago-Dave's full-sized avatar

David J Thomas Chicago-Dave

  • Chicago
View GitHub Profile
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 42 columns, instead of 18 in line 2.
"trip_id","startdate","enddate","bikeid","from_station_id","from_station_name","to_station_id","to_station_name","usertype","gender","birthyear","meters","seconds","from_station_latitude","from_station_longitude","age_in_2014","to_station_latitude","to_station_longitude","to_station_dpcapacity","from_station_dpcapacity","start","stop","ridetime","tempM","precipM","pressureM","dewptM","humidity","rain","thunder","fog","snow","start_nhood","start_zone","stop_nhood","stop_zone","ridestyle","ridedistM","weekday","divvyuser","weekdays","starthour"
1718802,"19-05-2014","19-05-2014",913,98,"LaSalle St & Washington St",174,"Canal St & Madison St","Subscriber","Male",1968,699,282,41.882664,-87.63253,47,41.882091,-87.639833,23,15,"14:12:00","14:17:00","0:05:00",21.1,0,1019.2,3.9,32,0,0,0,0,"Loop","Loop","West Loop","West Loop",2,1609,1,"Direct","Monday",14
398037,"03-09-2013","03-09-2013",490,186,"Ogden Ave & Race Ave",66,"Clinton St & Lake St","Subscriber","Male",1979,2111,491,41.891795,-87.658751,36,41.88583274,-87.6
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 42 columns, instead of 18 in line 2.
"trip_id","startdate","enddate","bikeid","from_station_id","from_station_name","to_station_id","to_station_name","usertype","gender","birthyear","meters","seconds","from_station_latitude","from_station_longitude","age_in_2014","to_station_latitude","to_station_longitude","to_station_dpcapacity","from_station_dpcapacity","start","stop","ridetime","tempM","precipM","pressureM","dewptM","humidity","rain","thunder","fog","snow","start_nhood","start_zone","stop_nhood","stop_zone","ridestyle","ridedistM","weekday","divvyuser","weekdays","starthour"
1718802,"19-05-2014","19-05-2014",913,98,"LaSalle St & Washington St",174,"Canal St & Madison St","Subscriber","Male",1968,699,282,41.882664,-87.63253,47,41.882091,-87.639833,23,15,"14:12:00","14:17:00","0:05:00",21.1,0,1019.2,3.9,32,0,0,0,0,"Loop","Loop","West Loop","West Loop",2,1609,1,"Direct","Monday",14
398037,"03-09-2013","03-09-2013",490,186,"Ogden Ave & Race Ave",66,"Clinton St & Lake St","Subscriber","Male",1979,2111,491,41.891795,-87.658751,36,41.88583274,-87.6
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 42 columns, instead of 18 in line 2.
"trip_id","startdate","enddate","bikeid","from_station_id","from_station_name","to_station_id","to_station_name","usertype","gender","birthyear","meters","seconds","from_station_latitude","from_station_longitude","age_in_2014","to_station_latitude","to_station_longitude","to_station_dpcapacity","from_station_dpcapacity","start","stop","ridetime","tempM","precipM","pressureM","dewptM","humidity","rain","thunder","fog","snow","start_nhood","start_zone","stop_nhood","stop_zone","ridestyle","ridedistM","weekday","divvyuser","weekdays","starthour"
1718802,"19-05-2014","19-05-2014",913,98,"LaSalle St & Washington St",174,"Canal St & Madison St","Subscriber","Male",1968,699,282,41.882664,-87.63253,47,41.882091,-87.639833,23,15,"14:12:00","14:17:00","0:05:00",21.1,0,1019.2,3.9,32,0,0,0,0,"Loop","Loop","West Loop","West Loop",2,1609,1,"Direct","Monday",14
398037,"03-09-2013","03-09-2013",490,186,"Ogden Ave & Race Ave",66,"Clinton St & Lake St","Subscriber","Male",1979,2111,491,41.891795,-87.658751,36,41.88583274,-87.6
We can make this file beautiful and searchable if this error is corrected: It looks like row 3 should actually have 42 columns, instead of 41 in line 2.
trip_id,startdate,enddate,bikeid,from_station_id,from_station_name,to_station_id,to_station_name,usertype,gender,birthyear,meters,seconds,from_station_latitude,from_station_longitude,age_in_2014,to_station_latitude,to_station_longitude,to_station_dpcapacity,from_station_dpcapacity,start,stop,ridetime,tempM,precipM,pressureM,dewptM,humidity,rain,thunder,fog,snow,start_nhood,start_zone,stop_nhood,stop_zone,ridestyle,ridedistM,weekday,divvyuser,weekdays,starthour
1718802,19-05-2014,19-05-2014,913,98,LaSalle St & Washington St,174,Canal St & Madison St,Subscriber,Male,1968,699,282,41.882664,-87.63253,47,41.882091,-87.639833,23,15,14:12:00,14:17:00,0:05:00,21.1,0,1019.2,3.9,32,0,0,0,0,Loop,Loop,West Loop,West Loop,2,1609,1,Direct,Monday,14
398037,03-09-2013,3/9/13,490,186,Ogden Ave & Race Ave,66,Clinton St & Lake St,Subscriber,Male,1979,2111,491,41.891795,-87.658751,36,41.88583274,-87.64138231,19,15,11:43:00,11:51:00,0:08:00,22.2,0,1018,11.1,49,0,0,0,0,West Town,West Loop,West Loop,West Loop,2,2575,1,Direct,Tuesda
@Chicago-Dave
Chicago-Dave / apiswithpurrr.R
Created June 14, 2017 15:37 — forked from stephlocke/apiswithpurrr.R
Call Microsoft Cognitive Services APIs in R
library(httr)
library(jsonlite)
library(dplyr)
library(purrr)
cogapikey<-"XXX"
text=c("is this english?"
,"tak er der mere kage"
,"merci beaucoup"