{"id":899,"date":"2023-07-28T09:27:40","date_gmt":"2023-07-28T09:27:40","guid":{"rendered":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/"},"modified":"2023-07-28T09:27:40","modified_gmt":"2023-07-28T09:27:40","slug":"ubah-kolom-menjadi-waktu-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/","title":{"rendered":"Cara mengonversi kolom menjadi datetime di pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin tertarik untuk mengonversi satu atau lebih kolom pandas DataFrame ke format DateTime. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.to_datetime.html\" target=\"_blank\" rel=\"noopener noreferrer\">to_datetime()<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memperlihatkan beberapa contoh penggunaan fungsi ini pada DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> numpy <span style=\"color: #107d3f;\">as<\/span> np\n<span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd.DataFrame({'event': ['A', 'B', 'C'],\n                   'start_date': ['20150601', '20160201', '20170401'],\n                   'end_date': ['20150608', '20160209', '20170416'] })\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tevent start_date end_date\n0 A 20150601 20150608\n1 B 20160201 20160209\n2 C 20170401 201704161\n\n<span style=\"color: #008080;\">#view column data types\n<\/span>df. <span style=\"color: #3366ff;\">dtypes\n\n<span style=\"color: #000000;\">event object\nstart_date object\nend_date object\ndtype:object<\/span><\/span><\/strong><\/pre>\n<h3> <strong><span style=\"color: #000000;\">Contoh 1: Ubah Satu Kolom menjadi DateTime<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengonversi kolom &#8220;tanggal_mulai&#8221; dari string ke format DateTime:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert start_date to DateTime format<\/span>\ndf['start_date'] = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> (df['start_date'])\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        event start_date end_date\n0 A 2015-06-01 20150608\n1 B 2016-02-01 20160209\n2 C 2017-04-01 20170416\n\n<span style=\"color: #008080;\">#view column date types\n<\/span>df. <span style=\"color: #3366ff;\">dtypes<\/span>\n\nevent object\nstart_date datetime64[ns]\nend_date object\ndtype:object<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa fungsi to_datetime() cerdas dan biasanya dapat menyimpulkan format tanggal yang benar untuk digunakan, namun Anda juga dapat menentukan format mana yang akan digunakan dengan argumen <strong>format<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert start_date to DateTime format<\/span>\ndf['start_date'] = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> (df['start_date'], format=' <span style=\"color: #993300;\">%Y%m%d<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        event start_date end_date\n0 A 2015-06-01 20150608\n1 B 2016-02-01 20160209\n2 C 2017-04-01 20170416\n\n<span style=\"color: #008080;\">#view column date types\n<\/span>df. <span style=\"color: #3366ff;\">dtypes<\/span>\n\nevent object\nstart_date datetime64[ns]\nend_date object\ndtype:object<\/strong><\/pre>\n<h3> <strong><span style=\"color: #000000;\">Contoh 2: Ubah Beberapa Kolom menjadi DateTime<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengonversi kolom &#8220;tanggal_mulai&#8221; dan &#8220;tanggal_akhir&#8221; dari string ke format DateTime:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert start_date and end_date to DateTime formats<\/span>\ndf[['start_date', 'end_date']] = df[['start_date', 'end_date']]. <span style=\"color: #3366ff;\">apply<\/span> (pd. <span style=\"color: #3366ff;\">to_datetime<\/span> )\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tevent start_date end_date\n0 A 2015-06-01 2015-06-08\n1 B 2016-02-01 2016-02-09\n2 C 2017-04-01 2017-04-16\n\n<span style=\"color: #008080;\">#view column date types\n<\/span>df. <span style=\"color: #3366ff;\">dtypes<\/span>\n\nevent object\nstart_date datetime64[ns]\nend_date datetime64[ns]\ndtype:object<\/strong><\/pre>\n<h3> <strong><span style=\"color: #000000;\">Contoh 3: Konversi kolom ke format DateTime dengan hitungan detik<\/span><\/strong><\/h3>\n<p> <span style=\"color: #000000;\">Dalam beberapa kasus, Anda mungkin juga memiliki kolom yang menyertakan tanggal serta jam, menit, dan detik, seperti DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd.DataFrame({'event': ['A', 'B', 'C'],\n                   'start_date': ['20150601043000', '20160201054500', '20170401021215'],\n                   'end_date': ['20150608', '20160209', '20170416'] })\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        event start_date end_date\n0 A 20150601043000 20150608\n1 B 20160201054500 20160209\n2 C 20170401021215 20170416\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sekali lagi, fungsi to_datetime() cerdas dan biasanya dapat menyimpulkan format yang benar untuk digunakan tanpa kita menentukannya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#convert start_date to DateTime format<\/span>\ndf['start_date'] = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> (df['start_date'])\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        event start_date end_date\n0 A 2015-06-01 04:30:00 20150608\n1 B 2016-02-01 05:45:00 20160209\n2 C 2017-04-01 02:12:15 20170416\n\n<span style=\"color: #008080;\">#view column date types\n<\/span>df. <span style=\"color: #3366ff;\">dtypes<\/span>\n\nevent object\nstart_date datetime64[ns]\nend_date object\ndtype:object<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tentu saja, di alam bebas Anda mungkin akan menemukan berbagai format DateTime yang aneh, jadi Anda mungkin perlu menggunakan argumen <strong>format<\/strong> untuk memberi tahu Python format DateTime mana yang akan digunakan.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dalam kasus ini, lihat <a href=\"https:\/\/strftime.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">halaman ini<\/a> untuk daftar lengkap<\/span> <span style=\"color: #000000;\">operator %DateTime yang dapat Anda gunakan untuk menentukan format.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/ubah-datetime-menjadi-panda-tanggal\/\">Bagaimana cara mengonversi DateTime ke tanggal di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/mengonversi-string-menjadi-panda-mengambang\/\">Bagaimana mengubah string menjadi float di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin tertarik untuk mengonversi satu atau lebih kolom pandas DataFrame ke format DateTime. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi to_datetime() . Tutorial ini memperlihatkan beberapa contoh penggunaan fungsi ini pada DataFrame berikut: import numpy as np import pandas as pd #createDataFrame df = pd.DataFrame({&#8216;event&#8217;: [&#8216;A&#8217;, &#8216;B&#8217;, &#8216;C&#8217;], &#8216;start_date&#8217;: [&#8216;20150601&#8217;, &#8216;20160201&#8217;, &#8216;20170401&#8217;], [&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>Cara mengonversi kolom menjadi DateTime di Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara mengonversi kolom DataFrame ke format DateTime di panda.\" \/>\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\/ubah-kolom-menjadi-waktu-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengonversi kolom menjadi DateTime di Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara mengonversi kolom DataFrame ke format DateTime di panda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T09:27:40+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=\"3 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/\",\"name\":\"Cara mengonversi kolom menjadi DateTime di Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T09:27:40+00:00\",\"dateModified\":\"2023-07-28T09:27:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara mengonversi kolom DataFrame ke format DateTime di panda.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengonversi kolom menjadi datetime di pandas\"}]},{\"@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":"Cara mengonversi kolom menjadi DateTime di Pandas \u2013 Statorials","description":"Penjelasan sederhana tentang cara mengonversi kolom DataFrame ke format DateTime di panda.","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\/ubah-kolom-menjadi-waktu-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengonversi kolom menjadi DateTime di Pandas \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara mengonversi kolom DataFrame ke format DateTime di panda.","og_url":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-28T09:27:40+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"3 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/","url":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/","name":"Cara mengonversi kolom menjadi DateTime di Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T09:27:40+00:00","dateModified":"2023-07-28T09:27:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara mengonversi kolom DataFrame ke format DateTime di panda.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ubah-kolom-menjadi-waktu-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengonversi kolom menjadi datetime di pandas"}]},{"@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\/899"}],"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=899"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/899\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}