I am confused and I have no idea what to do. I've tried googling but I am lost. I have attached instructions so I don't make anyone else as confused as I am. My code is at the bottom. The Project2_template is the ArrayLists at the beginning of my program. Java Programming. It also needs to be a loop until the user types quit. It also needs to be able to take in the absolute path if the user types that.
Instructions:
Good Input CSV Example:
Date,Time,Sensor_2278,Sensor_3276,Sensor_4689,Sensor_503212/12/2017,1345,68.96868687,68.36862745,57.5625,65.4855670112/12/2017,1400,68.89393939,68.51176471,57.45,65.4432989712/12/2017,1415,68.919,68.47843137,57.79166667,65.4329896912/12/2017,1430,68.903,68.41666667,56.46363636,65.5928571412/12/2017,1445,69.014,68.61862745,57.53846154,65.7132653112/12/2017,1500,69.186,68.41165049,56.56666667,65.7080808112/12/2017,1515,69.186,68.27254902,56.23333333,65.8494949512/12/2017,1400,69.128,66.47468354,54.08,66.2242424212/12/2017,1415,69.08989899,66.24683544,53.79230769,66.3464646512/8/2017,830,69.27878788,69.82718447,55.58666667,66.798989912/8/2017,845,69.57979798,69.61747573,54.7,67.6212121212/8/2017,900,69.72020202,69.65825243,56.01578947,68.4343434312/8/2017,845,69.86868687,66.2225,55.58181818,68.503030312/8/2017,900,70.13737374,66.575,56.79545455,68.8727272712/8/2017,845,70.49494949,66.88875,55.68125,68.2686868712/8/2017,900,70.75353535,67.065,56.89444444,67.512/8/2017,915,70.91717172,66.28375,60.1375,62.6767676812/8/2017,200,71.072,67.12647059,57.92857143,53.0232323212/8/2017,215,71.16336634,67.14950495,58.125,46.6727272712/8/2017,230,71.20693069,67.24752475,57.81304348,47.7070707112/8/2017,245,71.45841584,67.1970297,57.89473684,50.6734693912/8/2017,300,71.5990099,67.26960784,58.0952381,52.9797979812/8/2017,200,71.63861386,64.46666667,58.19473684,58.1535353512/8/2017,215,71.5980198,64.69113924,58.51904762,62.3303030312/8/2017,230,71.76732673,64.37820513,58.80869565,66.27512/8/2017,145,71.87029703,67.18653846,59.03,67.9212/8/2017,200,71.75445545,67.12647059,59.06111111,68.19612/8/2017,215,71.69108911,67.14950495,58.01111111,68.62412/8/2017,230,71.39405941,67.24752475,58.31578947,68.26612/8/2017,245,71.32079208,67.1970297,57.75294118,67.87112/8/2017,300,71.332,67.26960784,57.28125,68.02512/8/2017,145,71.254,64.38875,57.2,68.1312/8/2017,200,71.06138614,64.46666667,57.675,67.99712/8/2017,215,70.88613861,64.69113924,56.73571429,68.0900990112/8/2017,230,71.14455446,64.37820513,56.50555556,67.8217821810/31/2017,1630,71.15247525,68.36893204,56.16666667,67.797029710/31/2017,1645,71.10792079,68.21165049,56.60555556,67.7544554510/31/2017,1700,71.10990099,68.53009709,56.97894737,67.7752475210/31/2017,1630,71.0950495,65.82,57.61333333,67.86410/31/2017,1645,71.17722772,65.95,59.56428571,67.76110/3/2017,1015,70.88316832,68.48514851,60.18823529,67.58910/3/2017,1030,70.87425743,68.52970297,61.3,67.7424242410/3/2017,1015,71.07029703,65.95189873,61.49333333,67.704040410/3/2017,1030,71.2950495,66.36455696,60.9,67.6818181810/3/2017,1045,71.3029703,65.92151899,60.34285714,67.7171717210/3/2017,1100,71.27524752,65.90886076,59.94705882,67.595959610/3/2017,1115,71.17425743,66.17468354,60.38333333,67.5080808110/3/2017,1015,71.18514851,67.0625,61.4125,67.7464646510/3/2017,1030,71.12871287,66.765,60.73,67.6818181810/3/2017,1045,71.04950495,66.70375,60.74,67.9454545510/3/2017,1100,70.83861386,66.71375,60.54,68.0545454510/3/2017,1115,70.8980198,66.33125,61.13333333,68.0898989910/3/2017,1130,70.69009901,66.73,61.3,68.123232329/22/2017,945,70.58613861,69.45192308,62.2375,67.9339/22/2017,1000,70.46534653,69.54615385,63.02857143,67.953465359/22/2017,1015,70.55643564,69.62135922,61.14285714,67.684158429/22/2017,1030,70.71287129,69.70288462,60.18571429,67.994059419/22/2017,1045,70.63960396,69.64326923,60.99,67.932673279/22/2017,945,70.49207921,66.61,55.58181818,67.861386149/22/2017,1000,70.37722772,66.48,56.79545455,67.623762389/22/2017,1015,70.31782178,66.3675,55.68125,67.409900999/22/2017,1030,70.25,66.06125,56.89444444,67.108910899/9/2017,900,70.14215686,71.48415842,60.1375,66.939603969/9/2017,915,70.32156863,71.5049505,57.92857143,66.89504959/9/2017,930,70.27745098,71.47425743,58.125,66.715841589/9/2017,945,70.02941176,71.20990099,58.82727273,66.658415849/9/2017,1000,69.66960784,70.84950495,58.81176471,66.592079219/9/2017,1015,69.47647059,71.0019802,60.02142857,66.456435649/9/2017,900,69.37941176,68.11265823,59.97333333,66.235643569/9/2017,915,69.30098039,67.95063291,59.66818182,66.024752489/9/2017,930,69.03168317,67.90632911,57.81304348,65.923762389/9/2017,945,68.9049505,67.85063291,57.89473684,65.572277239/9/2017,1000,68.786,68.25443038,58.0952381,65.463366349/9/2017,1015,68.90594059,67.93037975,58.19473684,65.331683179/9/2017,1030,69.06960784,67.90253165,58.80869565,65.586138617/28/2017,845,69.01666667,69.61747573,59.03,65.567326737/28/2017,900,69.01862745,69.65825243,59.06111111,65.566336637/28/2017,915,69.01372549,69.82718447,58.01111111,65.391089117/28/2017,930,69.07156863,69.8815534,58.31578947,65.449504957/28/2017,845,69.15686275,66.2225,57.75294118,65.5247/28/2017,900,69.116,66.575,57.28125,65.5357/28/2017,845,69.326,66.88875,57.2,65.5637/28/2017,900,69.178,67.065,57.675,65.5376/28/2017,630,69.03535354,68.41188119,56.50555556,66.818367356/28/2017,645,68.93636364,68.62475248,56.16666667,66.719387766/28/2017,700,68.94141414,68.70792079,56.60555556,66.463265316/21/2017,1530,68.86868687,68.58653846,58.13125,66.078571436/21/2017,1545,68.778,68.66826923,59.56428571,65.655/21/2017,1800,68.795,70.77156863,60.18823529,65.590816335/21/2017,1815,68.768,70.69901961,61.3,65.452577325/21/2017,1830,68.755,70.64117647,61.49333333,65.327835055/21/2017,1845,68.78888889,70.06764706,60.34285714,65.11855675/21/2017,1900,68.807,69.87352941,59.94705882,65.002061865/21/2017,1915,68.91616162,69.7627451,61.4125,65.135714295/21/2017,1930,68.964,69.85490196,60.74,65.41855675/21/2017,1945,68.914,70.10686275,60.56363636,65.513402065/21/2017,2000,68.96868687,69.99117647,60.54,65.485567015/21/2017,2015,68.89393939,69.79705882,61.3,65.443298975/21/2017,2030,68.919,69.53465347,62.2375,65.432989695/21/2017,2045,68.903,69.38613861,60.58,65.592857145/21/2017,1830,69.014,67.6721519,61.51818182,65.713265315/21/2017,1845,69.186,67.60886076,63.21428571,65.708080815/21/2017,1900,69.186,67.62531646,63.02857143,65.849494955/21/2017,1915,69.128,67.50253165,60.44,66.224242425/21/2017,1930,69.08989899,67.59873418,57.51428571,66.346464655/21/2017,1830,69.27878788,68.26329114,54.46153846,66.79898995/21/2017,1845,69.57979798,68.16075949,57.79166667,67.621212125/21/2017,1900,69.72020202,68.19873418,57.78,68.434343435/21/2017,1915,69.86868687,68.16708861,57.39090909,68.50303035/21/2017,1930,70.13737374,68.3164557,56.46363636,68.872727275/21/2017,1945,70.49494949,67.70253165,57.53846154,68.268686875/21/2017,2000,70.75353535,67.8443038,56.56666667,67.55/21/2017,2015,70.91717172,67.19746835,56.23333333,62.676767685/21/2017,1830,71.072,66.93098592,55.62941176,53.023232325/21/2017,1845,71.16336634,67.08028169,54.08,46.672727275/21/2017,1900,71.20693069,67.25070423,53.79230769,47.707070715/21/2017,1915,71.45841584,66.94507042,56.01578947,50.673469395/21/2017,1930,71.5990099,66.45492958,55.58181818,52.979797985/21/2017,1945,71.63861386,66.10704225,56.79545455,58.153535355/21/2017,1830,71.5980198,63.07868852,60.1375,62.330303035/21/2017,1845,71.76732673,63.29836066,57.92857143,66.2755/21/2017,1900,71.87029703,63.29836066,58.125,67.925/21/2017,1915,71.75445545,62.89508197,58.82727273,68.1964/8/2017,1115,71.69108911,70.67,60.18823529,68.6244/8/2017,1130,71.39405941,70.355,61.3,68.2664/8/2017,1115,71.32079208,67.60759494,61.49333333,67.8714/8/2017,1130,71.332,67.59873418,59.94705882,68.0254/8/2017,1145,71.254,67.39493671,60.38333333,68.134/8/2017,1200,71.06138614,67.4721519,61.4125,67.9974/8/2017,1215,70.88613861,67.95189873,60.73,68.090099014/8/2017,1230,71.14455446,67.87594937,60.74,67.821782184/8/2017,1245,71.15247525,67.33291139,60.56363636,67.79702974/8/2017,1300,71.10792079,67.42025316,60.54,67.754455454/8/2017,1315,71.10990099,67.91265823,61.13333333,67.775247524/8/2017,1330,71.0950495,67.33164557,61.3,67.8641/20/2017,1915,71.17722772,69.2745098,60.26363636,67.7611/20/2017,1930,70.88316832,69.34455446,59.85454545,67.5891/20/2017,1915,70.87425743,66.73670886,60.44,67.742424241/20/2017,1930,71.07029703,66.52278481,55.61428571,67.70404041/20/2017,1945,71.2950495,65.81772152,59.33333333,67.681818181/20/2017,1915,71.3029703,66.69113924,60.16,67.717171721/20/2017,1930,71.27524752,66.93037975,55.13125,67.59595961/20/2017,1945,71.17425743,66.72405063,57.45,67.508080811/20/2017,2000,71.18514851,66.69113924,57.78,67.746464651/20/2017,1915,71.12871287,65.9943662,58.475,67.681818181/20/2017,1930,71.04950495,65.63943662,56.46363636,67.945454551/20/2017,1945,70.83861386,65.74507042,56.23333333,68.054545451/20/2017,2000,70.8980198,65.33239437,55.62941176,68.089898991/20/2017,2015,70.69009901,64.9056338,53.79230769,68.1232323211/22/2016,15,70.58613861,66.78333333,55.58666667,67.93311/22/2016,30,70.46534653,66.63137255,54.7,67.9534653511/22/2016,45,70.55643564,66.52352941,56.01578947,67.6841584211/22/2016,15,70.71287129,64.09871795,55.58181818,67.9940594111/22/2016,30,70.63960396,64.22564103,56.79545455,67.9326732710/28/2016,745,70.49207921,70.00769231,55.68125,67.8613861410/28/2016,800,70.37722772,69.83846154,56.89444444,67.6237623810/28/2016,815,70.31782178,69.94854369,60.1375,67.4099009910/28/2016,830,70.25,69.82718447,57.92857143,67.1089108910/28/2016,745,70.14215686,67.04875,58.125,66.9396039610/28/2016,800,70.32156863,66.86375,58.82727273,66.895049510/21/2016,615,70.27745098,68.51747573,57.81304348,66.7158415810/21/2016,630,70.02941176,68.91262136,57.89473684,66.6584158410/21/2016,615,69.66960784,66.9675,58.19473684,66.5920792110/21/2016,630,69.47647059,67.2875,58.51904762,66.4564356410/21/2016,645,69.37941176,68.1175,58.80869565,66.2356435610/21/2016,700,69.30098039,67.3425,59.03,66.0247524810/21/2016,715,69.03168317,67.305,59.06111111,65.9237623810/21/2016,730,68.9049505,67.24125,58.31578947,65.5722772310/21/2016,745,68.786,67.04875,57.75294118,65.4633663410/21/2016,800,68.90594059,66.86375,57.28125,65.3316831710/21/2016,815,69.06960784,66.39375,57.2,65.5861386110/21/2016,830,69.01666667,66.3475,57.675,65.5673267310/17/2016,2130,69.01862745,66.67352941,56.73571429,65.5663366310/17/2016,2145,69.01372549,66.81862745,56.50555556,65.3910891110/17/2016,2200,69.07156863,66.72254902,56.16666667,65.4495049510/17/2016,2215,69.15686275,66.80294118,56.60555556,65.52410/17/2016,2230,69.116,66.74313725,56.97894737,65.53510/17/2016,2245,69.326,66.71372549,58.98,65.56310/17/2016,2300,69.178,66.75686275,58.13125,65.53710/17/2016,2130,69.03535354,65.07948718,60.34285714,66.8183673510/17/2016,2145,68.93636364,64.77435897,59.94705882,66.7193877610/17/2016,2200,68.94141414,64.67051282,61.4125,66.4632653110/17/2016,2215,68.86868687,64.91282051,60.73,66.0785714310/17/2016,2230,68.778,65.16794872,60.74,65.6510/17/2016,2245,68.795,64.96794872,60.56363636,65.5908163310/17/2016,2300,68.768,64.36282051,60.54,65.4525773210/17/2016,2130,68.755,65.03125,61.3,65.3278350510/17/2016,2145,68.78888889,65.23,62.2375,65.11855679/7/2016,945,68.807,68.24019608,61.51818182,65.002061869/7/2016,1000,68.91616162,68.41176471,60.425,65.135714299/7/2016,945,68.964,66.05063291,60.34444444,65.41855679/7/2016,1000,68.914,66.08101266,59.85454545,65.513402069/2/2016,745,68.96868687,70.00769231,59.81818182,65.485567019/2/2016,800,68.89393939,69.83846154,60.44,65.443298979/2/2016,815,68.919,69.94854369,55.15714286,65.432989699/2/2016,830,68.903,69.82718447,59.33333333,65.592857149/2/2016,845,69.014,69.61747573,60.16,65.713265319/2/2016,900,69.186,69.65825243,60.66666667,65.708080819/2/2016,915,69.186,69.82718447,59.1,65.849494959/2/2016,930,69.128,69.8815534,59.28181818,66.224242429/2/2016,945,69.08989899,69.45192308,57.51428571,66.346464659/2/2016,1000,69.27878788,69.54615385,54.46153846,66.79898999/2/2016,1015,69.57979798,69.62135922,55.13125,67.621212129/2/2016,1030,69.72020202,69.70288462,58.475,68.434343439/2/2016,1045,69.86868687,69.64326923,57.53846154,68.50303039/2/2016,1100,70.13737374,69.62912621,56.56666667,68.872727279/2/2016,1115,70.49494949,69.50291262,55.62941176,68.268686879/2/2016,1130,70.75353535,69.58446602,54.08,67.59/2/2016,745,70.91717172,67.04875,53.79230769,62.676767689/2/2016,800,71.072,66.86375,55.58666667,53.023232329/2/2016,815,71.16336634,66.39375,55.58181818,46.672727279/2/2016,830,71.20693069,66.3475,56.79545455,47.707070719/2/2016,845,71.45841584,66.2225,55.68125,50.673469399/2/2016,900,71.5990099,66.575,56.89444444,52.979797989/2/2016,915,71.63861386,66.30625,60.1375,58.153535358/2/2016,1615,71.5980198,68.54854369,58.125,62.330303038/2/2016,1630,71.76732673,68.36893204,58.82727273,66.2758/2/2016,1645,71.87029703,68.21165049,58.81176471,67.928/2/2016,1700,71.75445545,68.53009709,60.02142857,68.1968/2/2016,1715,71.69108911,68.67475728,59.97333333,68.6248/2/2016,1730,71.39405941,68.95882353,59.66818182,68.2668/2/2016,1615,71.32079208,66.12375,57.81304348,67.8718/2/2016,1630,71.332,65.82,57.89473684,68.0258/2/2016,1615,71.254,65.24,58.51904762,68.138/2/2016,1630,71.06138614,65.8025,58.80869565,67.9977/28/2016,1900,70.88613861,68.19514563,59.03,68.090099017/28/2016,1915,71.14455446,68.13786408,59.06111111,67.821782187/28/2016,1930,71.15247525,68.26893204,58.01111111,67.79702977/28/2016,1945,71.10792079,68.06407767,58.31578947,67.754455457/28/2016,2000,71.10990099,68.1631068,56.73571429,67.775247527/28/2016,2015,71.0950495,68.11650485,58.98,67.8647/28/2016,2030,71.17722772,67.91442308,58.13125,67.7617/28/2016,2045,70.88316832,67.86730769,57.61333333,67.5897/28/2016,2100,70.87425743,67.63846154,59.56428571,67.742424247/8/2016,830,71.07029703,69.82718447,60.18823529,67.70404047/8/2016,845,71.2950495,69.61747573,61.3,67.681818187/8/2016,900,71.3029703,69.65825243,60.34285714,67.717171727/8/2016,915,71.27524752,69.82718447,59.94705882,67.59595967/8/2016,930,71.17425743,69.8815534,61.4125,67.508080817/8/2016,945,71.18514851,69.45192308,60.73,67.746464656/18/2016,1815,71.12871287,69.29009901,60.425,67.681818186/18/2016,1830,71.04950495,69.23267327,60.34444444,67.945454556/18/2016,1815,70.83861386,67.57307692,60.26363636,68.054545456/18/2016,1830,70.8980198,67.34358974,60.44,68.089898996/18/2016,1815,70.69009901,67.67820513,55.61428571,68.123232326/18/2016,1830,70.58613861,67.78461538,59.33333333,67.9336/18/2016,1845,70.46534653,67.98860759,59.1,67.953465356/18/2016,1900,70.55643564,68.07594937,59.28181818,67.684158426/18/2016,1915,70.71287129,67.26835443,56.93333333,67.994059416/18/2016,1930,70.63960396,67.2,57.93333333,67.932673276/18/2016,1815,70.49207921,67.16901408,55.13125,67.861386146/18/2016,1830,70.37722772,66.97183099,57.45,67.623762386/18/2016,1845,70.31782178,66.71408451,57.79166667,67.409900996/18/2016,1900,70.25,66.63661972,57.78,67.108910896/18/2016,1915,70.14215686,65.77746479,58.475,66.939603966/18/2016,1930,70.32156863,66.07323944,56.46363636,66.89504956/18/2016,1945,70.27745098,65.94225352,57.53846154,66.715841586/18/2016,2000,70.02941176,65.47183099,56.23333333,66.658415846/18/2016,2015,69.66960784,65.1915493,55.62941176,66.592079216/18/2016,2030,69.47647059,64.65352113,54.08,66.456435645/10/2016,645,69.37941176,68.49306931,53.79230769,66.235643565/10/2016,700,69.30098039,68.75445545,55.58666667,66.024752485/10/2016,715,69.03168317,68.81881188,54.7,65.923762385/10/2016,730,68.9049505,68.76336634,56.01578947,65.572277235/10/2016,745,68.786,68.77722772,55.58181818,65.463366345/10/2016,800,68.90594059,68.57425743,56.79545455,65.331683175/10/2016,815,69.06960784,68.55049505,55.68125,65.586138615/10/2016,830,69.01666667,68.72277228,56.89444444,65.567326734/4/2016,945,69.01862745,69.374,60.1375,65.566336634/4/2016,1000,69.01372549,69.375,58.125,65.391089114/4/2016,1015,69.07156863,69.494,58.82727273,65.449504953/14/2016,615,69.15686275,68.61,58.81176471,65.5243/14/2016,630,69.116,68.87,59.66818182,65.5353/14/2016,645,69.326,69.28888889,57.81304348,65.5633/14/2016,700,69.178,69.58787879,57.89473684,65.5373/13/2016,2200,69.03535354,68.72178218,58.0952381,66.818367353/13/2016,2215,68.93636364,68.43235294,58.19473684,66.719387763/13/2016,2230,68.94141414,68.40294118,58.51904762,66.463265313/13/2016,1215,68.86868687,71.71782178,58.80869565,66.078571433/13/2016,1230,68.778,71.53168317,59.03,65.653/13/2016,1245,68.795,71.37524752,59.06111111,65.590816333/13/2016,1300,68.768,71.59207921,58.01111111,65.452577323/8/2016,1115,68.755,68.64653465,58.31578947,65.327835053/8/2016,1130,68.78888889,68.73069307,57.75294118,65.11855673/8/2016,1145,68.807,68.36138614,57.28125,65.002061862/25/2016,1245,68.91616162,67.61584158,57.2,65.135714292/25/2016,1300,68.964,67.93168317,56.50555556,65.41855672/25/2016,1315,68.914,68.202,56.16666667,65.513402062/25/2016,1330,68.96868687,68.161,56.60555556,65.485567012/25/2016,1345,68.89393939,68.359,59.56428571,65.443298972/25/2016,1400,68.919,68.64141414,60.18823529,65.432989692/25/2016,1415,68.903,68.64455446,61.3,65.592857142/25/2016,1430,69.014,68.81568627,61.4125,65.713265312/25/2016,1445,69.186,69.03465347,60.73,65.708080812/25/2016,1500,69.186,69.15656566,60.74,65.849494952/25/2016,1515,69.128,68.66237624,60.56363636,66.224242422/25/2016,1530,69.08989899,68.82475248,62.2375,66.346464652/25/2016,1545,69.27878788,68.726,60.58,66.79898992/25/2016,1600,69.57979798,68.43069307,61.51818182,67.62121212
Date Error CSV Example:
Date,Time,Sensor_2278,Sensor_3276,Sensor_4689,Sensor_503212/12/2017,1345,68.96868687,68.36862745,57.5625,65.4855670112/12/2017,1400,68.89393939,68.51176471,57.45,65.4432989712/12/2017,1415,68.919,68.47843137,57.79166667,65.4329896912/12/2017,1430,68.903,68.41666667,56.46363636,65.5928571412/12/2017,1445,69.014,68.61862745,57.53846154,65.7132653112/12/2017,1500,69.186,68.41165049,56.56666667,65.7080808112/12/2017,1515,69.186,68.27254902,56.23333333,65.8494949512122017,1400,69.128,66.47468354,54.08,66.2242424212/12/2017,1415,69.08989899,66.24683544,53.79230769,66.3464646512/8/2017,830,69.27878788,69.82718447,55.58666667,66.798989912/8/2017,845,69.57979798,69.61747573,54.7,67.6212121212/8/2017,900,69.72020202,69.65825243,56.01578947,68.4343434312/8/2017,845,69.86868687,66.2225,55.58181818,68.503030312/8/2017,900,70.13737374,66.575,56.79545455,68.8727272712/8/2017,845,70.49494949,66.88875,55.68125,68.2686868712/8/2017,900,70.75353535,67.065,56.89444444,67.512/8/2017,915,70.91717172,66.28375,60.1375,62.6767676812/8/2017,200,71.072,67.12647059,57.92857143,53.0232323212/8/2017,215,71.16336634,67.14950495,58.125,46.6727272712/8/2017,230,71.20693069,67.24752475,57.81304348,47.7070707112/8/2017,245,71.45841584,67.1970297,57.89473684,50.6734693912/8/2017,300,71.5990099,67.26960784,58.0952381,52.9797979812/8/2017,200,71.63861386,64.46666667,58.19473684,58.1535353512/8/2017,215,71.5980198,64.69113924,58.51904762,62.3303030312/8/2017,230,71.76732673,64.37820513,58.80869565,66.27512/8/2017,145,71.87029703,67.18653846,59.03,67.9212/8/2017,200,71.75445545,67.12647059,59.06111111,68.19612/8/2017,215,71.69108911,67.14950495,58.01111111,68.62412/8/2017,230,71.39405941,67.24752475,58.31578947,68.26612/8/2017,245,71.32079208,67.1970297,57.75294118,67.87112/8/2017,300,71.332,67.26960784,57.28125,68.02512/8/2017,145,71.254,64.38875,57.2,68.1312/8/2017,200,71.06138614,64.46666667,57.675,67.99712/8/2017,215,70.88613861,64.69113924,56.73571429,68.0900990112/8/2017,230,71.14455446,64.37820513,56.50555556,67.8217821810/31/2017,1630,71.15247525,68.36893204,56.16666667,67.797029710/31/2017,1645,71.10792079,68.21165049,56.60555556,67.7544554510/31/2017,1700,71.10990099,68.53009709,56.97894737,67.7752475210/31/2017,1630,71.0950495,65.82,57.61333333,67.86410/31/2017,1645,71.17722772,65.95,59.56428571,67.76110/3/2017,1015,70.88316832,68.48514851,60.18823529,67.58910/3/2017,1030,70.87425743,68.52970297,61.3,67.7424242410/3/2017,1015,71.07029703,65.95189873,61.49333333,67.704040410/3/2017,1030,71.2950495,66.36455696,60.9,67.6818181810/3/2017,1045,71.3029703,65.92151899,60.34285714,67.7171717210/3/2017,1100,71.27524752,65.90886076,59.94705882,67.595959610/3/2017,1115,71.17425743,66.17468354,60.38333333,67.5080808110/3/2017,1015,71.18514851,67.0625,61.4125,67.7464646510/3/2017,1030,71.12871287,66.765,60.73,67.6818181810/3/2017,1045,71.04950495,66.70375,60.74,67.9454545510/3/2017,1100,70.83861386,66.71375,60.54,68.0545454510/3/2017,1115,70.8980198,66.33125,61.13333333,68.0898989910/3/2017,1130,70.69009901,66.73,61.3,68.123232329/22/2017,945,70.58613861,69.45192308,62.2375,67.9339/22/2017,1000,70.46534653,69.54615385,63.02857143,67.953465359/22/2017,1015,70.55643564,69.62135922,61.14285714,67.684158429/22/2017,1030,70.71287129,69.70288462,60.18571429,67.994059419/22/2017,1045,70.63960396,69.64326923,60.99,67.932673279/22/2017,945,70.49207921,66.61,55.58181818,67.861386149/22/2017,1000,70.37722772,66.48,56.79545455,67.623762389/22/2017,1015,70.31782178,66.3675,55.68125,67.409900999/22/2017,1030,70.25,66.06125,56.89444444,67.108910899/9/2017,900,70.14215686,71.48415842,60.1375,66.939603969/9/2017,915,70.32156863,71.5049505,57.92857143,66.89504959/9/2017,930,70.27745098,71.47425743,58.125,66.715841589/9/2017,945,70.02941176,71.20990099,58.82727273,66.658415849/9/2017,1000,69.66960784,70.84950495,58.81176471,66.592079219/9/2017,1015,69.47647059,71.0019802,60.02142857,66.456435649/9/2017,900,69.37941176,68.11265823,59.97333333,66.235643569/9/2017,915,69.30098039,67.95063291,59.66818182,66.024752489/9/2017,930,69.03168317,67.90632911,57.81304348,65.923762389/9/2017,945,68.9049505,67.85063291,57.89473684,65.572277239/9/2017,1000,68.786,68.25443038,58.0952381,65.463366349/9/2017,1015,68.90594059,67.93037975,58.19473684,65.331683179/9/2017,1030,69.06960784,67.90253165,58.80869565,65.586138617/28/2017,845,69.01666667,69.61747573,59.03,65.567326737/28/2017,900,69.01862745,69.65825243,59.06111111,65.566336637/28/2017,915,69.01372549,69.82718447,58.01111111,65.391089117/28/2017,930,69.07156863,69.8815534,58.31578947,65.449504957/28/2017,845,69.15686275,66.2225,57.75294118,65.5247/28/2017,900,69.116,66.575,57.28125,65.5357/28/2017,845,69.326,66.88875,57.2,65.5637/28/2017,900,69.178,67.065,57.675,65.5376/28/2017,630,69.03535354,68.41188119,56.50555556,66.818367356/28/2017,645,68.93636364,68.62475248,56.16666667,66.719387766/28/2017,700,68.94141414,68.70792079,56.60555556,66.463265316/21/2017,1530,68.86868687,68.58653846,58.13125,66.078571436/21/2017,1545,68.778,68.66826923,59.56428571,65.655/21/2017,1800,68.795,70.77156863,60.18823529,65.590816335/21/2017,1815,68.768,70.69901961,61.3,65.452577325/21/2017,1830,68.755,70.64117647,61.49333333,65.327835055/21/2017,1845,68.78888889,70.06764706,60.34285714,65.11855675/21/2017,1900,68.807,69.87352941,59.94705882,65.002061865/21/2017,1915,68.91616162,69.7627451,61.4125,65.135714295/21/2017,1930,68.964,69.85490196,60.74,65.41855675/21/2017,1945,68.914,70.10686275,60.56363636,65.513402065/21/2017,2000,68.96868687,69.99117647,60.54,65.485567015/21/2017,2015,68.89393939,69.79705882,61.3,65.443298975/21/2017,2030,68.919,69.53465347,62.2375,65.432989695/21/2017,2045,68.903,69.38613861,60.58,65.592857145/21/2017,1830,69.014,67.6721519,61.51818182,65.713265315/21/2017,1845,69.186,67.60886076,63.21428571,65.708080815/21/2017,1900,69.186,67.62531646,63.02857143,65.849494955/21/2017,1915,69.128,67.50253165,60.44,66.224242425/21/2017,1930,69.08989899,67.59873418,57.51428571,66.346464655/21/2017,1830,69.27878788,68.26329114,54.46153846,66.79898995/21/2017,1845,69.57979798,68.16075949,57.79166667,67.621212125/21/2017,1900,69.72020202,68.19873418,57.78,68.434343435/21/2017,1915,69.86868687,68.16708861,57.39090909,68.50303035/21/2017,1930,70.13737374,68.3164557,56.46363636,68.872727275/21/2017,1945,70.49494949,67.70253165,57.53846154,68.268686875/21/2017,2000,70.75353535,67.8443038,56.56666667,67.55/21/2017,2015,70.91717172,67.19746835,56.23333333,62.676767685/21/2017,1830,71.072,66.93098592,55.62941176,53.023232325/21/2017,1845,71.16336634,67.08028169,54.08,46.672727275/21/2017,1900,71.20693069,67.25070423,53.79230769,47.707070715/21/2017,1915,71.45841584,66.94507042,56.01578947,50.673469395/21/2017,1930,71.5990099,66.45492958,55.58181818,52.979797985/21/2017,1945,71.63861386,66.10704225,56.79545455,58.153535355/21/2017,1830,71.5980198,63.07868852,60.1375,62.330303035/21/2017,1845,71.76732673,63.29836066,57.92857143,66.2755/21/2017,1900,71.87029703,63.29836066,58.125,67.925/21/2017,1915,71.75445545,62.89508197,58.82727273,68.1964/8/2017,1115,71.69108911,70.67,60.18823529,68.6244/8/2017,1130,71.39405941,70.355,61.3,68.2664/8/2017,1115,71.32079208,67.60759494,61.49333333,67.8714/8/2017,1130,71.332,67.59873418,59.94705882,68.0254/8/2017,1145,71.254,67.39493671,60.38333333,68.134/8/2017,1200,71.06138614,67.4721519,61.4125,67.9974/8/2017,1215,70.88613861,67.95189873,60.73,68.090099014/8/2017,1230,71.14455446,67.87594937,60.74,67.821782184/8/2017,1245,71.15247525,67.33291139,60.56363636,67.79702974/8/2017,1300,71.10792079,67.42025316,60.54,67.754455454/8/2017,1315,71.10990099,67.91265823,61.13333333,67.775247524/8/2017,1330,71.0950495,67.33164557,61.3,67.8641/20/2017,1915,71.17722772,69.2745098,60.26363636,67.7611/20/2017,1930,70.88316832,69.34455446,59.85454545,67.5891/20/2017,1915,70.87425743,66.73670886,60.44,67.742424241/20/2017,1930,71.07029703,66.52278481,55.61428571,67.70404041/20/2017,1945,71.2950495,65.81772152,59.33333333,67.681818181/20/2017,1915,71.3029703,66.69113924,60.16,67.717171721/20/2017,1930,71.27524752,66.93037975,55.13125,67.59595961/20/2017,1945,71.17425743,66.72405063,57.45,67.508080811/20/2017,2000,71.18514851,66.69113924,57.78,67.746464651/20/2017,1915,71.12871287,65.9943662,58.475,67.681818181/20/2017,1930,71.04950495,65.63943662,56.46363636,67.945454551/20/2017,1945,70.83861386,65.74507042,56.23333333,68.054545451/20/2017,2000,70.8980198,65.33239437,55.62941176,68.089898991/20/2017,2015,70.69009901,64.9056338,53.79230769,68.1232323211/22/2016,15,70.58613861,66.78333333,55.58666667,67.93311/22/2016,30,70.46534653,66.63137255,54.7,67.9534653511/22/2016,45,70.55643564,66.52352941,56.01578947,67.6841584211/22/2016,15,70.71287129,64.09871795,55.58181818,67.9940594111/22/2016,30,70.63960396,64.22564103,56.79545455,67.9326732710/28/2016,745,70.49207921,70.00769231,55.68125,67.8613861410/28/2016,800,70.37722772,69.83846154,56.89444444,67.6237623810/28/2016,815,70.31782178,69.94854369,60.1375,67.4099009910/28/2016,830,70.25,69.82718447,57.92857143,67.1089108910/28/2016,745,70.14215686,67.04875,58.125,66.9396039610/28/2016,800,70.32156863,66.86375,58.82727273,66.895049510/21/2016,615,70.27745098,68.51747573,57.81304348,66.7158415810/21/2016,630,70.02941176,68.91262136,57.89473684,66.6584158410/21/2016,615,69.66960784,66.9675,58.19473684,66.5920792110/21/2016,630,69.47647059,67.2875,58.51904762,66.4564356410/21/2016,645,69.37941176,68.1175,58.80869565,66.2356435610/21/2016,700,69.30098039,67.3425,59.03,66.0247524810/21/2016,715,69.03168317,67.305,59.06111111,65.9237623810/21/2016,730,68.9049505,67.24125,58.31578947,65.5722772310/21/2016,745,68.786,67.04875,57.75294118,65.4633663410/21/2016,800,68.90594059,66.86375,57.28125,65.3316831710/21/2016,815,69.06960784,66.39375,57.2,65.5861386110/21/2016,830,69.01666667,66.3475,57.675,65.5673267310/17/2016,2130,69.01862745,66.67352941,56.73571429,65.5663366310/17/2016,2145,69.01372549,66.81862745,56.50555556,65.3910891110/17/2016,2200,69.07156863,66.72254902,56.16666667,65.4495049510/17/2016,2215,69.15686275,66.80294118,56.60555556,65.52410/17/2016,2230,69.116,66.74313725,56.97894737,65.53510/17/2016,2245,69.326,66.71372549,58.98,65.56310/17/2016,2300,69.178,66.75686275,58.13125,65.53710/17/2016,2130,69.03535354,65.07948718,60.34285714,66.8183673510/17/2016,2145,68.93636364,64.77435897,59.94705882,66.7193877610/17/2016,2200,68.94141414,64.67051282,61.4125,66.4632653110/17/2016,2215,68.86868687,64.91282051,60.73,66.0785714310/17/2016,2230,68.778,65.16794872,60.74,65.6510/17/2016,2245,68.795,64.96794872,60.56363636,65.5908163310/17/2016,2300,68.768,64.36282051,60.54,65.4525773210/17/2016,2130,68.755,65.03125,61.3,65.3278350510/17/2016,2145,68.78888889,65.23,62.2375,65.11855679/7/2016,945,68.807,68.24019608,61.51818182,65.002061869/7/2016,1000,68.91616162,68.41176471,60.425,65.135714299/7/2016,945,68.964,66.05063291,60.34444444,65.41855679/7/2016,1000,68.914,66.08101266,59.85454545,65.513402069/2/2016,745,68.96868687,70.00769231,59.81818182,65.485567019/2/2016,800,68.89393939,69.83846154,60.44,65.443298979/2/2016,815,68.919,69.94854369,55.15714286,65.432989699/2/2016,830,68.903,69.82718447,59.33333333,65.592857149/2/2016,845,69.014,69.61747573,60.16,65.713265319/2/2016,900,69.186,69.65825243,60.66666667,65.708080819/2/2016,915,69.186,69.82718447,59.1,65.849494959/2/2016,930,69.128,69.8815534,59.28181818,66.224242429/2/2016,945,69.08989899,69.45192308,57.51428571,66.346464659/2/2016,1000,69.27878788,69.54615385,54.46153846,66.79898999/2/2016,1015,69.57979798,69.62135922,55.13125,67.621212129/2/2016,1030,69.72020202,69.70288462,58.475,68.434343439/2/2016,1045,69.86868687,69.64326923,57.53846154,68.50303039/2/2016,1100,70.13737374,69.62912621,56.56666667,68.872727279/2/2016,1115,70.49494949,69.50291262,55.62941176,68.268686879/2/2016,1130,70.75353535,69.58446602,54.08,67.59/2/2016,745,70.91717172,67.04875,53.79230769,62.676767689/2/2016,800,71.072,66.86375,55.58666667,53.023232329/2/2016,815,71.16336634,66.39375,55.58181818,46.672727279/2/2016,830,71.20693069,66.3475,56.79545455,47.707070719/2/2016,845,71.45841584,66.2225,55.68125,50.673469399/2/2016,900,71.5990099,66.575,56.89444444,52.979797989/2/2016,915,71.63861386,66.30625,60.1375,58.153535358/2/2016,1615,71.5980198,68.54854369,58.125,62.330303038/2/2016,1630,71.76732673,68.36893204,58.82727273,66.2758/2/2016,1645,71.87029703,68.21165049,58.81176471,67.928/2/2016,1700,71.75445545,68.53009709,60.02142857,68.1968/2/2016,1715,71.69108911,68.67475728,59.97333333,68.6248/2/2016,1730,71.39405941,68.95882353,59.66818182,68.2668/2/2016,1615,71.32079208,66.12375,57.81304348,67.8718/2/2016,1630,71.332,65.82,57.89473684,68.0258/2/2016,1615,71.254,65.24,58.51904762,68.138/2/2016,1630,71.06138614,65.8025,58.80869565,67.9977/28/2016,1900,70.88613861,68.19514563,59.03,68.090099017/28/2016,1915,71.14455446,68.13786408,59.06111111,67.821782187/28/2016,1930,71.15247525,68.26893204,58.01111111,67.79702977/28/2016,1945,71.10792079,68.06407767,58.31578947,67.754455457/28/2016,2000,71.10990099,68.1631068,56.73571429,67.775247527/28/2016,2015,71.0950495,68.11650485,58.98,67.8647/28/2016,2030,71.17722772,67.91442308,58.13125,67.7617/28/2016,2045,70.88316832,67.86730769,57.61333333,67.5897/28/2016,2100,70.87425743,67.63846154,59.56428571,67.742424247/8/2016,830,71.07029703,69.82718447,60.18823529,67.70404047/8/2016,845,71.2950495,69.61747573,61.3,67.681818187/8/2016,900,71.3029703,69.65825243,60.34285714,67.717171727/8/2016,915,71.27524752,69.82718447,59.94705882,67.59595967/8/2016,930,71.17425743,69.8815534,61.4125,67.508080817/8/2016,945,71.18514851,69.45192308,60.73,67.746464656/18/2016,1815,71.12871287,69.29009901,60.425,67.681818186/18/2016,1830,71.04950495,69.23267327,60.34444444,67.945454556/18/2016,1815,70.83861386,67.57307692,60.26363636,68.054545456/18/2016,1830,70.8980198,67.34358974,60.44,68.089898996/18/2016,1815,70.69009901,67.67820513,55.61428571,68.123232326/18/2016,1830,70.58613861,67.78461538,59.33333333,67.9336/18/2016,1845,70.46534653,67.98860759,59.1,67.953465356/18/2016,1900,70.55643564,68.07594937,59.28181818,67.684158426/18/2016,1915,70.71287129,67.26835443,56.93333333,67.994059416/18/2016,1930,70.63960396,67.2,57.93333333,67.932673276/18/2016,1815,70.49207921,67.16901408,55.13125,67.861386146/18/2016,1830,70.37722772,66.97183099,57.45,67.623762386/18/2016,1845,70.31782178,66.71408451,57.79166667,67.409900996/18/2016,1900,70.25,66.63661972,57.78,67.108910896/18/2016,1915,70.14215686,65.77746479,58.475,66.939603966/18/2016,1930,70.32156863,66.07323944,56.46363636,66.89504956/18/2016,1945,70.27745098,65.94225352,57.53846154,66.715841586/18/2016,2000,70.02941176,65.47183099,56.23333333,66.658415846/18/2016,2015,69.66960784,65.1915493,55.62941176,66.592079216/18/2016,2030,69.47647059,64.65352113,54.08,66.456435645/10/2016,645,69.37941176,68.49306931,53.79230769,66.235643565/10/2016,700,69.30098039,68.75445545,55.58666667,66.024752485/10/2016,715,69.03168317,68.81881188,54.7,65.923762385/10/2016,730,68.9049505,68.76336634,56.01578947,65.572277235/10/2016,745,68.786,68.77722772,55.58181818,65.463366345/10/2016,800,68.90594059,68.57425743,56.79545455,65.331683175/10/2016,815,69.06960784,68.55049505,55.68125,65.586138615/10/2016,830,69.01666667,68.72277228,56.89444444,65.567326734/4/2016,945,69.01862745,69.374,60.1375,65.566336634/4/2016,1000,69.01372549,69.375,58.125,65.391089114/4/2016,1015,69.07156863,69.494,58.82727273,65.449504953/14/2016,615,69.15686275,68.61,58.81176471,65.5243/14/2016,630,69.116,68.87,59.66818182,65.5353/14/2016,645,69.326,69.28888889,57.81304348,65.5633/14/2016,700,69.178,69.58787879,57.89473684,65.5373/13/2016,2200,69.03535354,68.72178218,58.0952381,66.818367353/13/2016,2215,68.93636364,68.43235294,58.19473684,66.719387763/13/2016,2230,68.94141414,68.40294118,58.51904762,66.463265313/13/2016,1215,68.86868687,71.71782178,58.80869565,66.078571433/13/2016,1230,68.778,71.53168317,59.03,65.653/13/2016,1245,68.795,71.37524752,59.06111111,65.590816333/13/2016,1300,68.768,71.59207921,58.01111111,65.452577323/8/2016,1115,68.755,68.64653465,58.31578947,65.327835053/8/2016,1130,68.78888889,68.73069307,57.75294118,65.11855673/8/2016,1145,68.807,68.36138614,57.28125,65.002061862/25/2016,1245,68.91616162,67.61584158,57.2,65.135714292/25/2016,1300,68.964,67.93168317,56.50555556,65.41855672/25/2016,1315,68.914,68.202,56.16666667,65.513402062/25/2016,1330,68.96868687,68.161,56.60555556,65.485567012/25/2016,1345,68.89393939,68.359,59.56428571,65.443298972/25/2016,1400,68.919,68.64141414,60.18823529,65.432989692/25/2016,1415,68.903,68.64455446,61.3,65.592857142/25/2016,1430,69.014,68.81568627,61.4125,65.713265312/25/2016,1445,69.186,69.03465347,60.73,65.708080812/25/2016,1500,69.186,69.15656566,60.74,65.849494952/25/2016,1515,69.128,68.66237624,60.56363636,66.224242422/25/2016,1530,69.08989899,68.82475248,62.2375,66.346464652/25/2016,1545,69.27878788,68.726,60.58,66.79898992/25/2016,1600,69.57979798,68.43069307,61.51818182,67.62121212
Num Error CSV Example:
Date,Time,Sensor_2278,Sensor_3276,Sensor_4689,Sensor_503212/12/2017,1345,68.96868687,68.36862745,57.5625,65.4855670112/12/2017,1400,68.89t93939,68.51176471,57.45,65.4432989712/12/2017,1415,68.919,68.47843137,57.79166667,65.4329896912/12/2017,1430,68.903,68.41666667,56.46363636,65.5928571412/12/2017,1445,69.014,68.61862745,57.53846154,65.7132653112/12/2017,1500,69.186,68.41165049,56.56666667,65.7080808112/12/2017,1515,69.186,68.27254902,56.23333333,65.8494949512/12/2017,1400,69.128,66.47468354,54.08,66.2242424212/12/2017,1415,69.08989899,66.24683544,53.79230769,66.3464646512/8/2017,830,69.27878788,69.82718447,55.58666667,66.798989912/8/2017,845,69.57979798,69.61747573,54.7,67.6212121212/8/2017,900,69.72020202,69.65825243,56.01578947,68.4343434312/8/2017,845,69.86868687,66.2225,55.58181818,68.503030312/8/2017,900,70.13737374,66.575,56.79545455,68.8727272712/8/2017,845,70.49494949,66.88875,55.68125,68.2686868712/8/2017,900,70.75353535,67.065,56.89444444,67.512/8/2017,915,70.91717172,66.28375,60.1375,62.6767676812/8/2017,200,71.072,67.12647059,57.92857143,53.0232323212/8/2017,215,71.16336634,67.14950495,58.125,46.6727272712/8/2017,230,71.20693069,67.24752475,57.81304348,47.7070707112/8/2017,245,71.45841584,67.1970297,57.89473684,50.6734693912/8/2017,300,71.5990099,67.26960784,58.0952381,52.9797979812/8/2017,200,71.63861386,64.46666667,58.19473684,58.1535353512/8/2017,215,71.5980198,64.69113924,58.51904762,62.3303030312/8/2017,230,71.76732673,64.37820513,58.80869565,66.27512/8/2017,145,71.87029703,67.18653846,59.03,67.9212/8/2017,200,71.75445545,67.12647059,59.06111111,68.19612/8/2017,215,71.69108911,67.14950495,58.01111111,68.62412/8/2017,230,71.39405941,67.24752475,58.31578947,68.26612/8/2017,245,71.32079208,67.1970297,57.75294118,67.87112/8/2017,300,71.332,67.26960784,57.28125,68.02512/8/2017,145,71.254,64.38875,57.2,68.1312/8/2017,200,71.06138614,64.46666667,57.675,67.99712/8/2017,215,70.88613861,64.69113924,56.73571429,68.0900990112/8/2017,230,71.14455446,64.37820513,56.50555556,67.8217821810/31/2017,1630,71.15247525,68.36893204,56.16666667,67.797029710/31/2017,1645,71.10792079,68.21165049,56.60555556,67.7544554510/31/2017,1700,71.10990099,68.53009709,56.97894737,67.7752475210/31/2017,1630,71.0950495,65.82,57.61333333,67.86410/31/2017,1645,71.17722772,65.95,59.56428571,67.76110/3/2017,1015,70.88316832,68.48514851,60.18823529,67.58910/3/2017,1030,70.87425743,68.52970297,61.3,67.7424242410/3/2017,1015,71.07029703,65.95189873,61.49333333,67.704040410/3/2017,1030,71.2950495,66.36455696,60.9,67.6818181810/3/2017,1045,71.3029703,65.92151899,60.34285714,67.7171717210/3/2017,1100,71.27524752,65.90886076,59.94705882,67.595959610/3/2017,1115,71.17425743,66.17468354,60.38333333,67.5080808110/3/2017,1015,71.18514851,67.0625,61.4125,67.7464646510/3/2017,1030,71.12871287,66.765,60.73,67.6818181810/3/2017,1045,71.04950495,66.70375,60.74,67.9454545510/3/2017,1100,70.83861386,66.71375,60.54,68.0545454510/3/2017,1115,70.8980198,66.33125,61.13333333,68.0898989910/3/2017,1130,70.69009901,66.73,61.3,68.123232329/22/2017,945,70.58613861,69.45192308,62.2375,67.9339/22/2017,1000,70.46534653,69.54615385,63.02857143,67.953465359/22/2017,1015,70.55643564,69.62135922,61.14285714,67.684158429/22/2017,1030,70.71287129,69.70288462,60.18571429,67.994059419/22/2017,1045,70.63960396,69.64326923,60.99,67.932673279/22/2017,945,70.49207921,66.61,55.58181818,67.861386149/22/2017,1000,70.37722772,66.48,56.79545455,67.623762389/22/2017,1015,70.31782178,66.3675,55.68125,67.409900999/22/2017,1030,70.25,66.06125,56.89444444,67.108910899/9/2017,900,70.14215686,71.48415842,60.1375,66.939603969/9/2017,915,70.32156863,71.5049505,57.92857143,66.89504959/9/2017,930,70.27745098,71.47425743,58.125,66.715841589/9/2017,945,70.02941176,71.20990099,58.82727273,66.658415849/9/2017,1000,69.66960784,70.84950495,58.81176471,66.592079219/9/2017,1015,69.47647059,71.0019802,60.02142857,66.456435649/9/2017,900,69.37941176,68.11265823,59.97333333,66.235643569/9/2017,915,69.30098039,67.95063291,59.66818182,66.024752489/9/2017,930,69.03168317,67.90632911,57.81304348,65.923762389/9/2017,945,68.9049505,67.85063291,57.89473684,65.572277239/9/2017,1000,68.786,68.25443038,58.0952381,65.463366349/9/2017,1015,68.90594059,67.93037975,58.19473684,65.331683179/9/2017,1030,69.06960784,67.90253165,58.80869565,65.586138617/28/2017,845,69.01666667,69.61747573,59.03,65.567326737/28/2017,900,69.01862745,69.65825243,59.06111111,65.566336637/28/2017,915,69.01372549,69.82718447,58.01111111,65.391089117/28/2017,930,69.07156863,69.8815534,58.31578947,65.449504957/28/2017,845,69.15686275,66.2225,57.75294118,65.5247/28/2017,900,69.116,66.575,57.28125,65.5357/28/2017,845,69.326,66.88875,57.2,65.5637/28/2017,900,69.178,67.065,57.675,65.5376/28/2017,630,69.03535354,68.41188119,56.50555556,66.818367356/28/2017,645,68.93636364,68.62475248,56.16666667,66.719387766/28/2017,700,68.94141414,68.70792079,56.60555556,66.463265316/21/2017,1530,68.86868687,68.58653846,58.13125,66.078571436/21/2017,1545,68.778,68.66826923,59.56428571,65.655/21/2017,1800,68.795,70.77156863,60.18823529,65.590816335/21/2017,1815,68.768,70.69901961,61.3,65.452577325/21/2017,1830,68.755,70.64117647,61.49333333,65.327835055/21/2017,1845,68.78888889,70.06764706,60.34285714,65.11855675/21/2017,1900,68.807,69.87352941,59.94705882,65.002061865/21/2017,1915,68.91616162,69.7627451,61.4125,65.135714295/21/2017,1930,68.964,69.85490196,60.74,65.41855675/21/2017,1945,68.914,70.10686275,60.56363636,65.513402065/21/2017,2000,68.96868687,69.99117647,60.54,65.485567015/21/2017,2015,68.89393939,69.79705882,61.3,65.443298975/21/2017,2030,68.919,69.53465347,62.2375,65.432989695/21/2017,2045,68.903,69.38613861,60.58,65.592857145/21/2017,1830,69.014,67.6721519,61.51818182,65.713265315/21/2017,1845,69.186,67.60886076,63.21428571,65.708080815/21/2017,1900,69.186,67.62531646,63.02857143,65.849494955/21/2017,1915,69.128,67.50253165,60.44,66.224242425/21/2017,1930,69.08989899,67.59873418,57.51428571,66.346464655/21/2017,1830,69.27878788,68.26329114,54.46153846,66.79898995/21/2017,1845,69.57979798,68.16075949,57.79166667,67.621212125/21/2017,1900,69.72020202,68.19873418,57.78,68.434343435/21/2017,1915,69.86868687,68.16708861,57.39090909,68.50303035/21/2017,1930,70.13737374,68.3164557,56.46363636,68.872727275/21/2017,1945,70.49494949,67.70253165,57.53846154,68.268686875/21/2017,2000,70.75353535,67.8443038,56.56666667,67.55/21/2017,2015,70.91717172,67.19746835,56.23333333,62.676767685/21/2017,1830,71.072,66.93098592,55.62941176,53.023232325/21/2017,1845,71.16336634,67.08028169,54.08,46.672727275/21/2017,1900,71.20693069,67.25070423,53.79230769,47.707070715/21/2017,1915,71.45841584,66.94507042,56.01578947,50.673469395/21/2017,1930,71.5990099,66.45492958,55.58181818,52.979797985/21/2017,1945,71.63861386,66.10704225,56.79545455,58.153535355/21/2017,1830,71.5980198,63.07868852,60.1375,62.330303035/21/2017,1845,71.76732673,63.29836066,57.92857143,66.2755/21/2017,1900,71.87029703,63.29836066,58.125,67.925/21/2017,1915,71.75445545,62.89508197,58.82727273,68.1964/8/2017,1115,71.69108911,70.67,60.18823529,68.6244/8/2017,1130,71.39405941,70.355,61.3,68.2664/8/2017,1115,71.32079208,67.60759494,61.49333333,67.8714/8/2017,1130,71.332,67.59873418,59.94705882,68.0254/8/2017,1145,71.254,67.39493671,60.38333333,68.134/8/2017,1200,71.06138614,67.4721519,61.4125,67.9974/8/2017,1215,70.88613861,67.95189873,60.73,68.090099014/8/2017,1230,71.14455446,67.87594937,60.74,67.821782184/8/2017,1245,71.15247525,67.33291139,60.56363636,67.79702974/8/2017,1300,71.10792079,67.42025316,60.54,67.754455454/8/2017,1315,71.10990099,67.91265823,61.13333333,67.775247524/8/2017,1330,71.0950495,67.33164557,61.3,67.8641/20/2017,1915,71.17722772,69.2745098,60.26363636,67.7611/20/2017,1930,70.88316832,69.34455446,59.85454545,67.5891/20/2017,1915,70.87425743,66.73670886,60.44,67.742424241/20/2017,1930,71.07029703,66.52278481,55.61428571,67.70404041/20/2017,1945,71.2950495,65.81772152,59.33333333,67.681818181/20/2017,1915,71.3029703,66.69113924,60.16,67.717171721/20/2017,1930,71.27524752,66.93037975,55.13125,67.59595961/20/2017,1945,71.17425743,66.72405063,57.45,67.508080811/20/2017,2000,71.18514851,66.69113924,57.78,67.746464651/20/2017,1915,71.12871287,65.9943662,58.475,67.681818181/20/2017,1930,71.04950495,65.63943662,56.46363636,67.945454551/20/2017,1945,70.83861386,65.74507042,56.23333333,68.054545451/20/2017,2000,70.8980198,65.33239437,55.62941176,68.089898991/20/2017,2015,70.69009901,64.9056338,53.79230769,68.1232323211/22/2016,15,70.58613861,66.78333333,55.58666667,67.93311/22/2016,30,70.46534653,66.63137255,54.7,67.9534653511/22/2016,45,70.55643564,66.52352941,56.01578947,67.6841584211/22/2016,15,70.71287129,64.09871795,55.58181818,67.9940594111/22/2016,30,70.63960396,64.22564103,56.79545455,67.9326732710/28/2016,745,70.49207921,70.00769231,55.68125,67.8613861410/28/2016,800,70.37722772,69.83846154,56.89444444,67.6237623810/28/2016,815,70.31782178,69.94854369,60.1375,67.4099009910/28/2016,830,70.25,69.82718447,57.92857143,67.1089108910/28/2016,745,70.14215686,67.04875,58.125,66.9396039610/28/2016,800,70.32156863,66.86375,58.82727273,66.895049510/21/2016,615,70.27745098,68.51747573,57.81304348,66.7158415810/21/2016,630,70.02941176,68.91262136,57.89473684,66.6584158410/21/2016,615,69.66960784,66.9675,58.19473684,66.5920792110/21/2016,630,69.47647059,67.2875,58.51904762,66.4564356410/21/2016,645,69.37941176,68.1175,58.80869565,66.2356435610/21/2016,700,69.30098039,67.3425,59.03,66.0247524810/21/2016,715,69.03168317,67.305,59.06111111,65.9237623810/21/2016,730,68.9049505,67.24125,58.31578947,65.5722772310/21/2016,745,68.786,67.04875,57.75294118,65.4633663410/21/2016,800,68.90594059,66.86375,57.28125,65.3316831710/21/2016,815,69.06960784,66.39375,57.2,65.5861386110/21/2016,830,69.01666667,66.3475,57.675,65.5673267310/17/2016,2130,69.01862745,66.67352941,56.73571429,65.5663366310/17/2016,2145,69.01372549,66.81862745,56.50555556,65.3910891110/17/2016,2200,69.07156863,66.72254902,56.16666667,65.4495049510/17/2016,2215,69.15686275,66.80294118,56.60555556,65.52410/17/2016,2230,69.116,66.74313725,56.97894737,65.53510/17/2016,2245,69.326,66.71372549,58.98,65.56310/17/2016,2300,69.178,66.75686275,58.13125,65.53710/17/2016,2130,69.03535354,65.07948718,60.34285714,66.8183673510/17/2016,2145,68.93636364,64.77435897,59.94705882,66.7193877610/17/2016,2200,68.94141414,64.67051282,61.4125,66.4632653110/17/2016,2215,68.86868687,64.91282051,60.73,66.0785714310/17/2016,2230,68.778,65.16794872,60.74,65.6510/17/2016,2245,68.795,64.96794872,60.56363636,65.5908163310/17/2016,2300,68.768,64.36282051,60.54,65.4525773210/17/2016,2130,68.755,65.03125,61.3,65.3278350510/17/2016,2145,68.78888889,65.23,62.2375,65.11855679/7/2016,945,68.807,68.24019608,61.51818182,65.002061869/7/2016,1000,68.91616162,68.41176471,60.425,65.135714299/7/2016,945,68.964,66.05063291,60.34444444,65.41855679/7/2016,1000,68.914,66.08101266,59.85454545,65.513402069/2/2016,745,68.96868687,70.00769231,59.81818182,65.485567019/2/2016,800,68.89393939,69.83846154,60.44,65.443298979/2/2016,815,68.919,69.94854369,55.15714286,65.432989699/2/2016,830,68.903,69.82718447,59.33333333,65.592857149/2/2016,845,69.014,69.61747573,60.16,65.713265319/2/2016,900,69.186,69.65825243,60.66666667,65.708080819/2/2016,915,69.186,69.82718447,59.1,65.849494959/2/2016,930,69.128,69.8815534,59.28181818,66.224242429/2/2016,945,69.08989899,69.45192308,57.51428571,66.346464659/2/2016,1000,69.27878788,69.54615385,54.46153846,66.79898999/2/2016,1015,69.57979798,69.62135922,55.13125,67.621212129/2/2016,1030,69.72020202,69.70288462,58.475,68.434343439/2/2016,1045,69.86868687,69.64326923,57.53846154,68.50303039/2/2016,1100,70.13737374,69.62912621,56.56666667,68.872727279/2/2016,1115,70.49494949,69.50291262,55.62941176,68.268686879/2/2016,1130,70.75353535,69.58446602,54.08,67.59/2/2016,745,70.91717172,67.04875,53.79230769,62.676767689/2/2016,800,71.072,66.86375,55.58666667,53.023232329/2/2016,815,71.16336634,66.39375,55.58181818,46.672727279/2/2016,830,71.20693069,66.3475,56.79545455,47.707070719/2/2016,845,71.45841584,66.2225,55.68125,50.673469399/2/2016,900,71.5990099,66.575,56.89444444,52.979797989/2/2016,915,71.63861386,66.30625,60.1375,58.153535358/2/2016,1615,71.5980198,68.54854369,58.125,62.330303038/2/2016,1630,71.76732673,68.36893204,58.82727273,66.2758/2/2016,1645,71.87029703,68.21165049,58.81176471,67.928/2/2016,1700,71.75445545,68.53009709,60.02142857,68.1968/2/2016,1715,71.69108911,68.67475728,59.97333333,68.6248/2/2016,1730,71.39405941,68.95882353,59.66818182,68.2668/2/2016,1615,71.32079208,66.12375,57.81304348,67.8718/2/2016,1630,71.332,65.82,57.89473684,68.0258/2/2016,1615,71.254,65.24,58.51904762,68.138/2/2016,1630,71.06138614,65.8025,58.80869565,67.9977/28/2016,1900,70.88613861,68.19514563,59.03,68.090099017/28/2016,1915,71.14455446,68.13786408,59.06111111,67.821782187/28/2016,1930,71.15247525,68.26893204,58.01111111,67.79702977/28/2016,1945,71.10792079,68.06407767,58.31578947,67.754455457/28/2016,2000,71.10990099,68.1631068,56.73571429,67.775247527/28/2016,2015,71.0950495,68.11650485,58.98,67.8647/28/2016,2030,71.17722772,67.91442308,58.13125,67.7617/28/2016,2045,70.88316832,67.86730769,57.61333333,67.5897/28/2016,2100,70.87425743,67.63846154,59.56428571,67.742424247/8/2016,830,71.07029703,69.82718447,60.18823529,67.70404047/8/2016,845,71.2950495,69.61747573,61.3,67.681818187/8/2016,900,71.3029703,69.65825243,60.34285714,67.717171727/8/2016,915,71.27524752,69.82718447,59.94705882,67.59595967/8/2016,930,71.17425743,69.8815534,61.4125,67.508080817/8/2016,945,71.18514851,69.45192308,60.73,67.746464656/18/2016,1815,71.12871287,69.29009901,60.425,67.681818186/18/2016,1830,71.04950495,69.23267327,60.34444444,67.945454556/18/2016,1815,70.83861386,67.57307692,60.26363636,68.054545456/18/2016,1830,70.8980198,67.34358974,60.44,68.089898996/18/2016,1815,70.69009901,67.67820513,55.61428571,68.123232326/18/2016,1830,70.58613861,67.78461538,59.33333333,67.9336/18/2016,1845,70.46534653,67.98860759,59.1,67.953465356/18/2016,1900,70.55643564,68.07594937,59.28181818,67.684158426/18/2016,1915,70.71287129,67.26835443,56.93333333,67.994059416/18/2016,1930,70.63960396,67.2,57.93333333,67.932673276/18/2016,1815,70.49207921,67.16901408,55.13125,67.861386146/18/2016,1830,70.37722772,66.97183099,57.45,67.623762386/18/2016,1845,70.31782178,66.71408451,57.79166667,67.409900996/18/2016,1900,70.25,66.63661972,57.78,67.108910896/18/2016,1915,70.14215686,65.77746479,58.475,66.939603966/18/2016,1930,70.32156863,66.07323944,56.46363636,66.89504956/18/2016,1945,70.27745098,65.94225352,57.53846154,66.715841586/18/2016,2000,70.02941176,65.47183099,56.23333333,66.658415846/18/2016,2015,69.66960784,65.1915493,55.62941176,66.592079216/18/2016,2030,69.47647059,64.65352113,54.08,66.456435645/10/2016,645,69.37941176,68.49306931,53.79230769,66.235643565/10/2016,700,69.30098039,68.75445545,55.58666667,66.024752485/10/2016,715,69.03168317,68.81881188,54.7,65.923762385/10/2016,730,68.9049505,68.76336634,56.01578947,65.572277235/10/2016,745,68.786,68.77722772,55.58181818,65.463366345/10/2016,800,68.90594059,68.57425743,56.79545455,65.331683175/10/2016,815,69.06960784,68.55049505,55.68125,65.586138615/10/2016,830,69.01666667,68.72277228,56.89444444,65.567326734/4/2016,945,69.01862745,69.374,60.1375,65.566336634/4/2016,1000,69.01372549,69.375,58.125,65.391089114/4/2016,1015,69.07156863,69.494,58.82727273,65.449504953/14/2016,615,69.15686275,68.61,58.81176471,65.5243/14/2016,630,69.116,68.87,59.66818182,65.5353/14/2016,645,69.326,69.28888889,57.81304348,65.5633/14/2016,700,69.178,69.58787879,57.89473684,65.5373/13/2016,2200,69.03535354,68.72178218,58.0952381,66.818367353/13/2016,2215,68.93636364,68.43235294,58.19473684,66.719387763/13/2016,2230,68.94141414,68.40294118,58.51904762,66.463265313/13/2016,1215,68.86868687,71.71782178,58.80869565,66.078571433/13/2016,1230,68.778,71.53168317,59.03,65.653/13/2016,1245,68.795,71.37524752,59.06111111,65.590816333/13/2016,1300,68.768,71.59207921,58.01111111,65.452577323/8/2016,1115,68.755,68.64653465,58.31578947,65.327835053/8/2016,1130,68.78888889,68.73069307,57.75294118,65.11855673/8/2016,1145,68.807,68.36138614,57.28125,65.002061862/25/2016,1245,68.91616162,67.61584158,57.2,65.135714292/25/2016,1300,68.964,67.93168317,56.50555556,65.41855672/25/2016,1315,68.914,68.202,56.16666667,65.513402062/25/2016,1330,68.96868687,68.161,56.60555556,65.485567012/25/2016,1345,68.89393939,68.359,59.56428571,65.443298972/25/2016,1400,68.919,68.64141414,60.18823529,65.432989692/25/2016,1415,68.903,68.64455446,61.3,65.592857142/25/2016,1430,69.014,68.81568627,61.4125,65.713265312/25/2016,1445,69.186,69.03465347,60.73,65.708080812/25/2016,1500,69.186,69.15656566,60.74,65.849494952/25/2016,1515,69.128,68.66237624,60.56363636,66.224242422/25/2016,1530,69.08989899,68.82475248,62.2375,66.346464652/25/2016,1545,69.27878788,68.726,60.58,66.79898992/25/2016,1600,69.57979798,68.43069307,61.51818182,67.62121212
Here is my code of what I have gotten so far:
Does not need to reflect any exception handling Design Specification Requirements: 90 points Use the Project2_template.java file as an outline for the project. 1. Display the project title, followed by a blank line a. This should only be displayed 1 time when the program executes 2. 20 points: Prompt the user to input the file name and location a. If a FileNotFoundException is thrown the file does not exist or path is incorrect inform the user and prompt for new input file b. Entering incorrect input should not cause the program to crash c. The file Speed_Data.csv must be used for this project d. The file contains 6 columns: 5. 6. 7. i. Date, Time, Sensor_2278, Sensor_3276, Sensor_4689, Sensor_5032 3. 25 points: Read the data in from the file and store each column in its own ArrayList a. If a NumberFormat Exception is thrown inform the user the file contains bad number input and prompt the user for a new input file 4. 20 points: Convert the date column format from MM/DD/YYYY to YYYY/MM/DD a. If a ParseException is thrown inform the user the file contains bad date data and prompt the user for a new input file Subtract each row of sensor3276 speed data from sensor2278 speed data and store the difference in an ArrayList Subtract each row of sensor5032 speed data from sensor4689 speed data and store the difference in an ArrayList Calculate the average speed for each row of data and store the average in an ArrayList a. Columns Sensor_2278, Sensor_3276, Sensor_4689, Sensor_5032 store the speed data 1
8. 25 points: Output the data from all 9 ArrayList into a new csv file "fileNameInput"_Difference.csv a. The new file name must be i. Example: If file name entered is Speed_Data.csv the new file should be named Speed Data Difference.csv b. The data must be comma separated c. The order of the columns must be: i. Date, Time, Sensor_2278, Sensor_3276, Sensor_4689, Sensor_5032, Section1_Diff, Section2_Diff, Total_Avg ii. Column headers are required Note: Refer to the sample output in the Example Output section below. Minimum Requirements: -100 points Use must use at least 1 try-catch in your project o Your try-catch/s should catch, handle, and recover from FileNotFoundExceptions, NumberFormatExceptions, and ParseExceptions Use must use ArrayList to store the file data and calculated data Additional Notes: Use the FileReader class wrapped with the Scanner class to read data in from file o You may want to read in each line and then split the data on the comma to load them into their respective ArrayList • Use the SimpleDateFormat class to convert the date format o Make sure to use the Date class from the Java utility package not the Date class from the Java SQL package Use the FileWriter class wrapped with the PrintWriter class to output data to the new file o Use the println() method to write to the file line by line If an exception is thrown make sure to clear any data from all the ArrayList • When using Scanner(System.in) to get input from the user do not close the input stream until the program exits Follow the commenting and programming guidelines outlined in the Commenting and Programming guide documents o Failure to do so will result in up to a 25-point reduction
Example Output Good Input Example: Project 2 Data Preprocessing Enter file name & location. Speed Data.csv Reading in Data from the file Speed Data.csv Converting Dates from MM/DD/YYYY to YYYY/MM/DD Calculating Speed Difference Calculating Speed Average Writing data to file Speed_Data_Difference.csv Done! Exiting Program Bad Input Example 1: Project 2 Data Preprocessing Enter file name & location. Speed Data.csv Reading in Data from the file Speed Data.csv *Bad Number Data in CSV File.* Check CSV file data and try again. Enter file name & location. Bad Input Example 2: Project 2 Data Preprocessing Enter file name & location. SpeedData.csv Reading in Data from the file SpeedData.csv *File does not exist or path was entered incorrectly.* Please try again. Enter file name & location. Bad Input Example 3: Project 2 Data Preprocessing Enter file name & location. Speed Data.csv Reading in Data from the file Speed Data.csv Converting Dates from MM/DD/YYYY to YYYY/MM/DD *Bad Date Data in CSV File.* Check CSV file data and try again. Enter file name & location.
100 import java.io.File; 11 import java.io.FileNotFoundException; 12 import java.io.FileReader; 13 import java.text.ParseException; 14 import java.text.SimpleDateFormat; 15 import java.util.Date; 16 import java.util.Scanner; 17 import java.util.ArrayList; 18 19 public class Project2 { 20 21 22 23 24 25 26 27 28 29 300 12345678 39 48 44 42 33 40 41 public static ArrayList dates = new ArrayList(); public static ArrayList times = new ArrayList(); public static ArrayList sensor2278 = new ArrayList(); public static ArrayList sensor3276 = new ArrayList(); public static ArrayList sensor4689 = new ArrayList();l public static ArrayList sensor5032 = new ArrayList(); public static ArrayList section1Diff = new ArrayList(); public static ArrayList section2Diff = new ArrayList(); public static ArrayList totalAvg = new ArrayList(); public static void main(String[] args) { System.out.println("Project 2 Data Preprocessing\n"); boolean flag = true; while (flag) { try{ //Use the FileReader class wrapped with the Scanner class to read data in from file //You may want to read in each line and then split the data on the comma to load them into their //respective ArrayList Scanner scnr = new Scanner(System.in); System.out.println("Enter file name & location."); String fileName = scnr.nextLine();
43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 } } FileReader inputFile = new FileReader(new Scanner (fileName)); if(fileName.equals("quit")) { flag = false; System.out.println("Ending Program"); scnr.close(); } else { } } continue; ConvertDate(dates); } catch (FileNotFoundException fe) { System.out.println("*File does not exist or path was entered incorrectly.* \r\n" + "Please try again."); } catch (Number FormatException ne) { System.out.println("*Bad Number Data in CSV File.* \r\n" + "Check CSV file data and try again.") } catch (ParseException pe) { System.out.println("*Bad Date Data in CSV File.* \r\n" + "Check CSV file data and try again.");
75 760 77 78 79 80 81 82 83 84 } public static void ConvertDate(ArrayList dates) { SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd"); String format = formatter. format (dates); System.out.println(format); }
I am confused and I have no idea what to do. I've tried googling but I am lost. I have attached instructions so I don't
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am