{"id":3752,"date":"2023-07-15T18:25:35","date_gmt":"2023-07-15T18:25:35","guid":{"rendered":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/"},"modified":"2023-07-15T18:25:35","modified_gmt":"2023-07-15T18:25:35","slug":"perbedaan-waktu-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/","title":{"rendered":"Pandas: cara menghitung selisih dua kali"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghitung perbedaan antara dua kali dalam pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate time difference in hours\n<\/span>df[' <span style=\"color: #ff0000;\">hours_diff<\/span> '] = (df. <span style=\"color: #3366ff;\">end_time<\/span> - df. <span style=\"color: #3366ff;\">start_time<\/span> ) \/ pd. <span style=\"color: #3366ff;\">Timedelta<\/span> (hours= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#calculate time difference in minutes\n<\/span>df[' <span style=\"color: #ff0000;\">min_diff<\/span> '] = (df. <span style=\"color: #3366ff;\">end_time<\/span> - df. <span style=\"color: #3366ff;\">start_time<\/span> ) \/ pd. <span style=\"color: #3366ff;\">Timedelta<\/span> (minutes= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#calculate time difference in seconds\n<\/span>df[' <span style=\"color: #ff0000;\">sec_diff<\/span> '] = (df. <span style=\"color: #3366ff;\">end_time<\/span> - df. <span style=\"color: #3366ff;\">start_time<\/span> ) \/ pd. <span style=\"color: #3366ff;\">Timedelta<\/span> (seconds= <span style=\"color: #008000;\">1<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini menghitung perbedaan antara waktu di kolom <strong>end_time<\/strong> dan <strong>start_time<\/strong> dari beberapa Pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: menghitung selisih dua waktu pada panda<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<span style=\"color: #000000;\">\ndf=pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">start_time<\/span> ':pd. <span style=\"color: #3366ff;\">date_range<\/span> (start=' <span style=\"color: #ff0000;\">5\/25\/2020<\/span> ', periods= <span style=\"color: #008000;\">6<\/span> , freq=' <span style=\"color: #ff0000;\">15min<\/span> '),\n                 ' <span style=\"color: #ff0000;\">end_time<\/span> ':pd. <span style=\"color: #3366ff;\">date_range<\/span> (start=' <span style=\"color: #ff0000;\">5\/26\/2020<\/span> ', periods= <span style=\"color: #008000;\">6<\/span> , freq=' <span style=\"color: #ff0000;\">30min<\/span> ')})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">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<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung perbedaan waktu antara kolom <strong>start_time<\/strong> dan <strong>end_time<\/strong> dalam satuan jam, menit, dan detik:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate time difference in hours\n<\/span>df[' <span style=\"color: #ff0000;\">hours_diff<\/span> '] = (df. <span style=\"color: #3366ff;\">end_time<\/span> - df. <span style=\"color: #3366ff;\">start_time<\/span> ) \/ pd. <span style=\"color: #3366ff;\">Timedelta<\/span> (hours= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#calculate time difference in minutes\n<\/span>df[' <span style=\"color: #ff0000;\">min_diff<\/span> '] = (df. <span style=\"color: #3366ff;\">end_time<\/span> - df. <span style=\"color: #3366ff;\">start_time<\/span> ) \/ pd. <span style=\"color: #3366ff;\">Timedelta<\/span> (minutes= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#calculate time difference in seconds\n<\/span>df[' <span style=\"color: #ff0000;\">sec_diff<\/span> '] = (df. <span style=\"color: #3366ff;\">end_time<\/span> - df. <span style=\"color: #3366ff;\">start_time<\/span> ) \/ pd. <span style=\"color: #3366ff;\">Timedelta<\/span> (seconds= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\n<span style=\"color: #008000;\">print<\/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<p> <span style=\"color: #000000;\">Kolom baru berisi perbedaan waktu antara kolom <strong>start_time<\/strong> dan <strong>end_time<\/strong> dalam satuan yang berbeda.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, perhatikan baris pertama:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Perbedaan antara waktu mulai dan waktu berakhir adalah <strong>24 jam<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selisih waktu mulai dan waktu berakhir adalah <strong>1440 menit<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Selisih antara waktu mulai dan waktu berakhir adalah <strong>86.400 detik<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini, kolom <strong>start_time<\/strong> dan <strong>end_time<\/strong> sudah diformat sebagai datetime.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kolom waktu Anda saat ini diformat sebagai string, Anda dapat menggunakan <strong>pd.to_datetime<\/strong> untuk terlebih dahulu mengonversi setiap kolom ke format datetime sebelum menghitung selisih waktu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#convert columns to datetime format\n<\/span>df[[' <span style=\"color: #ff0000;\">start_time<\/span> ', ' <span style=\"color: #ff0000;\">end_time<\/span> ']] = df[[' <span style=\"color: #ff0000;\">start_time<\/span> ', ' <span style=\"color: #ff0000;\">end_time<\/span> ]]. <span style=\"color: #3366ff;\">apply<\/span> (pd. <span style=\"color: #3366ff;\">to_datetime<\/span> )\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Anda kemudian dapat melanjutkan untuk menghitung perbedaan waktu antar kolom karena keduanya sekarang dalam format tanggal-waktu yang dapat dikenali oleh panda.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-panda\/\" target=\"_blank\" rel=\"noopener\">Cara membuat rentang tanggal di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ekstrak-panda-bulan-dari-tanggal\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak bulan dari tanggal di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/waktu-cap-waktu-panda\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengubah stempel waktu menjadi tanggal\/waktu di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghitung perbedaan antara dua kali dalam pandas DataFrame: #calculate time difference in hours df[&#8216; hours_diff &#8216;] = (df. end_time &#8211; df. start_time ) \/ pd. Timedelta (hours= 1 ) #calculate time difference in minutes df[&#8216; min_diff &#8216;] = (df. end_time &#8211; df. start_time ) \/ pd. Timedelta (minutes= 1 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Pandas: Cara menghitung selisih dua kali - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung selisih dua kali di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menghitung selisih dua kali - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung selisih dua kali di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T18:25:35+00:00\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/\",\"name\":\"Pandas: Cara menghitung selisih dua kali - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T18:25:35+00:00\",\"dateModified\":\"2023-07-15T18:25:35+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung selisih dua kali di pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghitung selisih dua kali\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Pandas: Cara menghitung selisih dua kali - Statorial","description":"Tutorial ini menjelaskan cara menghitung selisih dua kali di pandas DataFrame, dengan sebuah contoh.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menghitung selisih dua kali - Statorial","og_description":"Tutorial ini menjelaskan cara menghitung selisih dua kali di pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-15T18:25:35+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/","url":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/","name":"Pandas: Cara menghitung selisih dua kali - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T18:25:35+00:00","dateModified":"2023-07-15T18:25:35+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung selisih dua kali di pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/perbedaan-waktu-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghitung selisih dua kali"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3752"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=3752"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3752\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3752"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3752"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3752"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}