Input
iVBORw0KGgoAAAANSUhEUgAAAXoAAAA0CAIAAAAL52RvAAAABGdBTUEAALGPC/xhBQAAAAlwSFlzAAAScQAAEnEB89x6jgAAABJ0RVh0U29mdHdhcmUAR3JlZW5zaG90XlUIBQAADRxJREFUeF7tnd+OFccRh/0GzhvEb4DfwH4D+w3sN0jewFxxhxIpcGEJCS4s+WKJsYR9w14kYq8WIWE2CgqKMVqL4FUQ8kIisCVL5NtTvZXa6j/TZ2fm7J51fWqNTtdU93QPU7+pnjNneetNEATBSgi5CYJgRYTcBEGwIk5Gbv7y5D83Hu2nSrAOPHny5O7du7u7u6keBMuzarl5/OLn97/49q0/fUNJpmAdCLkJxrNSubn37NVvPv2baM2ycvPjT7+c395DqhCsZApWSMhNMJ6Vys0n2z+o1iwlN1anWIgla7BCQm6C8ayH3Lz96Y62Crk5EUJugvGsh9zYViE3J0LITTCekJugi5CbYDwhN0EXITfBeEJugi5CboLxhNwEXYTcBOMZkJsff/rlj988+3jz+/e/+Na+MkN59/OH2Nl779mr5D3EycoN4zy/vff72/9iLmz5/OWjF2lfMETITTCeAbn54KvvbKjXyjvXHhDAgy/gLSU3f7j3b3SBgq7ZVmgcSmHLoABdffDcaaUW7PSAqibXEuz965P/Skmmxe8wRLlEvJJ1AbvUv92zok2sdvNZ+0mmCnaEM70GGXITjGdAbj7a3HXx2SiEbmpWYSm5sZ7t8t6f/5naZBCHTq2KBZ+GLljNRQTxRGLUIiW5LrB2TmCy1kEN1f+31/6erEffNvrd7SfJmuHm2HPEYxByE4xnQG6463LRE8+EHGJhCxYbD1LaiQatrHOyVrCe7dKQm3Of/yN3luLsRGxqk2GdmXWeKLkBWHkalGCwg+QUJesiv1M7pXZuUSLrttbZzf7+PocAPiRTk9evX4s/JFOdTjdFBsMhUn3Bsp3s7e25TsTCNtVLFH0GW4GM2Z09LNYo1R7Ef0LGPip2CjKh3ORKUSs2RC3ucFRtCsNnF6i1fnJtcsUlFDce7du97d++ow7W2YmFPQmsWPMUjBOuDpTaFMYzq9wQCTdv3rx8+fIFA9XNzU0X7QLGra2tK1euJNdDsOzs7CSnDPG5detWqjd5+PCh+Lspi5HRpnqT27dvi7/t5LPPPsPCNtVLFH0WPV24f/9+qpeQI7JN9QXSUI1S7UFOwsWLFxsyxy5xvnPnTjLVGSs37nKfUG6UpQ6huDAmU0g7jmIVh3hO1qPkckNah8QwknvPXrHNVYA1kTq3Vzc2hXFZEtC/7qW4JRXHZcy6F21KO2ZgPrkhfuR6LcK1zkWfXBdwfWNMuxcQltaC6BTDI+2+cGEwR4BLly6Jc1FuYPBUoIk6qgnlph3808oNzoOjHXSwnFm5sTpiH4g4iFh1oxQ7d3JDVNsHukVc3pTrkWKF6eqD58lqcCfNjtAdZXBUY5hJbrglLi7sA4gHG0gciyQC+8bGRjId1Rr2Wn9SJHqQvcWYlFYwGBtWAWtyM9iJRL4wodwAelpM+kAOqsoiSCtnVBibOBT/cTmrsreYVemJaiig5czKjX2uVEttBKsmjDBZDdaBbnui2uVWRR0Bm7zQc02Viksqd1qKI5+QOeSGa1Qu1sYdG7sNLV1AuZRHwV8UB89kOgSjSlVjIpqVSILjPBetUz+NdU2jk5FyI93WVnOTyw1In6xtncbpHDvXp3A25ebYo/rgq++S1WDlJl/v1LAaUewWbHrSWHO56ciSyvZPitRIoCZhDrmRoILOe6PeS2uRI2j8ODkQI7HBluBJ1gyJLtxkeG7KB10sBsC20YnkZWzzTopS4ij6YAE9CUWxk4G58yP+tZOmp6vxjyui6XqQY6E4ToYanE25cd/pJGsFO6qimhxPbuzX25SiHNgUrD0vt2768OvHttpzTkYyudxoll67UedIatNzfTfCVe/JxXCVvXII6aQoN9pJMYZlajjwIe+kODZH0QcL8EG0DHKZFglwoxLn4lChR27UhxmJRf/5amlmkbMpN2QKtkmyVphJbtAXbUXJ11P2C6zG0yWB3uxTHlsk2ZmbyeVG79Kd1ysRLv498qSPhFJ9gVoat2WJZInMXCngoItFJzL+Y3RSlBJH0QcL8IEjivLmCxyZmlOWRbtRcgMbGxv4XL9+Xao9s8jpkhuu9S8fvTi/vcdNVd6j1eJeojslcmMFguLG7Ir9cmdCuQGrehwoWQ+xe3skw50HKStYRgmTy40EBnSupDQqamFjKYaQWORzcXUgd2x2SQxLRLkpH3RxtBP35EJTm1onPYFa9MEC8lkfUWn8C3JW3bwW7cbKDfOSI+KmTTTZ6WRAbh6/+Pnjze/dJd4op1Nu+su0cuNewLHv1Ljcx71uU8MtqSgr+w8t5pObVB9CL/Fa2FjU2Q5YLPJZcxMbMHID10VWrhRw0MVhJ3oU24m00pdQ8k6KUuIo+mCBVKk8yZKz6k5R7mYpnqsikjMyKhlezz+EoyU35P+1nxrVyhxy4x6CzCo3xee1x5YbsCsg+wWZndS57vdlnPL2vLI8FfPJTecdUqOi5yovhpBYUuUwpHVpJk1IWKQK4uCmfNBF1ommGD2diIVtqpco+mCBVFkgj71B+5ez6k6R+NTOm4wZ3EyL6DeDmgMuRVVuuN86rSEq0AsKd1Suey3Wh2pqX+J4cuNatQ8hWIFg2DrUwZLaH2WM3NjB299J2D7zxzo1mIu2kkL/ad/MzCc3nX2yfBD/HrmR12HBaplYUsWEmazmarrghrdo8f9OdFTiJk00P4Jat2xTvUTRBwukyiHu8fnccqMndqknxEpVbuwPf9ovm6gbpRaxwonIzfgUYIzcuBdwZNHkjJ0PX9x50DLr233K5HKjF26PfAjyrCR/oSZHbvs2y4DF0Y6Eq6yeiGpZmLjwlph3Uz7o4mgn8mAYZ4nbwU70oKleQlo5HyyQKoegp/JIRU7L3HKzlHNOVW7sBd1+Tc56nkK5oSTrcRkjN2Cby5m039M3Xrex2BcCXWn8uHRCJpcbkDhpvL3ikMAevNa5z0vPulASpG2qLCBWxSj+7qF1rhSwcPed6ETYOv+8E1EEmqR6CRHWomqkikGFG5FdS7khpO0F3Y7wfs+VyY1rMvK7m5FyYx/TyM+y7Jqo81mvbUKy6V4sYr7JbzbmkBuJDahFgkPVgTt548GBqpJdSYEYU+UQffzhtAk65QZ0Ii4fgbwTXX/ZNZdFQ9rJnxhT5Sg6C1lbrbfcJGsF67mU3BxvEdEjN278/Q9HioyUG6ZpX+ez6jP4uo3gxEVSJDsqytxLqjnkRtMQqP2emECyQqCBTVw5NQE6vH79ujjkHYo9VQ6RMUDeW7/cLNuJGPHPzycSg529uXIdHLgiNyB9CustN+0I7/c8hnCAC7aedMB9zZy/87IUI+UG3GuHWnpet3HP7HUA2K2Kzb2kmkNuQKMLWIygERxC4LMsT1wYa/ICiMvW1harCbbYtas8VQHZlSoGxAJSxdAvN7BUJ0xHh8oUdnZ2FjPe3dzcFCN7XWoDsitVMji69rlmcuOeFDSyA/fUs60g9sZO6Xxs4bSvs5WL8DEJzni5cVPQIk+O29ijoy+2STHrmYmZ5AaIK1kCFCFc88BjGSJPN3Kw1xYp4pAqHSwlNzWKnUBj1kwhnzLI3lQpoVqwZnID9s75zrUHeWAgSfkbgNxj5e8Hk1DkEZ4/78RTeiYfkReX80WBUzSK/l1ktv2tcCsu3xqHFsbLDeQ/QTjX8bqNE5T8GY0dG0mQnJY5mE9uBDIUUhKCk1s08cYHllHtw9GEENrY2MCZLZ+xpH0lcINU6YAB4O8if5JOFJSRkYvuMGs+17QSeg7NGcg7kYa1nhmbONQGaVnKOacqN/kLrCiI/AcGH3792L74XyvFb6BrP/zRMvib7GIpLiXc2k0KnjIR+UGGnUhtPTKJ3OSDGUy40A67jCrKk1PVkcvGBnPLTfBroCo33PMHpYGCT0ML8nyhtqzQUhSpPC3KS3I9Su2hSa0U059J5CbPtorHsrgTW0u+nJDNtKQKuQnGU5Ub4PrOX2O1hQyImCGQ7MpLi3vQoHBXL/pLqf1pmBuP9hutGguTPE1rlOKAJ5EbsP0MPoFyz7nQlLSjhP1nmmlJFXITjKclNwLXPRKgmQ4xT9hwC7U3Zz4TP+rD1U+QNy56/OmBbulKOqQQUbUbuFBsxYEGv6tiJAyvoVaMvDFgBiZt2Q6ugBowcj3i4JiZqUxQ5pisFThv6kxpn8bjEXITjGdYbs4SxCFxjnxIIaRZ3M2RC+RwFNUaZCtZ14eQm2A8vy65OUHsmm4wWzmFhNwE4wm5WQUsA+13TKvJp6Yl5CYYT8jNKmDhplrz3oiHzSdIyE0wnpCb2bn37JVNbdovXp9aQm6C8YTczAhrqPPbe1Zr1jS1gZCbYDwhNxODoCAr7x79i/FS3q7/x3Wnn5CbYDwhNxPjJEYLWjPH6zArI+QmGE/IzcQ4lZHy0ebu+uY1QshNMJ6Qm4nR957ZfrL9w9UHz9fxa++cly9fPn36NP/zUUHQT8hNEAQrIuQmCIIVEXITBMFKePPmf4GyDTAL6GK4AAAAAElFTkSuQmCC
Weekly Challenge #351
C:\Users\karlh\AppData\Local\Temp\Engine_19404_f229f88fbfd041099b9ded7e3582963a_\Engine_3248_c5f80a9fd9df4ea6985ee7ee0e2b9527_.yxdb
Single
Profile
C:\Users\karlh\AppData\Local\Temp\Engine_19404_f229f88fbfd041099b9ded7e3582963a_\Engine_3248_dc185bbf0b24482e9d387ea6052626c9_.yxdb
Single
Profile
uber_nyc.csv
True
False
False
1
254
False
DoubleQuotes
,
False
28591
uber_nyc.csv
2015-01-01
Bronx
1075
2015-01-01
Brooklyn
12528
2015-01-01
Manhattan
35870
2015-01-01
Queens
5108
2015-01-01
Staten Island
53
2015-01-02
Bronx
545
2015-01-02
Brooklyn
7311
2015-01-02
Manhattan
27423
2015-01-02
Queens
4346
2015-01-02
Staten Island
22
2015-01-03
Bronx
719
2015-01-03
Brooklyn
11007
2015-01-03
Manhattan
41691
2015-01-03
Queens
5773
2015-01-03
Staten Island
23
2015-01-04
Bronx
590
2015-01-04
Brooklyn
8715
2015-01-04
Manhattan
27403
2015-01-04
Queens
6486
2015-01-04
Staten Island
16
2015-01-05
Bronx
487
2015-01-05
Brooklyn
6537
2015-01-05
Manhattan
30879
2015-01-05
Queens
5649
2015-01-05
Staten Island
19
2015-01-06
Bronx
601
2015-01-06
Brooklyn
7056
2015-01-06
Manhattan
41277
2015-01-06
Queens
4434
2015-01-06
Staten Island
13
2015-01-07
Bronx
590
2015-01-07
Brooklyn
8767
2015-01-07
Manhattan
49347
2015-01-07
Queens
4238
2015-01-07
Staten Island
22
2015-01-08
Bronx
704
2015-01-08
Brooklyn
9345
2015-01-08
Manhattan
57734
2015-01-08
Queens
5024
2015-01-08
Staten Island
17
2015-01-09
Bronx
758
2015-01-09
Brooklyn
9793
2015-01-09
Manhattan
55004
2015-01-09
Queens
5404
2015-01-09
Staten Island
37
2015-01-10
Bronx
793
2015-01-10
Brooklyn
14436
2015-01-10
Manhattan
59148
2015-01-10
Queens
5700
2015-01-10
Staten Island
25
2015-01-11
Bronx
707
2015-01-11
Brooklyn
11845
2015-01-11
Manhattan
42733
2015-01-11
Queens
5729
2015-01-11
Staten Island
16
2015-01-12
Bronx
644
2015-01-12
Brooklyn
7455
2015-01-12
Manhattan
45936
2015-01-12
Queens
4857
2015-01-12
Staten Island
23
2015-01-13
Bronx
631
2015-01-13
Brooklyn
7856
2015-01-13
Manhattan
51780
2015-01-13
Queens
4125
2015-01-13
Staten Island
23
2015-01-14
Bronx
673
2015-01-14
Brooklyn
8360
2015-01-14
Manhattan
51588
2015-01-14
Queens
4033
2015-01-14
Staten Island
25
2015-01-15
Bronx
726
2015-01-15
Brooklyn
8972
2015-01-15
Manhattan
53169
2015-01-15
Queens
4907
2015-01-15
Staten Island
25
2015-01-16
Bronx
856
2015-01-16
Brooklyn
10460
2015-01-16
Manhattan
56240
2015-01-16
Queens
5478
2015-01-16
Staten Island
33
2015-01-17
Bronx
991
2015-01-17
Brooklyn
15241
2015-01-17
Manhattan
53218
2015-01-17
Queens
5761
2015-01-17
Staten Island
34
2015-01-18
Bronx
1029
2015-01-18
Brooklyn
14355
2015-01-18
Manhattan
54725
2015-01-18
Queens
6018
2015-01-18
Staten Island
31
2015-01-19
Bronx
618
2015-01-19
Brooklyn
8355
2015-01-19
Manhattan
32283
2015-01-19
Queens
6083
2015-01-19
Staten Island
21
2015-01-20
Bronx
626
2015-01-20
Brooklyn
7414
2015-01-20
Manhattan
42411
2015-01-20
Queens
5178
2015-01-20
Staten Island
26
2015-01-21
Bronx
631
2015-01-21
Brooklyn
8112
2015-01-21
Manhattan
47292
2015-01-21
Queens
4182
2015-01-21
Staten Island
36
2015-01-22
Bronx
682
2015-01-22
Brooklyn
8565
2015-01-22
Manhattan
52214
2015-01-22
Queens
4777
2015-01-22
Staten Island
20
2015-01-23
Bronx
774
2015-01-23
Brooklyn
10293
2015-01-23
Manhattan
55833
2015-01-23
Queens
5360
2015-01-23
Staten Island
34
2015-01-24
Bronx
880
2015-01-24
Brooklyn
15206
2015-01-24
Manhattan
60549
2015-01-24
Queens
5835
2015-01-24
Staten Island
45
2015-01-25
Bronx
771
2015-01-25
Brooklyn
12655
2015-01-25
Manhattan
41530
2015-01-25
Queens
6268
2015-01-25
Staten Island
25
2015-01-26
Bronx
590
2015-01-26
Brooklyn
6361
2015-01-26
Manhattan
34128
2015-01-26
Queens
3964
2015-01-26
Staten Island
16
2015-01-27
Bronx
337
2015-01-27
Brooklyn
4071
2015-01-27
Manhattan
19242
2015-01-27
Queens
1613
2015-01-27
Staten Island
16
2015-01-28
Bronx
729
2015-01-28
Brooklyn
8625
2015-01-28
Manhattan
46541
2015-01-28
Queens
5253
2015-01-28
Staten Island
21
2015-01-29
Bronx
743
2015-01-29
Brooklyn
9179
2015-01-29
Manhattan
54329
2015-01-29
Queens
5364
2015-01-29
Staten Island
27
2015-01-30
Bronx
942
2015-01-30
Brooklyn
12153
2015-01-30
Manhattan
65081
2015-01-30
Queens
5826
2015-01-30
Staten Island
35
2015-01-31
Bronx
1019
2015-01-31
Brooklyn
17983
2015-01-31
Manhattan
68945
2015-01-31
Queens
6438
2015-01-31
Staten Island
42
pickup_date
ParseComplex
pickup_date
Warn
pickup_date_Matched
just
date
just
date
workDate
English
MM/dd/yy
useDate
rational
date
Convert workDate From:
MM/dd/yy
DateTimeMonth([useDate]) = 1
Custom
January
DateTimeMonth([useDate]) = 1
sum
by date
by borough
sum
by date
by borough
retype
retype
Horizontal
solution_351