Question

1 Approved Answer

Posted on Oct 21, 2024

1. Using the training dataset in Excel, show a comparison of at least 5 different models that you ran. Run 2-3 models so you have

1. Using the training dataset in Excel, show a comparison of at least 5 different models that you ran. Run 2-3 models so you have plenty to use in your comparison later. Be sure to investigate the possible usage of categorical and non-linear variables. (see video above). For some variables, you will need to recode them since they are currently stored in text format. For example, the season variable could be replaced with three separate columns (i.e. 0 or 1 for Winter, 0 or 1 for Spring, 0 or 1 for Summer, and then you don't need one for Fall because zeros in the other 3 columns would mean fall).

When you start your regression analysis, consider using either a forward selection (adding as you go), backward elimination (starting with all and taking away one at a time - but keep in mind Excel can only handle 16 independent variables so this might not be the best bet), or some other regression procedure to check all variables. Make scatter plots between independent and dependent variables to assess the type of relationship. Check residual plots for linearity and normally distributed residuals. Remember, not all variables will be needed in the model and sometimes more isn't always better.

2. Identify your best model. This should be the model with the highest adjusted R^2. Show residual plots for the independent variables in your model and any relevant scatter plots. image text in transcribed

Promotion Row# 1 Holiday Working Day 0 1 2 3 4 2 0 3 5 1 1 1 4 5 7 6 7 8 1 8 0 9 0 1 10 12 1 13 1 14 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Fri 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 15 16 17 18 21 22 23 24 25 26 27 28 30 31 32 33 34 35 36 37 38 39 41 42 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 0 0 1 1 0 0 1 1 1 1 1 0 1 1 1 1 1 0 0 1 1 1 1 0 Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter 1005 Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sat Cloudy 14.110847 80.5833 10.749882 985 Sun Cloudy 14.902598 69.6087 16.652113 801 Mon Clear 8.050924 43.7273 16.636703 1349 Tues Clear 8.2 59.0435 10.739832 1562 Wed Clear 9.305237 43.6957 12.5223 1600 Fri Cloudy 8.057402 49.8696 11.304642 1510 Sat Cloudy 6.765 53.5833 17.875868 959 Sun Clear 5.671653 43.4167 24.25065 822 Mon Clear 6.184153 48.2917 14.958889 1321 Wed Clear 7.081807 59.9545 20.410009 1162 Thurs Clear 6.765 47.0417 20.167 1406 Fri Clear 6.59567 53.7826 8.478716 1421 Sat Cloudy 9.566653 49.875 10.583521 1248 Sun Clear 9.498347 48.375 12.625011 1204 Mon Cloudy 7.209153 53.75 12.999139 1000 Tues Cloudy 8.883347 86.1667 9.833925 683 Clear 7.2775 45.7083 23.667214 1543 Sat Clear 2.4243464 40 11.52199 981 Sun Clear 3.9573897 43.6522 16.5222 986 Mon Clear 3.9930433 49.1739 10.60811 1416 Tues Cloudy 9.162598 61.6957 8.696332 1985 Wed Light 8.9175 86.25 19.68795 506 Thurs Clear 7.995 68.75 7.627079 431 Fri Cloudy 8.342598 79.3043 8.2611 1167 Sun Clear 8.877402 72.2174 4.9568342 1096 Mon Cloudy 7.414153 60.375 12.541864 1501 Tues Cloudy 7.879134 82.9565 3.565271 1360 Wed Cloudy 10.66 77.5417 17.708636 1526 Thurs Clear 7.665237 43.7826 18.609384 1550 Fri Cloudy 8.663464 58.5217 8.565213 1708 Sat Cloudy 9.566653 92.9167 10.792293 Sun Clear 11.719153 56.8333 9.5006 1623 Mon Clear 11.138347 73.8333 3.0423561 1712 Tues Clear 9.054153 53.7917 24.25065 1530 Thurs Clear 5.918268 43.7391 14.869645 1538 Fri Clear 7.752731 50.6364 7.27285 1746 Sat Clear 9.1225 54.4167 13.625589 1472 Mon Clear 17.015 37.5833 27.999836 1913 Tues Clear 10.909567 31.4348 19.522058 1815 Wed Clear 13.048701 42.3478 16.869997 2115 Thurs Clear 17.869153 50.5 15.416968 2475 Fri Clear 21.388347 51.6667 17.749975 2927 Clear 16.365847 18.7917 34.000021 1635 Sun Clear 11.693897 40.7826 14.956745 1812 Mon Cloudy 12.436653 60.5 20.625682 1107 Tues Clear 7.471102 57.7778 13.110761 1450 Wed Clear 9.091299 42.3043 6.305571 1917 Thurs Cloudy 12.121732 69.7391 16.783232 1807 Fri Cloudy 14.938268 71.2174 23.218113 1461 Sat Clear 11.5825 53.7917 12.500257 1969 Sun Clear 14.082598 68 8.391616 2402 Mon Cloudy 16.698193 87.6364 19.408962 1446 Tues Clear 10.933347 53.5 14.500475 1851 Wed Clear 13.735 44.9583 20.624811 2134 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 Sat 1 1 0 0 0 1 1 1 1 0 0 1 1 1 Promotion Holiday Working Day 1 1 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 Row# 62 63 64 65 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 89 90 91 92 93 94 95 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 115 116 117 119 121 124 0 0 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 1 0 0 0 1 1 1 OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Day of Week Thurs Fri Sat Sun Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Wed Thurs Fri Sat Sun Mon Tues Wed Fri Sat Sun Mon Tues Wed Thurs Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Wed Thurs Fri Sun Tues Fri Weather Situation Temperature Humidity Windspeed Total Riders Clear 8.131653 31.8333 15.125518 1685 Cloudy 10.728347 61.0417 13.624182 1944 Cloudy 15.750847 78.9167 16.875357 2077 Cloudy 15.437402 94.8261 23.000229 605 Clear 11.9925 42.0833 8.08355 2133 Cloudy 12.129153 77.5417 14.75005 1891 Light 15.952731 0 17.545759 623 Cloudy 12.977402 64.9565 15.60899 1977 Clear 13.495847 59.4583 14.791925 2132 Clear 15.758268 52.7391 18.130468 2417 Clear 13.333897 49.6957 9.174042 2046 Cloudy 13.013031 65.5652 12.348703 2056 Cloudy 14.973897 77.6522 13.608839 2192 Clear 17.015 60.2917 14.041793 2744 Clear 22.14 52.5217 15.478139 3239 Clear 19.3725 37.9167 24.667189 3117 Clear 13.6325 47.375 13.917307 2471 Cloudy 17.561653 85.8333 14.8338 2660 Cloudy 17.356653 75.75 3.167425 3068 Clear 15.306653 68.625 18.374482 2209 Clear 12.4025 54.25 12.750368 1011 Clear 11.266103 68.1304 10.391097 754 Clear 13.191299 50.6957 16.044155 1317 Cloudy 13.325 76.25 12.62615 1162 Clear 12.26433 50.3913 19.695387 2302 Clear 12.778347 63.6667 9.000579 2999 Clear 16.81 61.5833 14.750318 2485 Clear 15.17 69.25 12.875189 2294 Clear 11.194763 38.1304 22.087555 1951 Clear 6.15 44.125 24.499957 2236 Cloudy 4.4075 41.4583 12.3749 2368 Clear 10.899153 52.4167 8.709129 3272 Clear 16.126653 53.1667 11.708786 4521 Clear 13.8375 46.5 12.833314 3425 Cloudy 9.190847 70.1667 6.6263 2376 Clear 12.656536 64.6522 12.565984 3598 Cloudy 11.240847 84.75 8.791807 2177 Cloudy 15.6825 80.2917 12.124789 4097 Clear 11.240847 50.75 25.333236 3214 Clear 7.38 45.75 12.541261 2493 Clear 6.833347 41.9167 16.834286 2311 Clear 7.79 52.25 15.500986 2298 Cloudy 15.294763 71.6087 23.39171 2935 Clear 12.436653 44.3333 27.833743 3376 Clear 7.79 49.75 14.750586 3292 Cloudy 8.9175 45 13.58425 3163 Cloudy 7.106653 83.125 14.917014 1301 Cloudy 6.6625 79.625 13.375746 1977 Cloudy 8.951653 91.125 7.417436 2432 Clear 12.060847 64.375 10.791757 4270 Cloudy 14.008347 76.9583 4.9175186 4075 Cloudy 17.425 74.125 22.958689 3456 Clear 11.5825 31.125 16.08335 3243 Clear 15.99 41.6667 17.541739 4509 Clear 12.846653 52.6667 11.959232 4151 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 Working Day 0 Promotion 1 1 1 0 1 1 1 Holiday 0 0 0 0 0 0 0 0 0 1 1 1 0 1 1 1 1 1 1 1 0 1 0 0 1 0 1 0 0 41 0 0 0 0 0 0 0 0 0 0 0 1 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 Row# 125 126 128 129 131 132 134 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 170 171 172 173 174 175 176 177 178 179 180 182 183 184 186 187 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Spring Spring Spring Spring Spring 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sat Cloudy 10.830847 77.9583 8.167032 2832 Sun Cloudy 10.899153 68.7917 11.791732 2947 Tues Clear 14.520847 49.625 9.874393 4375 Wed Cloudy 10.523347 72.2917 8.959307 2802 Fri Cloudy 11.514153 54 7.834243 3831 Sat Light 9.190847 73.125 19.416332 2169 Mon Clear 9.1225 41.125 11.207961 3422 Thurs Cloudy 12.983347 75.2917 6.125475 3005 Fri Clear 14.076653 63.4583 13.791682 4154 Sat Clear 14.213347 53.4583 12.792243 4318 Sun Cloudy 11.48 51.5833 16.958504 2689 Mon Clear 11.48 50.7826 15.348561 3129 Tues Clear 11.800866 59.4348 13.783039 3777 Wed Clear 16.229153 56.7917 15.709557 4773 Thurs Clear 18.620847 55.4583 12.791171 5062 Fri Cloudy 16.7075 73.75 15.916989 3487 Sat Clear 11.924153 39.5833 28.250014 2732 Sun Clear 11.445847 13.750343 3389 Mon Clear 15.033347 49.0833 17.958211 4322 Tues Clear 14.725847 39.5833 12.958939 4363 Wed Cloudy 14.118268 80.4783 12.000839 1834 Thurs Clear 19.919153 61.5417 15.208129 4990 Fri Cloudy 14.486653 65.7083 9.708568 3194 Sat Cloudy 16.980847 62.125 10.792293 4066 Sun Clear 13.359153 40.3333 22.416257 3423 Mon Clear 9.976653 50.625 15.333486 3333 Tues Clear 10.591653 45.6667 13.458625 3956 Wed Clear 16.570847 51.3333 23.167193 4916 Thurs Clear 21.6275 56.75 29.584721 5382 Fri Cloudy 16.844153 40.7083 27.7916 4569 Sat Clear 11.7875 35.0417 15.12525 4118 Sun Clear 14.831299 47.6957 14.913329 4911 Mon Clear 19.133347 48.9167 13.916771 5298 Tues Clear 23.165 61.75 15.87565 5847 Wed Clear 23.4725 50.7083 7.709154 6312 Thurs Clear 22.8575 57.9583 10.042161 6192 Fri Cloudy 17.869153 84.2083 7.583864 4378 Sat Cloudy 21.080847 75.5833 7.417168 7836 Sun Cloudy 19.3725 81 8.501161 5892 Tues Clear 22.994153 80.7917 8.125157 6093 Fri Cloudy 13.393347 55.6667 25.083661 3623 Sat Clear 10.899153 44.125 27.292182 1749 Sun Clear 10.079153 51.5417 8.916561 1787 Mon Cloudy 9.483464 79.1304 5.1744368 920 Tues Cloudy 11.943464 73.4783 11.304642 1013 Wed Light 9.976653 82.3333 21.208582 441 Thurs Cloudy 10.420847 65.2917 23.458911 2114 Fri Cloudy 10.386653 59 10.416557 3095 Sat Cloudy 10.386653 75.2917 8.333661 1341 Sun Clear 10.489153 48.3333 23.500518 1796 Mon Cloudy 17.647835 73.7391 19.348461 2077 Tues Clear 18.108347 62.4583 15.12525 2703 Wed Cloudy 14.225237 83.9565 15.695487 2121 Fri Clear 10.830847 49.5 15.458575 2210 Sat Clear 10.899153 39.4167 14.041257 2496 1 1 0 0 1 1 1 1 1 0 0 1 1 0 0 1 0 1 1 1 0 0 1 1 1 1 0 0 Holiday 0 0 Working Day 0 1 1 1 0 Mon 0 0 0 Sat 0 0 0 0 0 1 1 1 1 0 0 0 Sat 0 0 Promotion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 1 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 0 0 0 1 1 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 Row# 188 189 190 191 194 195 196 197 198 199 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 234 235 236 237 238 239 240 241 242 243 244 245 246 Season Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sun Cloudy 10.374763 49.3913 12.3481 1693 Clear 10.838268 30.2174 14.217668 2028 Tues Clear 12.4025 31.4167 15.208732 2425 Wed Cloudy 12.3 64.6667 11.583496 1536 Cloudy 12.915 65.375 13.208782 2252 Sun Clear 15.511653 48 12.208271 3249 Mon Clear 23.506653 42.625 25.833257 3115 Tues Cloudy 16.980847 64.2083 26.000489 1795 Wed Clear 16.024153 47.0833 17.625221 2808 Thurs Clear 17.9375 60.2917 10.874904 3141 Cloudy 14.0425 87.75 8.916561 2455 Sun Cloudy 17.493347 85.75 9.833389 2895 Mon Cloudy 24.421732 71.6956 21.739758 3348 Tues Cloudy 20.6025 73.9167 18.416893 2034 Wed Cloudy 16.9125 81.9167 16.791339 2162 Thurs Clear 19.1675 54.0417 7.4169 3267 Fri Clear 18.313347 67.125 15.167125 3126 Sat Light 17.664153 88.8333 22.834136 795 Sun Clear 18.723347 47.9583 20.334232 3744 Mon Clear 21.0125 54.25 10.958989 3429 Tues Cloudy 20.739153 66.5833 10.584057 3204 Wed Clear 24.395 61.4167 16.208975 3944 Thurs Clear 18.825847 40.7083 21.792286 4189 Fri Cloudy 13.803347 72.9583 14.707907 1683 Sat Cloudy 18.86 88.7917 15.458575 4036 Sun Cloudy 23.848347 81.0833 12.875725 4191 Mon Clear 24.873347 77.6667 12.417311 4073 Tues Clear 25.898347 72.9167 21.8755 4400 Wed Cloudy 25.42 83.5417 20.9174 3872 Thurs Cloudy 25.3175 70.0833 21.500836 4058 Fri Clear 20.91 45.7083 16.084221 4595 Sat Clear 19.3725 50.3333 15.750025 5312 Sun Cloudy 18.518347 76.2083 7.125718 3351 Mon Cloudy 22.515847 73 12.291418 4401 Tues Cloudy 25.283347 69.7083 22.958689 4451 Wed Cloudy 16.980847 73.7083 22.042732 2633 Thurs Clear 18.825847 44.4167 19.791264 4433 Fri Clear 19.645847 59 15.292482 4608 Sat Clear 21.32 54.125 10.75015 4714 Sun Clear 21.661653 63.1667 5.0007125 4333 Mon Clear 21.8325 58.875 11.792 4362 Tues Clear 21.8325 48.9167 7.749957 4803 Thurs Clear 21.935 74.75 12.707689 4864 Fri Cloudy 21.0125 86.3333 12.041575 4105 Sat Cloudy 21.354153 92.25 9.04165 3409 Sun Cloudy 23.0625 86.7083 10.249593 4553 Mon Clear 23.6775 78.7917 8.500357 3958 Tues Cloudy 23.028347 83.7917 18.582718 4123 Wed Cloudy 22.55 87 13.499964 3855 Thurs Cloudy 21.764153 82.9583 7.250271 4575 Fri Clear 22.003347 71.9583 8.375871 4917 Sat Clear 24.7025 62.6667 8.08355 5805 Sun Clear 24.770847 74.9583 9.916536 4660 Mon Cloudy 25.898347 81 15.667414 4274 Tues Cloudy 27.06 74.0833 13.875164 4492 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 1 1 0 1 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 1 0 1 0 0 0 OO 0 0 0 1 1 1 Promotion Holiday 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 Working Day 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 0 0 1 1 1 1 0 0 1 1 1 0 0 1 1 1 1 0 0 1 1 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 1 Row# 247 248 249 250 251 252 253 254 256 257 258 259 260 262 263 264 265 266 267 269 270 271 272 273 274 275 277 278 279 280 281 282 284 285 286 287 288 290 291 292 293 294 295 297 298 299 300 301 303 304 306 307 308 309 310 Season Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Wed Clear 27.094153 69.625 10.333611 4978 Thurs Clear 29.041653 67.75 13.376014 4677 Fri Clear 27.948347 65.375 16.125493 4679 Sat Clear 26.889153 72.9583 15.416164 4758 Sun Clear 27.3675 81.875 14.333846 4788 Mon Clear 30.066653 68.5 8.792075 4098 Tues Clear 31.775 63.6667 7.459043 3982 Wed Cloudy 31.330847 67.7083 13.875164 3974 Fri Clear 25.42 35.4167 16.959107 5312 Sat Clear 26.035 45.625 8.250514 5342 Sun Cloudy 26.581653 65.25 9.292364 4906 Mon Clear 27.811653 60 8.167032 4548 Tues Clear 29.0075 59.7917 12.583136 4833 Thurs Cloudy 33.141653 56.8333 10.042161 3915 Fri Clear 30.955 60.5 9.417118 4586 Sat Clear 29.725 65.4583 10.37495 4966 Sun Clear 28.3925 74.7917 10.958989 4460 Mon Clear 26.035 49.4583 20.45845 5020 Tues Clear 24.770847 50.7083 18.041961 4891 Thurs Cloudy 25.761653 68.8333 13.833557 3767 Fri Clear 26.615847 73.5833 9.582943 4844 Sat Clear 28.563347 67.0417 8.000336 5119 Sun Cloudy 28.665847 66.6667 6.834 4744 Mon Cloudy 26.035 74.625 10.416825 4010 Wed Cloudy 21.798347 82.125 6.0004061 6230 Thurs Clear 22.720847 83.125 7.876654 6871 Sat Cloudy 20.6025 88.5417 12.916461 3372 Sun Cloudy 17.9375 88.0833 14.791925 4996 Mon Clear 18.279153 47.7917 25.917007 5558 Tues Clear 13.256653 29 12.541864 5102 Wed Clear 19.850847 48.125 19.541957 5698 Thurs Clear 20.260847 43.9167 21.41655 6133 Sat Cloudy 17.390847 73.8333 16.791339 6235 Sun Cloudy 17.459153 67.625 11.541889 6041 Mon Clear 17.790433 50.4348 20.913313 5936 Tues Clear 19.133347 39.6667 6.708911 6772 Wed Clear 22.208347 46.9583 12.125325 6436 Fri Clear 16.536653 37.7083 20.125996 6460 Sat Clear 17.9375 25.4167 18.416357 6857 Sun Clear 20.5 27.5833 15.583932 5169 Mon Clear 20.055847 31.75 23.999132 5585 Tues Clear 18.313347 43.5 16.708125 5918 Wed Clear 14.296536 46.9565 19.783358 4862 Fri Clear 18.1425 40.8333 10.416557 6398 Sat Clear 20.295 50.2917 12.791439 7460 Sun Clear 24.873347 50.7917 15.083643 7132 Mon Clear 27.230847 56.1667 19.083543 6370 Tues Clear 24.941653 39.0417 18.333143 6691 Thurs Clear 20.431653 61.25 4.4172564 6565 Fri Clear 21.593347 69.4583 10.041357 7290 Sun Light 16.263347 83.5417 23.084582 1027 Mon Cloudy 13.188347 76.6667 20.334232 3214 Tues Clear 16.946653 45.4167 16.708661 5633 Wed Clear 19.543347 42.7917 7.959064 6196 Thurs Cloudy 20.431653 75.6667 11.833875 5026 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 0 0 1 1 1 1 0 0 0 1 1 1 0 1 1 1 1 1 1 1 1 O O O Row# 375 377 378 379 380 381 382 385 Promotion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Holiday Working Day 0 1 0 0 0 0 1 0 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 0 1 386 388 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 1 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 390 391 392 393 394 396 397 398 402 403 404 406 407 408 409 410 416 418 419 420 421 422 423 424 425 426 427 428 430 431 433 434 435 436 437 438 439 440 441 442 445 446 447 448 449 1 1 1 0 0 1 1 1 1 1 0 0 1 1 Season Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Thurs Clear 28.563347 43.4167 12.415904 5515 Sat Clear 30.271653 44.4583 7.709154 5119 Sun Cloudy 29.383347 68.25 15.333486 4649 Mon Cloudy 29.793347 63.7917 5.4591064 6043 Tues Clear 30.613347 59.0417 8.459286 4665 Wed Clear 29.52 74.3333 10.042161 4629 Thurs Clear 30.75 65.125 10.6664 4592 Sun Clear 30.6475 57.8333 12.292557 4881 Mon Clear 31.2625 63.5833 18.916579 4086 Wed Clear 30.613347 63.1667 9.790911 4342 Fri Clear 27.196653 59.125 12.249811 5538 Sat Clear 28.153347 58.5 13.958914 5923 Sun Clear 29.485847 60.4167 16.417211 5302 Mon Clear 30.613347 65.125 14.458868 4458 Tues Clear 31.843347 65.0417 8.7502 4541 Thurs Cloudy 33.415 69.125 14.875407 3784 Fri Clear 34.781653 58.0417 8.9177 3387 Sat Clear 34.815847 50 8.791807 3285 Wed Clear 31.775 40.2917 12.292021 4656 Thurs Clear 31.945847 58.3333 11.958093 4390 Fri Clear 34.371653 54.25 11.667246 3846 Sun Clear 33.039153 48.0833 11.042471 4302 Mon Clear 31.638347 55.0833 10.500039 4266 Tues Clear 32.116653 49.125 13.79195 4845 Wed Cloudy 29.998347 65.75 9.084061 3574 Thurs Cloudy 29.11 75.75 13.20905 4576 Wed Clear 31.433347 42.4167 13.417286 4780 Fri Clear 29.041653 41.5 8.416607 4905 Sat Cloudy 28.119153 72.9583 14.167418 4150 Sun Cloudy 27.743347 81.75 14.916411 3820 Mon Clear 27.299153 71.2083 13.999918 4338 Tues Clear 28.734153 57.8333 15.834043 4725 Wed Clear 29.656653 57.5417 9.625689 4694 Thurs Clear 29.178347 65.4583 15.624936 3805 Fri Cloudy 28.085 72.2917 9.333636 4153 Sat Clear 28.5975 67.4167 6.999289 5191 Sun Clear 29.144153 77 16.666518 3873 Mon Clear 28.358347 18.54225 4758 Wed Clear 27.606653 60.5 16.958236 5130 Thurs Cloudy 28.050847 77.1667 14.125811 3542 Sat Cloudy 27.88 85 25.166339 1115 Sun Clear 28.989419 56.1765 20.412153 4334 Mon Clear 26.103347 55.4583 10.708275 4634 Tues Clear 26.205847 54.8333 8.375536 5204 Clear 26.923347 59.7917 5.5833311 5058 Thurs Clear 26.855 63.9167 9.500332 5115 Fri Cloudy 26.376653 72.7083 9.375243 4727 Sat Clear 27.435847 71.6667 12.416775 4484 Sun Clear 29.075847 74.2083 13.833289 4940 Mon Cloudy 27.606653 79.0417 14.250632 3351 Thurs Light 25.990433 93.9565 12.914116 1842 Fri Cloudy 26.65 89.7917 8.333393 3544 Sat Clear 27.06 75.375 10.291736 5345 Sun Clear 26.786653 71.375 7.708618 5046 Mon Clear 26.418268 69.2174 5.957171 4713 47 1 OOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOO 0 0 1 1 1 Wed 1 1 0 0 0 1 1 0 0 1 Sat Promotion 0 0 0 0 0 0 0 0 0 0 1 1 1 Holiday 0 0 0 0 0 0 0 0 0 0 0 0 0 Working Day 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 1 1 1 1 0 1 0 1 1 0 1 1 0 1 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 0 Row# 450 451 452 453 454 455 456 457 458 459 461 462 463 464 465 466 468 469 470 471 472 473 474 475 476 477 479 480 481 482 483 484 485 486 488 489 490 491 492 493 494 495 496 497 499 501 502 503 504 505 507 508 509 510 511 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Season Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer 0 1 1 1 1 0 0 1 1 1 1 0 0 1 Sat Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Tues Clear 26.684153 71.25 9.500868 4763 Wed Clear 27.606653 69.7083 11.2091 4785 Thurs Cloudy 23.6775 70.9167 18.166782 3659 Fri Cloudy 19.235847 59.0417 11.000261 4760 Cloudy 20.158347 71.8333 12.708225 4511 Sun Clear 20.8075 69.5 11.958361 4274 Mon Cloudy 22.515847 69 10.166714 4539 Tues Cloudy 23.028347 88.125 9.041918 3641 Wed Cloudy 24.395 90 6.4590814 4352 Thurs Cloudy 25.761653 90.2083 8.584375 4795 Fri Clear 31.8775 57.375 12.250414 5823 Sat Clear 29.998347 53.4583 12.041307 7458 Sun Clear 30.476653 47.9167 9.750175 6891 Mon Clear 29.349153 50.4167 20.125661 6779 Tues Clear 25.864153 37.3333 23.292014 7442 Wed Clear 28.5975 36 18.208925 7335 Fri Clear 34.200847 48.875 11.082939 5463 Sat Clear 31.365 60.125 10.791757 5687 Sun Clear 33.449153 51.875 11.291443 5531 Mon Clear 32.048347 44.7083 13.082889 6227 Tues Clear 32.014153 49.2083 8.457879 6660 Wed Clear 32.355847 53.875 9.04165 7403 Thurs Clear 33.9275 45.7917 12.999943 6241 Fri Clear 33.961653 45.0833 9.791514 6207 Sat Clear 35.328347 49.2083 10.958118 4840 Sun Clear 33.7225 57.375 8.417143 4672 Tues Cloudy 29.554153 66.75 10.166379 6290 Wed Clear 29.383347 63.3333 10.166111 7264 Thurs Clear 29.349153 52.9583 9.833925 7446 Fri Cloudy 29.998347 48.5833 5.41695 7499 Cloudy 28.836653 69.9167 9.626493 6969 Sun Clear 30.579153 71.7917 11.166689 6031 Mon Clear 31.296653 64.5 11.000529 6830 Tues Clear 33.551653 50.5833 7.666743 6786 Thurs Clear 31.57 60.0417 11.083743 6591 Fri Cloudy 27.299153 84.4167 14.000789 5870 Sat Light 24.429153 86.5417 14.2911 4459 Sun Cloudy 27.3675 76.25 6.2926936 7410 Mon Clear 30.408347 69.4167 9.291761 6966 Tues Clear 30.784153 65.5 14.167418 7592 Wed Clear 29.690847 45 11.0416 8173 Thurs Clear 31.843347 59.6667 19.082471 6861 Fri Clear 32.048347 59.4583 10.250464 6904 Sat Clear 30.989153 61.3333 10.54245 6685 Mon Clear 29.964153 66.875 10.292339 7105 Clear 29.4175 67.75 9.458993 7580 Thurs Clear 30.8525 65.9583 8.666718 7261 Fri Cloudy 31.399153 64.25 14.458064 7175 Sat Clear 32.526653 61.3333 17.249686 6824 Sun Clear 31.535847 65.25 19.458207 5464 Tues Cloudy 30.169153 70.375 7.832836 7273 Wed Cloudy 30.75 67.2917 7.4169 7534 Thurs Clear 30.989153 62.0417 10.4587 7286 Fri Cloudy 29.349153 71.5833 16.000471 5786 Sat Cloudy 28.3925 73.2917 13.834093 6299 1 1 1 1 1 1 1 1 0 1 1 1 1 1 Wed 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 0 440 1 Holiday Working Day 0 1 1 1 1 1 0 0 1 1 1 Promotion 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Fri 1 0 441 442 443 444 445 446 447 448 449 450 451 452 453 454 -455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 Row# 512 513 514 515 516 517 518 519 520 521 523 524 525 526 527 528 529 530 531 532 533 534 535 536 538 539 540 541 542 543 545 546 547 548 549 550 552 553 554 555 556 557 558 560 561 562 563 564 566 567 568 569 570 571 572 Season Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sun Clear 28.734153 53.0417 8.208304 6544 Mon Clear 29.554153 54.5417 9.126204 6883 Tues Clear 29.793347 68.6667 11.333586 6784 Wed Clear 28.973347 61.9583 11.374657 7347 Thurs Clear 29.485847 51.9167 9.500332 7605 Fri Clear 29.656653 57.0833 15.500718 7148 Sat Clear 27.811653 60.3333 11.917089 7865 Sun Cloudy 26.069153 71.1667 5.79215 4549 Mon Cloudy 26.069153 73.4167 8.708593 6530 Tues Clear 26.615847 67.375 4.8756436 7006 Thurs Clear 28.529153 63.5833 5.6679186 7765 Fri Cloudy 28.8025 61.5 4.8337686 7582 Sat Cloudy 27.128347 71.2917 16.375336 6053 Sun Cloudy 26.786653 84.5833 15.333486 5255 Mon Clear 28.836653 73.0417 8.625111 6917 Tues Clear 29.861653 62 12.791975 7040 Wed Clear 28.085 55.2083 7.541654 7697 Thurs Clear 28.973347 59.0417 5.1668189 7713 Clear 31.330847 58.75 11.291711 7350 Sat Cloudy 30.886653 63.8333 7.583529 6140 Sun Cloudy 28.563347 81.5 4.2927436 5810 Mon Clear 29.0075 79.0833 10.125107 6034 Tues Clear 29.759153 75.5 15.833507 6864 Wed Clear 30.203347 74.125 12.583136 7112 Fri Clear 28.836653 73.625 11.500282 7504 Sat Cloudy 27.025847 79.9167 18.833968 5976 Sun Clear 25.01 54.75 15.041232 8227 Mon Clear 23.916653 50.375 17.333771 7525 Tues Clear 23.6775 52 6.1676314 7767 Wed Clear 24.565847 57.7083 8.833682 7870 Fri Clear 25.966653 67.25 6.958821 8009 Sat Clear 24.941653 50.1667 16.583907 8714 Sun Clear 23.78 57 6.0422811 7333 Mon Cloudy 23.814153 73.4583 10.166714 6869 Tues Cloudy 25.556653 87.25 23.958329 4073 Wed Clear 22.6525 53.6667 14.416725 7591 Fri Clear 24.565847 66.875 10.333343 8167 Sat Clear 26.65 64.6667 19.000061 8395 Fri Cloudy 24.975847 97.25 5.2505689 2395 Sat Cloudy 24.873347 86.25 5.2516811 5423 Sun Cloudy 26.000847 84.5 3.3754064 5010 Mon Cloudy 26.615847 84.8333 7.4169 4630 Tues Cloudy 26.103347 88.5417 7.917457 4120 Thurs Clear 25.283347 69.9167 11.583161 4839 Fri Clear 23.130847 64.75 13.833825 5202 Sat Cloudy 16.81 75.375 19.583832 2429 Sun Cloudy 14.623347 79.1667 14.874871 2918 Mon Cloudy 15.750847 76.0833 5.5841686 3570 Wed Clear 22.071653 64.7917 11.87575 4826 Thurs Clear 20.260847 62.0833 9.041918 4765 Fri Clear 20.944153 68.4167 1.5002439 4985 Sat Clear 21.388347 70.125 3.0420814 5409 Sun Clear 22.174153 72.75 4.25115 5511 Mon Clear 23.404153 73.375 2.8343814 5117 Tues Cloudy 23.233347 80.875 9.583814 4563 1 0 0 0 0 0 1 1 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 0 0 1 1 1 1 0 1 0 0 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 1 0 0 0 1 0 1 0 1 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 OOO 1 0 0 0 1 Holiday Working Day 1 Promotion 0 0 0 0 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 0 Row# 573 574 575 576 577 578 579 580 581 582 585 586 587 588 589 590 591 592 593 594 596 597 598 599 600 603 604 606 607 608 609 610 611 612 613 614 615 616 618 619 620 623 624 625 626 627 628 630 631 633 634 635 636 637 639 OOO Season Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Wed Light 22.276653 90.625 16.62605 2416 Thurs Cloudy 24.155847 89.6667 9.499729 2913 Fri Cloudy 22.584153 71.625 15.000161 3644 Sat Clear 20.773347 48.3333 17.291561 5217 Sun Clear 20.978347 48.6667 18.875039 5041 Mon Clear 21.900847 57.9583 11.750393 4570 Tues Cloudy 21.8325 70.1667 7.375829 4748 Wed Light 22.211299 89.5217 16.303713 2424 Thurs Clear 19.509153 63.625 28.292425 4195 Fri Clear 17.5275 57.4167 14.833532 4304 Mon Clear 18.996653 77.2083 7.959064 4187 Tues Clear 19.338347 62.2917 11.166086 4687 Wed Cloudy 19.850847 72.0417 9.959014 3894 Thurs Cloudy 19.27 81.2917 13.250121 2659 Fri Cloudy 13.564153 58.5833 15.375093 3747 Sat Light 10.420847 88.25 23.541857 627 Sun Clear 13.085847 62.375 11.833339 3331 Mon Clear 13.94 70.3333 7.12545 3669 Tues Clear 16.434153 68.375 9.083257 4068 Wed Clear 15.4775 71.875 5.5001439 4186 Fri Cloudy 16.536653 62.25 18.209193 4046 Sat Clear 13.393347 51.9167 12.667154 3926 Sun Clear 14.281653 73.4583 6.1676314 3649 Mon Clear 16.195 75.875 3.834075 4035 Tues Clear 16.741653 72.1667 4.6255125 4205 Fri Clear 13.290847 44.625 21.083225 3368 Sat Clear 14.623347 55.2917 14.208154 4067 Mon Clear 21.73 58.7083 20.541932 4486 Tues Cloudy 21.73 68.875 13.375411 4195 Wed Light 18.723347 93 9.167543 1817 Thurs Cloudy 14.008347 57.5833 20.459254 3053 Fri Clear 11.240847 41 11.291711 3392 Sat Clear 13.495847 50.2083 15.041232 3663 Sun Cloudy 18.996653 68.4583 12.45865 3520 Mon Light 18.3475 91 9.249618 2765 Tues Light 17.083347 96.25 7.959064 1607 Wed Cloudy 18.074153 75.7917 22.500275 2566 Thurs Clear 15.306653 54.9167 11.209368 1495 Sat Clear 15.409153 68.1667 4.5841936 3068 Sun Clear 18.825847 69.8333 13.999918 3071 Mon Clear 20.642598 74.3043 9.522174 3867 Thurs Clear 12.8125 52.4583 14.750586 3727 Fri Clear 12.880847 62.5833 6.750518 3940 Sat 12.265847 61.2917 6.4174811 3614 Sun Clear 13.564153 77.5833 5.6252061 3485 Mon Cloudy 15.819153 82.7083 4.1679561 3811 Tues Light 18.9625 94.9583 15.583061 2594 Thurs 10.899153 58 16.083886 3322 Fri Clear 11.924153 69.5833 5.5420189 3620 Sun Clear 9.054153 49 4.4582939 2743 Mon Clear 9.771653 67.0833 4.25115 3310 Tues Clear 11.5825 59 9.41685 3523 Wed Cloudy 13.0175 66.375 4.0842061 3740 Thurs Cloudy 17.3225 63.4167 17.958814 3709 Sat Cloudy 10.591653 56.0833 16.292189 2739 0 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 0 1 1 0 0 1 1 1 1 1 0 0 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 Clear 0 0 0 0 0 0 0 0 Clear 0 0 0 0 0 0 0 0 1 0 1 0 1 0 0 0 Promotion 0 0 0 1 1 1 1 1 1 1 1 1 1 Holiday 0 0 0 0 0 0 0 0 0 0 0 0 0 Working Day 0 1 1 0 1 1 1 1 0 0 1 1 1 1 Sat 1 1 0 1 0 0 1 1 0 1 1 0 0 1 1 1 1 1 0 1 0 1 1 1 1 1 1 0 1 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 Row# 640 641 642 643 645 646 647 648 649 650 651 652 653 655 656 657 658 659 661 662 663 664 665 666 667 668 669 670 672 673 676 677 678 679 680 681 682 683 684 685 687 688 689 690 691 692 693 695 696 697 698 699 700 701 702 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 0 0 1 1 1 1 1 0 0 Season Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sun Clear 9.771653 58.625 11.375193 2431 Mon Clear 11.343347 63.75 11.584032 3403 Tues Cloudy 15.819153 59.5417 4.1252436 3750 Sun Clear 21.695847 46.7083 14.958286 7907 Tues Clear 22.55 57 15.833507 7538 Wed Clear 26.035 63.0833 16.3748 7733 Thurs Cloudy 26.65 69.0833 9.000914 7393 Fri Cloudy 25.385847 69 10.999993 7415 Clear 22.2425 54.2917 15.249468 8555 Sun Clear 21.593347 58.3333 9.042186 6889 Mon Cloudy 21.354153 64.9167 6.0838814 6778 Tues Light 24.224153 87.1667 6.999825 4639 Wed Cloudy 26.9575 79.375 4.4585686 7572 Fri Clear 25.215 62.75 7.12545 8156 Sat Clear 22.720847 66.4167 17.957675 7965 Sun Cloudy 17.049153 70.8333 9.457854 3510 Mon Cloudy 15.716653 70.9583 12.708493 5478 Tues Cloudy 18.313347 76.1667 12.7501 6392 Thurs Clear 17.835 46.3333 12.166932 7570 Fri Clear 17.9375 53.9167 15.751164 7282 Sat Clear 16.126653 49.4583 9.791514 7109 Sun Clear 21.388347 64.0417 18.667004 6639 Mon Cloudy 23.028347 70.75 19.834479 5875 Tues Clear 19.201653 55.8333 12.208807 7534 Wed Clear 18.689153 69.2917 6.791857 7461 Thurs Cloudy 21.4225 72.8333 15.874779 7509 Fri Cloudy 23.096653 81.5 9.041918 5424 Sat Clear 19.850847 57.2917 7.874979 8090 Mon Clear 19.9875 56.8333 5.4593811 7058 Tues Clear 22.310847 64.1667 6.3345686 7466 Fri Cloudy 22.379153 80.7083 8.875289 7444 Sat Cloudy 21.73 72 15.791364 7852 Sun Cloudy 19.5775 69.4583 26.666536 4459 Mon Light 18.04 23.9994 22 Tues Cloudy 13.045462 82.5455 14.271603 1096 Wed Cloudy 14.6575 66.6667 11.166689 5566 Thurs Cloudy 14.999153 58.1667 10.542182 5986 Fri Clear 14.555 52.2083 17.833725 5847 Sat Cloudy 14.076653 49.125 18.125443 5138 Sun Clear 13.359153 53.2917 12.000236 5107 Tues Clear 11.514153 56.7083 11.625371 5686 Wed Cloudy 12.129153 54.75 20.375236 5035 Thurs Clear 14.439134 33.3478 23.304945 5315 Fri Clear 14.828347 54.0833 14.375386 5992 Sat Clear 15.955847 64.5417 3.8756686 6536 Sun Clear 17.254153 65.9167 8.5425 6852 Mon Clear 19.885 74.1667 11.625639 6269 Wed Clear 11.855847 55.2083 13.374875 5495 Thurs Cloudy 13.188347 62.0417 10.250129 5445 Fri Clear 14.145 52.4583 11.458675 5698 Sat Clear 13.325 54.5417 12.041843 5629 Sun Clear 14.0425 69.2917 15.250004 4669 Mon Cloudy 15.614153 62.3333 15.749489 5499 Tues Cloudy 15.340847 68.5 5.542575 5634 Wed Clear 14.486653 61.375 6.917482 5146 88 1 1 1 1 1 1 1 1 1 1 0 0 0 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 1 Promotion Holiday Working Day 1 1 1 1 1 1 1 0 0 1 0 0 1 1 1 1 1 0 0 1 1 1 1 1 1 1 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 Row# 703 704 705 706 707 708 709 710 711 712 713 714 716 717 718 719 720 721 722 723 724 725 726 727 728 729 731 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Season Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Fall Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Thurs Clear 13.94 58.0417 3.5423436 2425 Fri Clear 15.101653 56.875 9.917407 3910 Sat Clear 11.411653 40.4583 25.250357 2277 Sun Clear 10.079153 46.8333 10.0835 2424 Mon Clear 12.846653 53.5417 3.12555 5087 Tues Cloudy 11.958347 78.6667 15.916654 3959 Wed Clear 12.163347 50.625 14.125007 5260 Thurs Clear 11.51567 55.5652 7.739974 5323 Fri Clear 12.231653 64.9583 3.9175436 5668 Sat Cloudy 12.231653 80.6667 4.0001814 5191 Sun Cloudy 14.2475 82.3333 8.333393 4649 Mon Clear 18.5525 76.75 5.5422936 6234 Wed Clear 17.971653 48.5 21.709407 5729 Thurs Clear 10.489153 50.875 11.708518 5375 Fri Cloudy 13.154153 76.4167 8.7502 5008 Sat Cloudy 15.648347 91.125 6.792393 5582 Sun Cloudy 15.750847 90.5417 10.584325 3228 Mon Cloudy 17.869153 92.5 12.750636 5170 Tues Cloudy 14.486653 59.6667 19.834479 5501 Wed Cloudy 12.1975 53.8333 10.916779 5319 Thurs Clear 12.129153 48.5833 11.666643 5532 Fri Clear 11.548347 64.2917 8.792343 5611 Sat Clear 13.290847 65.0417 7.12545 5047 Sun Cloudy 14.8625 83.875 6.749714 3786 Mon Cloudy 16.126653 90.7083 6.5833061 4585 Tues Clear 16.844153 66.625 14.834068 5557 Thurs Cloudy 13.53 66.7917 8.875021 4128 1 1 0 0 1 1 1 1 1 0 0 1 1 1 PREDICTED RIDERS Light Working Day or 1 Row # Promotion Holiday Day Season Week Situation Temperature Humidity Speed 50 387 0 0 1 Summer Tues Clear 32.560847 55.9167 13.417018 51 389 0 0 1 Summer Thurs Clear 27.914153 47.625 16.124689 52 395 0 0 1 Summer Wed Clear 31.501653 70.7083 7.625739 53 399 0 0 0 Summer Sun Clear 34.03 55.0833 11.334457 54 400 0 0 1 Summer Mon Clear 30.476653 75.7083 6.0841561 55 401 0 0 1 Summer Tues Clear 31.638347 54.0833 13.417286 56 405 0 0 0 Summer Sat Clear 32.970847 46.5833 11.291979 57 411 0 0 1 Summer Fri Clear 29.144153 63.0833 12.374632 58 412 0 0 0 Summer Sat Cloudy 29.383347 75.5 15.29275 59 413 0 0 Summer Sun Clear 30.4425 75.2917 13.499629 60 414 0 1 Summer Mon Clear 31.365 59.2083 12.875725 61 415 0 1 Summer Tues Clear 31.775 57.0417 10.125107 62 417 0 1 Summer Thurs Clear 29.4175 42.375 11.041332 63 429 0 0 1 Summer Tues Clear 26.274153 45.5417 9.833121 64 432 0 0 1 Summer Fri Clear 28.7 76.125 5.6254875 65 443 0 0 1 Summer Tues 22.14 88.6957 23.044181 66 444 0 0 1 Summer Wed Light 24.565847 91.7083 6.5003936 67 460 1 0 1 Summer Thurs Clear 33.039153 56.7917 7.958729 68 467 1 0 1 Summer Thurs Clear 30.715847 42.25 11.50055 69 478 1 0 1 Summer Mon Cloudy 29.144153 68.3333 12.125325 70 487 1 0 1 Summer Wed Clear 32.52665357.7083 9.208614 71 498 1 0 0 Summer Sun Clear 29.588347 62.375 11.416532 72 500 1 0 1 Summer Tues Clear 29.246653 70.4167 11.083475 73 506 1 0 1 Summer Mon Cloudy 30.8525 65.4167 8.666718 74 522 1 0 1 Summer Wed Clear 27.3675 67.7083 4.7089811 75 537 1 0 1 Summer Thurs Cloudy 28.563347 81.0417 9.542207 76 544 1 0 1 Summer Thurs Clear 25.1125 63.7083 5.5422936 77 551 1 0 1 Summer Thurs Clear 22.413347 61.8333 7.917189 78 559 0 0 1 Fall Wed Cloudy 26.035 84.875 9.958143 79 565 0 0 1 Fall Tues Clear 19.850847 71 13.792218 80 583 0 0 0 Fall Sat Clear 17.3225 62.9167 6.2086689 81 584 0 0 Fall Sun Clear 17.288347 74.125 6.6673375 82 595 0 1 Fall Thurs Clear 16.741653 70.2083 9.166739 83 601 0 1 Fall Wed Clear 16.4 75.8333 4.1671186 84 602 0 1 Fall Thurs Cloudy 15.58 81.3333 12.667489 85 605 0 0 Fall Sun Clear 18.074153 45.8333 18.875307 86 617 0 1 Fall Fri Clear 15.375 64.375 6.6260186 87 621 0 1 Fall Tues Cloudy 18.791653 83.0833 17.292164 88 622 0 1 Fall Wed Clear 13.325 61.3333 18.167586 89 629 0 1 Fall Wed Light 16.81 97.0417 17.833725 90 632 0 0 Fall Sat Clear 11.275 50.75 15.625807 91 638 1 Fall Fri Cloudy 15.375 50.0417 17.458525 92 644 1 1 Fall Mon Clear 21.080847 49.2917 9.541068 93 654 1 0 1 Thurs Cloudy 26.9575 72.2917 7.875582 94 660 1 0 1 Fall Wed Clear 21.080847 63.0833 12.584007 95 671 1 0 Sun Clear 19.030847 51 11.125618 96 674 1 1 Wed Clear 24.0875 63.625 4.8762064 97 675 1 1 Thurs Cloudy 22.55 80.0417 8.333125 98 686 1 1 Fall Mon Clear 13.085847 49.4167 15.833775 OO Fall Fall Fall Fall 1 Row # 98 686 99 694 100 715 101 730 Working Promotion Holiday Day 1 1 1 1 1 1 1 1 Day of Season Week Fall Mon Fall Tues Fall Tues Fall Wed Weather Wind PREDICTED Situation Temperature Humidity Speed RIDERS Clear 13.085847 49.4167 15.833775 Cloudy 14.076653 66.2917; 22.917082 Clear 19.509153 73.375 11.666643 Clear 13.6325 62.5417 12.334164 Promotion Row# 1 Holiday Working Day 0 1 2 3 4 2 0 3 5 1 1 1 4 5 7 6 7 8 1 8 0 9 0 1 10 12 1 13 1 14 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Fri 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 15 16 17 18 21 22 23 24 25 26 27 28 30 31 32 33 34 35 36 37 38 39 41 42 43 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 0 0 1 1 0 0 1 1 1 1 1 0 1 1 1 1 1 0 0 1 1 1 1 0 Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter 1005 Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sat Cloudy 14.110847 80.5833 10.749882 985 Sun Cloudy 14.902598 69.6087 16.652113 801 Mon Clear 8.050924 43.7273 16.636703 1349 Tues Clear 8.2 59.0435 10.739832 1562 Wed Clear 9.305237 43.6957 12.5223 1600 Fri Cloudy 8.057402 49.8696 11.304642 1510 Sat Cloudy 6.765 53.5833 17.875868 959 Sun Clear 5.671653 43.4167 24.25065 822 Mon Clear 6.184153 48.2917 14.958889 1321 Wed Clear 7.081807 59.9545 20.410009 1162 Thurs Clear 6.765 47.0417 20.167 1406 Fri Clear 6.59567 53.7826 8.478716 1421 Sat Cloudy 9.566653 49.875 10.583521 1248 Sun Clear 9.498347 48.375 12.625011 1204 Mon Cloudy 7.209153 53.75 12.999139 1000 Tues Cloudy 8.883347 86.1667 9.833925 683 Clear 7.2775 45.7083 23.667214 1543 Sat Clear 2.4243464 40 11.52199 981 Sun Clear 3.9573897 43.6522 16.5222 986 Mon Clear 3.9930433 49.1739 10.60811 1416 Tues Cloudy 9.162598 61.6957 8.696332 1985 Wed Light 8.9175 86.25 19.68795 506 Thurs Clear 7.995 68.75 7.627079 431 Fri Cloudy 8.342598 79.3043 8.2611 1167 Sun Clear 8.877402 72.2174 4.9568342 1096 Mon Cloudy 7.414153 60.375 12.541864 1501 Tues Cloudy 7.879134 82.9565 3.565271 1360 Wed Cloudy 10.66 77.5417 17.708636 1526 Thurs Clear 7.665237 43.7826 18.609384 1550 Fri Cloudy 8.663464 58.5217 8.565213 1708 Sat Cloudy 9.566653 92.9167 10.792293 Sun Clear 11.719153 56.8333 9.5006 1623 Mon Clear 11.138347 73.8333 3.0423561 1712 Tues Clear 9.054153 53.7917 24.25065 1530 Thurs Clear 5.918268 43.7391 14.869645 1538 Fri Clear 7.752731 50.6364 7.27285 1746 Sat Clear 9.1225 54.4167 13.625589 1472 Mon Clear 17.015 37.5833 27.999836 1913 Tues Clear 10.909567 31.4348 19.522058 1815 Wed Clear 13.048701 42.3478 16.869997 2115 Thurs Clear 17.869153 50.5 15.416968 2475 Fri Clear 21.388347 51.6667 17.749975 2927 Clear 16.365847 18.7917 34.000021 1635 Sun Clear 11.693897 40.7826 14.956745 1812 Mon Cloudy 12.436653 60.5 20.625682 1107 Tues Clear 7.471102 57.7778 13.110761 1450 Wed Clear 9.091299 42.3043 6.305571 1917 Thurs Cloudy 12.121732 69.7391 16.783232 1807 Fri Cloudy 14.938268 71.2174 23.218113 1461 Sat Clear 11.5825 53.7917 12.500257 1969 Sun Clear 14.082598 68 8.391616 2402 Mon Cloudy 16.698193 87.6364 19.408962 1446 Tues Clear 10.933347 53.5 14.500475 1851 Wed Clear 13.735 44.9583 20.624811 2134 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 0 0 0 1 1 Sat 1 1 0 0 0 1 1 1 1 0 0 1 1 1 Promotion Holiday Working Day 1 1 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 Row# 62 63 64 65 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 89 90 91 92 93 94 95 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 115 116 117 119 121 124 0 0 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 0 0 0 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 1 0 0 0 1 1 1 OOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Day of Week Thurs Fri Sat Sun Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Wed Thurs Fri Sat Sun Mon Tues Wed Fri Sat Sun Mon Tues Wed Thurs Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Tues Wed Thurs Fri Sat Sun Mon Wed Thurs Fri Sun Tues Fri Weather Situation Temperature Humidity Windspeed Total Riders Clear 8.131653 31.8333 15.125518 1685 Cloudy 10.728347 61.0417 13.624182 1944 Cloudy 15.750847 78.9167 16.875357 2077 Cloudy 15.437402 94.8261 23.000229 605 Clear 11.9925 42.0833 8.08355 2133 Cloudy 12.129153 77.5417 14.75005 1891 Light 15.952731 0 17.545759 623 Cloudy 12.977402 64.9565 15.60899 1977 Clear 13.495847 59.4583 14.791925 2132 Clear 15.758268 52.7391 18.130468 2417 Clear 13.333897 49.6957 9.174042 2046 Cloudy 13.013031 65.5652 12.348703 2056 Cloudy 14.973897 77.6522 13.608839 2192 Clear 17.015 60.2917 14.041793 2744 Clear 22.14 52.5217 15.478139 3239 Clear 19.3725 37.9167 24.667189 3117 Clear 13.6325 47.375 13.917307 2471 Cloudy 17.561653 85.8333 14.8338 2660 Cloudy 17.356653 75.75 3.167425 3068 Clear 15.306653 68.625 18.374482 2209 Clear 12.4025 54.25 12.750368 1011 Clear 11.266103 68.1304 10.391097 754 Clear 13.191299 50.6957 16.044155 1317 Cloudy 13.325 76.25 12.62615 1162 Clear 12.26433 50.3913 19.695387 2302 Clear 12.778347 63.6667 9.000579 2999 Clear 16.81 61.5833 14.750318 2485 Clear 15.17 69.25 12.875189 2294 Clear 11.194763 38.1304 22.087555 1951 Clear 6.15 44.125 24.499957 2236 Cloudy 4.4075 41.4583 12.3749 2368 Clear 10.899153 52.4167 8.709129 3272 Clear 16.126653 53.1667 11.708786 4521 Clear 13.8375 46.5 12.833314 3425 Cloudy 9.190847 70.1667 6.6263 2376 Clear 12.656536 64.6522 12.565984 3598 Cloudy 11.240847 84.75 8.791807 2177 Cloudy 15.6825 80.2917 12.124789 4097 Clear 11.240847 50.75 25.333236 3214 Clear 7.38 45.75 12.541261 2493 Clear 6.833347 41.9167 16.834286 2311 Clear 7.79 52.25 15.500986 2298 Cloudy 15.294763 71.6087 23.39171 2935 Clear 12.436653 44.3333 27.833743 3376 Clear 7.79 49.75 14.750586 3292 Cloudy 8.9175 45 13.58425 3163 Cloudy 7.106653 83.125 14.917014 1301 Cloudy 6.6625 79.625 13.375746 1977 Cloudy 8.951653 91.125 7.417436 2432 Clear 12.060847 64.375 10.791757 4270 Cloudy 14.008347 76.9583 4.9175186 4075 Cloudy 17.425 74.125 22.958689 3456 Clear 11.5825 31.125 16.08335 3243 Clear 15.99 41.6667 17.541739 4509 Clear 12.846653 52.6667 11.959232 4151 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 1 1 1 Working Day 0 Promotion 1 1 1 0 1 1 1 Holiday 0 0 0 0 0 0 0 0 0 1 1 1 0 1 1 1 1 1 1 1 0 1 0 0 1 0 1 0 0 41 0 0 0 0 0 0 0 0 0 0 0 1 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 Row# 125 126 128 129 131 132 134 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 170 171 172 173 174 175 176 177 178 179 180 182 183 184 186 187 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 Season Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Winter Spring Spring Spring Spring Spring 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 0 0 Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sat Cloudy 10.830847 77.9583 8.167032 2832 Sun Cloudy 10.899153 68.7917 11.791732 2947 Tues Clear 14.520847 49.625 9.874393 4375 Wed Cloudy 10.523347 72.2917 8.959307 2802 Fri Cloudy 11.514153 54 7.834243 3831 Sat Light 9.190847 73.125 19.416332 2169 Mon Clear 9.1225 41.125 11.207961 3422 Thurs Cloudy 12.983347 75.2917 6.125475 3005 Fri Clear 14.076653 63.4583 13.791682 4154 Sat Clear 14.213347 53.4583 12.792243 4318 Sun Cloudy 11.48 51.5833 16.958504 2689 Mon Clear 11.48 50.7826 15.348561 3129 Tues Clear 11.800866 59.4348 13.783039 3777 Wed Clear 16.229153 56.7917 15.709557 4773 Thurs Clear 18.620847 55.4583 12.791171 5062 Fri Cloudy 16.7075 73.75 15.916989 3487 Sat Clear 11.924153 39.5833 28.250014 2732 Sun Clear 11.445847 13.750343 3389 Mon Clear 15.033347 49.0833 17.958211 4322 Tues Clear 14.725847 39.5833 12.958939 4363 Wed Cloudy 14.118268 80.4783 12.000839 1834 Thurs Clear 19.919153 61.5417 15.208129 4990 Fri Cloudy 14.486653 65.7083 9.708568 3194 Sat Cloudy 16.980847 62.125 10.792293 4066 Sun Clear 13.359153 40.3333 22.416257 3423 Mon Clear 9.976653 50.625 15.333486 3333 Tues Clear 10.591653 45.6667 13.458625 3956 Wed Clear 16.570847 51.3333 23.167193 4916 Thurs Clear 21.6275 56.75 29.584721 5382 Fri Cloudy 16.844153 40.7083 27.7916 4569 Sat Clear 11.7875 35.0417 15.12525 4118 Sun Clear 14.831299 47.6957 14.913329 4911 Mon Clear 19.133347 48.9167 13.916771 5298 Tues Clear 23.165 61.75 15.87565 5847 Wed Clear 23.4725 50.7083 7.709154 6312 Thurs Clear 22.8575 57.9583 10.042161 6192 Fri Cloudy 17.869153 84.2083 7.583864 4378 Sat Cloudy 21.080847 75.5833 7.417168 7836 Sun Cloudy 19.3725 81 8.501161 5892 Tues Clear 22.994153 80.7917 8.125157 6093 Fri Cloudy 13.393347 55.6667 25.083661 3623 Sat Clear 10.899153 44.125 27.292182 1749 Sun Clear 10.079153 51.5417 8.916561 1787 Mon Cloudy 9.483464 79.1304 5.1744368 920 Tues Cloudy 11.943464 73.4783 11.304642 1013 Wed Light 9.976653 82.3333 21.208582 441 Thurs Cloudy 10.420847 65.2917 23.458911 2114 Fri Cloudy 10.386653 59 10.416557 3095 Sat Cloudy 10.386653 75.2917 8.333661 1341 Sun Clear 10.489153 48.3333 23.500518 1796 Mon Cloudy 17.647835 73.7391 19.348461 2077 Tues Clear 18.108347 62.4583 15.12525 2703 Wed Cloudy 14.225237 83.9565 15.695487 2121 Fri Clear 10.830847 49.5 15.458575 2210 Sat Clear 10.899153 39.4167 14.041257 2496 1 1 0 0 1 1 1 1 1 0 0 1 1 0 0 1 0 1 1 1 0 0 1 1 1 1 0 0 Holiday 0 0 Working Day 0 1 1 1 0 Mon 0 0 0 Sat 0 0 0 0 0 1 1 1 1 0 0 0 Sat 0 0 Promotion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 1 0 1 0 1 1 0 0 0 0 0 0 1 0 1 0 1 0 1 0 1 0 0 0 0 1 1 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 Row# 188 189 190 191 194 195 196 197 198 199 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 234 235 236 237 238 239 240 241 242 243 244 245 246 Season Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Sun Cloudy 10.374763 49.3913 12.3481 1693 Clear 10.838268 30.2174 14.217668 2028 Tues Clear 12.4025 31.4167 15.208732 2425 Wed Cloudy 12.3 64.6667 11.583496 1536 Cloudy 12.915 65.375 13.208782 2252 Sun Clear 15.511653 48 12.208271 3249 Mon Clear 23.506653 42.625 25.833257 3115 Tues Cloudy 16.980847 64.2083 26.000489 1795 Wed Clear 16.024153 47.0833 17.625221 2808 Thurs Clear 17.9375 60.2917 10.874904 3141 Cloudy 14.0425 87.75 8.916561 2455 Sun Cloudy 17.493347 85.75 9.833389 2895 Mon Cloudy 24.421732 71.6956 21.739758 3348 Tues Cloudy 20.6025 73.9167 18.416893 2034 Wed Cloudy 16.9125 81.9167 16.791339 2162 Thurs Clear 19.1675 54.0417 7.4169 3267 Fri Clear 18.313347 67.125 15.167125 3126 Sat Light 17.664153 88.8333 22.834136 795 Sun Clear 18.723347 47.9583 20.334232 3744 Mon Clear 21.0125 54.25 10.958989 3429 Tues Cloudy 20.739153 66.5833 10.584057 3204 Wed Clear 24.395 61.4167 16.208975 3944 Thurs Clear 18.825847 40.7083 21.792286 4189 Fri Cloudy 13.803347 72.9583 14.707907 1683 Sat Cloudy 18.86 88.7917 15.458575 4036 Sun Cloudy 23.848347 81.0833 12.875725 4191 Mon Clear 24.873347 77.6667 12.417311 4073 Tues Clear 25.898347 72.9167 21.8755 4400 Wed Cloudy 25.42 83.5417 20.9174 3872 Thurs Cloudy 25.3175 70.0833 21.500836 4058 Fri Clear 20.91 45.7083 16.084221 4595 Sat Clear 19.3725 50.3333 15.750025 5312 Sun Cloudy 18.518347 76.2083 7.125718 3351 Mon Cloudy 22.515847 73 12.291418 4401 Tues Cloudy 25.283347 69.7083 22.958689 4451 Wed Cloudy 16.980847 73.7083 22.042732 2633 Thurs Clear 18.825847 44.4167 19.791264 4433 Fri Clear 19.645847 59 15.292482 4608 Sat Clear 21.32 54.125 10.75015 4714 Sun Clear 21.661653 63.1667 5.0007125 4333 Mon Clear 21.8325 58.875 11.792 4362 Tues Clear 21.8325 48.9167 7.749957 4803 Thurs Clear 21.935 74.75 12.707689 4864 Fri Cloudy 21.0125 86.3333 12.041575 4105 Sat Cloudy 21.354153 92.25 9.04165 3409 Sun Cloudy 23.0625 86.7083 10.249593 4553 Mon Clear 23.6775 78.7917 8.500357 3958 Tues Cloudy 23.028347 83.7917 18.582718 4123 Wed Cloudy 22.55 87 13.499964 3855 Thurs Cloudy 21.764153 82.9583 7.250271 4575 Fri Clear 22.003347 71.9583 8.375871 4917 Sat Clear 24.7025 62.6667 8.08355 5805 Sun Clear 24.770847 74.9583 9.916536 4660 Mon Cloudy 25.898347 81 15.667414 4274 Tues Cloudy 27.06 74.0833 13.875164 4492 0 0 0 0 0 0 0 0 0 0 0 0 1 1 1 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 1 1 0 1 0 0 0 0 0 0 0 1 0 1 1 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 0 0 1 1 0 0 1 0 1 0 0 0 OO 0 0 0 1 1 1 Promotion Holiday 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1 1 Working Day 1 1 1 0 0 0 1 1 1 0 0 1 1 1 1 0 0 1 1 1 1 0 0 1 1 1 0 0 1 1 1 1 0 0 1 1 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 1 Row# 247 248 249 250 251 252 253 254 256 257 258 259 260 262 263 264 265 266 267 269 270 271 272 273 274 275 277 278 279 280 281 282 284 285 286 287 288 290 291 292 293 294 295 297 298 299 300 301 303 304 306 307 308 309 310 Season Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Spring Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Wed Clear 27.094153 69.625 10.333611 4978 Thurs Clear 29.041653 67.75 13.376014 4677 Fri Clear 27.948347 65.375 16.125493 4679 Sat Clear 26.889153 72.9583 15.416164 4758 Sun Clear 27.3675 81.875 14.333846 4788 Mon Clear 30.066653 68.5 8.792075 4098 Tues Clear 31.775 63.6667 7.459043 3982 Wed Cloudy 31.330847 67.7083 13.875164 3974 Fri Clear 25.42 35.4167 16.959107 5312 Sat Clear 26.035 45.625 8.250514 5342 Sun Cloudy 26.581653 65.25 9.292364 4906 Mon Clear 27.811653 60 8.167032 4548 Tues Clear 29.0075 59.7917 12.583136 4833 Thurs Cloudy 33.141653 56.8333 10.042161 3915 Fri Clear 30.955 60.5 9.417118 4586 Sat Clear 29.725 65.4583 10.37495 4966 Sun Clear 28.3925 74.7917 10.958989 4460 Mon Clear 26.035 49.4583 20.45845 5020 Tues Clear 24.770847 50.7083 18.041961 4891 Thurs Cloudy 25.761653 68.8333 13.833557 3767 Fri Clear 26.615847 73.5833 9.582943 4844 Sat Clear 28.563347 67.0417 8.000336 5119 Sun Cloudy 28.665847 66.6667 6.834 4744 Mon Cloudy 26.035 74.625 10.416825 4010 Wed Cloudy 21.798347 82.125 6.0004061 6230 Thurs Clear 22.720847 83.125 7.876654 6871 Sat Cloudy 20.6025 88.5417 12.916461 3372 Sun Cloudy 17.9375 88.0833 14.791925 4996 Mon Clear 18.279153 47.7917 25.917007 5558 Tues Clear 13.256653 29 12.541864 5102 Wed Clear 19.850847 48.125 19.541957 5698 Thurs Clear 20.260847 43.9167 21.41655 6133 Sat Cloudy 17.390847 73.8333 16.791339 6235 Sun Cloudy 17.459153 67.625 11.541889 6041 Mon Clear 17.790433 50.4348 20.913313 5936 Tues Clear 19.133347 39.6667 6.708911 6772 Wed Clear 22.208347 46.9583 12.125325 6436 Fri Clear 16.536653 37.7083 20.125996 6460 Sat Clear 17.9375 25.4167 18.416357 6857 Sun Clear 20.5 27.5833 15.583932 5169 Mon Clear 20.055847 31.75 23.999132 5585 Tues Clear 18.313347 43.5 16.708125 5918 Wed Clear 14.296536 46.9565 19.783358 4862 Fri Clear 18.1425 40.8333 10.416557 6398 Sat Clear 20.295 50.2917 12.791439 7460 Sun Clear 24.873347 50.7917 15.083643 7132 Mon Clear 27.230847 56.1667 19.083543 6370 Tues Clear 24.941653 39.0417 18.333143 6691 Thurs Clear 20.431653 61.25 4.4172564 6565 Fri Clear 21.593347 69.4583 10.041357 7290 Sun Light 16.263347 83.5417 23.084582 1027 Mon Cloudy 13.188347 76.6667 20.334232 3214 Tues Clear 16.946653 45.4167 16.708661 5633 Wed Clear 19.543347 42.7917 7.959064 6196 Thurs Cloudy 20.431653 75.6667 11.833875 5026 1 1 1 1 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 1 1 1 1 0 1 0 1 0 0 1 1 1 1 0 0 0 1 1 1 0 1 1 1 1 1 1 1 1 O O O Row# 375 377 378 379 380 381 382 385 Promotion 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Holiday Working Day 0 1 0 0 0 0 1 0 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 0 1 386 388 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 1 0 1 0 1 0 0 0 1 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 390 391 392 393 394 396 397 398 402 403 404 406 407 408 409 410 416 418 419 420 421 422 423 424 425 426 427 428 430 431 433 434 435 436 437 438 439 440 441 442 445 446 447 448 449 1 1 1 0 0 1 1 1 1 1 0 0 1 1 Season Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Thurs Clear 28.563347 43.4167 12.415904 5515 Sat Clear 30.271653 44.4583 7.709154 5119 Sun Cloudy 29.383347 68.25 15.333486 4649 Mon Cloudy 29.793347 63.7917 5.4591064 6043 Tues Clear 30.613347 59.0417 8.459286 4665 Wed Clear 29.52 74.3333 10.042161 4629 Thurs Clear 30.75 65.125 10.6664 4592 Sun Clear 30.6475 57.8333 12.292557 4881 Mon Clear 31.2625 63.5833 18.916579 4086 Wed Clear 30.613347 63.1667 9.790911 4342 Fri Clear 27.196653 59.125 12.249811 5538 Sat Clear 28.153347 58.5 13.958914 5923 Sun Clear 29.485847 60.4167 16.417211 5302 Mon Clear 30.613347 65.125 14.458868 4458 Tues Clear 31.843347 65.0417 8.7502 4541 Thurs Cloudy 33.415 69.125 14.875407 3784 Fri Clear 34.781653 58.0417 8.9177 3387 Sat Clear 34.815847 50 8.791807 3285 Wed Clear 31.775 40.2917 12.292021 4656 Thurs Clear 31.945847 58.3333 11.958093 4390 Fri Clear 34.371653 54.25 11.667246 3846 Sun Clear 33.039153 48.0833 11.042471 4302 Mon Clear 31.638347 55.0833 10.500039 4266 Tues Clear 32.116653 49.125 13.79195 4845 Wed Cloudy 29.998347 65.75 9.084061 3574 Thurs Cloudy 29.11 75.75 13.20905 4576 Wed Clear 31.433347 42.4167 13.417286 4780 Fri Clear 29.041653 41.5 8.416607 4905 Sat Cloudy 28.119153 72.9583 14.167418 4150 Sun Cloudy 27.743347 81.75 14.916411 3820 Mon Clear 27.299153 71.2083 13.999918 4338 Tues Clear 28.734153 57.8333 15.834043 4725 Wed Clear 29.656653 57.5417 9.625689 4694 Thurs Clear 29.178347 65.4583 15.624936 3805 Fri Cloudy 28.085 72.2917 9.333636 4153 Sat Clear 28.5975 67.4167 6.999289 5191 Sun Clear 29.144153 77 16.666518 3873 Mon Clear 28.358347 18.54225 4758 Wed Clear 27.606653 60.5 16.958236 5130 Thurs Cloudy 28.050847 77.1667 14.125811 3542 Sat Cloudy 27.88 85 25.166339 1115 Sun Clear 28.989419 56.1765 20.412153 4334 Mon Clear 26.103347 55.4583 10.708275 4634 Tues Clear 26.205847 54.8333 8.375536 5204 Clear 26.923347 59.7917 5.5833311 5058 Thurs Clear 26.855 63.9167 9.500332 5115 Fri Cloudy 26.376653 72.7083 9.375243 4727 Sat Clear 27.435847 71.6667 12.416775 4484 Sun Clear 29.075847 74.2083 13.833289 4940 Mon Cloudy 27.606653 79.0417 14.250632 3351 Thurs Light 25.990433 93.9565 12.914116 1842 Fri Cloudy 26.65 89.7917 8.333393 3544 Sat Clear 27.06 75.375 10.291736 5345 Sun Clear 26.786653 71.375 7.708618 5046 Mon Clear 26.418268 69.2174 5.957171 4713 47 1 OOOOOOOOOOOOOOOOOOOOOOOOOOOO OOOOOOOOOOOOOOOOOOOOOOOOOOO 0 0 1 1 1 Wed 1 1 0 0 0 1 1 0 0 1 Sat Promotion 0 0 0 0 0 0 0 0 0 0 1 1 1 Holiday 0 0 0 0 0 0 0 0 0 0 0 0 0 Working Day 1 1 1 1 0 0 1 1 1 1 1 0 0 1 1 1 1 1 1 1 1 1 0 1 0 1 1 0 0 1 1 1 1 0 1 0 1 1 0 1 1 0 1 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 0 Row# 450 451 452 453 454 455 456 457 458 459 461 462 463 464 465 466 468 469 470 471 472 473 474 475 476 477 479 480 481 482 483 484 485 486 488 489 490 491 492 493 494 495 496 497 499 501 502 503 504 505 507 508 509 510 511 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Season Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer Summer 0 1 1 1 1 0 0 1 1 1 1 0 0 1 Sat Day of Week Weather Situation Temperature Humidity Windspeed Total Riders Tues Clear 26.684153 71.25 9.500868 4763 Wed Clear 27.606653 69.7083 11.2091 4785 Thurs Cloudy 23.6775 70.9167 18.166782 3659 Fri Cloudy 19.235847 59.0417 11.000261 4760 Cloudy 20.158347 71.8333 12.70