{"id":3748,"date":"2023-07-15T18:25:35","date_gmt":"2023-07-15T18:25:35","guid":{"rendered":"https:\/\/statorials.org\/ja\/%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e3%81%ae%e6%99%82%e5%b7%ae\/"},"modified":"2023-07-15T18:25:35","modified_gmt":"2023-07-15T18:25:35","slug":"%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e3%81%ae%e6%99%82%e5%b7%ae","status":"publish","type":"post","link":"https:\/\/statorials.org\/ja\/%e3%83%8f%e3%82%9a%e3%83%b3%e3%82%bf%e3%82%99%e3%81%ae%e6%99%82%e5%b7%ae\/","title":{"rendered":"\u30d1\u30f3\u30c0: 2 \u3064\u306e\u6642\u9593\u306e\u5dee\u3092\u8a08\u7b97\u3059\u308b\u65b9\u6cd5"},"content":{"rendered":"

<\/p>\n

\n

\u6b21\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001pandas DataFrame \u306e 2 \u3064\u306e\u6642\u9593\u306e\u5dee\u3092\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

 #calculate time difference in hours\n<\/span>df[' hours_diff<\/span> '] = (df. end_time<\/span> - df. start_time<\/span> ) \/ pd. Timedelta<\/span> (hours= 1<\/span> )\n\n#calculate time difference in minutes\n<\/span>df[' min_diff<\/span> '] = (df. end_time<\/span> - df. start_time<\/span> ) \/ pd. Timedelta<\/span> (minutes= 1<\/span> )\n\n#calculate time difference in seconds\n<\/span>df[' sec_diff<\/span> '] = (df. end_time<\/span> - df. start_time<\/span> ) \/ pd. Timedelta<\/span> (seconds= 1<\/span> )\n<\/strong><\/pre>\n
\u3053\u306e\u7279\u5b9a\u306e\u4f8b\u3067\u306f\u3001\u4e00\u90e8\u306e Pandas DataFrame \u306eend_time \u5217<\/strong>\u3068start_time<\/strong>\u5217\u306e\u6642\u9593\u306e\u5dee\u3092\u8a08\u7b97\u3057\u307e\u3059\u3002<\/span><\/p>\n
\u6b21\u306e\u4f8b\u306f\u3001\u3053\u306e\u69cb\u6587\u3092\u5b9f\u969b\u306b\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n
\u4f8b: pandas \u3067\u306e 2 \u3064\u306e\u6642\u9593\u306e\u5dee\u306e\u8a08\u7b97<\/strong><\/span><\/h2>\n
\u6b21\u306e\u30d1\u30f3\u30c0 \u30c7\u30fc\u30bf\u30d5\u30ec\u30fc\u30e0\u304c\u3042\u308b\u3068\u3057\u307e\u3059\u3002<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf=pd. DataFrame<\/span> ({' start_time<\/span> ':pd. date_range<\/span> (start=' 5\/25\/2020<\/span> ', periods= 6<\/span> , freq=' 15min<\/span> '),\n                 ' end_time<\/span> ':pd. date_range<\/span> (start=' 5\/26\/2020<\/span> ', periods= 6<\/span> , freq=' 30min<\/span> ')})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n           start_time end_time\n0 2020-05-25 00:00:00 2020-05-26 00:00:00\n1 2020-05-25 00:15:00 2020-05-26 00:30:00\n2 2020-05-25 00:30:00 2020-05-26 01:00:00\n3 2020-05-25 00:45:00 2020-05-26 01:30:00\n4 2020-05-25 01:00:00 2020-05-26 02:00:00\n5 2020-05-25 01:15:00 2020-05-26 02:30:00\n<\/span><\/span><\/strong><\/pre>\n
\u6b21\u306e\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001 start_time \u5217<\/strong>\u3068end_time<\/strong>\u5217\u306e\u9593\u306e\u6642\u9593\u5dee\u3092\u6642\u3001\u5206\u3001\u79d2\u306e\u5358\u4f4d\u3067\u8a08\u7b97\u3067\u304d\u307e\u3059\u3002<\/span><\/span><\/p>\n
 #calculate time difference in hours\n<\/span>df[' hours_diff<\/span> '] = (df. end_time<\/span> - df. start_time<\/span> ) \/ pd. Timedelta<\/span> (hours= 1<\/span> )\n\n#calculate time difference in minutes\n<\/span>df[' min_diff<\/span> '] = (df. end_time<\/span> - df. start_time<\/span> ) \/ pd. Timedelta<\/span> (minutes= 1<\/span> )\n\n#calculate time difference in seconds\n<\/span>df[' sec_diff<\/span> '] = (df. end_time<\/span> - df. start_time<\/span> ) \/ pd. Timedelta<\/span> (seconds= 1<\/span> )\n\n#view updated DataFrame<\/span>\nprint<\/span> (df)\n\n           start_time end_time hours_diff min_diff sec_diff\n0 2020-05-25 00:00:00 2020-05-26 00:00:00 24.00 1440.0 86400.0\n1 2020-05-25 00:15:00 2020-05-26 00:30:00 24.25 1455.0 87300.0\n2 2020-05-25 00:30:00 2020-05-26 01:00:00 24.50 1470.0 88200.0\n3 2020-05-25 00:45:00 2020-05-26 01:30:00 24.75 1485.0 89100.0\n4 2020-05-25 01:00:00 2020-05-26 02:00:00 25.00 1500.0 90000.0\n5 2020-05-25 01:15:00 2020-05-26 02:30:00 25.25 1515.0 90900.0\n<\/strong><\/pre>\n
\u65b0\u3057\u3044\u5217\u306b\u306f\u3001 start_time \u5217<\/strong>\u3068end_time<\/strong>\u5217\u9593\u306e\u6642\u9593\u5dee\u304c\u7570\u306a\u308b\u5358\u4f4d\u3067\u542b\u307e\u308c\u307e\u3059\u3002<\/span><\/p>\n
\u305f\u3068\u3048\u3070\u3001\u6700\u521d\u306e\u884c\u3092\u8003\u3048\u3066\u307f\u307e\u3057\u3087\u3046\u3002<\/span><\/p>\n