traffic_data_maricopa.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "32d3b9d1",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "     index  SiteID       Date  weekofyear  dayofweek                             OnRoad Direction                                   RefRoad Travel ADT 2020    AM_Hour  AM_Volume   PM_Hour  PM_Volume\n",
      "0        0  3712.0 2020-08-26          35          2                            7th Ave        N                               Carefree Hwy     B      5893       8.25      427.0  15:45:00      533.0\n",
      "1        1  4350.0 2020-09-02          36          2                            7th Ave        N                                   Cloud Rd     B      4535        7.5      319.0  15:15:00      375.0\n",
      "2        2  7086.0 2020-09-02          36          2                            7th Ave         S                                  Cloud Rd      B     5443        7.0      382.0  15:15:00      434.0\n",
      "3        3  7094.0 2020-09-14          38          0                            7th Ave         N                           Desert Hills Dr      B      885       10.5       77.0  16:00:00       81.0\n",
      "4        4  3726.0 2020-09-14          38          0                            7th Ave        N                               Joy Ranch Rd     B      2459       7.25      190.0  16:30:00      210.0\n",
      "5       16  4773.0 2020-09-14          38          0                           19th Ave        S                            Desert Hills Dr     B       661       7.25       53.0  12:15:00       55.0\n",
      "6       34  4408.0 2020-07-20          30          0                            56th St        N                                Dixileta Dr     B      2781       10.5      259.0  15:45:00      211.0\n",
      "7       35  4416.0 2020-07-20          30          0                            56th St        N                              Dynamite Blvd     B      2115       8.25      165.0  15:15:00      172.0\n",
      "8       36  7135.0 2020-07-20          30          0                            56th St         N                             Montgomery Rd      B     2404       10.5      199.0  15:30:00      201.0\n",
      "9       37  7069.0 2020-05-06          19          2                     56th St - Mesa         N                             University Dr      B      955       9.75       84.0  14:30:00       80.0\n",
      "10      38  7070.0 2020-05-06          19          2                     56th St - Mesa         S                             University Dr      B     1128      11.25       91.0  16:30:00       93.0\n",
      "11     263  3589.0 2020-01-08           2          2                     Alma School Rd        N                                   Hunt Hwy     B      3114       7.25      248.0  15:45:00      313.0\n",
      "12     264  3634.0 2020-01-29           5          2                     Alma School Rd        N                               McKellips Rd     B      9885        7.5     1269.0  17:00:00     1132.0\n",
      "13     265  3632.0 2020-01-27           5          0                     Alma School Rd         N                               McLellan Rd      B    11894        7.0     1177.0  16:45:00      857.0\n",
      "14     266  8293.0 2020-01-27           5          0                     Alma School Rd         N                               McLellan Rd      N        B        7.0     1177.0  16:45:00      857.0\n",
      "15     267  8294.0 2020-01-27           5          0                     Alma School Rd         N                               McLellan Rd      S    15271       7.75      998.0  17:00:00     1766.0\n",
      "16     268  3587.0 2020-01-15           3          2                     Alma School Rd        N                                   Riggs Rd     B     17935      11.25     1412.0  15:15:00     1564.0\n",
      "17     269  5001.0 2020-01-15           3          2                     Alma School Rd         S                                  Riggs Rd      B    10938      11.25      974.0  12:15:00      935.0\n",
      "18     270  4069.0 2020-01-27           5          0                     Alma School Rd        N   SR 202 Red Mountain   (Negative Roadway)     B      8538        7.5     1408.0  17:00:00      861.0\n",
      "19     467  4771.0 2020-08-25          35          1                        Central Ave        N                               Carefree Hwy     B       347      11.25       34.0  13:30:00       32.0\n",
      "20     504  7048.0 2020-02-18           8          1  Country Club Dr - Maricopa County         E                              Lindgren Ave      B      934      11.25      106.0  14:15:00       90.0\n",
      "21     583  3605.0 2020-01-08           2          2                          Dobson Rd        N                                   Hunt Hwy     B      2399        7.0      188.0  16:00:00      195.0\n",
      "22     584  7032.0 2020-01-07           2          1                          Dobson Rd         S                                  Riggs Rd      B     4527      11.25      357.0  12:30:00      378.0\n",
      "23     310  3766.0 2020-11-16          47          0                        Baseline Rd         E                                  67th Ave      B    16322       7.25     1098.0  15:45:00     1455.0\n",
      "24     311  3768.0 2020-11-16          47          0                        Baseline Rd         W                                  67th Ave      B    10890       7.25      667.0  17:00:00     1059.0\n",
      "25     312  4002.0 2020-11-16          47          0                        Baseline Rd         W                                  83rd Ave      B     4814       6.75      308.0  16:00:00      629.0\n",
      "26     313  3770.0 2020-11-16          47          0                        Baseline Rd         E                                  91st Ave      B     4849       6.75      313.0  15:45:00      621.0\n",
      "27     314  3772.0 2020-11-16          47          0                        Baseline Rd         W                                  91st Ave      B      283       8.75       21.0  12:15:00       30.0\n",
      "28     315  3287.0 2020-10-19          43          0                        Baseline Rd         E                                 331st Ave      B     4372        5.5      358.0  16:30:00      409.0\n",
      "29     316  3335.0 2020-12-02          49          2                        Baseline Rd         E                                 523rd Ave      B      203      11.25       22.0  13:45:00       23.0\n",
      "30     317  3336.0 2020-12-02          49          2                        Baseline Rd         W                                 535th Ave      B      132      11.25       16.0  13:45:00       19.0\n",
      "31     318  3170.0 2020-12-14          51          0                        Baseline Rd         E                                 Apache Rd      B     6778      11.25      469.0  15:30:00      660.0\n",
      "32     319  3471.0 2020-12-02          49          2                        Baseline Rd         E                      Harquahala Valley Rd      B      280       7.25       21.0  14:15:00       50.0\n",
      "33     320  3222.0 2020-09-14          38          0                        Baseline Rd         E                                Johnson Rd      B     3810        5.5      287.0  15:45:00      326.0\n",
      "34     321  3221.0 2020-09-14          38          0                        Baseline Rd         W                                Johnson Rd      B     3643        5.5      293.0  15:45:00      303.0\n",
      "35     322  7064.0 2020-02-18           8          1                        Baseline Rd         W                               Meridian Rd      B    12169      11.25      798.0  15:45:00     1317.0\n",
      "36     323  7171.0 2020-12-14          51          0                        Baseline Rd         W                                 Miller Rd      B     3286       11.0      217.0  16:30:00      331.0\n",
      "37     324  3171.0 2020-12-14          51          0                        Baseline Rd         E                                   Rail Rd      B     1588      11.25      106.0  16:15:00      208.0\n",
      "38     325  7279.0 2020-10-19          43          0                        Baseline Rd         E                                Salome Hwy      B     2301       5.25      192.0  17:15:00      252.0\n",
      "39     326  7172.0 2020-12-14          51          0                        Baseline Rd         E                                     SR 85      B     2752      10.75      196.0  16:15:00      255.0\n",
      "40     327  3271.0 2020-08-31          36          0                        Baseline Rd         W                                     SR 85      B     4836       4.75      354.0  15:15:00      346.0\n",
      "41     328  7256.0 2020-09-01          36          1                        Baseline Rd         E                                 Turner Rd      B     4481       6.75      334.0  16:30:00      353.0\n",
      "42     357  3321.0 2020-11-03          45          1                        Broadway Rd         E                                  35th Ave      B    21015        7.0     1409.0  16:00:00     1797.0\n",
      "43     358  8249.0 2020-11-03          45          1                        Broadway Rd         E                                  35th Ave      E    10745      10.25      552.0  16:00:00     1209.0\n",
      "44     359  8250.0 2020-11-03          45          1                        Broadway Rd         E                                  35th Ave      W    10270       7.25     1031.0  14:45:00      697.0\n",
      "45     360  4732.0 2020-11-04          45          2                        Broadway Rd         E                                  43rd Ave      B    19178        7.5     1447.0  17:00:00     1613.0\n",
      "46     361  8253.0 2020-11-04          45          2                        Broadway Rd         E                                  43rd Ave      E     8455       7.25      967.0  15:15:00      535.0\n",
      "47     362  8254.0 2020-11-04          45          2                        Broadway Rd         E                                  43rd Ave      W    10723       7.75      528.0  17:00:00     1206.0\n",
      "48     363  3750.0 2020-11-04          45          2                        Broadway Rd         W                                  51st Ave      B    11625        6.0      849.0  16:45:00      887.0\n",
      "49     364  3776.0 2020-11-17          47          1                        Broadway Rd         E                                  67th Ave      B    13631        7.0     1003.0  16:30:00     1104.0\n",
      "50     365  3778.0 2020-11-17          47          1                        Broadway Rd         E                                  83rd Ave      B     8532       7.25      582.0  17:30:00      754.0\n",
      "51     366  3478.0 2020-11-17          47          1                        Broadway Rd         E                                  91st Ave      B     9232       7.25      616.0  16:15:00      823.0\n",
      "52     367  3364.0 2020-10-20          43          1                        Broadway Rd         W                                 339th Ave      B      501        7.5       37.0  17:00:00       70.0\n",
      "53     368  7285.0 2020-10-28          44          2                        Broadway Rd         E                                 355th Ave      B      351       7.75       25.0  17:15:00       51.0\n",
      "54     369  3195.0 2020-11-18          47          2                        Broadway Rd         E                             Avondale Blvd      B     3172       7.75      175.0  16:30:00      387.0\n",
      "55     370  4272.0 2020-02-24           9          0                        Broadway Rd        W                               Ellsworth Rd     B     23452        7.5     1643.0  15:45:00     1972.0\n",
      "56     371  3244.0 2020-09-08          37          1                        Broadway Rd         E                                Johnson Rd      B       41       7.75       10.0  15:15:00        4.0\n",
      "57     372  7067.0 2020-03-09          11          0                        Broadway Rd         W                               Meridian Rd      B    11136      11.25      776.0  16:45:00     1002.0\n",
      "58     373  3180.0 2020-12-14          51          0                        Broadway Rd         E                                Rainbow Rd      B     2630       7.75      196.0  16:45:00      276.0\n",
      "59     374  3664.0 2020-03-09          11          0                        Broadway Rd        E                            Signal Butte Rd     B     12562       11.0      874.0  15:30:00     1089.0\n",
      "60     375  3249.0 2020-12-14          51          0                        Broadway Rd         E                                     SR 85      B     1627      11.25      108.0  14:45:00      147.0\n",
      "61     376  3188.0 2020-12-09          50          2                        Broadway Rd         E                                Verrado Wy      B     1997        7.0      112.0  16:45:00      237.0\n",
      "62     385  3920.0 2020-10-21          43          2                         Buckeye Rd         W                                 339th Ave      B     1399        6.5      134.0  15:00:00      138.0\n",
      "63     386  3359.0 2020-10-26          44          0                         Buckeye Rd         E                                 355th Ave      B     1078        6.5      218.0  16:30:00       80.0\n",
      "64     387  4706.0 2020-10-26          44          0                         Buckeye Rd         W                                 355th Ave      B     1022        6.5      132.0  14:30:00       75.0\n",
      "65     388  7290.0 2020-10-26          44          0                         Buckeye Rd         W                                 363rd Ave      B      828        6.5       96.0  16:30:00       68.0\n",
      "66     390  3338.0 2020-11-30          49          0                         Buckeye Rd         W                      Harquahala Valley Rd      B       55        8.0        5.0  13:00:00        8.0\n",
      "67     391  3928.0 2020-11-16          47          0                         Buckeye Rd         E                                Salome Hwy      B      174       11.0       21.0  19:00:00       14.0\n",
      "68     409  2863.0 2020-06-09          24          1                       Camelback Rd         E                                 152nd Ave      B    13671       7.25     1133.0  16:45:00     1126.0\n",
      "69     410  2901.0 2020-05-13          20          2                       Camelback Rd         E                                 Dysart Rd      B    19258       7.25     1157.0  15:30:00     2235.0\n",
      "70     411  8243.0 2020-05-13          20          2                       Camelback Rd         E                                 Dysart Rd      E     9843       7.25      330.0  14:00:00     1589.0\n",
      "71     412  8244.0 2020-05-13          20          2                       Camelback Rd         E                                 Dysart Rd      W     9415        7.0      832.0  15:30:00      699.0\n",
      "72     413  2995.0 2020-05-11          20          0                       Camelback Rd         E                              El Mirage Rd      B    22662       6.75     1703.0  16:45:00     1824.0\n",
      "73     414  4910.0 2020-05-27          22          2                       Camelback Rd         E                             Litchfield Rd      E     8070       7.25      566.0  16:45:00      603.0\n",
      "74     415  4911.0 2020-05-27          22          2                       Camelback Rd         E                             Litchfield Rd      W     8082       6.75      491.0  17:15:00      692.0\n",
      "75     416  4912.0 2020-05-27          22          2                       Camelback Rd         W                             Litchfield Rd      B    17591       7.25     1438.0  16:15:00     1345.0\n",
      "76     417  2859.0 2020-06-09          24          1                       Camelback Rd        E                                Sarival Ave     B     12781        7.0      828.0  16:00:00      899.0\n",
      "77     745  7199.0 2020-05-11          20          0                   Indian School Rd         W                                  99th Ave      B    30891       7.25     2151.0  16:15:00     2496.0\n",
      "78     746  2903.0 2020-05-11          20          0                   Indian School Rd         E                                 107th Ave      B    25902       7.75     1690.0  17:00:00     2124.0\n",
      "79     747  7200.0 2020-05-11          20          0                   Indian School Rd         W                                 107th Ave      B    26160       7.75     1690.0  17:00:00     2165.0\n",
      "80     748  7218.0 2020-06-10          24          2                   Indian School Rd         W                                 195th Ave      B     8835       10.0      622.0  13:15:00      654.0\n",
      "81     749  8245.0 2020-06-10          24          2                   Indian School Rd         W                                 195th Ave      E     4250      11.25      262.0  16:00:00      325.0\n",
      "82     750  8246.0 2020-06-10          24          2                   Indian School Rd         W                                 195th Ave      W     4585      10.25      372.0  13:15:00      382.0\n",
      "83     751  3356.0 2020-07-20          30          0                   Indian School Rd        E                                  355th Ave     B      1134        9.5       88.0  16:30:00       85.0\n",
      "84     752  3355.0 2020-07-20          30          0                   Indian School Rd        W                                  355th Ave     B       899        9.5       68.0  13:00:00       79.0\n",
      "85     753  3429.0 2020-07-22          30          2                   Indian School Rd         E                                 411th Ave      B      227      10.25       19.0  15:15:00       27.0\n",
      "86     754  3350.0 2020-11-23          48          0                   Indian School Rd         W                                 411th Ave      B     1235       10.5       97.0  12:30:00       98.0\n",
      "87     755  3006.0 2020-05-11          20          0                   Indian School Rd         E                              El Mirage Rd      B    21735       7.75     1500.0  16:00:00     1883.0\n",
      "88     756  4717.0 2020-11-23          48          0                   Indian School Rd         E                                Salome Hwy      B        4      10.75        1.0  12:15:00        1.0\n",
      "89     757  7229.0 2020-07-22          30          2                   Indian School Rd         E                            Wintersburg Rd      B      529       10.0       35.0  15:45:00       46.0\n",
      "90     758  3354.0 2020-07-22          30          2                   Indian School Rd         W                            Wintersburg Rd      B     1407        7.5       98.0  14:45:00      122.0\n",
      "91     857  3689.0 2020-05-19          21          1                        McDowell Rd        E                                    78th St     B      5580       9.75      436.0  17:15:00      413.0\n",
      "92     858  3631.0 2020-01-22           4          2                        McDowell Rd         E                            Alma School Rd      B    12092       7.25     1318.0  17:00:00     1446.0\n",
      "93     859  4318.0 2020-01-22           4          2                        McDowell Rd        W                             Alma School Rd     B      8636       7.25     1278.0  17:00:00      777.0\n",
      "94     860  4035.0 2020-05-19          21          1                        McDowell Rd        E                                   Hawes Rd     B      2426       9.75      200.0  17:45:00      165.0\n",
      "95     861  2930.0 2020-06-10          24          2                        McDowell Rd        E                              Jackrabbit Tr     B      2254      10.75      182.0  13:45:00      171.0\n",
      "96     862  2931.0 2020-06-10          24          2                        McDowell Rd        W                              Jackrabbit Tr     B      1895       7.75      112.0  16:15:00      154.0\n",
      "97     863  4324.0 2020-01-14           3          1                        McDowell Rd        E                                Longmore Rd     B     13973       7.25     1647.0  16:45:00     1763.0\n",
      "98     864  4320.0 2020-01-22           4          2                        McDowell Rd         W                                     SR 87      B    12972       7.25     1681.0  17:00:00     1503.0\n",
      "99     865  7227.0 2020-07-13          29          0                        McDowell Rd         W                           Sun Valley Pkwy      B      167       9.25       21.0  13:15:00       30.0\n",
      "100    866  4797.0 2020-05-19          21          1                        McDowell Rd        W                              Usery Pass Rd     B      2973       9.75      248.0  15:45:00      221.0\n",
      "101    982  3026.0 2020-01-08           2          2                         Peoria Ave        E                                   99th Ave     B         2  15.683333        0.0  12:15:00        1.0\n",
      "102    983  3015.0 2020-01-13           3          0                         Peoria Ave         E                                 105th Ave      E     4154      11.25      384.0  12:15:00      376.0\n",
      "103    984  3016.0 2020-01-13           3          0                         Peoria Ave        E                                  105th Ave     W      4522      10.75      364.0  15:15:00      453.0\n",
      "104    985  2962.0 2020-01-13           3          0                         Peoria Ave         E                                 108th Ave      E     2829       8.25      240.0  13:30:00      226.0\n",
      "105    986  2963.0 2020-01-13           3          0                         Peoria Ave        E                                  108th Ave     W      3228       11.0      232.0  16:15:00      368.0\n",
      "106    987  7300.0 2020-01-13           3          0                         Peoria Ave         W                                 111th Ave      B     2909       8.25      177.0  16:30:00      251.0\n",
      "107    988  3028.0 2020-01-13           3          0                         Peoria Ave        E                                  Balboa Dr     E      4477      11.25      393.0  12:30:00      385.0\n",
      "108    989  3027.0 2020-01-13           3          0                         Peoria Ave         E                                 Balboa Dr      W     4695      11.25      376.0  15:15:00      481.0\n",
      "109    990  2979.0 2020-06-02          23          1                         Peoria Ave        E                                Bullard Ave     B      5445       7.25      347.0  15:45:00      447.0\n",
      "110    991  7215.0 2020-06-24          26          2                         Peoria Ave         W                                 Citrus Rd      B     7159       8.25      494.0  16:15:00      630.0\n",
      "111    992  2978.0 2020-06-04          23          3                         Peoria Ave        E                              Litchfield Rd     B      3472       10.0      284.0  14:45:00      254.0\n",
      "112    993  2848.0 2020-06-02          23          1                         Peoria Ave        E                                Sarival Ave     B      5260      10.25      330.0  13:45:00      419.0\n",
      "113   1188  2922.0 2020-06-17          25          2                          Thomas Rd         W                             Perryville Rd      B     1103        8.5       82.0  17:00:00       98.0\n",
      "114   1222  3670.0 2020-05-13          20          2                      University Dr        E                                 Crismon Rd     B     14506       7.75      847.0  15:15:00     1150.0\n",
      "115   1223  3649.0 2020-05-13          20          2                      University Dr        E                                  Higley Rd     B     13377      10.25      873.0  16:00:00     1082.0\n",
      "116   1224  4282.0 2020-05-13          20          2                      University Dr        W                                Meridian Rd     B     11356      10.75      780.0  15:15:00      876.0\n",
      "117   1225  3650.0 2020-05-13          20          2                      University Dr        W                                   Power Rd     B     12499      11.25      793.0  16:45:00      986.0\n",
      "118   1226  4280.0 2020-05-13          20          2                      University Dr        E                            Signal Butte Rd     B     12046      10.75      775.0  15:15:00      926.0\n",
      "119   1276  2914.0 2020-12-07          50          0                            Yuma Rd         E                                 Citrus Rd      B     7645      11.25      492.0  17:00:00      773.0\n",
      "120   1277  2933.0 2020-12-07          50          0                            Yuma Rd         E                             Jackrabbit Tr      B     5757      11.25      408.0  15:45:00      603.0\n",
      "121   1278  3858.0 2020-09-08          37          1                            Yuma Rd         W                             Palo Verde Rd      B     1181      11.25       93.0  12:30:00       88.0\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "                                OnRoad                                   RefRoad Direction   AM_Hour  AM_Volume\n",
      "0                             19th Ave                           Desert Hills Dr        S    6.90181       68.0\n",
      "1                             19th Ave                           Desert Hills Dr        S   6.395036       38.0\n",
      "2                              56th St                             Dynamite Blvd        N   6.026927      201.0\n",
      "3                              7th Ave                              Carefree Hwy        N   6.457689      411.0\n",
      "4                              7th Ave                                  Cloud Rd         S       7.0      382.0\n",
      "5                              7th Ave                                  Cloud Rd         S   6.01157      342.0\n",
      "6                              7th Ave                                  Cloud Rd         S  6.358126      462.0\n",
      "7                              7th Ave                           Desert Hills Dr         N  6.898547      518.0\n",
      "8                       Alma School Rd                               McLellan Rd         N       7.0     1177.0\n",
      "9                       Alma School Rd                               McLellan Rd         N       7.0     1177.0\n",
      "10                      Alma School Rd                               McLellan Rd         N  6.876722     1426.0\n",
      "11                      Alma School Rd                               McLellan Rd         N  6.102585     1146.0\n",
      "12                      Alma School Rd                               McLellan Rd         N  6.951482     1245.0\n",
      "13                      Alma School Rd                                  Riggs Rd         S  6.689184      994.0\n",
      "14                      Alma School Rd                                  Riggs Rd         S  6.852166     1194.0\n",
      "15                      Alma School Rd                                  Riggs Rd        N   6.934415     1167.0\n",
      "16                      Alma School Rd  SR 202 Red Mountain   (Negative Roadway)        N   6.077048     1183.0\n",
      "17                         Baseline Rd                                 331st Ave         E  6.369641      706.0\n",
      "18                         Baseline Rd                                 331st Ave         E  6.771415      858.0\n",
      "19                         Baseline Rd                                 535th Ave         W  6.898239      929.0\n",
      "20                         Baseline Rd                                  67th Ave         E  6.812107      928.0\n",
      "21                         Baseline Rd                                  83rd Ave         W      6.75      308.0\n",
      "22                         Baseline Rd                                  83rd Ave         W  6.129906      666.0\n",
      "23                         Baseline Rd                                  91st Ave         E      6.75      313.0\n",
      "24                         Baseline Rd                                  91st Ave         W   6.27887      680.0\n",
      "25                         Baseline Rd                                  91st Ave         W   6.79997      884.0\n",
      "26                         Baseline Rd                      Harquahala Valley Rd         E  6.050258      560.0\n",
      "27                         Baseline Rd                               Meridian Rd         W  6.332726      679.0\n",
      "28                         Baseline Rd                                Salome Hwy         E  6.701051      846.0\n",
      "29                         Baseline Rd                                Salome Hwy         E  6.344312      728.0\n",
      "30                         Baseline Rd                                 Turner Rd         E      6.75      334.0\n",
      "118                        Baseline Rd                                 Turner Rd         E  6.836316      956.0\n",
      "31                         Broadway Rd                                  35th Ave         E       7.0     1409.0\n",
      "32                         Broadway Rd                                  35th Ave         E  6.927967     1219.0\n",
      "33                         Broadway Rd                                  35th Ave         E  6.046729      886.0\n",
      "34                         Broadway Rd                                  35th Ave         E  6.748025     1257.0\n",
      "35                         Broadway Rd                                  43rd Ave         E   6.32985      977.0\n",
      "36                         Broadway Rd                                  51st Ave         W       6.0      849.0\n",
      "37                         Broadway Rd                                  67th Ave         E       7.0     1003.0\n",
      "38                         Broadway Rd                                  67th Ave         E  6.789992     1189.0\n",
      "39                         Broadway Rd                                  67th Ave         E  6.321203      996.0\n",
      "40                         Broadway Rd                                  67th Ave         E   6.79341     1206.0\n",
      "41                         Broadway Rd                                  67th Ave         E  6.972202     1409.0\n",
      "42                         Broadway Rd                                  83rd Ave         E  6.558739     1166.0\n",
      "43                         Broadway Rd                              Ellsworth Rd        W   6.528708     1184.0\n",
      "44                         Broadway Rd                                Johnson Rd         E  6.960403     1290.0\n",
      "45                         Broadway Rd                                Johnson Rd         E  6.590813     1118.0\n",
      "46                         Broadway Rd                               Meridian Rd         W  6.151424      972.0\n",
      "47                         Broadway Rd                                Verrado Wy         E       7.0      112.0\n",
      "48                         Broadway Rd                                Verrado Wy         E  6.938324     1263.0\n",
      "49                          Buckeye Rd                                 339th Ave         W       6.5      134.0\n",
      "50                          Buckeye Rd                                 355th Ave         E       6.5      218.0\n",
      "51                          Buckeye Rd                                 355th Ave         W       6.5      132.0\n",
      "52                          Buckeye Rd                                 363rd Ave         W       6.5       96.0\n",
      "53                        Camelback Rd                                 152nd Ave         E  6.455276      800.0\n",
      "54                        Camelback Rd                                 Dysart Rd         E       7.0      832.0\n",
      "55                        Camelback Rd                                 Dysart Rd         E  6.441054     1212.0\n",
      "56                        Camelback Rd                                 Dysart Rd         E  6.358489      885.0\n",
      "57                        Camelback Rd                              El Mirage Rd         E      6.75     1703.0\n",
      "58                        Camelback Rd                             Litchfield Rd         E      6.75      491.0\n",
      "59                        Camelback Rd                             Litchfield Rd         E  6.243567      896.0\n",
      "60                        Camelback Rd                             Litchfield Rd         W  6.439895      589.0\n",
      "61                        Camelback Rd                             Litchfield Rd         W  6.993952     1537.0\n",
      "62                        Camelback Rd                             Litchfield Rd         E  6.961925     1650.0\n",
      "63                        Camelback Rd                             Litchfield Rd         W  6.364528     1406.0\n",
      "64                        Camelback Rd                             Litchfield Rd         E  6.692278     1282.0\n",
      "65                        Camelback Rd                               Sarival Ave        E        7.0      828.0\n",
      "66                         Central Ave                              Carefree Hwy        N   6.453074       70.0\n",
      "67                         Central Ave                              Carefree Hwy        N   6.470884       89.0\n",
      "68   Country Club Dr - Maricopa County                              Lindgren Ave         E  6.794662      195.0\n",
      "69   Country Club Dr - Maricopa County                              Lindgren Ave         E  6.506108      162.0\n",
      "70                           Dobson Rd                                  Hunt Hwy        N        7.0      188.0\n",
      "71                           Dobson Rd                                  Hunt Hwy        N   6.292888      155.0\n",
      "72                           Dobson Rd                                  Riggs Rd         S  6.745092      199.0\n",
      "73                    Indian School Rd                                 107th Ave         W  6.715454     1467.0\n",
      "74                    Indian School Rd                                 107th Ave         W  6.289584     1509.0\n",
      "75                    Indian School Rd                                 195th Ave         W  6.494544     1452.0\n",
      "76                    Indian School Rd                                 195th Ave         W  6.253443     1049.0\n",
      "77                    Indian School Rd                                 195th Ave         W  6.754378     1212.0\n",
      "78                    Indian School Rd                                 355th Ave        E   6.009628      140.0\n",
      "79                    Indian School Rd                                 355th Ave        W    6.34896      159.0\n",
      "80                    Indian School Rd                                 355th Ave        W   6.065614      178.0\n",
      "81                    Indian School Rd                                 355th Ave        W   6.764317      124.0\n",
      "82                    Indian School Rd                                 355th Ave        E   6.640193      141.0\n",
      "83                    Indian School Rd                                 355th Ave        E   6.098803      137.0\n",
      "84                    Indian School Rd                                 355th Ave        W   6.957679      206.0\n",
      "85                    Indian School Rd                                  99th Ave         W  6.071081     1252.0\n",
      "86                         McDowell Rd                                   78th St        E   6.402045     1306.0\n",
      "87                         McDowell Rd                            Alma School Rd        W   6.835278     1124.0\n",
      "88                         McDowell Rd                                  Hawes Rd        E   6.936892     1239.0\n",
      "89                         McDowell Rd                             Jackrabbit Tr        E   6.830266     1471.0\n",
      "90                         McDowell Rd                             Jackrabbit Tr        E   6.788942     1334.0\n",
      "91                         McDowell Rd                             Jackrabbit Tr        W   6.752293     1353.0\n",
      "92                         McDowell Rd                             Jackrabbit Tr        W   6.797589     1460.0\n",
      "93                         McDowell Rd                               Longmore Rd        E    6.24067      958.0\n",
      "94                         McDowell Rd                                     SR 87         W   6.27423      934.0\n",
      "95                         McDowell Rd                           Sun Valley Pkwy         W  6.379834     1140.0\n",
      "96                         McDowell Rd                             Usery Pass Rd        W   6.084468      868.0\n",
      "97                          Peoria Ave                                 105th Ave         E  6.559011      258.0\n",
      "98                          Peoria Ave                                 105th Ave        E   6.084254      288.0\n",
      "99                          Peoria Ave                                 108th Ave        E   6.890824      344.0\n",
      "100                         Peoria Ave                                 108th Ave        E   6.007953      201.0\n",
      "101                         Peoria Ave                                  99th Ave        E   6.065088      300.0\n",
      "102                         Peoria Ave                                 Balboa Dr        E   6.601814      260.0\n",
      "103                         Peoria Ave                                 Balboa Dr         E  6.566468      280.0\n",
      "104                         Peoria Ave                                 Citrus Rd         W  6.203584      290.0\n",
      "105                         Peoria Ave                             Litchfield Rd        E   6.090884      235.0\n",
      "106                         Peoria Ave                             Litchfield Rd        E   6.850881      382.0\n",
      "107                         Peoria Ave                             Litchfield Rd        E   6.792203      341.0\n",
      "108                          Thomas Rd                             Perryville Rd         W  6.239365       80.0\n",
      "109                      University Dr                                 Higley Rd        E   6.377602      776.0\n",
      "110                      University Dr                                  Power Rd        W   6.303818      812.0\n",
      "111                            Yuma Rd                                 Citrus Rd         E  6.546328      829.0\n",
      "112                            Yuma Rd                                 Citrus Rd         E  6.317609      848.0\n",
      "113                            Yuma Rd                                 Citrus Rd         E  6.474842      566.0\n",
      "114                            Yuma Rd                             Jackrabbit Tr         E  6.586046      767.0\n",
      "115                            Yuma Rd                             Jackrabbit Tr         E  6.182528      919.0\n",
      "116                            Yuma Rd                             Palo Verde Rd         W  6.057572      829.0\n",
      "117                            Yuma Rd                             Palo Verde Rd         W  6.456228      904.0\n"
     ]
    }
   ],
   "source": [
    "import datetime as dt\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from datetime import *\n",
    "import string\n",
    "import random\n",
    "from random import seed\n",
    "from random import randint\n",
    "\n",
    "# *******CLEANING AND FORMATTING DATA**********\n",
    "data = pd.read_csv('TrafficCountBook.csv')\n",
    "# print(data.to_string())\n",
    "# data_clean = data.drop([\"Unamed: 15\", \"Unamed: 15\", \"Unamed: 15\", \"Unamed: 16\", \"Unamed: 17\"], axis=1)\n",
    "# data_clean = data.dropna()\n",
    "data_clean = data.drop(labels=range(1378, 1998), axis=0)\n",
    "# print(data_clean.shape)\n",
    "data_clean = data_clean.drop(columns=data_clean.columns[11:23], axis=1)\n",
    "data_clean = data_clean.dropna()\n",
    "data_clean = data_clean.reset_index(drop=True)\n",
    "data_clean['Date'] = pd.to_datetime(data_clean['Date'])\n",
    "data_clean['AM Hour'] = pd.to_datetime(data_clean['AM Hour']).dt.time\n",
    "data_clean['PM Hour'] = pd.to_datetime(data_clean['PM Hour']).dt.time\n",
    "# print(data_clean.shape)\n",
    "# print(data_clean.to_string())\n",
    "df = pd.DataFrame(data_clean)\n",
    "df = df.rename(columns={'Site ID': 'SiteID', 'On Road': 'OnRoad', 'Ref Road': 'RefRoad', 'AM Hour': 'AM_Hour',\n",
    "                        'AM Volume': 'AM_Volume', 'PM Hour': 'PM_Hour', 'PM Volume': 'PM_Volume'})\n",
    "dayofweek_array = df['Date'].dt.dayofweek\n",
    "weekofyear_array = df['Date'].dt.isocalendar().week\n",
    "# df.assign(dayofweek=df['Date'].dt.dayofweek)\n",
    "df.insert(loc=2, column='weekofyear', value=weekofyear_array)\n",
    "df.insert(loc=3, column='dayofweek', value=dayofweek_array)\n",
    "#print(len(df))\n",
    "#for i in range(0, len(df)):\n",
    "\n",
    "# df.to_csv(r'C:\\#Classes\\CSE599\\TrafficData\\traffic_data_export.csv')   #export new .csv file\n",
    "\n",
    "# print(df.to_string())\n",
    "# print(dayofweek_array.to_string())\n",
    "# print(weekofyear_array.to_string())\n",
    "\n",
    "# dataTypeSeries = data_clean.dtypes\n",
    "# print(dataTypeSeries)\n",
    "\n",
    "# SELECTING 10 STREETS in N/S DIRECTION\n",
    "ns_group1 = df[(df.OnRoad == '7th Ave')]\n",
    "ns_group_later = df[(df.OnRoad == 'Central Ave') | (df.OnRoad == 'ScottSdale Rd') |\n",
    "                    (df.OnRoad == '19th Ave') | (df.OnRoad == 'Dobson Rd') | (df.OnRoad == 'Alma School Rd') |\n",
    "                    (df.OnRoad == '56th St') | (df.OnRoad == '56th St - Mesa') | (df.OnRoad == 'Arizona Ave') |\n",
    "                    (df.OnRoad == 'Country Club Dr - Maricopa County')]\n",
    "# print(ns_group1.to_string())\n",
    "# SELECTING 10 STREETS in E/W DIRECTION\n",
    "ew_group = df[(df.OnRoad == 'Baseline Rd') | (df.OnRoad == 'University Dr') | (df.OnRoad == 'Broadway Rd') |\n",
    "              (df.OnRoad == 'McDowell Rd') | (df.OnRoad == 'Camelback Rd') | (df.OnRoad == 'Indian School Rd') |\n",
    "              (df.OnRoad == 'Peoria Ave') | (df.OnRoad == 'Thomas Rd') | (df.OnRoad == 'Buckeye Rd') |\n",
    "              (df.OnRoad == 'Yuma Rd')]\n",
    "# print(ew_group.to_string())\n",
    "group = pd.concat([ns_group1, ns_group_later, ew_group])\n",
    "group = group.reset_index()\n",
    "# print(group.to_string())\n",
    "for i in range(0, len(group)):\n",
    "    #print(group.iloc[i]['AM_Hour'])\n",
    "    group.at[i, 'AM_Hour'] = group.iloc[i]['AM_Hour'].hour + group.iloc[i]['AM_Hour'].minute/60\n",
    "print(group.to_string())\n",
    "\n",
    "# def generation_7thAve():\n",
    "#     df_gen = pd.DataFrame(columns=[\"OnRoad\", \"RefRoad\", \"Hour\", \"Volume\"])\n",
    "#     example = {'OnRoad':'7th Ave', 'RefRoad':'Carefree', 'Hour':'8:00', 'Volume':100}\n",
    "#     df_gen = df_gen.append(example, ignore_index=True)\n",
    "#     for i in range(5):\n",
    "#         df_gen.loc[i] = ['7th Ave', 'Hill', '7:30', 123]\n",
    "#     print(df_gen.to_string())\n",
    "#     #dataTypeSeries = df_gen.dtypes\n",
    "#     #print(dataTypeSeries)\n",
    "# generation_7thAve()\n",
    "\n",
    "def removeDuplicates(lst):\n",
    "    return list(set([i for i in lst]))\n",
    "group_fortuple = group[['OnRoad', 'RefRoad', 'Direction']]\n",
    "road_tuple = []\n",
    "for row in group_fortuple.itertuples(index=False):\n",
    "    road_tuple.append(tuple(row))\n",
    "    removeDuplicates(road_tuple)\n",
    "#print(road_tuple)\n",
    "\n",
    "def road_pattern(selection, start_t, end_t):\n",
    "    #print(selection[0][0])\n",
    "    new_record = {}\n",
    "    rand_time = random.uniform(start_t, end_t)\n",
    "    if selection[0][0] == \"Baseline Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 30) + 5 + (rand_time * 15))\n",
    "        if start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 100) + 140 + (rand_time - 5) * 400)\n",
    "            #print(est_volume)\n",
    "        if start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"baseline if\")\n",
    "        #print(new_record)\n",
    "    if selection[0][0] == \"Broadway Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 30) + 5 + (rand_time * 10))\n",
    "        if start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 300) + 200 + (rand_time - 5) * 500)\n",
    "        if start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 400) + 550 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"broadway if\")\n",
    "        #print(new_record)\n",
    "    if selection[0][0] == \"Buckeye Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 0 + (rand_time * 10))\n",
    "            #print(\"first if\")\n",
    "        if start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 40) + 30 + (rand_time - 5) * 50)\n",
    "            #print(est_volume)\n",
    "        if start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "            #print(\"second if\")\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"Buckeye if\")\n",
    "        #print(new_record)\n",
    "    if selection[0][0] == \"Camelback Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 1000) + 300 + (rand_time - 5) * 200)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"camelback if\")\n",
    "        #print(new_record)\n",
    "    if selection[0][0] == \"Indian School Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            if selection[0][1] == \"99th Ave\":\n",
    "                est_volume = int(randint(0, 500) + 500 + (rand_time - 5) * 400)\n",
    "            if selection[0][1] == \"107th Ave\":\n",
    "                est_volume = int(randint(0, 500) + 500 + (rand_time - 5) * 400)\n",
    "            if selection[0][1] == \"195th Ave\":\n",
    "                est_volume = int(randint(0, 500) + 500 + (rand_time - 5) * 400)\n",
    "            if selection[0][1] == \"El Mirage Rd\":\n",
    "                est_volume = int(randint(0, 500) + 500 + (rand_time - 5) * 400)\n",
    "            if selection[0][1] == \"355th Ave\":\n",
    "                est_volume = int(randint(0, 100) + 80 + (rand_time - 5) * 20)\n",
    "            if selection[0][1] == \"411th Ave\":\n",
    "                est_volume = int(randint(0, 100) + 80 + (rand_time - 5) * 20)\n",
    "            if selection[0][1] == \"Salome Hwy\":\n",
    "                est_volume = int(randint(0, 100) + 80 + (rand_time - 5) * 20)\n",
    "            if selection[0][1] == \"Wintersburg Rd\":\n",
    "                est_volume = int(randint(0, 100) + 80 + (rand_time - 5) * 20)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"indian school if\")\n",
    "    if selection[0][0] == \"McDowell Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 500) + 300 + (rand_time - 5) * 400)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"McDowell if\")\n",
    "    if selection[0][0] == \"Peoria Ave\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 100) + 100 + (rand_time - 5) * 100)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"peoria if\")\n",
    "    if selection[0][0] == \"Thomas Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 50) + 30 + (rand_time - 5) * 20)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"thomas if\")\n",
    "    if selection[0][0] == \"University Dr\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 400) + 300 + (rand_time - 5) * 100)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"university if\")\n",
    "    if selection[0][0] == \"Yuma Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 500) + 300 + (rand_time - 5) * 150)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"yuma if\")\n",
    "    if selection[0][0] == \"7th Ave\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 80) + 120 + (rand_time - 5) * 200)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"7th if\")\n",
    "    if selection[0][0] == \"19th Ave\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 30) + 20 + (rand_time - 5) * 10)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"19th if\")\n",
    "    if selection[0][0] == \"56th St\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 150) + 100 + (rand_time - 5) * 80)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "    if selection[0][0] == \"56th St - Mesa\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 100) + 50 + (rand_time - 5) * 50)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                          'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                          'AM_Volume': est_volume}\n",
    "        #print(\"56th if\")\n",
    "    if selection[0][0] == \"Alma School Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 500) + 500 + (rand_time - 5) * 250)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"alma if\")\n",
    "    if selection[0][0] == \"Central Ave\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 50) + 30 + (rand_time - 5) * 20)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"central if\")\n",
    "    if selection[0][0] == \"Country Club Dr - Maricopa County\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 80) + 80 + (rand_time - 5) * 50)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"country club if\")\n",
    "    if selection[0][0] == \"Dobson Rd\":\n",
    "        est_volume = 0\n",
    "        if start_t >= 0 and end_t < 5:\n",
    "            est_volume = int(randint(0, 20) + 5 + (rand_time * 10))\n",
    "        elif start_t >= 5 and end_t < 8:\n",
    "            est_volume = int(randint(0, 80) + 50 + (rand_time - 5) * 40)\n",
    "        elif start_t >= 8 and end_t < 12:\n",
    "            est_volume = int(randint(0, 100) + 850 + (rand_time - 8) * -200)\n",
    "        new_record = {'OnRoad': selection[0][0], 'RefRoad': selection[0][1],\n",
    "                      'Direction': selection[0][2], 'AM_Hour': rand_time,\n",
    "                      'AM_Volume': est_volume}\n",
    "        #print(\"dobson if\")\n",
    "    #print(new_record)\n",
    "    return new_record\n",
    "\n",
    "def am_patter1(start_t, end_t):\n",
    "    # time1 = datetime.strptime(\"5:00:00\", \"%H:%M:%S\")\n",
    "    # time1 = time1.time()\n",
    "    df_sample1 = group[group['AM_Hour'].between(start_t, end_t)]\n",
    "    df_sample1 = df_sample1[['OnRoad', 'RefRoad', 'Direction', 'AM_Hour', 'AM_Volume']]\n",
    "    for i in range(100):\n",
    "        random_select = random.sample(road_tuple, 1)\n",
    "        #print(random_select[0])\n",
    "        #random_select = ('56th St', 'Montgomery Rd', 'N')\n",
    "        new_record = road_pattern(random_select, start_t, end_t)\n",
    "        df_sample1 = df_sample1.append(new_record, ignore_index=True)\n",
    "        df_sample1 = df_sample1.sort_values(by=['OnRoad', 'RefRoad'])\n",
    "    #df_sample1 = df_sample1.sort_values(by=['OnRoad', 'RefRoad'])\n",
    "    print(df_sample1.to_string())\n",
    "    df_sample1.to_json('sample6_7.json', orient=\"records\")\n",
    "\n",
    "am_patter1(6, 7)\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "60e440d6",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}