主頁 > 移動端開發 > 從到達時間到每小時平均任務數與一天中的時間對比

從到達時間到每小時平均任務數與一天中的時間對比

2021-10-16 18:19:43 移動端開發

我正試圖為我的研究分析真實世界的谷歌痕跡。我有以毫秒為單位的任務到達時間,我想在Y軸上表示 -> 每小時的平均任務數與X軸 -> 每天的小時數。到目前為止,我還在掙扎。為了簡單起見,我只放了2000個到達時間的數值。如果有任何幫助,我將非常感激。

將Python代碼翻譯成R:

one_hour_in_milliseconds = 1000*60*60
hours_in_a_day =  24

def get_tasks_per_hour_of_day(tasks_df)
    tasks_per_hour_df = tasks_df.groupby(F.floor(F. col("ts_submit") /F. lit(one_hour_in_milliseconds)。 別名("hour")。 count()。
    tasks_per_hour_of_week = tasks_per_hour_df.groupby((F. col("hour") % hours_in_a_day)。 別名("hour_of_day"). agg(F.avg("count")
    return tasks_per_hour_of_week

"ts_submit "對應于到達時間,它是這樣的:

"ts_submit "對應于到達時間。

arrival_time < - c(757956, 757956 757956,/span> 760949 760949, 760949 760949, 760949, 760949, 
    760949,/span> 760949 760950, 760950,  760950, 760950 760950, 760950, 760950, 
    772013, 870116 870116, 870116,  870117, 870117 870117, 870118, 870117, 
    870118, 919618 1107986, 1372983 1372983, 1372983,  1372984, 1372984, 
    1372984, 1398938 1398938, 1398938 1398939, 1423337 1423337, 1423337, 
    1423337, 1423337 1423337, 1423338 1423338, 1423338 1423339, 1423339, 
    1423339, 1437049 1437049, 1437049 1437050, 1437050 1437050, 1437050, 
    1437050, 1437050 1437051, 1437051 1437051, 1437051 1599232, 1599232, 
    1599232, 1599232 2073894, 2100114,  2100114, 2100114 2100114, 2100114, 
    2100114, 2100115 2112582, 2122978,  2135463, 2135463 2135464, 2135464, 
    2135464,/span> 2135464 2135464, 2135464 2135466, 2135466 2140221, 2140221, 
    2149856, 2149857 2149857,/span> 2175430 2175431, 2175431 2175431, 2175431, 
    2175431,/span> 2175432 2175432, 2175432 2199343, 2199343,  2199343, 2199343, 
    2199344, 2199344 2199345, 2199345 2199345, 2199346 2488835, 2488835, 
    2639241, 2639241 2639241, 2639241,  2639241, 2639242 2639242, 2639242, 
    2639242,/span> 2639242 2788104, 2788104 2788104,/span> 2788105 2788105, 2788105, 
    2851444,/span> 2851444 2851444, 2851444 2851445, 2851445 2851445, 2851445, 
    2851445,/span> 2851445 3094321, 3094321 3094321, 3238164 3238164, 3238164, 
    3238164, 3238165 3238165, 3238165 3238165, 3410843,  3410843, 3410843, 
    3413803, 3525977 3525978, 3525978 3525978, 3525978,  3525978, 3525978, 
    3549873,/span> 3549873 3549873, 3549873 3549873, 3549873 3549873, 3549873, 
    3549873,/span> 3549873 3851600, 3851601 3938009, 3938009 3938009, 3938009, 
    3986760, 4037632 4186660, 4186660,  4186660, 4186660 4205532, 4205532, 
    4205532,/span> 4223089 4223090, 4223090 4223090,/span> 4277981 4277981, 4277981, 
    4314340, 4314340 4365067, 4365067,  4365068, 4365068,  4365068, 4365068, 
    4365068, 4365068 4365068, 4365068,  4365068, 4365068 4607608, 4607608, 
    4839388, 4839388 4852011, 4852011 4852011, 4852011 4852011, 4852011, 
    4852011, 4948953 4948954, 4948954,  4950308, 4950308,  4950309, 4950309, 
    4950309, 4950309 5269837, 5286999 5334312,/span> 5475300 5548613, 5548613, 
    5797195,/span> 5797195 5797196, 5797196,  6003342, 6144761 6144761, 6144761, 
    6209245, 6232036 6385718,/span> 6497910,  6675175, 6675175 6726517, 6726517, 
    6751350, 6751350 6751350,/span> 6751351,  7146772, 7561379 7625130, 7625130, 
    7879679, 8109251 8183407, 8183407 8183407,/span> 8183408 8183408, 8183408, 
    8291747, 8341073 8341910,/span> 8341911,  8341911,/span> 8341912 8341912, 8341912, 
    8341912, 8341912 8341912,/span> 8341913 8341913, 8341913 8341914, 8341914, 
    8341914,/span> 8559979 8559979, 8559979 8597532, 8597532 8736044, 8736044, 
    8736044, 8847283 8847283, 8847283 8847283, 8886313 8886313, 8886313, 
    8923410,/span> 9386029 9386030, 9386030,  9683967,/span> 10109483,  10125754, 10125754, 
    10154979,/span> 10190049 10214849,/span> 10288755 10298767,/span> 10698932,  10698933, 10698933, 
    10698933,/span> 10911758 10937271, 10937271 11408067, 11408067,  12213612, 12213612, 
    12311840, 12311840 12311840, 12311840 12472906, 12509542,  12509542, 12509542, 
    12911217, 12911226 13163002, 13163002 13163002,/span> 13185420 13185420, 13185420, 
    13185420, 13185421 13185421, 13185421 13185421, 13252574 13374280, 13374280, 
    13398830, 13398830 13400736, 13475167 13475168, 13475169 13701338, 13701338, 
    13701339,/span> 13701339 13701339, 13701339,  13701339, 13701340,  13701340, 13701340, 
    13701340, 13701340 13701340, 13701340 13826250, 13826250 13826250, 13826250, 
    13954187, 13954187 13954187, 13954188 13962612,/span> 14072634,  14294046, 14294046,  
    14294047,/span> 14294047 14294047, 14294047 14294048, 14294048,  14294048, 
    14294049, 14294049 14294049,/span> 14364720,  14364720, 14364720 14364720, 
    14663840, 14874149 14874149, 14874149 14874149,/span> 14937730 15314089, 15314089, 
    15326106, 15326108 15326108, 15326108,  15326108, 15326108,  15326109, 15326109, 
    15326109,/span> 15326109 15326110, 15326110 15326110,/span> 15326111 15326111, 15326111, 
    15338576, 15486616 15486616,/span> 15647460 15647460, 15647460 15647460, 15647460,  
    15806441,/span> 15806441 15844483, 15844483 15844483, 15844483 15844483, 15844483,  
    15844483,/span> 15844483 15844483,/span> 15918805,  15918805, 15986737,  15986738, 15986738, 
    15986738,/span> 15986738 15986739, 15986740 16079743,/span> 16216549 16216549, 16216549, 
    16216549, 16216549 16254921, 16254921,  16254921,/span> 16254922 16254922, 16254922, 
    16254922, 16254922 16254922,/span> 16254923 16254923,/span> 16469030,  16530256, 16530256, 
    16530257, 16617988 16801458,/span> 16907652 17301184,/span> 17301185,  17301186, 17301186, 
    17301186,/span> 17458282 17458283, 17458283,  17458284, 17494866 17507368, 17507368, 
    17507368,/span> 17583714 17583714,/span> 17921147 18069403,/span> 18069404,  18069404, 18069404,  
    18094921, 18094921 18244693, 18244693 18244693, 18244693,  18244693, 18244693, 
    18391425, 18472661 18472661,/span> 18708037 18708037, 18797563 18821442, 18821442, 
    18844215,/span> 18981864 18981864, 18981864 19007073, 19009142 19084466, 19084466, 
    19084466, 19084466 19109977, 19198215,  19198215,/span> 19198216,  19348976, 19348976, 
    19410777,/span> 19410777 19410777, 19549339 19582661, 19660325 19709086, 19709086, 
    19758327, 19821920 19909761, 19909761 20080135, 20080135 20080135, 20080135, 
    20080135, 20143181 20296794, 20485668,  20485668, 20485668 20485668, 20485668, 
    20485668,/span> 20485669 20485669, 20485669 20522133,/span> 20524785 20524785, 20524785, 
    20538764,/span> 20538764 20787352,/span> 20834431,  21135456, 21135456,  21268106, 21268106, 
    21268106, 21307519 21695402, 21695402 21695402, 21695402 21695402, 21695402, 
    21695402, 21695403 21695403, 21695403 21700449,/span> 21708509 21708509, 21708509, 
    21846639, 21869462 21869463, 21869463 21911309, 21911309,  22113517, 22113517, 
    22113518,/span> 22113518 22132507,/span> 22175044 22175044, 22175044 22175044, 22175044, 
    22175044, 22175045 22175045, 22224907,  22274211, 22291331 22349386, 22349386, 
    22349386,/span> 22349388 22349388,/span> 22452173,  22464686, 22464686 22464687, 22464687, 
    22502278, 22571928 22571928, 22588242 22714864, 22866236 23227341, 23227341,  
    23227341,/span> 23250030 23251797, 23265533 23298161,/span> 23353828 23353828, 
    23353829,/span> 23353829 23353829, 23363507 23363507,/span> 23456219 23467556, 23467556, 
    23528672,/span> 23528672 23528672,/span> 23528673 23595173, 23605403 23605403, 23605403,  
    23664892, 23689971 23804575,/span> 24039832,  24095776, 24095776 24095776, 
    24095776,/span> 24095776 24095776, 24095776 24095776, 24095776 24095777, 24095777, 
    24104204, 24115500 24119849, 24120916 24352267, 24352267 24352267, 
    24442081, 24670784 24705243, 24705243,  24724065, 24864393 24949334, 24949334, 
    25007713,/span> 25007713 25010975, 25110349 25187708, 25187708,  25498002, 25498002, 
    25667013,/span> 25667013 25667013,/span> 25667014 25699719,/span> 25707399 25740850, 25740850, 
    26043560, 26064571 26064571, 26136232 26136233, 26136233 26136234, 26136234, 
    26136234, 26150821 26230497, 26259966 26291610, 26291610,  26644150, 26644150, 
    26644150,/span> 26644150 26644150,/span> 26785031 26785032,/span> 26785042,  26785042, 26785042,  
    26785042,/span> 26785042 26785042,/span> 26785043 26785043,/span> 26842512 26842512, 
    26920823, 27083447 27083448, 27083448 27083449, 27083449 27083449, 27083449,  
    27083450,/span> 27083450 27083450, 27083450,  27083450, 27083534,  27083534, 27083534, 
    27083534,/span> 27083534 270835, 27083536 27083536,/span> 27083537 27179751, 27179751, 
    27204895, 27514060 27681148, 27755972,  27755980,/span> 27755986,  27758456, 27758456, 
    28093450,/span> 28093450 28093450, 28142347 28210772, 28363317 28363317, 
    28497902, 28497902 28497902, 28497902 28497903, 28497903 28497903, 28497903,  
    28497904, 28497904 28497904, 28497904 28497904, 28497904 28497904, 28497904,  
    28497904, 28497904 28497905, 28497905,  28497905, 28497905 28497905, 28497905, 
    28546659,/span> 28546660 28546660, 28546660 28546660,/span> 28546661,  28546661, 28546661,  
    28551688,/span> 28551688 28551688,/span> 28551689 28551689,/span> 29248859 29248859, 
    29248859, 29309935 29535662, 29535662 29541149,/span> 29707778 29848098, 29848098, 
    29848098, 29983569 29983569, 29983569 29983569,/span> 29983570 29983570, 29983570, 
    30194883, 30442041 30442041, 30442041,  30525968,/span> 30525969,  30604622, 30604622, 
    30823608, 30885528 31159416, 31345499 32354843,/span> 32354844,  32354844, 32354844, 
    32354844, 32354845 32354845, 32354845,  32354846, 32354846,  32354846, 32354846, 
    32354846, 32354846 32443597, 32443597,  32443597, 32443597 32443597, 32443597, 
    32443598, 32443598 32443598, 32443598,  32443599, 32443599 32443599, 32443599, 
    32443600, 32443600 32443600,/span> 32443601,  32443601,/span> 32443603 32443603, 32443603,  
    32443604, 32443604 32443605, 32443605 32443606, 32443607 32443608, 32443608, 
    32443608, 32443609 32443609, 32443609 32443610, 32443610,  32443611, 32443611, 
    32443611, 32443612 32443613, 32443613,  32443613, 32443613,  32443614, 32443614, 
    32443615,/span> 32443616 32443617, 32443617,  32443617,/span> 32491340 32493301, 32493301, 
    32951556, 33037800 33098521, 33235764,  34113105, 34336104 34409634, 34409634, 
    34418071,/span> 34418071 34418071, 34418071 34418072, 34418072 34418072, 34418072, 
    34418073,/span> 34418073 34418074, 34418074 34418074, 34418074,  34637093, 34637093, 
    34637093,/span> 34637093 34637094, 34637094,  34761083, 34905880 34979175, 34979175, 
    34979175, 35016369 35016370, 35016370 35016371, 35016371,  35016371, 35016371, 
    35019674, 35019674 35166054, 35850468,  35859368, 36014996 36317663, 36317663, 
    36317663,/span> 36317663 36317664,/span> 36317665 36317666, 36317666,  36863673, 36863673, 
    36863674, 36929379 37088849, 37279075 37309596, 37309596,  37309597, 37309597, 
    37504453, 37528551 37530874, 37530874 37530875, 37530875 37530876, 37530876, 
    37530876, 37614185 37667591, 37702858,  37704580, 37704580 37714912, 37714912, 
    37855804, 38189537 38213184,/span> 38308386 38308386, 38308386 38308387, 38308387, 
    38308387,/span> 38308387 38308387, 38308387 38308387, 38308387 38308387, 38308387, 
    38308387, 38308388 38308388, 38308388 38308388, 38308389,  38308389, 38308389, 
    38308389, 38308389 38308389,/span> 38308390 38308390, 38308390 38308391, 38308391, 
    38308391, 38308391 38308392, 38308392 38308392, 38308392 38308392, 38308392, 
    38308393,/span> 38308393 38308393,/span> 38308394 38308394,/span> 38308395,  38308395, 38308395, 
    38308395, 38308395 38308396, 38308396 38308396, 38308396,  38308396, 38308396, 
    38430415, 39140178 39140178,/span> 39140179 39140179, 39140179 39415380, 39415380, 
    39575481,/span> 39575481 39575481, 39575481 39575482, 39575482,  39575483, 39575483, 
    39575483,/span> 39575483 39575483, 39583572 39670699, 39670699 39913944, 39913944, 
    39919941, 39941344 39941344, 39941344 39941344,/span> 39941345,  39941345, 39941345, 
    39941345, 39941345 39941345,/span> 40200753 40699497, 40699497 41230877, 41230877, 
    41230877, 41230878 41230878, 41312702 41423823, 42135444,  42135444, 42135444, 
    42135460, 42148090 42148150, 42148162,  42148162, 42212294,  42390686, 42390686, 
    42390686, 42390687 42390687, 42390687 42390688,/span> 42390689 42390690, 42390690, 
    42635231, 42635231 42638029, 42638029 42638029, 42980989 43344928, 43344928, 
    43485736, 44401393 44542352, 44542352 44736757, 44736757,  44736757, 44736757,  
    44736757, 44772454 44774029,/span> 44774030,  44808621, 44915963 45212960, 45212960, 
    45637062,/span> 45637062 45637062, 45637062 45637062,/span> 45776584 46184655, 46184655, 
    46357726,/span> 46357726 46357726,/span> 46357727,  46657424,/span> 46657425 46657425, 
    46657425, 46657425 46657425, 46657425,  46657425,/span> 46657426,  46657426, 
    46657426, 46657426 46657426, 46657426,  47360778,/span> 47433852,  47433852, 47433852, 
    47433852, 47433984 47433985,/span> 47604913,  47662504, 47662504,  47662505, 47662505, 
    47662505, 47662505 47662505, 47662505 47662506, 47662506 47814440, 47814440, 
    47814440, 47814440 47849206,/span> 47849207 47849207, 47849207 47849208, 47849208, 
    47861403,/span> 47861403 47861403, 47861403 47861403,/span> 47861404 47861404, 47861404, 
    47861404,/span> 47861404 47861404,/span> 47861405,  47861405, 47861405 47861405, 47861405, 
    47861406,/span> 47861406 47861406,/span> 47861407 47861407, 47861407,  47861407, 47861407, 
    47861408, 48463583 48469546, 48524758 48661693, 48673536,  48673536, 48673536, 
    48673536, 48673537 48689005, 48699797 48699798, 48699798 48699799, 48699799, 
    48699799,/span> 48699800 48699800, 48699801 48699801,/span> 48699802 48699802, 48699802, 
    48723653,/span> 48723653 48723653,/span> 49037695,  49037699,/span> 49163896 49189852, 49189852, 
    49189852, 49286549 49286549,/span> 49297165 49325507,/span> 49334090,  49337118, 49337118, 
    49749268,/span> 49749269 49758997, 49800456,  49800456, 49800456 49800457, 49800457, 
    49800457, 49800457 49800457, 49800457 49800457, 49800457 49800458, 49800458, 
    49800458, 49800458 49800458, 50114159,  50265451,/span> 50469956 50482424, 50482424, 
    50482424,/span> 50482424 50482424, 50482424 50482424,/span> 50482425 50482425, 
    50482425,/span> 50482425 50482426, 50482426 50482426, 50482426 50482427, 
    50482427,/span> 50482427 50482427, 50482427,  50482427,/span> 50482428 50482428, 
    50482428,/span> 50482428 50482429, 50482429 50482429, 50482429 50482429, 
    50482431,/span> 50482431 50482431, 50482431 50482431, 50482431 50482432, 50482432, 
    50482432,/span> 50482433 50482433, 50482433,  50482433, 50482433,  50482433, 
    50482434,/span> 50636008 50636008, 50639808 50639809, 50639809 50639809, 50639809, 
    50639810,/span> 50680249 51425487,/span> 51568769,  51582475,/span> 51855743 52094367, 52094367, 
    52406956,/span> 52406956 52481978,/span> 52550437 52560092, 52560092 52754531, 52754531, 
    53021992, 53021992 53021992,/span> 53021993,  53021993,/span> 53021994,  53021994, 53021994, 
    53021994, 53021995 53021995,/span> 53037426 53037427, 53037427,  53060227, 53060227, 
    53281608,/span> 53281608 53281608,/span> 53307653,  53355669, 53355669 53647271, 53647271, 
    53647272, 53709981 53709982, 53720672,  53720690,/span> 53795612,  53795612, 53795612, 
    53795613,/span> 53795613 53795613, 53795615 53795615, 53795616 53795616, 53795616,  
    53795616,/span> 53795618 53795618, 53795619 53795619, 53795619 53925439, 53925439, 
    54010507, 54537694 54637861,/span> 54738366 54845159,/span> 54873097,  54892639, 54892639, 
    54950924, 54979981 54979981, 54979981 55107460, 55390353,  55390353, 55390353, 
    55390353, 55390353 55390353,/span> 55390354 55390354, 55390354 55390354, 55390354, 
    55390354, 55545710 55545710, 55560762 55560763,/span> 55571473 55571473, 55571473, 
    55571474,/span> 55574240 55574241, 55574241,  55574241, 55574241 55574241, 55574241, 
    55574241, 55574241 55638292,/span> 55668469 55832897, 55860912 55860913, 55860913,  
    55860913, 55860914 55860914, 55887756,  56198611,/span> 56198612,  56198612, 56198612, 
    56198612,/span> 56198612 56198613, 56198613 56198613,/span> 56494310 56494310, 56494310, 
    56517633,/span> 56517633 56517633,/span> 56517642,  56519945, 56530111 56530112, 56530112, 
    56793944,/span> 56793944 56793944, 56793944 56893498, 56897176 57142484, 57142484, 
    57253989, 57329324 57369776, 57369776 57369776, 57369776,  57889818, 57889818, 
    57889818, 57889818 57889819, 57889819 57889819, 57889819 57891918, 57891918, 
    57891919,/span> 57891919 57891919,/span> 57961257 58176575, 58176575 58176576, 58176576, 
    58176576, 58176576 58176577, 58176577,  58377258, 5837725858377259, 58377260 58443163,/span> 58627503 58741438,/span> 58931876 59079448, 59079448, 
    59079448, 59079448 59079448,/span> 59079449 59079449,/span> 59079450 59079450, 59079450, 
    59079451,/span> 59084904 59084905, 59112957 59129501, 59129501 59129501, 59129501, 
    59129501, 59129501 59129502, 59129502 59176863, 59225796 59225796, 59225796, 
    59268481, 59268481 59371229,/span> 59371230,  59439688, 59447236,  59447236, 59447236, 
    59447236,/span> 59447237 59447237,/span> 59447238,  59683626,/span> 59940114 60325859, 60325859, 
    60411051, 60634569 60634569,/span> 60729839,  60824385,/span> 60829336,  60988482, 60988482, 
    61011801, 61011801 61090753,/span> 61205430 61245545,/span> 61336568 61657853, 61657853, 
    61657853,/span> 61657854 61657854,/span> 61657855,  61657855, 61657855,  61682564, 61682564, 
    61685227, 61912488 61912488, 61912488,  62012104, 62012104 62012104, 62012104,  
    62012105, 62058074 62058919,/span> 62513624 62528305,/span> 62575355 62671367, 62671367, 
    62694310, 62806735 62806735,/span> 62871168 62885177,/span> 62885179 62886202, 62886202, 
    62886202, 62886202 62886203,/span> 62886204 62886204,/span> 62886205 62886205, 
    62933437,/span> 63125213 63171350, 63171350 63214146, 63214146,  63262433, 63262433, 
    63360290, 63444920 63447598,/span> 63546986 63751354,/span> 63787894 63787895, 63787895, 
    63833676,/span> 63981489 63981489,/span> 63997975 64384806, 64522143,  64522143, 64522143, 
    64522143, 64522143 64522144,/span> 64536594 64536594, 64660657 64796620, 64796620, 
    64796620, 64796620 64999801,/span> 65233922,  65267983, 65267983,  65405554, 65405554, 
    65539371,/span> 65625725 65704385, 65760736,  66161330,/span> 66316074,  66364353, 66364353, 
    66364353,/span> 66364353 66466991,/span> 66488145 66488145,/span> 66506952 66506953, 66506953,  
    66579607, 66740301 66740302, 66740302 66740302, 66740302 66740302, 66740302, 
    66740303,/span> 66740303 66820009,/span> 67091236 67091236, 67091236 67113527, 67113527, 
    67151838, 67248954 67248955, 67248955 67248955, 67248955,  67408976, 67408976, 
    67573552,/span> 67573552 67666935, 67881803,  67916236,/span> 67971425 68246431, 68246431, 
    68471507, 68495414 68780188, 68837867 69068470, 69068470 69068470, 69068470,  
    69068470,/span> 69068471 69068472, 69068472,  69068472, 69068473,  69068473, 69068473, 
    69273410,/span> 69273410 69478571, 69545443 69545444, 69545444 69907898, 69907898, 
    70189600,/span> 70189601 70718202,/span> 70724278,  70724278,/span> 70796341 70796341, 70796341, 
    70826560,/span> 70857008 70862056,/span> 70863680 70863681, 70863681,  70943370, 70943370, 
    71004502,/span> 71004503 71053539, 71059974,  71059974, 71075017,  71079823, 71079823, 
    71097524, 71100997 71100997, 71100997 71134237, 71134237 71134237, 71134237, 
    71134238,/span> 71134238 71134238, 71134238 71134238, 71134238 71134238, 71134238, 
    71134238,/span> 71134239 71134239, 71134239 71134239, 71134239 71134239, 71134239, 
    71290708,/span> 71290708 71290708,/span> 71329874 71329874,/span> 71370725,  71370725, 71370725, 
    71370725, 71370725 71370726, 71370726 71469848, 71469848 71539790, 71539790, 
    71539790,/span> 71563614 71622432,/span> 71806530 71806530,/span> 71806531,  72135750, 72135750, 
    72178223,/span> 72178223 72274414,/span> 72351729,  72675060,/span> 72675061 72675061, 72675061, 
    72675061, 72675061 72675062, 72675062,  72675062, 72675062 72675063, 72675063, 
    72675063, 72675063 72675063, 72675063,  72675063, 72777183,  72777183, 72777183, 
    72777183, 72777184 72777184, 72777184 72777185,/span> 72777186,  72777186, 
    72780189,/span> 72780189 72780189, 72780189,  72780190, 72780190 72780190, 72780190,  
    72780190,/span> 72788659 72796723,/span> 72978870 73207448,/span> 73401342 73522703, 73522703, 
    73522703, 73566900 73566901, 73566901,  73566901,/span> 73572839,  73585497, 73585497, 
    73585497,/span> 73585498 73585619, 73585619 73683372, 73735106,  73755927, 73755927, 
    73755927,/span> 73755928 73762112 73833778 73833778,/span> 74026418 74029109, 74029109, 
    74060244, 74097558 74143707, 74143707,  74143707, 74143707 74143708, 74143708, 
    74143708, 74143708 74143720,/span> 74143721,  74143721, 74143721 74143722, 74143722, 
    74143722,/span> 74143723 74143723, 74143723 74143724,/span> 74163648,  74163648, 74163648, 
    74163648, 74163649 74163650, 74163650,  74163650, 74163650 74163650, 74163650, 
    74163651,/span> 74163651 74225586, 74229234 74229234,/span> 74244927 74244927, 74244927, 
    74267674, 74267674 74468446,/span> 74529190 74546378, 74550484,  74608548, 74608548, 
    74680812, 74680812 74680812,/span> 74680813 74680813, 74680813 74680814, 74680814, 
    74722815,/span> 74872271 74895622, 74895623 74952896, 75123194 75123194, 75123194, 
    75287349,/span> 75396027 75396027,/span> 75396028 75396028, 75694684 75697179, 75697179, 
    75788767, 75806456 76004572, 76175984 76178539,/span> 76178540,  76665433, 76665433, 
    76789974, 76789974 76789975, 76789975 76984916, 77088158 77088158, 77088158, 
    77211792, 77220562 77269965, 77398749 77398749,/span> 77460675 77553760, 77553760, 
    77737735, 77773127 77848104, 78098123 78186359,/span> 78278050,  78278050, 
    78278050, 78292132 78315016,/span> 78361410 78361410, 78361410 78361448, 78361448, 
    78361448, 78361448 78385967, 78385967 78385967, 78385968 78410826, 78410826, 
    78510022,/span> 78531930 78535277, 78535277 78572226,/span> 78611469 78639538, 78639538, 
    78657266, 78688108 78787315, 78787315,  78857986, 78857986 78894564, 78894564, 
    78894564, 79051278 79070637,/span> 79174030,  79246177,/span> 79350675 79406571, 79406571, 
    79639643, 79639643 79639643,/span> 79707252 79746611,/span> 79985433 79985436, 79985436, 
    79985436,/span> 80008991 80041214, 80085547 80144783,/span> 80311060,  80491693, 80491693, 
    80491693, 80491693 80491693,/span> 80491694 80505779,/span> 80559619,  80644479, 80644479, 
    80880743, 80880744 80920419, 80920419,  80920420,/span> 81018404 81022920, 81022920, 
    81110021, 81152159 81152160,/span> 81154987 81154988, 81154988,  81196294, 81196294, 
    81201358, 81201358 81201358, 81204946,  81305550,/span> 81347707,  81347708, 81347708, 
    81347708, 81434323 81898669, 81898669,  81898669, 81898669 81898669, 81898669, 
    81979010, 82174601 82174601, 82174601,  82174601,/span> 82174602 82174602, 82174602, 
    82174602,/span> 82174602 82174602, 82174602 82174602, 82174602 82249955, 82249955, 
    82296355, 82320090 82520048, 82747607 82747607,/span> 82819990,  82819990, 82819990, 
    82851264, 82873136 82873136, 82873136 82873136,/span> 82873137 82873138, 82873138, 
    82993012, 83207843 83285153, 83288998 83288998, 83288998 83288998, 83288998, 
    83294190,/span> 83294190 83294191,/span> 83371710 83822767,/span> 83915529,  84075828, 84075828, 
    84075829, 84075829 84075829,/span> 84075830 84228502,/span> 84228503,  84331280, 84331280, 
    84429542, 84429542 84475188, 84538851 84590030, 84590030,  84590031, 84590031, 
    84662177, 84697070 84943765,/span> 85039997,  85047461, 85047461 85047462, 85047462, 
    85076835,/span> 85125425 85125426, 85125426 85125426, 85166777,  85166777, 85166777, 
    85186810,/span> 85221710 85314545,/span> 85317218,  85352519, 85352519,  85352521, 85352521, 
    85352521, 85352522 85352522,/span> 85392206 85392206, 85392206 85392207, 85392207,  
    85392207, 85392207 85392207, 85392207 85392208, 85392208 85392208, 85392208, 
    85392208,/span> 85392209 85392209, 85392209 85392210, 85398185 85398185, 85398185, 
    85398186, 85398186 85398187, 85398187 85398187,/span> 85426511 85426511, 85426511, 
    85426511, 85426513 85426513,/span> 85426514,  85426514, 85426514 85426514, 85426514, 
    85466060,/span> 85466060 85466060, 85466060,  85466060, 85466061 85466061, 85466061, 
    85612637, 85630078 85630078,/span> 85630079,  85758504, 85758504 85758504, 85758504, 
    85758504,/span> 85758504 85758505,/span> 85865854 85865854, 85865854 85869891, 85869891, 
    85869891, 85869891 85869891, 85869891 85869892, 85869892 85869892, 
    85869892,/span> 85869892 85869893, 85969662,  86022326,  86022327,  86022327, 86022327, 
    86022327,/span> 86022327 86022327, 86022327 86022327, 86022327 86045129, 86045129, 
    86062688, 86062688 86062688,/span> 86062689,  86062689, 86062689,  86062689, 86062689, 
    86062689, 86062689 86062689, 86062689 86207257,/span> 86365835,  86365835, 86365835, 
    86365835, 86365835 86365836, 86365837,  86365837, 86365837 86365837, 86365837, 
    86365838,/span> 86365838 86707487,/span> 86867203 86867204, 86867204 86867204, 86867204, 
    86867204, 86886456 87008520, 87008520 87082425, 87082425 87082425, 
    87082425,/span> 87082426 87082426, 87082426 87082426,/span> 87082427 87082427, 87082427,  
    87342981, 87342981

對于谷歌來說,所需的輸出應該是這樣的:

在此輸入圖片描述

uj5u.com熱心網友回復:

這里上傳了兩種方法:

首先,將串列轉換成資料框:

arrival_time <- data.framearrival_time

如果你想得到一天中確切的小時數,在這種情況下,每個明顯的小時數的觀測值將非常少,而且繪圖將有點擁擠:

如果你想得到一天中確切的小時數,在這種情況下,每個明顯的小時數的觀測值將非常少,而且繪圖將有點擁擠。

library(ggplot2) 

arrival_time %>%。
  mutate(hour = (arrival_time/(1000*60*60 %> %
  group_by(hour) %> %
  summarise(count=n() %> %
  ggplot() 
  geom_point(aes(x=hour,  y=count) 
  geom_line(aes(x=hour,  y=count group=1 >
  xlab('hour of day')/span> 
  ylab('Av. num. tasks per hour') 
  theme_bw()

Output1

現在,如果你考慮我在評論中提到的到達,即如果到達在0到15分鐘之間,將被視為0小時,如果在1小時1分鐘到2小時之間,將被視為1小時,像這樣:

arrival_time %>% 突變(hour = floor(arrival_time/(1000*60*60 %> % group_by(hour) %> % summarise(count=n() %> % ggplot() geom_point(aes(x=hour, y=count) geom_line(aes(x=hour, y=count xlab('hour of day')/span> ylab('Av. num. tasks per hour') theme_bw()

輸出2

這與你在問題中所分享的情節類似。盡管評論中的邏輯并不一致。

按照評論中的要求添加另一個情節。

arrival_time %>%
  突變(hour = floor(arrival_time/(1000*60*60
         分鐘= 地板(到達時間/(1000*60 %> %
  group_by(小時,分鐘) %>%
  summarise(count=n() %> %
  ungroup() %> %
  ggplot() 。
  geom_point(aes(x=minute,  y=count) 
  geom_line(aes(x=minute,  y=count) 
  scale_x_continuous(breaks = seq(0 1440, 60 標簽 = seq0 24, 1)) 
  xlab('hour of day')/span> 
  ylab('Av. num. tasks per hour') 
  theme_bw

輸出3

轉載請註明出處,本文鏈接:https://www.uj5u.com/yidong/318894.html

標籤:

上一篇:在ggplot柱狀圖中顯示百分比

下一篇:R:geom_text()在gganimate中出了問題

標籤雲
其他(157675) Python(38076) JavaScript(25376) Java(17977) C(15215) 區塊鏈(8255) C#(7972) AI(7469) 爪哇(7425) MySQL(7132) html(6777) 基礎類(6313) sql(6102) 熊猫(6058) PHP(5869) 数组(5741) R(5409) Linux(5327) 反应(5209) 腳本語言(PerlPython)(5129) 非技術區(4971) Android(4554) 数据框(4311) css(4259) 节点.js(4032) C語言(3288) json(3245) 列表(3129) 扑(3119) C++語言(3117) 安卓(2998) 打字稿(2995) VBA(2789) Java相關(2746) 疑難問題(2699) 细绳(2522) 單片機工控(2479) iOS(2429) ASP.NET(2402) MongoDB(2323) 麻木的(2285) 正则表达式(2254) 字典(2211) 循环(2198) 迅速(2185) 擅长(2169) 镖(2155) 功能(1967) .NET技术(1958) Web開發(1951) python-3.x(1918) HtmlCss(1915) 弹簧靴(1913) C++(1909) xml(1889) PostgreSQL(1872) .NETCore(1853) 谷歌表格(1846) Unity3D(1843) for循环(1842)

熱門瀏覽
  • 【從零開始擼一個App】Dagger2

    Dagger2是一個IOC框架,一般用于Android平臺,第一次接觸的朋友,一定會被搞得暈頭轉向。它延續了Java平臺Spring框架代碼碎片化,注解滿天飛的傳統。嘗試將各處代碼片段串聯起來,理清思緒,真不是件容易的事。更不用說還有各版本細微的差別。 與Spring不同的是,Spring是通過反射 ......

    uj5u.com 2020-09-10 06:57:59 more
  • Flutter Weekly Issue 66

    新聞 Flutter 季度調研結果分享 教程 Flutter+FaaS一體化任務編排的思考與設計 詳解Dart中如何通過注解生成代碼 GitHub 用對了嗎?Flutter 團隊分享如何管理大型開源專案 插件 flutter-bubble-tab-indicator A Flutter librar ......

    uj5u.com 2020-09-10 06:58:52 more
  • Proguard 常用規則

    介紹 Proguard 入口,如何查看輸出,如何使用 keep 設定入口以及使用實體,如何配置壓縮,混淆,校驗等規則。

    ......

    uj5u.com 2020-09-10 06:59:00 more
  • Android 開發技術周報 Issue#292

    新聞 Android即將獲得類AirDrop功能:可向附近設備快速分享檔案 谷歌為安卓檔案管理應用引入可安全隱藏資料的Safe Folder功能 Android TV新主界面將顯示電影、電視節目和應用推薦內容 泄露的Android檔案暗示了傳說中的谷歌Pixel 5a與折疊屏新機 谷歌發布Andro ......

    uj5u.com 2020-09-10 07:00:37 more
  • AutoFitTextureView Error inflating class

    報錯: Binary XML file line #0: Binary XML file line #0: Error inflating class xxx.AutoFitTextureView 解決: <com.example.testy2.AutoFitTextureView android: ......

    uj5u.com 2020-09-10 07:00:41 more
  • 根據Uri,Cursor沒有獲取到對應的屬性

    Android: 背景:呼叫攝像頭,拍攝視頻,指定保存的地址,但是回傳的Cursor檔案,只有名稱和大小的屬性,沒有其他諸如時長,連ID屬性都沒有 使用 cursor.getInt(cursor.getColumnIndexOrThrow(MediaStore.Video.Media.DURATIO ......

    uj5u.com 2020-09-10 07:00:44 more
  • Android連載29-持久化技術

    一、持久化技術 我們平時所使用的APP產生的資料,在記憶體中都是瞬時的,會隨著斷電、關機等丟失資料,因此android系統采用了持久化技術,用于存盤這些“瞬時”資料 持久化技術包括:檔案存盤、SharedPreference存盤以及資料庫存盤,還有更復雜的SD卡記憶體儲。 二、檔案存盤 最基本存盤方式, ......

    uj5u.com 2020-09-10 07:00:47 more
  • Android Camera2Video整合到自己專案里

    背景: Android專案里呼叫攝像頭拍攝視頻,原本使用的 MediaStore.ACTION_VIDEO_CAPTURE, 后來因專案需要,改成了camera2 1.Camera2Video 官方demo有點問題,下載后,不能直接整合到專案 問題1.多次拍攝視頻崩潰 問題2.雙擊record按鈕, ......

    uj5u.com 2020-09-10 07:00:50 more
  • Android 開發技術周報 Issue#293

    新聞 谷歌為Android TV開發者提供多種新功能 Android 11將自動填表功能整合到鍵盤輸入建議中 谷歌宣布Android Auto即將支持更多的導航和數字停車應用 谷歌Pixel 5只有XL版本 搭載驍龍765G且將比Pixel 4更便宜 [圖]Wear OS將迎來重磅更新:應用啟動時間 ......

    uj5u.com 2020-09-10 07:01:38 more
  • 海豚星空掃碼投屏 Android 接收端 SDK 集成 六步驟

    掃碼投屏,開放網路,獨占設備,不需要額外下載軟體,微信掃碼,發現設備。支持標準DLNA協議,支持倍速播放。視頻,音頻,圖片投屏。好點意思。還支持自定義基于 DLNA 擴展的操作動作。好像要收費,沒體驗。 這里簡單記錄一下集成程序。 一 跟目錄的build.gradle添加私有mevan倉庫 mave ......

    uj5u.com 2020-09-10 07:01:43 more
最新发布
  • 歡迎頁輪播影片

    如圖,引導開始,球從上落下,同時淡入文字,然后文字開始輪播,最后一頁時停止,點擊進入首頁。 在來看看效果圖。 重力球先不講,主要歡迎輪播簡單實作 首先新建一個類 TextTranslationXGuideView,用于影片展示 文本是類似的,最后會有個圖片箭頭影片,布局很簡單,就是一個 TextVi ......

    uj5u.com 2023-04-20 08:40:31 more
  • 【FAQ】關于華為推送服務因營銷訊息頻次管控導致服務通訊類訊息

    一. 問題描述 使用華為推送服務下發IM訊息時,下發訊息請求成功且code碼為80000000,但是手機總是收不到訊息; 在華為推送自助分析(Beta)平臺查看發現,訊息發送觸發了頻控。 二. 問題原因及背景 2023年1月05日起,華為推送服務對咨詢營銷類訊息做了單個設備每日推送數量上限管理,具體 ......

    uj5u.com 2023-04-20 08:40:11 more
  • 歡迎頁輪播影片

    如圖,引導開始,球從上落下,同時淡入文字,然后文字開始輪播,最后一頁時停止,點擊進入首頁。 在來看看效果圖。 重力球先不講,主要歡迎輪播簡單實作 首先新建一個類 TextTranslationXGuideView,用于影片展示 文本是類似的,最后會有個圖片箭頭影片,布局很簡單,就是一個 TextVi ......

    uj5u.com 2023-04-20 08:39:36 more
  • 【FAQ】關于華為推送服務因營銷訊息頻次管控導致服務通訊類訊息

    一. 問題描述 使用華為推送服務下發IM訊息時,下發訊息請求成功且code碼為80000000,但是手機總是收不到訊息; 在華為推送自助分析(Beta)平臺查看發現,訊息發送觸發了頻控。 二. 問題原因及背景 2023年1月05日起,華為推送服務對咨詢營銷類訊息做了單個設備每日推送數量上限管理,具體 ......

    uj5u.com 2023-04-20 08:39:13 more
  • iOS從UI記憶體地址到讀取成員變數(oc/swift)

    開發除錯時,我們發現bug時常首先是從UI顯示發現例外,下一步才會去定位UI相關連的資料的。XCode有給我們提供一系列debug工具,但是很多人可能還沒有形成一套穩定的除錯流程,因此本文嘗試解決這個問題,順便提出一個暴論:UI顯示例外問題只需要兩個步驟就能完成定位作業的80%: 定位例外 UI 組 ......

    uj5u.com 2023-04-19 09:16:23 more
  • FIDE重磅更新!性能飛躍!體驗有禮!

    FIDE 開發者工具重構升級啦!實作500%性能提升,誠邀體驗! 一直以來不少開發者朋友在社區反饋,在使用 FIDE 工具的程序中,時常會遇到諸如加載不及時、代碼預覽/渲染性能不如意的情況,十分影響開發體驗。 作為技術團隊,我們深知一件趁手的開發工具對開發者的重要性,因此,在2023年開年,FinC ......

    uj5u.com 2023-04-19 09:16:15 more
  • 游戲內嵌社區服務開放,助力開發者提升玩家互動與留存

    華為 HMS Core 游戲內嵌社區服務提供快速訪問華為游戲中心論壇能力,支持玩家直接在游戲內瀏覽帖子和交流互動,助力開發者擴展內容生產和觸達的場景。 一、為什么要游戲內嵌社區? 二、游戲內嵌社區的典型使用場景 1、游戲內打開論壇 您可以在游戲內繪制論壇入口,為玩家提供沉浸式發帖、瀏覽、點贊、回帖、 ......

    uj5u.com 2023-04-19 09:15:46 more
  • iOS從UI記憶體地址到讀取成員變數(oc/swift)

    開發除錯時,我們發現bug時常首先是從UI顯示發現例外,下一步才會去定位UI相關連的資料的。XCode有給我們提供一系列debug工具,但是很多人可能還沒有形成一套穩定的除錯流程,因此本文嘗試解決這個問題,順便提出一個暴論:UI顯示例外問題只需要兩個步驟就能完成定位作業的80%: 定位例外 UI 組 ......

    uj5u.com 2023-04-19 09:14:53 more
  • FIDE重磅更新!性能飛躍!體驗有禮!

    FIDE 開發者工具重構升級啦!實作500%性能提升,誠邀體驗! 一直以來不少開發者朋友在社區反饋,在使用 FIDE 工具的程序中,時常會遇到諸如加載不及時、代碼預覽/渲染性能不如意的情況,十分影響開發體驗。 作為技術團隊,我們深知一件趁手的開發工具對開發者的重要性,因此,在2023年開年,FinC ......

    uj5u.com 2023-04-19 09:14:08 more
  • 游戲內嵌社區服務開放,助力開發者提升玩家互動與留存

    華為 HMS Core 游戲內嵌社區服務提供快速訪問華為游戲中心論壇能力,支持玩家直接在游戲內瀏覽帖子和交流互動,助力開發者擴展內容生產和觸達的場景。 一、為什么要游戲內嵌社區? 二、游戲內嵌社區的典型使用場景 1、游戲內打開論壇 您可以在游戲內繪制論壇入口,為玩家提供沉浸式發帖、瀏覽、點贊、回帖、 ......

    uj5u.com 2023-04-19 09:08:34 more