{"id":1949,"date":"2023-07-24T08:26:07","date_gmt":"2023-07-24T08:26:07","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/"},"modified":"2023-07-24T08:26:07","modified_gmt":"2023-07-24T08:26:07","slug":"panda-mengecualikan-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/","title":{"rendered":"Cara mengecualikan kolom di pandas (dengan contoh)"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks berikut untuk mengecualikan kolom di pandas DataFrame:<\/span><\/p>\n

 #exclude column1<\/span>\ndf. loc<\/span> [:, df. columns<\/span> !=' column1<\/span> ']\n\n#exclude column1, column2, ...\n<\/span>df. loc<\/span> [:, ~df. columns<\/span> . isin<\/span> ([' column1<\/span> ',' column2<\/span> ',...])]\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh 1: mengecualikan kolom<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara memilih semua kecuali satu kolom di pandas DataFrame:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span> \ndf = pd. DataFrame<\/span> ({' points<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12],\n                   ' blocks<\/span> ': [2, 3, 3, 5, 3, 2, 1, 2]})\n\n#view DataFrame\n<\/span>df\n\n\tpoints assists rebounds blocks\n0 25 5 11 2\n1 12 7 8 3\n2 15 7 10 3\n3 14 9 6 5\n4 19 12 6 3\n5 23 9 5 2\n6 25 9 9 1\n7 29 4 12 2\n\n#select all columns except 'rebounds'\ndf. loc<\/span> [:, df. columns<\/span> !=' rebounds<\/span> ']\n<\/span><\/span>\n        points assists blocks\n0 25 5 2\n1 12 7 3\n2 15 7 3\n3 14 9 5\n4 19 12 3\n5 23 9 2\n6 25 9 1\n7 29 4 2\n<\/strong><\/pre>\n
 Contoh 2: kecualikan beberapa kolom<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara memilih semua kecuali beberapa kolom di pandas DataFrame:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame<\/span> \ndf = pd. DataFrame<\/span> ({' points<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12],\n                   ' blocks<\/span> ': [2, 3, 3, 5, 3, 2, 1, 2]})\n\n#view DataFrame\n<\/span>df\n\n\tpoints assists rebounds blocks\n0 25 5 11 2\n1 12 7 8 3\n2 15 7 10 3\n3 14 9 6 5\n4 19 12 6 3\n5 23 9 5 2\n6 25 9 9 1\n7 29 4 12 2\n\n#select all columns except 'rebounds' and 'assists'\n<\/span>df. loc<\/span> [:, ~df. columns<\/span> . isin<\/span> ([' rebounds<\/span> ', ' assists<\/span> '])]\n\n\tpoint blocks\n0 25 2\n1 12 3\n2 15 3\n3 14 5\n4 19 3\n5 23 2\n6 25 1\n7 29 2\n<\/strong><\/pre>\n
 Dengan menggunakan sintaks ini Anda dapat mengecualikan sejumlah kolom yang Anda inginkan berdasarkan nama.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Bagaimana cara menambahkan baris ke Pandas DataFrame<\/a>
 Bagaimana cara menambahkan array Numpy ke Pandas DataFrame<\/a>
 Cara menghitung jumlah baris di Pandas DataFrame<\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks berikut untuk mengecualikan kolom di pandas DataFrame: #exclude column1 df. loc [:, df. columns !=’ column1 ‘] #exclude column1, column2, … df. loc [:, ~df. columns . isin ([‘ column1 ‘,’ column2 ‘,…])] Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: mengecualikan kolom Kode berikut menunjukkan cara memilih […]<\/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":"\nCara mengecualikan kolom di Pandas (dengan contoh) \u2013 Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengecualikan satu atau lebih kolom di pandas DataFrame, dengan 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\/panda-mengecualikan-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengecualikan kolom di Pandas (dengan contoh) \u2013 Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengecualikan satu atau lebih kolom di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T08:26:07+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=\"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-mengecualikan-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/\",\"name\":\"Cara mengecualikan kolom di Pandas (dengan contoh) \u2013 Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T08:26:07+00:00\",\"dateModified\":\"2023-07-24T08:26:07+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengecualikan satu atau lebih kolom di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengecualikan kolom di pandas (dengan contoh)\"}]},{\"@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 mengecualikan kolom di Pandas (dengan contoh) \u2013 Statorial","description":"Tutorial ini menjelaskan cara mengecualikan satu atau lebih kolom di pandas DataFrame, dengan 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\/panda-mengecualikan-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengecualikan kolom di Pandas (dengan contoh) \u2013 Statorial","og_description":"Tutorial ini menjelaskan cara mengecualikan satu atau lebih kolom di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-24T08:26:07+00:00","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-mengecualikan-kolom\/","url":"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/","name":"Cara mengecualikan kolom di Pandas (dengan contoh) \u2013 Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T08:26:07+00:00","dateModified":"2023-07-24T08:26:07+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengecualikan satu atau lebih kolom di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengecualikan-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengecualikan kolom di pandas (dengan contoh)"}]},{"@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\/1949"}],"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=1949"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1949\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1949"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1949"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1949"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}