{"id":4088,"date":"2023-07-13T16:38:03","date_gmt":"2023-07-13T16:38:03","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/"},"modified":"2023-07-13T16:38:03","modified_gmt":"2023-07-13T16:38:03","slug":"panda-membaca-kolom-lewati-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/","title":{"rendered":"Pandas: abaikan kolom tertentu saat mengimpor file excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define columns to skip\n<\/span>skip_cols = [1, 2]\n\n<span style=\"color: #008080;\">#define columns to keep\n<\/span>keep_cols = [i <span style=\"color: #008000;\">for<\/span> i <span style=\"color: #008000;\">in<\/span> <span style=\"color: #008000;\">range<\/span> (4) <span style=\"color: #008000;\">if<\/span> i <span style=\"color: #008000;\">not in<\/span> skip_cols]\n\n<span style=\"color: #008080;\">#import Excel file and skip specific columns\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ', usecols=keep_cols)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini akan mengabaikan kolom di posisi indeks <strong>1<\/strong> dan <strong>2<\/strong> saat mengimpor file Excel bernama <strong>my_data.xlsx<\/strong> ke dalam panda.<\/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: Abaikan kolom tertentu saat mengimpor file Excel ke Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file Excel berikut bernama <strong>player_data.xlsx<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32506 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter-excel1.png\" alt=\"\" width=\"497\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengimpor file ini ke dalam pandas DataFrame dan mengabaikan kolom di posisi indeks <strong>1<\/strong> dan <strong>2<\/strong> (kolom titik dan pantulan) selama impor:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define columns to skip\n<\/span>skip_cols = [1, 2]\n\n<span style=\"color: #008080;\">#define columns to keep\n<\/span>keep_cols = [i <span style=\"color: #008000;\">for<\/span> i <span style=\"color: #008000;\">in<\/span> <span style=\"color: #008000;\">range<\/span> (4) <span style=\"color: #008000;\">if<\/span> i <span style=\"color: #008000;\">not in<\/span> skip_cols]\n\n<span style=\"color: #008080;\">#import Excel file and skip specific columns\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">player_data.xlsx<\/span> ', usecols=keep_cols)\n\n<span style=\"color: #008080;\">#view DataFrame<\/span>\n<span style=\"color: #008000;\">print<\/span> (df)\n\n  team assists\n0 to 5\n1 B 3\n2 C 7\n3 D 8\n4 E 8\n5 F 9\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua kolom dalam file Excel kecuali kolom pada posisi indeks <strong>1<\/strong> dan <strong>2<\/strong> (kolom titik dan pantulan) telah diimpor ke pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa metode ini mengasumsikan bahwa Anda mengetahui sebelumnya berapa banyak kolom dalam file Excel.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Karena kami tahu ada total 4 kolom dalam file, kami menggunakan <strong>range(4)<\/strong> untuk menentukan kolom yang ingin kami pertahankan.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>read_excel()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.read_excel.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 tugas umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara melewati baris saat membaca file Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menentukan tipe saat mengimpor file Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menggabungkan-beberapa-lembar-excel-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggabungkan beberapa lembar Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame: #define columns to skip skip_cols = [1, 2] #define columns to keep keep_cols = [i for i in range (4) if i not in skip_cols] #import Excel file and skip specific columns df = pd. read_excel (&#8216; my_data.xlsx [&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: abaikan kolom tertentu saat mengimpor file Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame, beserta contohnya.\" \/>\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-membaca-kolom-lewati-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: abaikan kolom tertentu saat mengimpor file Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T16:38:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter-excel1.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-membaca-kolom-lewati-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/\",\"name\":\"Pandas: abaikan kolom tertentu saat mengimpor file Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T16:38:03+00:00\",\"dateModified\":\"2023-07-13T16:38:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: abaikan kolom tertentu saat mengimpor file 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":"Pandas: abaikan kolom tertentu saat mengimpor file Excel - Statorials","description":"Tutorial ini menjelaskan cara mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame, beserta contohnya.","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-membaca-kolom-lewati-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: abaikan kolom tertentu saat mengimpor file Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T16:38:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter-excel1.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-membaca-kolom-lewati-excel\/","url":"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/","name":"Pandas: abaikan kolom tertentu saat mengimpor file Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T16:38:03+00:00","dateModified":"2023-07-13T16:38:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan kolom tertentu saat mengimpor file Excel ke pandas DataFrame, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-kolom-lewati-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: abaikan kolom tertentu saat mengimpor file 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\/4088"}],"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=4088"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4088\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4088"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4088"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4088"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}