Question 4,5
bike4 <- read.delim("bike_sharing_data.txt")
bike2 <- read.table("bike_sharing_data.txt", sep="\t", header=TRUE)
bike1 <- read.table("bike_sharing_data.csv", sep=",", header=TRUE)
bike3 <- read.csv("bike_sharing_data.csv")
Question 6
str(bike1)
## 'data.frame': 17379 obs. of 13 variables:
## $ datetime : chr "1/1/2011 0:00" "1/1/2011 1:00" "1/1/2011 2:00" "1/1/2011 3:00" ...
## $ season : int 1 1 1 1 1 1 1 1 1 1 ...
## $ holiday : int 0 0 0 0 0 0 0 0 0 0 ...
## $ workingday: int 0 0 0 0 0 0 0 0 0 0 ...
## $ weather : int 1 1 1 1 1 2 1 1 1 1 ...
## $ temp : num 9.84 9.02 9.02 9.84 9.84 ...
## $ atemp : num 14.4 13.6 13.6 14.4 14.4 ...
## $ humidity : chr "81" "80" "80" "75" ...
## $ windspeed : num 0 0 0 0 0 ...
## $ casual : int 3 8 5 3 0 0 2 1 1 8 ...
## $ registered: int 13 32 27 10 1 1 0 2 7 6 ...
## $ count : int 16 40 32 13 1 1 2 3 8 14 ...
## $ sources : chr "ad campaign" "www.yahoo.com" "www.google.fi" "AD campaign" ...
Question 7
bike1[6251,2]
## [1] 4
Question 8
table(bike1$season)
##
## 1 2 3 4
## 4242 4409 4496 4232
Question 9
question_9 <- bike1[(bike1$season == 4) & (bike1$windspeed > 20), ]
question_9
## datetime season holiday workingday weather temp atemp humidity
## 6410 9/29/2011 15:00 4 0 1 1 27.88 31.820 45
## 6411 9/29/2011 16:00 4 0 1 1 27.88 31.820 41
## 6432 9/30/2011 13:00 4 0 1 2 27.06 31.060 47
## 6437 9/30/2011 18:00 4 0 1 1 23.78 27.275 49
## 6441 9/30/2011 22:00 4 0 1 1 21.32 25.000 55
## 6442 9/30/2011 23:00 4 0 1 1 21.32 25.000 55
## 6443 10/1/2011 0:00 4 0 0 1 20.50 24.240 63
## 6444 10/1/2011 1:00 4 0 0 1 19.68 23.485 67
## 6445 10/1/2011 2:00 4 0 0 1 18.86 22.725 63
## 6446 10/1/2011 3:00 4 0 0 1 18.86 22.725 59
## 6447 10/1/2011 4:00 4 0 0 1 18.04 21.970 58
## 6449 10/1/2011 6:00 4 0 0 1 17.22 21.210 67
## 6451 10/1/2011 8:00 4 0 0 2 16.40 20.455 76
## 6452 10/1/2011 9:00 4 0 0 3 16.40 20.455 82
## 6453 10/1/2011 10:00 4 0 0 3 16.40 20.455 76
## 6454 10/1/2011 11:00 4 0 0 3 15.58 19.695 82
## 6456 10/1/2011 13:00 4 0 0 2 16.40 20.455 82
## 6457 10/1/2011 14:00 4 0 0 2 17.22 21.210 71
## 6476 10/2/2011 9:00 4 0 0 1 14.76 16.665 76
## 6531 10/4/2011 16:00 4 0 1 1 23.78 27.275 56
## 6532 10/4/2011 17:00 4 0 1 1 22.96 26.515 60
## 6549 10/5/2011 10:00 4 0 1 1 22.96 26.515 56
## 6551 10/5/2011 12:00 4 0 1 1 25.42 31.060 43
## 6555 10/5/2011 16:00 4 0 1 1 26.24 31.060 47
## 6711 10/12/2011 4:00 4 0 1 3 22.14 25.760 94
## 6712 10/12/2011 5:00 4 0 1 2 22.14 25.760 88
## 6714 10/12/2011 7:00 4 0 1 2 22.14 25.760 88
## 6715 10/12/2011 8:00 4 0 1 2 22.14 25.760 88
## 6716 10/12/2011 9:00 4 0 1 2 22.14 25.760 88
## 6717 10/12/2011 10:00 4 0 1 2 22.14 25.760 88
## 6718 10/12/2011 11:00 4 0 1 3 22.14 25.760 94
## 6719 10/12/2011 12:00 4 0 1 3 22.14 25.760 88
## 6765 10/14/2011 10:00 4 0 1 3 22.14 25.760 88
## 6768 10/14/2011 13:00 4 0 1 1 22.96 26.515 73
## 6769 10/14/2011 14:00 4 0 1 1 25.42 31.060 43
## 6772 10/14/2011 17:00 4 0 1 1 23.78 27.275 46
## 6774 10/14/2011 19:00 4 0 1 1 22.14 25.760 39
## 6789 10/15/2011 10:00 4 0 0 1 22.14 25.760 45
## 6790 10/15/2011 11:00 4 0 0 1 22.96 26.515 40
## 6791 10/15/2011 12:00 4 0 0 1 23.78 27.275 35
## 6792 10/15/2011 13:00 4 0 0 1 24.60 31.060 35
## 6793 10/15/2011 14:00 4 0 0 1 24.60 31.060 33
## 6794 10/15/2011 15:00 4 0 0 1 25.42 31.060 31
## 6795 10/15/2011 16:00 4 0 0 1 25.42 31.060 29
## 6818 10/16/2011 15:00 4 0 0 1 25.42 31.060 35
## 6819 10/16/2011 16:00 4 0 0 1 24.60 31.060 46
## 6820 10/16/2011 17:00 4 0 0 1 23.78 27.275 49
## 6821 10/16/2011 18:00 4 0 0 1 22.96 26.515 49
## 6822 10/16/2011 19:00 4 0 0 1 22.14 25.760 52
## 6823 10/16/2011 20:00 4 0 0 1 22.14 25.760 52
## 6824 10/16/2011 21:00 4 0 0 1 22.14 25.760 52
## 6825 10/16/2011 22:00 4 0 0 1 22.96 26.515 49
## 6826 10/16/2011 23:00 4 0 0 1 22.96 26.515 52
## 6827 10/17/2011 0:00 4 0 1 1 22.14 25.760 56
## 6828 10/17/2011 1:00 4 0 1 1 22.96 26.515 54
## 6829 10/17/2011 2:00 4 0 1 1 22.96 26.515 54
## 6882 10/19/2011 8:00 4 0 1 3 22.14 25.760 70
## 6883 10/19/2011 9:00 4 0 1 3 21.32 25.000 88
## 6884 10/19/2011 10:00 4 0 1 3 21.32 25.000 88
## 6886 10/19/2011 12:00 4 0 1 3 21.32 25.000 94
## 6896 10/19/2011 22:00 4 0 1 2 23.78 27.275 94
## 6897 10/19/2011 23:00 4 0 1 2 23.78 27.275 94
## 6899 10/20/2011 1:00 4 0 1 1 22.96 26.515 88
## 6900 10/20/2011 2:00 4 0 1 1 22.96 26.515 88
## 6901 10/20/2011 3:00 4 0 1 1 20.50 24.240 82
## 6902 10/20/2011 4:00 4 0 1 1 20.50 24.240 82
## 6903 10/20/2011 5:00 4 0 1 1 19.68 23.485 82
## 6904 10/20/2011 6:00 4 0 1 1 18.04 21.970 82
## 6905 10/20/2011 7:00 4 0 1 1 17.22 21.210 77
## 6906 10/20/2011 8:00 4 0 1 1 18.04 21.970 67
## 6907 10/20/2011 9:00 4 0 1 1 18.04 21.970 67
## 6908 10/20/2011 10:00 4 0 1 1 18.86 22.725 59
## 6909 10/20/2011 11:00 4 0 1 1 19.68 23.485 55
## 6910 10/20/2011 12:00 4 0 1 1 19.68 23.485 48
## 6911 10/20/2011 13:00 4 0 1 1 20.50 24.240 45
## 6912 10/20/2011 14:00 4 0 1 2 19.68 23.485 48
## 6913 10/20/2011 15:00 4 0 1 2 19.68 23.485 51
## 6914 10/20/2011 16:00 4 0 1 2 19.68 23.485 51
## 6915 10/20/2011 17:00 4 0 1 2 19.68 23.485 48
## 6917 10/20/2011 19:00 4 0 1 1 18.86 22.725 51
## 6918 10/20/2011 20:00 4 0 1 2 18.86 22.725 51
## 6920 10/20/2011 22:00 4 0 1 1 18.04 21.970 51
## 6935 10/21/2011 13:00 4 0 1 1 19.68 23.485 48
## 6941 10/21/2011 19:00 4 0 1 2 18.04 21.970 54
## 7030 10/25/2011 12:00 4 0 1 1 22.14 25.760 39
## 7031 10/25/2011 13:00 4 0 1 1 22.96 26.515 37
## 7053 10/26/2011 11:00 4 0 1 1 21.32 25.000 59
## 7083 10/27/2011 17:00 4 0 1 2 20.50 24.240 72
## 7084 10/27/2011 18:00 4 0 1 2 19.68 23.485 67
## 7085 10/27/2011 19:00 4 0 1 2 18.04 21.970 67
## 7086 10/27/2011 20:00 4 0 1 1 17.22 21.210 67
## 7087 10/27/2011 21:00 4 0 1 1 16.40 20.455 62
## 7088 10/27/2011 22:00 4 0 1 1 14.76 15.910 66
## 7089 10/27/2011 23:00 4 0 1 1 13.94 15.150 61
## 7113 10/28/2011 23:00 4 0 1 3 12.30 13.635 81
## 7117 10/29/2011 3:00 4 0 0 3 12.30 13.635 81
## 7118 10/29/2011 4:00 4 0 0 3 12.30 13.635 81
## 7119 10/29/2011 5:00 4 0 0 3 10.66 11.365 93
## 7120 10/29/2011 6:00 4 0 0 3 10.66 11.365 87
## 7121 10/29/2011 7:00 4 0 0 3 10.66 11.365 87
## 7122 10/29/2011 8:00 4 0 0 3 11.48 12.880 87
## 7123 10/29/2011 9:00 4 0 0 3 11.48 12.880 87
## 7124 10/29/2011 10:00 4 0 0 3 10.66 11.365 93
## 7125 10/29/2011 11:00 4 0 0 3 10.66 11.365 93
## 7126 10/29/2011 12:00 4 0 0 3 9.84 9.850 87
## 7127 10/29/2011 13:00 4 0 0 3 9.84 9.850 87
## 7128 10/29/2011 14:00 4 0 0 3 9.84 9.850 87
## 7130 10/29/2011 16:00 4 0 0 3 9.02 9.850 93
## 7131 10/29/2011 17:00 4 0 0 3 9.02 9.850 93
## 7132 10/29/2011 18:00 4 0 0 3 9.02 9.850 93
## 7133 10/29/2011 19:00 4 0 0 1 9.84 10.605 87
## 7134 10/29/2011 20:00 4 0 0 1 9.84 10.605 87
## 7135 10/29/2011 21:00 4 0 0 1 9.84 10.605 87
## 7141 10/30/2011 3:00 4 0 0 1 9.84 10.605 75
## 7142 10/30/2011 4:00 4 0 0 1 9.02 9.850 80
## 7266 11/4/2011 8:00 4 0 1 2 16.40 20.455 87
## 7267 11/4/2011 9:00 4 0 1 2 17.22 21.210 71
## 7268 11/4/2011 10:00 4 0 1 2 17.22 21.210 71
## 7269 11/4/2011 11:00 4 0 1 2 18.04 21.970 67
## 7270 11/4/2011 12:00 4 0 1 2 19.68 23.485 55
## 7271 11/4/2011 13:00 4 0 1 1 18.04 21.970 51
## 7273 11/4/2011 15:00 4 0 1 1 18.86 22.725 44
## 7274 11/4/2011 16:00 4 0 1 1 18.86 22.725 36
## 7275 11/4/2011 17:00 4 0 1 1 17.22 21.210 38
## 7276 11/4/2011 18:00 4 0 1 1 17.22 21.210 32
## 7277 11/4/2011 19:00 4 0 1 1 16.40 20.455 37
## 7280 11/4/2011 22:00 4 0 1 1 13.94 15.150 46
## 7281 11/4/2011 23:00 4 0 1 1 13.12 15.150 49
## 7282 11/5/2011 0:00 4 0 0 1 13.12 14.395 45
## 7284 11/5/2011 2:00 4 0 0 1 12.30 13.635 52
## 7286 11/5/2011 4:00 4 0 0 1 11.48 12.880 56
## 7287 11/5/2011 5:00 4 0 0 1 10.66 11.365 60
## 7290 11/5/2011 8:00 4 0 0 1 11.48 12.880 56
## 7413 11/10/2011 11:00 4 0 1 2 18.86 22.725 67
## 7414 11/10/2011 12:00 4 0 1 2 17.22 21.210 67
## 7415 11/10/2011 13:00 4 0 1 3 14.76 16.665 81
## 7427 11/11/2011 1:00 4 1 0 1 13.12 15.150 57
## 7432 11/11/2011 6:00 4 1 0 1 11.48 12.880 45
## 7434 11/11/2011 8:00 4 1 0 1 12.30 13.635 42
## 7435 11/11/2011 9:00 4 1 0 1 13.12 14.395 45
## 7436 11/11/2011 10:00 4 1 0 1 13.12 13.635 42
## 7437 11/11/2011 11:00 4 1 0 1 13.94 14.395 42
## 7438 11/11/2011 12:00 4 1 0 1 13.94 14.395 42
## 7439 11/11/2011 13:00 4 1 0 1 15.58 19.695 37
## 7440 11/11/2011 14:00 4 1 0 1 15.58 19.695 37
## 7441 11/11/2011 15:00 4 1 0 1 14.76 16.665 37
## 7442 11/11/2011 16:00 4 1 0 1 14.76 16.665 34
## 7443 11/11/2011 17:00 4 1 0 1 13.94 15.150 39
## 7484 11/13/2011 10:00 4 0 0 1 18.04 21.970 44
## 7485 11/13/2011 11:00 4 0 0 1 18.86 22.725 40
## 7486 11/13/2011 12:00 4 0 0 2 21.32 25.000 29
## 7487 11/13/2011 13:00 4 0 0 2 21.32 25.000 29
## 7488 11/13/2011 14:00 4 0 0 2 22.14 25.760 28
## 7489 11/13/2011 15:00 4 0 0 2 20.50 24.240 42
## 7490 11/13/2011 16:00 4 0 0 2 22.14 25.760 28
## 7491 11/13/2011 17:00 4 0 0 1 21.32 25.000 27
## 7492 11/13/2011 18:00 4 0 0 1 21.32 25.000 27
## 7493 11/13/2011 19:00 4 0 0 1 20.50 24.240 29
## 7494 11/13/2011 20:00 4 0 0 1 20.50 24.240 31
## 7496 11/13/2011 22:00 4 0 0 1 19.68 23.485 41
## 7500 11/14/2011 2:00 4 0 1 1 18.86 22.725 63
## 7507 11/14/2011 9:00 4 0 1 2 19.68 23.485 67
## 7511 11/14/2011 13:00 4 0 1 1 24.60 31.060 49
## 7512 11/14/2011 14:00 4 0 1 1 25.42 31.060 46
## 7513 11/14/2011 15:00 4 0 1 1 26.24 31.060 44
## 7514 11/14/2011 16:00 4 0 1 1 25.42 31.060 46
## 7518 11/14/2011 20:00 4 0 1 1 24.60 31.060 53
## 7519 11/14/2011 21:00 4 0 1 1 24.60 31.060 53
## 7520 11/14/2011 22:00 4 0 1 1 23.78 27.275 56
## 7522 11/15/2011 0:00 4 0 1 1 22.96 26.515 64
## 7525 11/15/2011 3:00 4 0 1 2 22.14 25.760 68
## 7541 11/15/2011 19:00 4 0 1 2 20.50 24.240 72
## 7564 11/16/2011 18:00 4 0 1 3 18.86 22.725 88
## 7565 11/16/2011 19:00 4 0 1 3 18.86 22.725 88
## 7566 11/16/2011 20:00 4 0 1 3 18.04 21.970 88
## 7573 11/17/2011 3:00 4 0 1 2 17.22 21.210 77
## 7574 11/17/2011 4:00 4 0 1 2 16.40 20.455 62
## 7575 11/17/2011 5:00 4 0 1 3 13.94 15.150 71
## 7579 11/17/2011 9:00 4 0 1 2 13.94 15.150 61
## 7580 11/17/2011 10:00 4 0 1 2 13.94 15.150 61
## 7581 11/17/2011 11:00 4 0 1 3 13.12 15.150 66
## 7583 11/17/2011 13:00 4 0 1 2 13.94 15.150 49
## 7584 11/17/2011 14:00 4 0 1 2 13.94 15.150 49
## 7585 11/17/2011 15:00 4 0 1 2 13.94 15.150 49
## 7586 11/17/2011 16:00 4 0 1 1 13.12 14.395 39
## 7587 11/17/2011 17:00 4 0 1 1 13.12 14.395 42
## 7595 11/18/2011 1:00 4 0 1 1 10.66 11.365 44
## 7622 11/19/2011 4:00 4 0 0 1 10.66 11.365 48
## 7624 11/19/2011 6:00 4 0 0 1 9.84 10.605 60
## 7716 11/23/2011 2:00 4 0 1 3 20.50 24.240 94
## 7717 11/23/2011 3:00 4 0 1 3 20.50 24.240 94
## 7718 11/23/2011 4:00 4 0 1 3 21.32 25.000 88
## 7725 11/23/2011 11:00 4 0 1 2 20.50 24.240 72
## 7726 11/23/2011 12:00 4 0 1 1 19.68 23.485 55
## 7727 11/23/2011 13:00 4 0 1 2 18.04 21.970 54
## 7728 11/23/2011 14:00 4 0 1 1 17.22 21.210 54
## 7729 11/23/2011 15:00 4 0 1 2 17.22 21.210 54
## 7730 11/23/2011 16:00 4 0 1 2 16.40 20.455 62
## 7731 11/23/2011 17:00 4 0 1 3 15.58 19.695 71
## 7732 11/23/2011 18:00 4 0 1 2 16.40 20.455 58
## 7733 11/23/2011 19:00 4 0 1 1 15.58 19.695 58
## 7734 11/23/2011 20:00 4 0 1 1 14.76 16.665 62
## 7735 11/23/2011 21:00 4 0 1 1 14.76 15.910 57
## 7736 11/23/2011 22:00 4 0 1 1 13.94 15.150 61
## 7737 11/23/2011 23:00 4 0 1 1 13.94 15.150 61
## 7739 11/24/2011 1:00 4 1 0 1 13.12 14.395 57
## 7821 11/27/2011 11:00 4 0 0 1 20.50 24.240 63
## 7824 11/27/2011 14:00 4 0 0 1 25.42 31.060 43
## 7861 11/29/2011 4:00 4 0 1 2 21.32 25.000 83
## 7866 11/29/2011 9:00 4 0 1 3 22.96 26.515 73
## 7867 11/29/2011 10:00 4 0 1 3 22.96 26.515 73
## 7869 11/29/2011 12:00 4 0 1 3 17.22 21.210 82
## 7872 11/29/2011 15:00 4 0 1 3 16.40 20.455 87
## 7876 11/29/2011 19:00 4 0 1 2 16.40 20.455 82
## 7880 11/29/2011 23:00 4 0 1 1 14.76 16.665 76
## 7881 11/30/2011 0:00 4 0 1 1 14.76 16.665 62
## 7882 11/30/2011 1:00 4 0 1 1 13.94 15.150 66
## 7894 11/30/2011 13:00 4 0 1 2 15.58 19.695 43
## 7895 11/30/2011 14:00 4 0 1 2 15.58 19.695 43
## 7896 11/30/2011 15:00 4 0 1 1 14.76 16.665 46
## 7898 11/30/2011 17:00 4 0 1 2 13.94 15.150 49
## 7899 11/30/2011 18:00 4 0 1 1 13.94 15.150 49
## 7902 11/30/2011 21:00 4 0 1 1 13.12 14.395 53
## 7905 12/1/2011 0:00 4 0 1 1 11.48 12.880 52
## 7912 12/1/2011 7:00 4 0 1 1 9.84 10.605 65
## 7913 12/1/2011 8:00 4 0 1 1 10.66 11.365 60
## 7914 12/1/2011 9:00 4 0 1 1 12.30 13.635 52
## 8055 12/7/2011 6:00 4 0 1 3 19.68 23.485 100
## 8066 12/7/2011 17:00 4 0 1 3 16.40 20.455 100
## 8068 12/7/2011 19:00 4 0 1 3 13.94 14.395 87
## 8069 12/7/2011 20:00 4 0 1 3 13.94 14.395 87
## 8070 12/7/2011 21:00 4 0 1 3 12.30 12.880 87
## 8071 12/7/2011 22:00 4 0 1 3 9.84 9.850 93
## 8072 12/7/2011 23:00 4 0 1 1 9.84 10.605 93
## 8074 12/8/2011 1:00 4 0 1 1 10.66 11.365 81
## 8077 12/8/2011 4:00 4 0 1 2 9.84 9.850 60
## 8082 12/8/2011 9:00 4 0 1 1 9.84 10.605 52
## 8083 12/8/2011 10:00 4 0 1 1 10.66 11.365 52
## 8085 12/8/2011 12:00 4 0 1 1 11.48 12.880 52
## 8086 12/8/2011 13:00 4 0 1 1 12.30 13.635 49
## 8132 12/10/2011 11:00 4 0 0 1 13.12 14.395 53
## 8133 12/10/2011 12:00 4 0 0 1 13.12 14.395 45
## 8134 12/10/2011 13:00 4 0 0 1 13.94 15.150 34
## 8135 12/10/2011 14:00 4 0 0 1 13.94 15.150 31
## 8136 12/10/2011 15:00 4 0 0 1 13.94 15.150 34
## 8137 12/10/2011 16:00 4 0 0 1 13.12 14.395 31
## 8138 12/10/2011 17:00 4 0 0 1 11.48 12.880 36
## 8205 12/13/2011 12:00 4 0 1 1 14.76 16.665 43
## 8206 12/13/2011 13:00 4 0 1 1 16.40 20.455 37
## 8252 12/15/2011 11:00 4 0 1 2 16.40 20.455 62
## 8253 12/15/2011 12:00 4 0 1 2 18.86 22.725 59
## 8254 12/15/2011 13:00 4 0 1 2 20.50 24.240 55
## 8255 12/15/2011 14:00 4 0 1 2 21.32 25.000 52
## 8261 12/15/2011 20:00 4 0 1 1 21.32 25.000 59
## 8263 12/15/2011 22:00 4 0 1 1 21.32 25.000 63
## 8264 12/15/2011 23:00 4 0 1 1 21.32 25.000 63
## 8265 12/16/2011 0:00 4 0 1 1 20.50 24.240 72
## 8270 12/16/2011 5:00 4 0 1 1 19.68 23.485 44
## 8273 12/16/2011 8:00 4 0 1 1 14.76 16.665 46
## 8274 12/16/2011 9:00 4 0 1 1 14.76 16.665 46
## 8277 12/16/2011 12:00 4 0 1 2 13.94 15.150 42
## 8278 12/16/2011 13:00 4 0 1 2 13.94 15.150 39
## 8300 12/17/2011 11:00 4 0 0 2 11.48 12.880 45
## 8303 12/17/2011 14:00 4 0 0 1 11.48 12.880 45
## 8307 12/17/2011 18:00 4 0 0 1 10.66 11.365 48
## 8308 12/17/2011 19:00 4 0 0 3 9.84 10.605 65
## 8349 12/19/2011 12:00 4 0 1 1 12.30 13.635 61
## 8350 12/19/2011 13:00 4 0 1 1 13.94 15.150 49
## 15021 9/23/2012 1:00 4 0 0 1 22.14 25.760 52
## 15028 9/23/2012 8:00 4 0 0 1 19.68 23.485 55
## 15029 9/23/2012 9:00 4 0 0 1 20.50 24.240 51
## 15036 9/23/2012 16:00 4 0 0 1 24.60 31.060 33
## 15082 9/25/2012 14:00 4 0 1 1 27.06 31.060 39
## 15083 9/25/2012 15:00 4 0 1 1 27.06 31.060 36
## 15091 9/25/2012 23:00 4 0 1 1 24.60 31.060 56
## 15093 9/26/2012 1:00 4 0 1 1 23.78 27.275 64
## 15132 9/27/2012 16:00 4 0 1 2 29.52 33.335 58
## 15181 9/29/2012 17:00 4 0 0 1 24.60 31.060 38
## 15206 9/30/2012 18:00 4 0 0 1 21.32 25.000 59
## 15297 10/4/2012 13:00 4 0 1 2 29.52 33.335 58
## 15345 10/6/2012 13:00 4 0 0 2 26.24 31.060 57
## 15346 10/6/2012 14:00 4 0 0 2 24.60 31.060 56
## 15347 10/6/2012 15:00 4 0 0 1 24.60 31.060 46
## 15348 10/6/2012 16:00 4 0 0 1 24.60 31.060 43
## 15349 10/6/2012 17:00 4 0 0 1 22.14 25.760 49
## 15350 10/6/2012 18:00 4 0 0 1 21.32 25.000 48
## 15447 10/10/2012 19:00 4 0 1 2 22.96 26.515 46
## 15448 10/10/2012 20:00 4 0 1 1 21.32 25.000 48
## 15449 10/10/2012 21:00 4 0 1 1 20.50 24.240 51
## 15460 10/11/2012 8:00 4 0 1 1 15.58 19.695 46
## 15461 10/11/2012 9:00 4 0 1 1 16.40 20.455 43
## 15462 10/11/2012 10:00 4 0 1 1 18.04 21.970 41
## 15487 10/12/2012 11:00 4 0 1 1 22.14 25.760 37
## 15488 10/12/2012 12:00 4 0 1 1 22.14 25.760 39
## 15489 10/12/2012 13:00 4 0 1 1 22.96 26.515 37
## 15490 10/12/2012 14:00 4 0 1 1 22.96 26.515 37
## 15491 10/12/2012 15:00 4 0 1 1 21.32 25.000 42
## 15492 10/12/2012 16:00 4 0 1 1 18.86 22.725 41
## 15493 10/12/2012 17:00 4 0 1 1 18.86 22.725 38
## 15536 10/14/2012 12:00 4 0 0 1 25.42 31.060 46
## 15537 10/14/2012 13:00 4 0 0 1 26.24 31.060 41
## 15538 10/14/2012 14:00 4 0 0 1 27.06 31.060 39
## 15539 10/14/2012 15:00 4 0 0 1 27.06 31.060 39
## 15545 10/14/2012 21:00 4 0 0 1 22.96 26.515 73
## 15546 10/14/2012 22:00 4 0 0 1 22.96 26.515 73
## 15549 10/15/2012 1:00 4 0 1 2 23.78 27.275 64
## 15550 10/15/2012 2:00 4 0 1 2 23.78 27.275 64
## 15555 10/15/2012 7:00 4 0 1 2 23.78 27.275 68
## 15556 10/15/2012 8:00 4 0 1 2 24.60 30.305 64
## 15557 10/15/2012 9:00 4 0 1 3 24.60 29.545 69
## 15558 10/15/2012 10:00 4 0 1 2 24.60 29.545 73
## 15559 10/15/2012 11:00 4 0 1 2 24.60 29.545 73
## 15560 10/15/2012 12:00 4 0 1 3 24.60 28.790 78
## 15563 10/15/2012 15:00 4 0 1 1 24.60 28.790 78
## 15568 10/15/2012 20:00 4 0 1 2 21.32 25.000 72
## 15569 10/15/2012 21:00 4 0 1 1 21.32 25.000 59
## 15572 10/16/2012 0:00 4 0 1 1 18.86 22.725 63
## 15583 10/16/2012 11:00 4 0 1 1 20.50 24.240 45
## 15584 10/16/2012 12:00 4 0 1 2 21.32 25.000 45
## 15587 10/16/2012 15:00 4 0 1 1 22.14 25.760 41
## 15633 10/18/2012 13:00 4 0 1 1 25.42 31.060 53
## 15637 10/18/2012 17:00 4 0 1 2 23.78 27.275 64
## 15638 10/18/2012 18:00 4 0 1 2 22.96 26.515 64
## 15660 10/19/2012 16:00 4 0 1 3 25.42 30.305 69
## 15661 10/19/2012 17:00 4 0 1 3 25.42 30.305 69
## 15703 10/21/2012 11:00 4 0 0 1 21.32 25.000 44
## 15704 10/21/2012 12:00 4 0 0 1 22.14 25.760 39
## 15707 10/21/2012 15:00 4 0 0 1 22.96 26.515 35
## 15859 10/27/2012 23:00 4 0 0 2 21.32 25.000 68
## 15863 10/28/2012 3:00 4 0 0 2 20.50 24.240 63
## 15864 10/28/2012 4:00 4 0 0 2 20.50 24.240 63
## 15866 10/28/2012 6:00 4 0 0 2 20.50 24.240 59
## 15868 10/28/2012 8:00 4 0 0 2 20.50 24.240 59
## 15869 10/28/2012 9:00 4 0 0 2 20.50 24.240 55
## 15870 10/28/2012 10:00 4 0 0 2 19.68 23.485 51
## 15871 10/28/2012 11:00 4 0 0 2 20.50 24.240 51
## 15872 10/28/2012 12:00 4 0 0 2 19.68 23.485 59
## 15873 10/28/2012 13:00 4 0 0 2 19.68 23.485 59
## 15874 10/28/2012 14:00 4 0 0 2 20.50 24.240 59
## 15875 10/28/2012 15:00 4 0 0 2 20.50 24.240 63
## 15876 10/28/2012 16:00 4 0 0 3 19.68 23.485 67
## 15877 10/28/2012 17:00 4 0 0 3 18.86 22.725 77
## 15878 10/28/2012 18:00 4 0 0 3 17.22 21.210 94
## 15879 10/28/2012 19:00 4 0 0 3 17.22 21.210 94
## 15880 10/28/2012 20:00 4 0 0 3 17.22 21.210 94
## 15881 10/28/2012 21:00 4 0 0 3 18.04 21.970 88
## 15882 10/28/2012 22:00 4 0 0 3 18.04 21.970 88
## 15883 10/28/2012 23:00 4 0 0 3 17.22 21.210 94
## 15884 10/29/2012 0:00 4 0 1 3 18.04 21.970 88
## 15885 10/30/2012 13:00 4 0 1 3 12.30 13.635 81
## 15886 10/30/2012 14:00 4 0 1 3 12.30 13.635 81
## 15955 11/2/2012 11:00 4 0 1 1 17.22 21.210 41
## 15956 11/2/2012 12:00 4 0 1 1 17.22 21.210 41
## 15957 11/2/2012 13:00 4 0 1 1 16.40 20.455 43
## 15958 11/2/2012 14:00 4 0 1 2 16.40 20.455 40
## 15959 11/2/2012 15:00 4 0 1 2 16.40 20.455 40
## 15960 11/2/2012 16:00 4 0 1 1 15.58 19.695 40
## 15961 11/2/2012 17:00 4 0 1 1 15.58 19.695 40
## 15962 11/2/2012 18:00 4 0 1 2 15.58 19.695 43
## 15964 11/2/2012 20:00 4 0 1 2 14.76 16.665 46
## 15965 11/2/2012 21:00 4 0 1 2 14.76 16.665 46
## 15969 11/3/2012 1:00 4 0 0 2 13.94 15.150 49
## 15978 11/3/2012 10:00 4 0 0 1 14.76 16.665 46
## 15979 11/3/2012 11:00 4 0 0 2 14.76 16.665 46
## 15980 11/3/2012 12:00 4 0 0 2 14.76 15.910 46
## 15981 11/3/2012 13:00 4 0 0 2 14.76 16.665 46
## 15982 11/3/2012 14:00 4 0 0 2 14.76 16.665 50
## 15983 11/3/2012 15:00 4 0 0 2 14.76 15.910 46
## 15984 11/3/2012 16:00 4 0 0 2 14.76 16.665 46
## 16008 11/4/2012 16:00 4 0 0 1 16.40 20.455 40
## 16012 11/4/2012 20:00 4 0 0 1 13.12 14.395 53
## 16021 11/5/2012 5:00 4 0 1 2 12.30 13.635 52
## 16028 11/5/2012 12:00 4 0 1 1 14.76 16.665 43
## 16067 11/7/2012 3:00 4 0 1 2 11.48 12.880 52
## 16069 11/7/2012 5:00 4 0 1 2 11.48 12.880 52
## 16075 11/7/2012 11:00 4 0 1 2 13.12 14.395 51
## 16078 11/7/2012 14:00 4 0 1 2 13.12 14.395 53
## 16080 11/7/2012 16:00 4 0 1 2 13.12 14.395 53
## 16081 11/7/2012 17:00 4 0 1 2 13.12 14.395 53
## 16082 11/7/2012 18:00 4 0 1 2 13.12 14.395 53
## 16084 11/7/2012 20:00 4 0 1 2 13.12 15.150 49
## 16089 11/8/2012 1:00 4 0 1 3 12.30 13.635 52
## 16094 11/8/2012 7:00 4 0 1 1 11.48 12.880 36
## 16096 11/8/2012 9:00 4 0 1 1 13.12 14.395 31
## 16097 11/8/2012 10:00 4 0 1 1 13.12 15.150 31
## 16098 11/8/2012 11:00 4 0 1 1 14.76 16.665 29
## 16099 11/8/2012 12:00 4 0 1 1 16.40 20.455 24
## 16100 11/8/2012 13:00 4 0 1 1 18.04 21.970 18
## 16101 11/8/2012 14:00 4 0 1 1 18.04 21.970 18
## 16102 11/8/2012 15:00 4 0 1 1 18.04 21.970 18
## 16103 11/8/2012 16:00 4 0 1 1 17.22 21.210 16
## 16105 11/8/2012 18:00 4 0 1 1 16.40 20.455 24
## 16106 11/8/2012 19:00 4 0 1 1 15.58 19.695 27
## 16107 11/8/2012 20:00 4 0 1 1 15.58 19.695 29
## 16108 11/8/2012 21:00 4 0 1 1 14.76 16.665 37
## 16110 11/8/2012 23:00 4 0 1 1 13.94 15.150 46
## 16111 11/9/2012 0:00 4 0 1 1 13.94 15.150 49
## 16114 11/9/2012 3:00 4 0 1 1 13.12 14.395 53
## 16115 11/9/2012 4:00 4 0 1 1 13.12 14.395 53
## 16120 11/9/2012 9:00 4 0 1 1 13.94 15.150 53
## 16121 11/9/2012 10:00 4 0 1 1 14.76 16.665 50
## 16123 11/9/2012 12:00 4 0 1 1 18.04 21.970 41
## 16208 11/13/2012 1:00 4 0 1 3 18.04 21.970 88
## 16209 11/13/2012 2:00 4 0 1 3 14.76 15.910 87
## 16210 11/13/2012 3:00 4 0 1 3 14.76 16.665 87
## 16211 11/13/2012 4:00 4 0 1 2 14.76 16.665 81
## 16213 11/13/2012 6:00 4 0 1 3 13.12 14.395 81
## 16216 11/13/2012 9:00 4 0 1 3 13.12 15.150 81
## 16217 11/13/2012 10:00 4 0 1 3 12.30 13.635 75
## 16221 11/13/2012 14:00 4 0 1 1 15.58 19.695 46
## 16224 11/13/2012 17:00 4 0 1 1 13.94 15.150 49
## 16226 11/13/2012 19:00 4 0 1 1 13.12 14.395 49
## 16227 11/13/2012 20:00 4 0 1 1 12.30 13.635 49
## 16228 11/13/2012 21:00 4 0 1 1 12.30 13.635 49
## 16229 11/13/2012 22:00 4 0 1 1 10.66 11.365 56
## 16240 11/14/2012 9:00 4 0 1 1 12.30 13.635 52
## 16241 11/14/2012 10:00 4 0 1 1 13.12 14.395 45
## 16340 11/18/2012 13:00 4 0 0 1 16.40 20.455 62
## 16343 11/18/2012 16:00 4 0 0 2 16.40 20.455 62
## 16469 11/23/2012 22:00 4 0 1 1 18.04 21.970 33
## 16470 11/23/2012 23:00 4 0 1 1 17.22 21.210 38
## 16471 11/24/2012 0:00 4 0 0 1 16.40 20.455 37
## 16472 11/24/2012 1:00 4 0 0 1 13.94 14.395 42
## 16473 11/24/2012 2:00 4 0 0 1 13.12 13.635 39
## 16474 11/24/2012 3:00 4 0 0 1 11.48 12.880 41
## 16475 11/24/2012 4:00 4 0 0 1 10.66 10.605 41
## 16476 11/24/2012 5:00 4 0 0 1 10.66 11.365 41
## 16478 11/24/2012 7:00 4 0 0 2 10.66 11.365 41
## 16479 11/24/2012 8:00 4 0 0 2 10.66 10.605 44
## 16480 11/24/2012 9:00 4 0 0 2 10.66 10.605 41
## 16483 11/24/2012 12:00 4 0 0 2 12.30 12.880 36
## 16484 11/24/2012 13:00 4 0 0 1 13.12 15.150 36
## 16485 11/24/2012 14:00 4 0 0 1 13.12 14.395 33
## 16486 11/24/2012 15:00 4 0 0 1 12.30 13.635 36
## 16487 11/24/2012 16:00 4 0 0 1 11.48 12.120 38
## 16488 11/24/2012 17:00 4 0 0 1 10.66 11.365 41
## 16489 11/24/2012 18:00 4 0 0 1 10.66 11.365 38
## 16497 11/25/2012 2:00 4 0 0 1 9.02 9.850 44
## 16555 11/27/2012 12:00 4 0 1 3 11.48 12.880 87
## 16557 11/27/2012 14:00 4 0 1 3 11.48 12.880 87
## 16560 11/27/2012 17:00 4 0 1 2 12.30 13.635 75
## 16561 11/27/2012 18:00 4 0 1 1 10.66 11.365 81
## 16563 11/27/2012 20:00 4 0 1 1 10.66 11.365 75
## 16579 11/28/2012 12:00 4 0 1 1 13.94 15.150 42
## 16582 11/28/2012 15:00 4 0 1 1 14.76 16.665 32
## 16735 12/5/2012 1:00 4 0 1 1 21.32 25.000 55
## 16738 12/5/2012 4:00 4 0 1 1 20.50 24.240 63
## 16740 12/5/2012 6:00 4 0 1 3 19.68 23.485 55
## 16744 12/5/2012 10:00 4 0 1 2 18.04 21.970 47
## 16748 12/5/2012 14:00 4 0 1 1 19.68 23.485 33
## 16752 12/5/2012 18:00 4 0 1 1 17.22 21.210 35
## 16753 12/5/2012 19:00 4 0 1 1 15.58 19.695 43
## 16754 12/5/2012 20:00 4 0 1 1 13.94 15.150 46
## 16755 12/5/2012 21:00 4 0 1 1 13.94 15.150 46
## 16756 12/5/2012 22:00 4 0 1 1 13.12 14.395 45
## 16757 12/5/2012 23:00 4 0 1 1 12.30 13.635 49
## 16878 12/11/2012 0:00 4 0 1 3 18.86 22.725 77
## 16879 12/11/2012 1:00 4 0 1 1 17.22 21.210 71
## 16880 12/11/2012 2:00 4 0 1 2 16.40 20.455 66
## 16883 12/11/2012 5:00 4 0 1 3 13.94 15.150 71
## 16885 12/11/2012 7:00 4 0 1 1 13.94 15.150 66
## 16887 12/11/2012 9:00 4 0 1 1 13.94 15.150 61
## 16888 12/11/2012 10:00 4 0 1 1 14.76 16.665 57
## 16889 12/11/2012 11:00 4 0 1 2 14.76 16.665 53
## 16890 12/11/2012 12:00 4 0 1 2 14.76 15.910 53
## 17060 12/18/2012 14:00 4 0 1 1 18.86 22.725 47
## 17061 12/18/2012 15:00 4 0 1 1 18.86 22.725 44
## 17062 12/18/2012 16:00 4 0 1 1 18.04 21.970 41
## 17063 12/18/2012 17:00 4 0 1 1 16.40 20.455 47
## 17064 12/18/2012 18:00 4 0 1 1 15.58 19.695 46
## 17065 12/18/2012 19:00 4 0 1 1 15.58 19.695 46
## 17086 12/19/2012 16:00 4 0 1 1 17.22 21.210 50
## 17087 12/19/2012 17:00 4 0 1 1 16.40 20.455 50
## 17088 12/19/2012 18:00 4 0 1 1 15.58 19.695 50
## 17089 12/19/2012 19:00 4 0 1 1 15.58 19.695 50
## 17110 12/20/2012 16:00 4 0 1 2 13.94 15.150 53
## windspeed casual registered count sources
## 6410 26.0027 44 141 185 www.yahoo.com
## 6411 23.9994 45 232 277 www.bing.com
## 6432 22.0028 59 173 232 Twitter
## 6437 23.9994 53 384 437 ad campaign
## 6441 22.0028 19 105 124 www.bing.com
## 6442 22.0028 18 86 104 facebook page
## 6443 26.0027 24 106 130 ad campaign
## 6444 22.0028 11 47 58 ad campaign
## 6445 27.9993 21 46 67 Twitter
## 6446 27.9993 8 17 25 www.yahoo.com
## 6447 27.9993 2 6 8 AD campaign
## 6449 22.0028 4 15 19 ad campaign
## 6451 22.0028 9 58 67 Twitter
## 6452 23.9994 17 112 129 www.google.co.uk
## 6453 23.9994 21 100 121 ad campaign
## 6454 22.0028 30 102 132 direct
## 6456 22.0028 27 98 125 ad campaign
## 6457 23.9994 33 147 180 AD campaign
## 6476 23.9994 19 96 115 www.google.fi
## 6531 22.0028 36 273 309 www.google.com
## 6532 26.0027 55 530 585 www.google.fi
## 6549 26.0027 30 103 133 direct
## 6551 22.0028 34 180 214 Twitter
## 6555 22.0028 37 245 282 www.yahoo.com
## 6711 26.0027 1 6 7 direct
## 6712 22.0028 0 22 22 direct
## 6714 26.0027 15 244 259 ad campaign
## 6715 26.0027 27 377 404 www.google.fi
## 6716 30.0026 14 183 197 AD campaign
## 6717 26.0027 15 98 113 www.bing.com
## 6718 22.0028 18 102 120 www.bing.com
## 6719 22.0028 9 53 62 <NA>
## 6765 23.9994 17 108 125 Twitter
## 6768 23.9994 18 114 132 ad campaign
## 6769 23.9994 37 119 156 www.yahoo.com
## 6772 27.9993 55 426 481 facebook page
## 6774 22.0028 27 221 248 www.bing.com
## 6789 30.0026 115 207 322 www.bing.com
## 6790 26.0027 153 221 374 <NA>
## 6791 36.9974 195 261 456 www.yahoo.com
## 6792 31.0009 171 223 394 www.bing.com
## 6793 31.0009 242 230 472 www.google.com
## 6794 32.9975 166 211 377 www.google.com
## 6795 26.0027 179 264 443 www.google.fi
## 6818 26.0027 182 230 412 www.google.co.uk
## 6819 26.0027 177 289 466 ad campaign
## 6820 31.0009 152 253 405 www.bing.com
## 6821 30.0026 102 226 328 www.google.co.uk
## 6822 26.0027 52 181 233 ad campaign
## 6823 31.0009 49 129 178 www.bing.com
## 6824 26.0027 14 88 102 www.google.fi
## 6825 27.9993 42 88 130 www.bing.com
## 6826 27.9993 14 48 62 www.google.fi
## 6827 22.0028 12 25 37 www.yahoo.com
## 6828 26.0027 2 15 17 www.google.fi
## 6829 26.0027 4 3 7 www.bing.com
## 6882 32.9975 10 200 210 www.google.co.uk
## 6883 32.9975 17 185 202 Twitter
## 6884 32.9975 14 109 123 Ad Campaign
## 6886 22.0028 13 117 130 ad campaign
## 6896 23.9994 13 94 107 www.yahoo.com
## 6897 23.9994 14 55 69 www.google.co.uk
## 6899 23.9994 2 12 14 direct
## 6900 30.0026 1 5 6 <NA>
## 6901 31.0009 1 4 5 ad campaign
## 6902 31.0009 1 4 5 ad campaign
## 6903 23.9994 1 23 24 ad campaign
## 6904 27.9993 3 62 65 www.google.fi
## 6905 30.0026 9 233 242 facebook page
## 6906 35.0008 19 363 382 Twitter
## 6907 39.0007 17 172 189 facebook page
## 6908 30.0026 15 101 116 Twitter
## 6909 35.0008 19 110 129 AD campaign
## 6910 35.0008 22 143 165 ad campaign
## 6911 39.0007 23 134 157 ad campaign
## 6912 36.9974 18 120 138 ad campaign
## 6913 30.0026 19 127 146 facebook page
## 6914 30.0026 20 189 209 ad campaign
## 6915 26.0027 23 356 379 Ad Campaign
## 6917 23.9994 19 221 240 www.google.com
## 6918 22.0028 16 172 188 www.google.com
## 6920 22.0028 13 96 109 facebook page
## 6935 22.0028 33 158 191 direct
## 6941 26.0027 21 206 227 AD campaign
## 7030 23.9994 28 151 179 direct
## 7031 26.0027 27 139 166 Twitter
## 7053 22.0028 21 115 136 www.bing.com
## 7083 31.0009 23 341 364 www.google.com
## 7084 31.0009 22 329 351 direct
## 7085 31.0009 16 209 225 www.google.co.uk
## 7086 32.9975 14 178 192 Twitter
## 7087 35.0008 11 112 123 www.bing.com
## 7088 32.9975 5 85 90 www.bing.com
## 7089 27.9993 6 65 71 ad campaign
## 7113 22.0028 5 40 45 www.google.co.uk
## 7117 27.9993 2 9 11 facebook page
## 7118 27.9993 1 5 6 ad campaign
## 7119 23.9994 1 5 6 ad campaign
## 7120 23.9994 1 11 12 facebook page
## 7121 23.9994 2 28 30 <NA>
## 7122 23.9994 5 58 63 facebook page
## 7123 23.9994 12 62 74 www.google.fi
## 7124 22.0028 11 56 67 ad campaign
## 7125 26.0027 13 52 65 Twitter
## 7126 32.9975 11 57 68 facebook page
## 7127 35.0008 11 53 64 ad campaign
## 7128 30.0026 11 52 63 ad campaign
## 7130 22.0028 11 78 89 ad campaign
## 7131 22.0028 9 76 85 Twitter
## 7132 22.0028 7 77 84 www.yahoo.com
## 7133 23.9994 9 92 101 facebook page
## 7134 23.9994 8 74 82 www.bing.com
## 7135 23.9994 6 53 59 ad campaign
## 7141 23.9994 2 10 12 www.yahoo.com
## 7142 22.0028 1 4 5 www.yahoo.com
## 7266 23.9994 8 387 395 www.google.fi
## 7267 31.0009 15 239 254 www.bing.com
## 7268 22.0028 19 115 134 www.bing.com
## 7269 30.0026 34 128 162 AD campaign
## 7270 32.9975 44 153 197 Twitter
## 7271 27.9993 33 161 194 www.bing.com
## 7273 26.0027 45 192 237 direct
## 7274 26.0027 53 237 290 www.yahoo.com
## 7275 23.9994 42 438 480 www.bing.com
## 7276 31.0009 35 339 374 <NA>
## 7277 23.9994 14 182 196 www.bing.com
## 7280 22.0028 6 109 115 ad campaign
## 7281 22.0028 17 72 89 Ad Campaign
## 7282 23.9994 4 48 52 www.google.fi
## 7284 22.0028 7 24 31 facebook page
## 7286 22.0028 3 5 8 ad campaign
## 7287 22.0028 0 2 2 direct
## 7290 22.0028 4 80 84 blog
## 7413 26.0027 9 99 108 facebook page
## 7414 23.9994 18 149 167 www.google.co.uk
## 7415 23.9994 9 87 96 www.yahoo.com
## 7427 22.0028 3 16 19 ad campaign
## 7432 22.0028 0 46 46 facebook page
## 7434 23.9994 9 249 258 ad campaign
## 7435 30.0026 15 186 201 Ad Campaign
## 7436 36.9974 38 162 200 ad campaign
## 7437 32.9975 20 150 170 www.yahoo.com
## 7438 31.0009 41 198 239 ad campaign
## 7439 36.9974 57 179 236 facebook page
## 7440 31.0009 64 183 247 www.bing.com
## 7441 27.9993 29 187 216 ad campaign
## 7442 22.0028 49 189 238 www.google.co.uk
## 7443 22.0028 24 286 310 <NA>
## 7484 22.0028 63 178 241 ad campaign
## 7485 27.9993 108 187 295 www.google.co.uk
## 7486 27.9993 112 242 354 www.yahoo.com
## 7487 27.9993 105 234 339 www.bing.com
## 7488 32.9975 108 263 371 Twitter
## 7489 22.0028 89 221 310 Twitter
## 7490 26.0027 93 226 319 www.yahoo.com
## 7491 22.0028 44 187 231 www.google.co.uk
## 7492 22.0028 35 155 190 www.yahoo.com
## 7493 23.9994 36 121 157 AD campaign
## 7494 23.9994 24 115 139 <NA>
## 7496 26.0027 25 64 89 direct
## 7500 23.9994 7 10 17 Twitter
## 7507 22.0028 29 204 233 AD campaign
## 7511 26.0027 50 153 203 www.bing.com
## 7512 30.0026 47 138 185 facebook page
## 7513 22.0028 53 142 195 direct
## 7514 27.9993 51 264 315 ad campaign
## 7518 23.9994 30 210 240 www.google.com
## 7519 23.9994 37 176 213 ad campaign
## 7520 23.9994 17 96 113 ad campaign
## 7522 23.9994 7 15 22 AD campaign
## 7525 22.0028 0 4 4 ad campaign
## 7541 23.9994 27 259 286 direct
## 7564 26.0027 13 176 189 direct
## 7565 26.0027 3 108 111 direct
## 7566 26.0027 5 94 99 AD campaign
## 7573 22.0028 0 3 3 ad campaign
## 7574 27.9993 1 3 4 www.google.fi
## 7575 22.0028 1 21 22 ad campaign
## 7579 22.0028 14 184 198 www.bing.com
## 7580 22.0028 7 74 81 www.yahoo.com
## 7581 22.0028 4 93 97 www.bing.com
## 7583 30.0026 15 109 124 AD campaign
## 7584 26.0027 5 105 110 www.yahoo.com
## 7585 30.0026 10 106 116 ad campaign
## 7586 27.9993 8 187 195 www.bing.com
## 7587 26.0027 20 379 399 www.google.com
## 7595 22.0028 0 10 10 Twitter
## 7622 22.0028 4 4 8 www.google.co.uk
## 7624 22.0028 2 10 12 ad campaign
## 7716 23.9994 1 4 5 direct
## 7717 23.9994 0 3 3 ad campaign
## 7718 23.9994 0 4 4 ad campaign
## 7725 27.9993 19 106 125 direct
## 7726 27.9993 24 143 167 www.bing.com
## 7727 32.9975 18 126 144 www.google.fi
## 7728 31.0009 19 124 143 ad campaign
## 7729 30.0026 17 127 144 Twitter
## 7730 31.0009 14 170 184 direct
## 7731 26.0027 17 178 195 Ad Campaign
## 7732 35.0008 17 314 331 www.bing.com
## 7733 26.0027 14 213 227 facebook page
## 7734 26.0027 8 150 158 Twitter
## 7735 31.0009 6 102 108 facebook page
## 7736 30.0026 5 79 84 facebook page
## 7737 23.9994 5 55 60 www.bing.com
## 7739 27.9993 2 15 17 www.yahoo.com
## 7821 23.9994 111 189 300 AD campaign
## 7824 31.0009 200 238 438 Twitter
## 7861 22.0028 0 4 4 facebook page
## 7866 27.9993 18 117 135 facebook page
## 7867 27.9993 19 74 93 AD campaign
## 7869 27.9993 10 69 79 www.yahoo.com
## 7872 22.0028 7 57 64 ad campaign
## 7876 22.0028 9 183 192 ad campaign
## 7880 26.0027 6 51 57 www.yahoo.com
## 7881 27.9993 2 21 23 www.google.com
## 7882 22.0028 1 9 10 www.google.co.uk
## 7894 23.9994 14 128 142 ad campaign
## 7895 23.9994 16 121 137 www.bing.com
## 7896 22.0028 14 127 141 <NA>
## 7898 22.0028 13 310 323 ad campaign
## 7899 22.0028 12 298 310 www.yahoo.com
## 7902 26.0027 6 98 104 AD campaign
## 7905 22.0028 1 19 20 ad campaign
## 7912 23.9994 11 265 276 direct
## 7913 22.0028 15 462 477 ad campaign
## 7914 22.0028 9 215 224 Twitter
## 8055 27.9993 0 18 18 Ad Campaign
## 8066 22.0028 4 48 52 www.google.com
## 8068 43.0006 2 31 33 ad campaign
## 8069 43.0006 1 25 26 Twitter
## 8070 35.0008 0 6 6 Ad Campaign
## 8071 30.0026 0 13 13 ad campaign
## 8072 26.0027 0 16 16 Twitter
## 8074 23.9994 1 6 7 www.google.co.uk
## 8077 31.0009 0 2 2 www.google.co.uk
## 8082 26.0027 7 218 225 www.google.fi
## 8083 22.0028 1 109 110 www.bing.com
## 8085 22.0028 8 148 156 Twitter
## 8086 23.9994 9 115 124 Twitter
## 8132 27.9993 44 192 236 ad campaign
## 8133 27.9993 48 235 283 www.bing.com
## 8134 27.9993 47 239 286 www.google.fi
## 8135 22.0028 51 242 293 ad campaign
## 8136 23.9994 60 239 299 facebook page
## 8137 26.0027 58 183 241 facebook page
## 8138 22.0028 34 151 185 www.yahoo.com
## 8205 23.9994 20 147 167 www.yahoo.com
## 8206 22.0028 7 120 127 direct
## 8252 27.9993 9 126 135 AD campaign
## 8253 32.9975 17 140 157 www.google.fi
## 8254 23.9994 14 150 164 www.bing.com
## 8255 22.0028 8 124 132 direct
## 8261 22.0028 12 209 221 AD campaign
## 8263 22.0028 8 116 124 ad campaign
## 8264 22.0028 10 104 114 www.google.co.uk
## 8265 22.0028 12 60 72 www.yahoo.com
## 8270 26.0027 0 26 26 ad campaign
## 8273 27.9993 10 449 459 www.yahoo.com
## 8274 26.0027 8 235 243 AD campaign
## 8277 23.9994 10 163 173 ad campaign
## 8278 23.9994 12 125 137 ad campaign
## 8300 22.0028 21 188 209 facebook page
## 8303 23.9994 30 207 237 www.google.fi
## 8307 26.0027 7 150 157 <NA>
## 8308 22.0028 11 95 106 Twitter
## 8349 22.0028 13 128 141 www.yahoo.com
## 8350 22.0028 15 127 142 facebook page
## 15021 23.9994 14 76 90 Twitter
## 15028 23.9994 25 95 120 www.bing.com
## 15029 22.0028 64 195 259 www.google.co.uk
## 15036 22.0028 233 354 587 www.bing.com
## 15082 22.0028 67 200 267 facebook page
## 15083 22.0028 66 236 302 www.yahoo.com
## 15091 22.0028 19 109 128 www.yahoo.com
## 15093 22.0028 3 17 20 facebook page
## 15132 22.0028 63 369 432 www.google.fi
## 15181 23.9994 231 328 559 ad campaign
## 15206 30.0026 125 279 404 www.google.com
## 15297 22.0028 63 231 294 Twitter
## 15345 35.0008 310 400 710 Twitter
## 15346 27.9993 269 307 576 ad campaign
## 15347 27.9993 279 341 620 ad campaign
## 15348 35.0008 317 342 659 www.google.co.uk
## 15349 26.0027 268 342 610 direct
## 15350 27.9993 183 312 495 ad campaign
## 15447 39.0007 32 534 566 blog
## 15448 32.9975 21 371 392 facebook page
## 15449 23.9994 18 251 269 direct
## 15460 26.0027 25 773 798 blog
## 15461 26.0027 27 328 355 www.yahoo.com
## 15462 23.9994 39 165 204 www.google.co.uk
## 15487 23.9994 61 252 313 facebook page
## 15488 31.0009 75 312 387 blog
## 15489 26.0027 81 300 381 www.google.co.uk
## 15490 31.0009 109 262 371 ad campaign
## 15491 30.0026 138 317 455 facebook page
## 15492 23.9994 108 412 520 www.google.com
## 15493 26.0027 131 706 837 Ad Campaign
## 15536 22.0028 200 362 562 ad campaign
## 15537 30.0026 218 401 619 ad campaign
## 15538 27.9993 249 368 617 AD campaign
## 15539 27.9993 213 355 568 ad campaign
## 15545 30.0026 40 156 196 www.google.fi
## 15546 26.0027 38 87 125 blog
## 15549 26.0027 5 24 29 direct
## 15550 23.9994 1 5 6 www.bing.com
## 15555 22.0028 15 461 476 <NA>
## 15556 26.0027 24 713 737 www.bing.com
## 15557 26.0027 31 328 359 ad campaign
## 15558 26.0027 43 125 168 www.bing.com
## 15559 26.0027 88 175 263 facebook page
## 15560 22.0028 73 211 284 www.google.co.uk
## 15563 22.0028 70 190 260 direct
## 15568 26.0027 19 237 256 ad campaign
## 15569 22.0028 16 190 206 www.yahoo.com
## 15572 26.0027 3 45 48 www.google.co.uk
## 15583 27.9993 56 172 228 www.google.co.uk
## 15584 22.0028 69 256 325 www.google.fi
## 15587 22.0028 76 270 346 ad campaign
## 15633 23.9994 96 236 332 Ad Campaign
## 15637 22.0028 102 788 890 www.yahoo.com
## 15638 22.0028 68 720 788 www.yahoo.com
## 15660 23.9994 131 434 565 AD campaign
## 15661 23.9994 48 377 425 www.google.co.uk
## 15703 22.0028 178 310 488 www.google.co.uk
## 15704 22.0028 203 345 548 www.bing.com
## 15707 22.0028 217 347 564 www.bing.com
## 15859 26.0027 24 113 137 Ad Campaign
## 15863 22.0028 5 22 27 Ad Campaign
## 15864 23.9994 3 8 11 ad campaign
## 15866 22.0028 4 22 26 facebook page
## 15868 36.9974 24 93 117 www.yahoo.com
## 15869 27.9993 60 185 245 AD campaign
## 15870 27.9993 101 220 321 facebook page
## 15871 26.0027 138 275 413 Ad Campaign
## 15872 32.9975 122 292 414 Twitter
## 15873 27.9993 131 283 414 www.yahoo.com
## 15874 30.0026 146 281 427 www.google.com
## 15875 32.9975 136 281 417 Ad Campaign
## 15876 31.0009 75 206 281 ad campaign
## 15877 35.0008 39 175 214 AD campaign
## 15878 32.9975 13 123 136 ad campaign
## 15879 23.9994 11 125 136 direct
## 15880 31.0009 9 119 128 www.google.co.uk
## 15881 27.9993 10 90 100 www.google.co.uk
## 15882 23.9994 8 78 86 direct
## 15883 23.9994 7 57 64 Twitter
## 15884 23.9994 4 25 29 www.google.co.uk
## 15885 23.9994 7 121 128 ad campaign
## 15886 23.9994 6 108 114 ad campaign
## 15955 27.9993 42 179 221 ad campaign
## 15956 23.9994 52 240 292 www.yahoo.com
## 15957 23.9994 64 230 294 Ad Campaign
## 15958 32.9975 63 199 262 ad campaign
## 15959 27.9993 51 255 306 direct
## 15960 22.0028 48 373 421 direct
## 15961 22.0028 57 581 638 ad campaign
## 15962 22.0028 32 490 522 Twitter
## 15964 27.9993 14 207 221 www.google.com
## 15965 23.9994 23 133 156 ad campaign
## 15969 22.0028 6 83 89 ad campaign
## 15978 26.0027 68 260 328 Twitter
## 15979 26.0027 56 284 340 Ad Campaign
## 15980 31.0009 74 320 394 AD campaign
## 15981 23.9994 110 339 449 ad campaign
## 15982 22.0028 136 319 455 www.google.com
## 15983 30.0026 117 331 448 Twitter
## 15984 22.0028 108 292 400 <NA>
## 16008 22.0028 119 316 435 www.bing.com
## 16012 23.9994 7 134 141 ad campaign
## 16021 22.0028 1 38 39 ad campaign
## 16028 22.0028 38 206 244 facebook page
## 16067 22.0028 2 9 11 www.yahoo.com
## 16069 22.0028 0 27 27 direct
## 16075 23.9994 15 132 147 <NA>
## 16078 23.9994 19 142 161 ad campaign
## 16080 23.9994 23 250 273 www.bing.com
## 16081 26.0027 16 501 517 ad campaign
## 16082 23.9994 17 448 465 blog
## 16084 22.0028 7 249 256 Twitter
## 16089 23.9994 1 11 12 ad campaign
## 16094 26.0027 12 411 423 Twitter
## 16096 23.9994 22 253 275 www.yahoo.com
## 16097 22.0028 13 148 161 www.google.co.uk
## 16098 26.0027 16 155 171 www.yahoo.com
## 16099 32.9975 33 202 235 ad campaign
## 16100 27.9993 33 195 228 Twitter
## 16101 27.9993 33 149 182 AD campaign
## 16102 27.9993 32 201 233 ad campaign
## 16103 26.0027 18 321 339 Ad Campaign
## 16105 27.9993 16 491 507 Twitter
## 16106 23.9994 14 359 373 direct
## 16107 31.0009 10 235 245 ad campaign
## 16108 26.0027 11 222 233 ad campaign
## 16110 23.9994 5 82 87 ad campaign
## 16111 22.0028 9 46 55 ad campaign
## 16114 27.9993 3 6 9 www.google.fi
## 16115 23.9994 0 14 14 ad campaign
## 16120 27.9993 23 304 327 www.yahoo.com
## 16121 22.0028 34 163 197 direct
## 16123 22.0028 48 214 262 ad campaign
## 16208 43.0006 0 5 5 Twitter
## 16209 30.0026 7 4 11 direct
## 16210 23.9994 2 3 5 Ad Campaign
## 16211 26.0027 0 9 9 Ad Campaign
## 16213 31.0009 2 48 50 facebook page
## 16216 22.0028 1 109 110 AD campaign
## 16217 26.0027 10 84 94 Ad Campaign
## 16221 26.0027 34 169 203 facebook page
## 16224 23.9994 33 575 608 direct
## 16226 23.9994 12 344 356 facebook page
## 16227 23.9994 12 211 223 facebook page
## 16228 23.9994 9 178 187 www.yahoo.com
## 16229 22.0028 15 120 135 www.google.co.uk
## 16240 26.0027 22 310 332 ad campaign
## 16241 23.9994 18 153 171 ad campaign
## 16340 22.0028 113 334 447 ad campaign
## 16343 22.0028 59 313 372 Twitter
## 16469 35.0008 18 137 155 ad campaign
## 16470 30.0026 14 97 111 www.google.fi
## 16471 27.9993 9 72 81 www.google.co.uk
## 16472 32.9975 5 56 61 www.google.fi
## 16473 40.9973 5 29 34 facebook page
## 16474 23.9994 2 15 17 www.google.co.uk
## 16475 30.0026 1 6 7 ad campaign
## 16476 22.0028 1 8 9 Twitter
## 16478 22.0028 3 58 61 direct
## 16479 31.0009 12 110 122 Twitter
## 16480 30.0026 23 176 199 ad campaign
## 16483 40.9973 39 227 266 direct
## 16484 22.0028 71 286 357 www.bing.com
## 16485 31.0009 58 259 317 direct
## 16486 31.0009 48 219 267 ad campaign
## 16487 30.0026 37 212 249 Ad Campaign
## 16488 26.0027 25 182 207 ad campaign
## 16489 26.0027 20 175 195 Ad Campaign
## 16497 23.9994 3 25 28 www.yahoo.com
## 16555 26.0027 8 108 116 ad campaign
## 16557 23.9994 7 98 105 facebook page
## 16560 26.0027 15 451 466 ad campaign
## 16561 23.9994 12 411 423 direct
## 16563 22.0028 9 217 226 www.bing.com
## 16579 26.0027 22 199 221 www.google.co.uk
## 16582 22.0028 26 210 236 www.google.co.uk
## 16735 22.0028 0 11 11 www.google.fi
## 16738 30.0026 1 9 10 www.google.fi
## 16740 26.0027 5 119 124 www.yahoo.com
## 16744 23.9994 14 127 141 www.bing.com
## 16748 32.9975 39 179 218 facebook page
## 16752 30.0026 29 580 609 direct
## 16753 23.9994 14 400 414 Twitter
## 16754 26.0027 19 274 293 www.google.fi
## 16755 27.9993 14 184 198 www.bing.com
## 16756 26.0027 4 101 105 Twitter
## 16757 26.0027 5 69 74 ad campaign
## 16878 31.0009 2 29 31 www.google.co.uk
## 16879 30.0026 1 7 8 ad campaign
## 16880 22.0028 0 1 1 direct
## 16883 22.0028 1 40 41 www.yahoo.com
## 16885 27.9993 8 372 380 www.bing.com
## 16887 26.0027 12 322 334 Twitter
## 16888 22.0028 12 142 154 www.yahoo.com
## 16889 23.9994 28 145 173 www.google.co.uk
## 16890 30.0026 13 213 226 Twitter
## 17060 30.0026 56 191 247 ad campaign
## 17061 32.9975 28 218 246 facebook page
## 17062 31.0009 40 323 363 www.bing.com
## 17063 30.0026 39 533 572 ad campaign
## 17064 22.0028 13 512 525 www.yahoo.com
## 17065 26.0027 19 334 353 direct
## 17086 23.9994 37 297 334 facebook page
## 17087 26.0027 26 536 562 www.google.co.uk
## 17088 23.9994 23 546 569 www.yahoo.com
## 17089 26.0027 7 329 336 www.yahoo.com
## 17110 22.0028 21 283 304 AD campaign
Question 10
question_10 <- bike1[(bike1$season %in% c(1,4)) & (bike1$windspeed >= 40), ]
question_10
## datetime season holiday workingday weather temp atemp humidity
## 1008 2/14/2011 15:00 1 0 1 1 22.96 26.515 21
## 1010 2/14/2011 17:00 1 0 1 1 18.86 22.725 33
## 1011 2/14/2011 18:00 1 0 1 1 16.40 20.455 40
## 1015 2/14/2011 22:00 1 0 1 1 13.94 14.395 46
## 1018 2/15/2011 1:00 1 0 1 1 12.30 12.120 42
## 1019 2/15/2011 2:00 1 0 1 1 11.48 11.365 41
## 1120 2/19/2011 9:00 1 0 0 1 16.40 20.455 16
## 1124 2/19/2011 13:00 1 0 0 1 18.04 21.970 16
## 1125 2/19/2011 14:00 1 0 0 1 18.86 22.725 15
## 1126 2/19/2011 15:00 1 0 0 1 18.04 21.970 16
## 1127 2/19/2011 16:00 1 0 0 1 18.04 21.970 16
## 1128 2/19/2011 17:00 1 0 0 1 17.22 21.210 19
## 1259 2/25/2011 14:00 1 0 1 3 22.96 26.515 56
## 1260 2/25/2011 15:00 1 0 1 1 18.86 22.725 41
## 1262 2/25/2011 17:00 1 0 1 1 13.12 13.635 49
## 1265 2/25/2011 20:00 1 0 1 1 12.30 12.880 49
## 1333 2/28/2011 19:00 1 0 1 3 18.04 21.970 88
## 1334 2/28/2011 20:00 1 0 1 3 18.04 21.970 88
## 1478 3/6/2011 21:00 1 0 0 3 9.84 9.090 93
## 8068 12/7/2011 19:00 4 0 1 3 13.94 14.395 87
## 8069 12/7/2011 20:00 4 0 1 3 13.94 14.395 87
## 8706 1/3/2012 13:00 1 0 1 1 7.38 6.060 34
## 8943 1/13/2012 11:00 1 0 1 1 9.84 9.090 38
## 9644 2/11/2012 18:00 1 0 0 2 9.02 9.090 47
## 9647 2/11/2012 21:00 1 0 0 1 5.74 3.790 43
## 9653 2/12/2012 3:00 1 0 0 2 4.10 2.275 46
## 9654 2/12/2012 4:00 1 0 0 2 4.10 2.275 46
## 9662 2/12/2012 12:00 1 0 0 1 5.74 3.790 39
## 9957 2/24/2012 21:00 1 0 1 1 17.22 21.210 35
## 9959 2/24/2012 23:00 1 0 1 1 15.58 19.695 37
## 9971 2/25/2012 11:00 1 0 0 1 12.30 12.880 39
## 9972 2/25/2012 12:00 1 0 0 1 13.12 13.635 29
## 10169 3/4/2012 18:00 1 0 0 1 13.12 13.635 33
## 10193 3/5/2012 18:00 1 0 1 3 11.48 11.365 55
## 10260 3/8/2012 13:00 1 0 1 2 24.60 31.060 49
## 10261 3/8/2012 14:00 1 0 1 2 25.42 31.060 43
## 10262 3/8/2012 15:00 1 0 1 1 26.24 31.060 38
## 10263 3/8/2012 16:00 1 0 1 2 25.42 31.060 41
## 10264 3/8/2012 17:00 1 0 1 1 25.42 31.060 38
## 10290 3/9/2012 19:00 1 0 1 1 17.22 21.210 28
## 16208 11/13/2012 1:00 4 0 1 3 18.04 21.970 88
## 16473 11/24/2012 2:00 4 0 0 1 13.12 13.635 39
## 16483 11/24/2012 12:00 4 0 0 2 12.30 12.880 36
## 17150 12/22/2012 8:00 1 0 0 1 10.66 10.605 44
## 17154 12/22/2012 12:00 1 0 0 1 12.30 12.880 36
## 17345 12/30/2012 13:00 1 0 0 1 12.30 12.880 36
## windspeed casual registered count sources
## 1008 43.9989 19 71 90 www.google.co.uk
## 1010 40.9973 25 218 243 ad campaign
## 1011 40.9973 11 194 205 ad campaign
## 1015 43.9989 1 44 45 www.google.co.uk
## 1018 51.9987 0 5 5 www.google.fi
## 1019 46.0022 1 2 3 www.google.fi
## 1120 43.9989 18 37 55 Ad Campaign
## 1124 40.9973 52 103 155 Twitter
## 1125 43.9989 102 94 196 Twitter
## 1126 50.0021 84 87 171 ad campaign
## 1127 43.0006 39 81 120 blog
## 1128 40.9973 36 91 127 Ad Campaign
## 1259 40.9973 22 55 77 www.bing.com
## 1260 54.0020 31 98 129 www.google.co.uk
## 1262 50.0021 13 180 193 www.google.com
## 1265 40.9973 3 66 69 direct
## 1333 40.9973 8 76 84 Twitter
## 1334 40.9973 8 47 55 facebook page
## 1478 40.9973 1 6 7 ad campaign
## 8068 43.0006 2 31 33 ad campaign
## 8069 43.0006 1 25 26 Twitter
## 8706 43.9989 5 68 73 www.google.co.uk
## 8943 40.9973 12 102 114 www.yahoo.com
## 9644 43.9989 3 105 108 <NA>
## 9647 43.0006 5 43 48 Twitter
## 9653 46.0022 0 14 14 www.yahoo.com
## 9654 47.9988 0 1 1 www.bing.com
## 9662 43.0006 7 133 140 ad campaign
## 9957 54.0020 12 138 150 ad campaign
## 9959 46.0022 9 71 80 Twitter
## 9971 40.9973 29 155 184 www.google.com
## 9972 43.9989 49 218 267 www.google.com
## 10169 40.9973 20 164 184 <NA>
## 10193 43.9989 12 363 375 www.yahoo.com
## 10260 43.0006 35 198 233 www.bing.com
## 10261 43.0006 48 155 203 ad campaign
## 10262 46.0022 24 161 185 ad campaign
## 10263 43.0006 37 305 342 AD campaign
## 10264 43.9989 52 545 597 blog
## 10290 40.9973 12 232 244 www.google.fi
## 16208 43.0006 0 5 5 Twitter
## 16473 40.9973 5 29 34 facebook page
## 16483 40.9973 39 227 266 direct
## 17150 40.9973 8 75 83 ad campaign
## 17154 43.9989 30 169 199 www.yahoo.com
## 17345 43.9989 28 152 180 ad campaign