Citibike Data Summary

Column

Chart 1

  tripduration           starttime            stoptime start.station.id
1          364 2017-07-01 00:00:00 2017-07-01 00:06:05              539
2         2142 2017-07-01 00:00:03 2017-07-01 00:35:46              293
3          328 2017-07-01 00:00:08 2017-07-01 00:05:37             3242
4         2530 2017-07-01 00:00:11 2017-07-01 00:42:22             2002
5         2534 2017-07-01 00:00:15 2017-07-01 00:42:29             2002
6          545 2017-07-01 00:00:18 2017-07-01 00:09:24              361
              start.station.name start.station.latitude
1 Metropolitan Ave & Bedford Ave               40.71535
2          Lafayette St & E 8 St               40.73021
3     Schermerhorn St & Court St               40.69103
4   Wythe Ave & Metropolitan Ave               40.71689
5   Wythe Ave & Metropolitan Ave               40.71689
6           Allen St & Hester St               40.71606
  start.station.longitude end.station.id         end.station.name
1               -73.96024           3107 Bedford Ave & Nassau Ave
2               -73.99103           3425        2 Ave  & E 104 St
3               -73.99183           3397     Court St & Nelson St
4               -73.96320            398 Atlantic Ave & Furman St
5               -73.96320            398 Atlantic Ave & Furman St
6               -73.99191            502      Henry St & Grand St
  end.station.latitude end.station.longitude bikeid   usertype birth.year
1             40.72312             -73.95212  14744 Subscriber       1986
2             40.78921             -73.94371  19587 Subscriber       1981
3             40.67639             -73.99870  27937 Subscriber       1984
4             40.69165             -73.99998  26066 Subscriber       1985
5             40.69165             -73.99998  29408 Subscriber       1982
6             40.71422             -73.98135  21203 Subscriber       1954
  gender
1   MALE
2   MALE
3 FEMALE
4   MALE
5 FEMALE
6 FEMALE

Column

Chart 2

  tripduration      starttime           stoptime         start.station.id
 Min.   :     61   Length:1735599     Length:1735599     Min.   :  72    
 1st Qu.:    395   Class :character   Class :character   1st Qu.: 359    
 Median :    676   Mode  :character   Mode  :character   Median : 486    
 Mean   :   1060                                         Mean   :1372    
 3rd Qu.:   1183                                         3rd Qu.:3142    
 Max.   :2477222                                         Max.   :3478    
                                                                         
 start.station.name start.station.latitude start.station.longitude
 Length:1735599     Min.   :40.66          Min.   :-74.02         
 Class :character   1st Qu.:40.72          1st Qu.:-74.00         
 Mode  :character   Median :40.74          Median :-73.99         
                    Mean   :40.74          Mean   :-73.99         
                    3rd Qu.:40.76          3rd Qu.:-73.98         
                    Max.   :40.88          Max.   :-73.90         
                                                                  
 end.station.id end.station.name   end.station.latitude
 Min.   :  72   Length:1735599     Min.   :40.66       
 1st Qu.: 359   Class :character   1st Qu.:40.72       
 Median : 485   Mode  :character   Median :40.74       
 Mean   :1371                      Mean   :40.74       
 3rd Qu.:3141                      3rd Qu.:40.76       
 Max.   :3478                      Max.   :40.88       
                                                       
 end.station.longitude     bikeid            usertype      
 Min.   :-74.07        Min.   :14529   Customer  : 261712  
 1st Qu.:-74.00        1st Qu.:18402   Subscriber:1473887  
 Median :-73.99        Median :25191                       
 Mean   :-73.99        Mean   :23171                       
 3rd Qu.:-73.98        3rd Qu.:27734                       
 Max.   :-73.90        Max.   :30337                       
                                                           
   birth.year         gender       
 Min.   :1874     UNKNOWN: 235194  
 1st Qu.:1972     MALE   :1099384  
 Median :1983     FEMALE : 401021  
 Mean   :1980                      
 3rd Qu.:1989                      
 Max.   :2001                      
 NA's   :228596                    

Chart 3

           tripduration               starttime                stoptime 
              "integer"             "character"             "character" 
       start.station.id      start.station.name  start.station.latitude 
              "integer"             "character"               "numeric" 
start.station.longitude          end.station.id        end.station.name 
              "numeric"               "integer"             "character" 
   end.station.latitude   end.station.longitude                  bikeid 
              "numeric"               "numeric"               "integer" 
               usertype              birth.year                  gender 
               "factor"               "integer"                "factor" 

Birth Year and User Type Analysis

Row

Chart 1

Row

Chart 2

Chart 3

Gender Analysis

column

Chart 1

column

Chart 2

Trip Duration Analysis

Column

Chart 1

Chart 2

Column

Chart 3

Weekday Analysis

Column

Chart 1

Column

Chart 2

Hour Summary Charts

Column

Chart 1

Chart 2

Column

Chart 3