{"id":902,"date":"2023-07-28T09:16:44","date_gmt":"2023-07-28T09:16:44","guid":{"rendered":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/"},"modified":"2023-07-28T09:16:44","modified_gmt":"2023-07-28T09:16:44","slug":"ekspor-kerangka-data-panda-ke-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/","title":{"rendered":"Cara mengekspor pandas dataframe ke excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin tertarik untuk mengekspor DataFrame pandas ke Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi pandas <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.to_excel.html\" target=\"_blank\" rel=\"noopener\">to_excel()<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk menggunakan fungsi ini, Anda harus menginstal <strong>openpyxl<\/strong> terlebih dahulu agar Anda dapat menulis file ke Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>pip install openpyxl<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Tutorial ini akan menjelaskan beberapa contoh penggunaan fungsi ini dengan DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><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({'points': [25, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, 9, 12],\n                   'rebounds': [11, 8, 10, 6, 6]}) \n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        points assists rebounds\n0 25 5 11\n1 12 7 8\n2 15 7 10\n3 14 9 6\n4 19 12 6\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Ekspor dasar<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengekspor DataFrame ke jalur file tertentu dan menyimpannya sebagai <strong>mydata.xlsx<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_excel<\/span> (r'C:\\Users\\Zach\\Desktop\\mydata.xlsx')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Seperti inilah tampilan file Excel sebenarnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9644 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pandasexcel1.png\" alt=\"\" width=\"499\" height=\"465\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Ekspor tanpa indeks<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengekspor DataFrame ke jalur file tertentu dan menghapus kolom indeks:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_excel<\/span> (r'C:\\Users\\Zach\\Desktop\\mydata.xlsx', index= <span style=\"color: #339966;\">False<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Seperti inilah tampilan file Excel sebenarnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9645 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pandasexcel2.png\" alt=\"\" width=\"500\" height=\"489\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Ekspor tanpa indeks atau header<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengekspor DataFrame ke jalur file tertentu dan menghapus kolom indeks dan baris header:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_excel<\/span> (r'C:\\Users\\Zach\\Desktop\\mydata.xlsx', index= <span style=\"color: #339966;\">False, <span style=\"color: #000000;\">header=<\/span> False<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Seperti inilah tampilan file Excel sebenarnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9646 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pandasexcel3.png\" alt=\"\" width=\"500\" height=\"493\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 4: Ekspor dan beri nama sheet<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut memperlihatkan cara mengekspor DataFrame ke jalur file tertentu dan memberi nama lembar kerja Excel:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">to_excel<\/span> (r'C:\\Users\\Zach\\Desktop\\mydata.xlsx', sheet_name=' <span style=\"color: #339966;\">this_data<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Seperti inilah tampilan file Excel sebenarnya:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-9647 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pandasexcel4.png\" alt=\"\" width=\"501\" height=\"484\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\"><em>Anda dapat menemukan dokumentasi lengkap fungsi to_excel() <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.to_excel.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin tertarik untuk mengekspor DataFrame pandas ke Excel. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi pandas to_excel() . Untuk menggunakan fungsi ini, Anda harus menginstal openpyxl terlebih dahulu agar Anda dapat menulis file ke Excel: pip install openpyxl Tutorial ini akan menjelaskan beberapa contoh penggunaan fungsi ini dengan DataFrame berikut: import pandas [&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 mengekspor Pandas DataFrame ke Excel \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara mengekspor DataFrame pandas ke Excel, termasuk beberapa 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\/ekspor-kerangka-data-panda-ke-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengekspor Pandas DataFrame ke Excel \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara mengekspor DataFrame pandas ke Excel, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T09:16:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pandasexcel1.png\" \/>\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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/\",\"name\":\"Cara mengekspor Pandas DataFrame ke Excel \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T09:16:44+00:00\",\"dateModified\":\"2023-07-28T09:16:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara mengekspor DataFrame pandas ke Excel, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengekspor pandas dataframe ke excel\"}]},{\"@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 mengekspor Pandas DataFrame ke Excel \u2013 Statologi","description":"Penjelasan sederhana tentang cara mengekspor DataFrame pandas ke Excel, termasuk beberapa 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\/ekspor-kerangka-data-panda-ke-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengekspor Pandas DataFrame ke Excel \u2013 Statologi","og_description":"Penjelasan sederhana tentang cara mengekspor DataFrame pandas ke Excel, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T09:16:44+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pandasexcel1.png"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/","url":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/","name":"Cara mengekspor Pandas DataFrame ke Excel \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T09:16:44+00:00","dateModified":"2023-07-28T09:16:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara mengekspor DataFrame pandas ke Excel, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengekspor pandas dataframe ke excel"}]},{"@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\/902"}],"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=902"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/902\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}