{"id":4167,"date":"2023-07-13T03:37:40","date_gmt":"2023-07-13T03:37:40","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/"},"modified":"2023-07-13T03:37:40","modified_gmt":"2023-07-13T03:37:40","slug":"panda-mengonversi-indeks-menjadi-datetime","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/","title":{"rendered":"Pandas: cara mengonversi indeks menjadi tanggal\/waktu"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengonversi kolom indeks pandas DataFrame ke format datetime:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">index<\/span> = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> ( <span style=\"color: #3366ff;\">df.index<\/span> )\n<\/strong><\/pre>\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: Ubah Kolom Indeks menjadi Datetime di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang berisi informasi tentang penjualan produk di sebuah toko:<\/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;\">time<\/span> ': ['4-15-2022 10:15', '5-19-2022 7:14', '8-01-2022 1:14',\n                            '6-14-2022 9:45', '10-24-2022 2:58', '12-13-2022 11:03'],\n                   ' <span style=\"color: #ff0000;\">product<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F'],\n                   ' <span style=\"color: #ff0000;\">sales<\/span> ': [12, 25, 23, 18, 14, 10]})\n\n<span style=\"color: #008080;\">#set 'time' column as index\n<\/span>df = df. <span style=\"color: #3366ff;\">set_index<\/span> (' <span style=\"color: #ff0000;\">time<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n                 product sales\ntime                           \n4-15-2022 10:15 A 12\n5-19-2022 7:14 B 25\n8-01-2022 1:14 C 23\n6-14-2022 9:45 D 18\n10-24-2022 2:58 E 14\n12-13-2022 11:03 F 10<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita mencoba membuat kolom baru yang berisi waktu pada kolom indeks:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#attempt to create new column that contains hour of index column\n<\/span>df[' <span style=\"color: #ff0000;\">hour<\/span> '] = df. <span style=\"color: #3366ff;\">index<\/span> . <span style=\"color: #3366ff;\">hour\n\n<span style=\"color: #000000;\">AttributeError: 'Index' object has no attribute 'hour'\n<\/span><\/span><\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kami menerima kesalahan karena kolom indeks saat ini tidak dalam format datetime dan oleh karena itu tidak mengandung atribut &#8216;waktu&#8217;.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menghindari kesalahan ini, kita dapat menggunakan fungsi pandas <strong>to_datetime()<\/strong> untuk mengonversi kolom indeks ke format datetime:<\/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 index column to datetime format\n<\/span>df. <span style=\"color: #3366ff;\">index<\/span> = pd. <span style=\"color: #3366ff;\">to_datetime<\/span> ( <span style=\"color: #3366ff;\">df.index<\/span> )\n\n<span style=\"color: #008080;\">#create new column that contains hour of index column\n<\/span>df[' <span style=\"color: #ff0000;\">hour<\/span> '] = df. <span style=\"color: #3366ff;\">index<\/span> . <span style=\"color: #3366ff;\">hour<\/span>\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n                    product sales hour\ntime                                    \n2022-04-15 10:15:00 At 12 10\n2022-05-19 07:14:00 B 25 7\n2022-08-01 01:14:00 C 23 1\n2022-06-14 09:45:00 D 18 9\n2022-10-24 02:58:00 E 14 2\n2022-12-13 11:03:00 F 10 11\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dengan menggunakan fungsi <strong>to_datetime()<\/strong> kita dapat mengubah kolom indeks ke format datetime.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jadi, kita berhasil membuat kolom baru bernama <strong>waktu<\/strong> yang berisi waktu jam di kolom indeks tanpa menerima kesalahan apa pun.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>to_datetime()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.to_datetime.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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\/waktu-cap-waktu-panda\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengubah stempel waktu menjadi tanggal\/waktu di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-tanggal-panda\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung selisih dua kurma di panda<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengonversi kolom indeks pandas DataFrame ke format datetime: df. index = pd. to_datetime ( df.index ) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Ubah Kolom Indeks menjadi Datetime di Pandas Misalkan kita memiliki panda DataFrame berikut yang berisi informasi tentang penjualan produk di sebuah toko: import [&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 mengonversi indeks ke tanggal\/waktu - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengonversi kolom indeks pandas DataFrame menjadi datetime, 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\/panda-mengonversi-indeks-menjadi-datetime\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengonversi indeks ke tanggal\/waktu - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengonversi kolom indeks pandas DataFrame menjadi datetime, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T03:37: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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/\",\"name\":\"Pandas: Cara mengonversi indeks ke tanggal\/waktu - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T03:37:40+00:00\",\"dateModified\":\"2023-07-13T03:37:40+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengonversi kolom indeks pandas DataFrame menjadi datetime, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengonversi indeks menjadi tanggal\/waktu\"}]},{\"@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 mengonversi indeks ke tanggal\/waktu - Statorials","description":"Tutorial ini menjelaskan cara mengonversi kolom indeks pandas DataFrame menjadi datetime, 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\/panda-mengonversi-indeks-menjadi-datetime\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengonversi indeks ke tanggal\/waktu - Statorials","og_description":"Tutorial ini menjelaskan cara mengonversi kolom indeks pandas DataFrame menjadi datetime, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/","og_site_name":"Statorials","article_published_time":"2023-07-13T03:37:40+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\/panda-mengonversi-indeks-menjadi-datetime\/","url":"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/","name":"Pandas: Cara mengonversi indeks ke tanggal\/waktu - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T03:37:40+00:00","dateModified":"2023-07-13T03:37:40+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengonversi kolom indeks pandas DataFrame menjadi datetime, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengonversi-indeks-menjadi-datetime\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengonversi indeks menjadi tanggal\/waktu"}]},{"@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\/4167"}],"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=4167"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4167\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4167"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4167"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4167"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}