{"id":4134,"date":"2023-07-13T08:59:33","date_gmt":"2023-07-13T08:59:33","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/"},"modified":"2023-07-13T08:59:33","modified_gmt":"2023-07-13T08:59:33","slug":"panda-untuk-unggul-tanpa-indeks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/","title":{"rendered":"Pandas: ekspor dataframe ke excel tanpa indeks"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk mengekspor DataFrame pandas ke file Excel dan tidak menyertakan kolom indeks:<\/span><\/p>\n

 df. to_excel<\/span> (' my_data.xlsx<\/span> ', index= False<\/span> )\n<\/strong><\/pre>\n
 Argumen index=False<\/strong> memberitahu panda untuk tidak menyertakan kolom indeks saat mengekspor DataFrame ke file Excel.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: mengekspor Pandas DataFrame ke file Excel tanpa indeks<\/strong><\/span><\/h2>\n
 Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span>\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],\n                   ' points<\/span> ': [18, 22, 19, 14, 14, 11, 20, 28],\n                   ' assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n#view DataFrame\n<\/span>print<\/span> (df)\n\n  team points assists rebounds\n0 A 18 5 11\n1 B 22 7 8\n2 C 19 7 10\n3 D 14 9 6\n4 E 14 12 6\n5 F 11 9 5\n6 G 20 9 9\n7:28 4 12<\/strong><\/pre>\n
 Jika kita menggunakan fungsi to_excel()<\/strong> untuk mengekspor DataFrame ke file Excel, panda akan menyertakan kolom indeks secara default:<\/span><\/p>\n
 #export DataFrame to Excel file<\/span>\ndf. to_excel<\/span> (' basketball_data.xlsx<\/span> ')\n<\/strong><\/span><\/pre>\n
 Seperti inilah tampilan file Excelnya:<\/span> <\/p>\n
\"\"<\/p>\n
 Perhatikan bahwa kolom indeks disertakan dalam file Excel secara default.<\/span><\/p>\n
 Untuk mengekspor DataFrame ke file Excel tanpa kolom indeks, Anda harus menentukan index=False<\/strong> :<\/span><\/p>\n
 #export DataFrame to Excel file without index column<\/span>\ndf. to_excel<\/span> (' basketball_data.xlsx<\/span> ', index= False<\/span> )<\/strong><\/span><\/pre>\n
 Seperti inilah tampilan file Excelnya:<\/span> <\/p>\n
\"ekspor<\/p>\n
 Perhatikan bahwa kolom indeks tidak lagi disertakan dalam file Excel.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas to_excel()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Cara mengabaikan kolom tertentu saat mengimpor file Excel ke Pandas<\/a>
 Cara menggabungkan beberapa lembar Excel di Pandas<\/a>
 Cara menulis Pandas DataFrames di beberapa lembar Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk mengekspor DataFrame pandas ke file Excel dan tidak menyertakan kolom indeks: df. to_excel (‘ my_data.xlsx ‘, index= False ) Argumen index=False memberitahu panda untuk tidak menyertakan kolom indeks saat mengekspor DataFrame ke file Excel. Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: mengekspor Pandas DataFrame ke file […]<\/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":"\nPandas: ekspor DataFrame ke Excel tanpa indeks - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekspor DataFrame pandas ke file Excel tanpa indeks, 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-untuk-unggul-tanpa-indeks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: ekspor DataFrame ke Excel tanpa indeks - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekspor DataFrame pandas ke file Excel tanpa indeks, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T08:59:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelno1.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\/panda-untuk-unggul-tanpa-indeks\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/\",\"name\":\"Pandas: ekspor DataFrame ke Excel tanpa indeks - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T08:59:33+00:00\",\"dateModified\":\"2023-07-13T08:59:33+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekspor DataFrame pandas ke file Excel tanpa indeks, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: ekspor dataframe ke excel tanpa indeks\"}]},{\"@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: ekspor DataFrame ke Excel tanpa indeks - Statologi","description":"Tutorial ini menjelaskan cara mengekspor DataFrame pandas ke file Excel tanpa indeks, 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-untuk-unggul-tanpa-indeks\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: ekspor DataFrame ke Excel tanpa indeks - Statologi","og_description":"Tutorial ini menjelaskan cara mengekspor DataFrame pandas ke file Excel tanpa indeks, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/","og_site_name":"Statorials","article_published_time":"2023-07-13T08:59:33+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/excelno1.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\/panda-untuk-unggul-tanpa-indeks\/","url":"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/","name":"Pandas: ekspor DataFrame ke Excel tanpa indeks - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T08:59:33+00:00","dateModified":"2023-07-13T08:59:33+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekspor DataFrame pandas ke file Excel tanpa indeks, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-untuk-unggul-tanpa-indeks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: ekspor dataframe ke excel tanpa indeks"}]},{"@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\/4134"}],"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=4134"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4134\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4134"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4134"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4134"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}