Skip to content

Instantly share code, notes, and snippets.

@milafrerichs

milafrerichs/trip_distance_weekday.csv

Last active November 8, 2018 11:55
Show Gist options
  • Save milafrerichs/5cb8610d514ced82aa98c7ddfac585ef to your computer and use it in GitHub Desktop.
Save milafrerichs/5cb8610d514ced82aa98c7ddfac585ef to your computer and use it in GitHub Desktop.
Download ZIP
Raw
trip_distance_weekday.csv
o weekday mean count
0 Sunday 2.1279472558802586 1403
1 Monday 1.6992589641434273 1255
2 Tuesday 1.678251582278482 1264
3 Wednesday 1.6827566807313659 1422
4 Thursday 1.6591638795986645 1495
5 Friday 2.107544776119401 1340
6 Saturday 2.2442722451384802 1697
Raw
trip_distance_weekday_hour.csv
weekday hour mean count
0 4 4.345000000000001 2
0 5 2.21 1
0 6 0.9950000000000001 6
0 7 0.7077777777777778 9
0 8 1.2121874999999998 32
0 9 1.4467567567567563 37
0 10 2.2800000000000007 61
0 11 1.71247619047619 105
0 12 1.7226890756302524 119
0 13 2.3300588235294133 170
0 14 2.207380952380953 126
0 15 2.34780487804878 123
0 16 2.5562295081967226 122
0 17 1.77390977443609 133
0 18 1.8792957746478862 142
0 19 2.7758088235294114 136
0 20 2.41620253164557 79
1 6 0.555 6
1 7 1.1770000000000003 20
1 8 1.0791428571428574 35
1 9 1.3599999999999999 44
1 10 1.1674999999999998 32
1 11 1.3618750000000006 80
1 12 1.3129203539823013 113
1 13 1.770752688172043 93
1 14 1.818241758241759 91
1 15 2.0694117647058814 102
1 16 1.4505303030303038 132
1 17 1.466779661016949 118
1 18 2.0304375 160
1 19 2.211293103448275 116
1 20 2.025272727272727 110
1 21 1.1633333333333333 3
2 5 0.78 1
2 6 1.1600000000000001 10
2 7 1.5113636363636365 22
2 8 0.6909375 32
2 9 1.698863636363636 44
2 10 1.4365999999999999 50
2 11 1.6927884615384625 104
2 12 1.292622950819672 122
2 13 1.415454545454545 88
2 14 1.8494642857142851 112
2 15 1.7316528925619836 121
2 16 1.7054954954954953 111
2 17 1.1641739130434783 115
2 18 1.825686274509804 102
2 19 2.168559999999999 125
2 20 2.3955238095238105 105
3 5 0.74 1
3 6 0.7425 4
3 7 1.006086956521739 23
3 8 1.085151515151515 33
3 9 1.4344827586206894 29
3 10 1.264426229508197 61
3 11 1.122892561983471 121
3 12 1.4899122807017537 114
3 13 1.7088235294117649 119
3 14 1.530568181818181 88
3 15 1.7603007518796994 133
3 16 2.0814843749999987 128
3 17 1.6096969696969685 132
3 18 1.95421052631579 152
3 19 1.8942361111111121 144
3 20 2.0423741007194245 139
3 21 1.0 1
4 6 11.66 1
4 7 0.5710000000000001 20
4 8 1.1010714285714285 28
4 9 1.2019444444444443 36
4 10 1.179230769230769 52
4 11 1.2903759398496228 133
4 12 1.5974479166666675 192
4 13 1.6062874251497004 167
4 14 2.2533858267716536 127
4 15 1.365737704918034 122
4 16 1.5724390243902442 164
4 17 1.5976744186046525 129
4 18 1.7504032258064515 124
4 19 2.3163265306122454 98
4 20 2.103333333333334 102
5 5 7.342499999999999 4
5 6 1.8559999999999999 5
5 7 0.7925 4
5 8 2.6052173913043477 23
5 9 2.4108474576271184 59
5 10 2.2997222222222224 72
5 11 1.9571698113207545 106
5 12 1.736742424242425 132
5 13 1.9926206896551717 145
5 14 2.398765432098766 162
5 15 2.110759493670885 158
5 16 2.3280689655172417 145
5 17 1.9351677852348996 149
5 18 1.8156626506024092 83
5 19 2.02109375 64
5 20 2.0982758620689657 29
6 5 9.6675 4
6 6 1.4700000000000002 2
6 7 3.89 1
6 8 1.621904761904762 21
6 9 3.7002499999999996 40
6 10 2.450769230769232 65
6 11 2.27 124
6 12 2.39796992481203 133
6 13 2.2914485981308412 214
6 14 2.3938116591928247 223
6 15 2.371956521739131 184
6 16 2.1355978260869573 184
6 17 1.7089759036144578 166
6 18 1.8107382550335565 149
6 19 2.017964601769911 113
6 20 2.5155405405405404 74
Raw
trip_time_weekday.csv
o weekday mean count
0 Sunday 21.83464005702067 1403
1 Monday 17.450996015936255 1255
2 Tuesday 17.994462025316455 1264
3 Wednesday 17.338255977496484 1422
4 Thursday 17.331772575250834 1495
5 Friday 23.46641791044776 1340
6 Saturday 24.98173246906305 1697
Raw
trip_time_weekday_hour.csv
weekday hour mean count
0 4 38.0 2
0 5 87.0 1
0 6 6.166666666666667 6
0 7 8.222222222222221 9
0 8 10.75 32
0 9 13.783783783783784 37
0 10 23.081967213114755 61
0 11 21.695238095238096 105
0 12 16.605042016806724 119
0 13 22.24705882352941 170
0 14 23.396825396825395 126
0 15 25.658536585365855 123
0 16 27.885245901639344 122
0 17 17.142857142857142 133
0 18 18.85211267605634 142
0 19 25.46323529411765 136
0 20 27.037974683544302 79
1 6 7.833333333333333 6
1 7 8.4 20
1 8 9.0 35
1 9 10.886363636363637 44
1 10 9.9375 32
1 11 14.2125 80
1 12 14.247787610619469 113
1 13 20.655913978494624 93
1 14 17.46153846153846 91
1 15 20.019607843137255 102
1 16 15.727272727272727 132
1 17 16.864406779661017 118
1 18 21.9 160
1 19 20.95689655172414 116
1 20 20.363636363636363 110
1 21 11.333333333333334 3
2 5 5.0 1
2 6 11.5 10
2 7 11.727272727272727 22
2 8 6.21875 32
2 9 16.204545454545453 44
2 10 12.44 50
2 11 17.71153846153846 104
2 12 13.360655737704919 122
2 13 16.625 88
2 14 18.142857142857142 112
2 15 16.75206611570248 121
2 16 21.882882882882882 111
2 17 15.88695652173913 115
2 18 25.245098039215687 102
2 19 20.224 125
2 20 23.61904761904762 105
3 5 4.000000000000001 1
3 6 5.5 4
3 7 8.26086956521739 23
3 8 8.484848484848484 33
3 9 13.03448275862069 29
3 10 14.508196721311476 61
3 11 12.859504132231406 121
3 12 14.342105263157896 114
3 13 16.30252100840336 119
3 14 14.681818181818182 88
3 15 17.842105263157894 133
3 16 22.1171875 128
3 17 17.083333333333332 132
3 18 20.026315789473685 152
3 19 18.930555555555557 144
3 20 23.0431654676259 139
3 21 41.0 1
4 6 185.0 1
4 7 6.65 20
4 8 9.428571428571429 28
4 9 15.833333333333334 36
4 10 13.173076923076923 52
4 11 13.24812030075188 133
4 12 17.098958333333332 192
4 13 16.059880239520957 167
4 14 21.866141732283463 127
4 15 15.40983606557377 122
4 16 14.640243902439025 164
4 17 19.782945736434108 129
4 18 18.032258064516128 124
4 19 22.153061224489797 98
4 20 22.84313725490196 102
5 5 46.75000000000001 4
5 6 22.0 5
5 7 7.5 4
5 8 23.347826086956523 23
5 9 26.677966101694917 59
5 10 24.444444444444443 72
5 11 18.764150943396228 106
5 12 21.856060606060606 132
5 13 20.620689655172413 145
5 14 26.598765432098766 162
5 15 25.841772151898734 158
5 16 25.26206896551724 145
5 17 21.87248322147651 149
5 18 26.927710843373493 83
5 19 19.03125 64
5 20 21.24137931034483 29
6 5 70.25 4
6 6 11.0 2
6 7 22.0 1
6 8 13.238095238095237 21
6 9 29.575 40
6 10 19.53846153846154 65
6 11 24.766129032258064 124
6 12 25.827067669172934 133
6 13 24.92056074766355 214
6 14 26.748878923766817 223
6 15 31.33695652173913 184
6 16 23.690217391304348 184
6 17 22.63855421686747 166
6 18 19.97986577181208 149
6 19 23.451327433628318 113
6 20 27.35135135135135 74
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment