{"id":2487,"date":"2023-07-22T01:42:29","date_gmt":"2023-07-22T01:42:29","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/"},"modified":"2023-07-22T01:42:29","modified_gmt":"2023-07-22T01:42:29","slug":"pandas-memeriksa-apakah-kolom-tersebut-ada","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/","title":{"rendered":"Cara memeriksa apakah ada kolom di pandas (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memeriksa apakah ada kolom di pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Periksa apakah ada kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>' <span style=\"color: #ff0000;\">column1<\/span> ' <span style=\"color: #008000;\">in<\/span> df. <span style=\"color: #3366ff;\">columns\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengembalikan <strong>True<\/strong> jika &#8220;column1&#8221; ada di DataFrame, jika tidak maka akan mengembalikan <strong>False<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Periksa apakah ada beberapa kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>{' <span style=\"color: #ff0000;\">column1<\/span> ', ' <span style=\"color: #ff0000;\">column2<\/span> '}. <span style=\"color: #3366ff;\">issubset<\/span> ( <span style=\"color: #3366ff;\">df.columns<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini akan mengembalikan <strong>True<\/strong> jika &#8220;column1&#8221; <em>dan<\/em> &#8220;column2&#8221; ada di DataFrame, jika tidak maka akan mengembalikan <strong>False<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/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\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [18, 22, 19, 14, 14, 11, 20, 28],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">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\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Periksa apakah ada kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk melihat apakah kolom &#8216;tim&#8217; ada di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if 'team' column exists in DataFrame\n<span style=\"color: #000000;\">' <span style=\"color: #ff0000;\">team<\/span> ' <span style=\"color: #008000;\">in<\/span> df. <span style=\"color: #3366ff;\">columns\n\n<span style=\"color: #000000;\">True<\/span><\/span><\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kolom &#8220;tim&#8221; ada di DataFrame, jadi panda mengembalikan nilai <strong>True<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa menggunakan pernyataan <strong>if<\/strong> untuk melakukan operasi jika kolom &#8220;tim&#8221; ada:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#if 'team' exists, create new column called 'team_name'\n<\/span><span style=\"color: #008000;\">if<\/span> ' <span style=\"color: #ff0000;\">team<\/span> ' <span style=\"color: #008000;\">in<\/span> df. <span style=\"color: #3366ff;\">columns<\/span> :\n    df[' <span style=\"color: #ff0000;\">team_name<\/span> '] = df[' <span style=\"color: #ff0000;\">team<\/span> ']\n    \n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points assists rebounds team_name\n0 A 18 5 11 A\n1 B 22 7 8 B\n2 C 19 7 10 C\n3 D 14 9 6 D\n4 E 14 12 6 E\n5 F 11 9 5 F\n6 G 20 9 9 G\n7:28 a.m. 4:12 p.m.\n<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Periksa apakah ada beberapa kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk melihat apakah kolom &#8216;tim&#8217; <em>dan<\/em> &#8216;pemain&#8217; ada di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if 'team' and 'player' columns both exist in DataFrame<span style=\"color: #000000;\">\n{' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">player<\/span> '}. <span style=\"color: #3366ff;\">issubset<\/span> ( <span style=\"color: #3366ff;\">df.columns<\/span> )\n\nFalse<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kolom &#8216;tim&#8217; ada di DataFrame tetapi &#8216;pemain&#8217; tidak, jadi panda mengembalikan nilai <strong>False<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa menggunakan kode berikut untuk melihat apakah &#8220;poin&#8221; dan &#8220;bantuan&#8221; ada di DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if 'points' and 'assists' columns both exist in DataFrame<span style=\"color: #000000;\">\n{' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> '}. <span style=\"color: #3366ff;\">issubset<\/span> ( <span style=\"color: #3366ff;\">df.columns<\/span> )\n\nTrue<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kedua kolom tersebut ada, sehingga panda mengembalikan nilai <strong>True<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita kemudian dapat menggunakan pernyataan <strong>if<\/strong> untuk melakukan operasi jika &#8220;titik&#8221; dan &#8220;pembantu&#8221; ada:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#if both exist, create new column called 'total' that finds sum of points and assists\n<\/span><span style=\"color: #008000;\">if<\/span> {' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">assists<\/span> '}. <span style=\"color: #3366ff;\">issubset<\/span> ( <span style=\"color: #3366ff;\">df.columns<\/span> ):\n    df[' <span style=\"color: #ff0000;\">total<\/span> '] = df[' <span style=\"color: #ff0000;\">points<\/span> '] + df[' <span style=\"color: #ff0000;\">assists<\/span> ']\n    \n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n     team points assists rebounds total\n0 A 18 5 11 23\n1 B 22 7 8 29\n2 C 19 7 10 26\n3 D 14 9 6 23\n4 E 14 12 6 26\n5 F 11 9 5 20\n6 G 20 9 9 29\n7:28 4 12 32\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Karena &#8220;poin&#8221; dan &#8220;bantuan&#8221; ada di DataFrame, pandas membuat kolom baru bernama &#8220;total&#8221; yang menunjukkan jumlah kolom &#8220;poin&#8221; dan &#8220;bantuan&#8221;.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\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\/kolom-taman-panda\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mempertahankan kolom tertentu di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara memilih kolom berdasarkan indeks di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kolom-pergeseran-panda\/\" target=\"_blank\" rel=\"noopener\">Cara memindahkan kolom di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk memeriksa apakah ada kolom di pandas DataFrame: Metode 1: Periksa apakah ada kolom &#8216; column1 &#8216; in df. columns Ini akan mengembalikan True jika &#8220;column1&#8221; ada di DataFrame, jika tidak maka akan mengembalikan False . Metode 2: Periksa apakah ada beberapa kolom {&#8216; column1 &#8216;, &#8216; column2 &#8216;}. issubset [&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 memeriksa apakah ada kolom di panda (dengan contoh) \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah ada 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\/pandas-memeriksa-apakah-kolom-tersebut-ada\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memeriksa apakah ada kolom di panda (dengan contoh) \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah ada kolom di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T01:42:29+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\/pandas-memeriksa-apakah-kolom-tersebut-ada\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/\",\"name\":\"Cara memeriksa apakah ada kolom di panda (dengan contoh) \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T01:42:29+00:00\",\"dateModified\":\"2023-07-22T01:42:29+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa apakah ada kolom di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memeriksa apakah ada 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 memeriksa apakah ada kolom di panda (dengan contoh) \u2013 Statologi","description":"Tutorial ini menjelaskan cara memeriksa apakah ada 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\/pandas-memeriksa-apakah-kolom-tersebut-ada\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memeriksa apakah ada kolom di panda (dengan contoh) \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara memeriksa apakah ada kolom di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/","og_site_name":"Statorials","article_published_time":"2023-07-22T01:42:29+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\/pandas-memeriksa-apakah-kolom-tersebut-ada\/","url":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/","name":"Cara memeriksa apakah ada kolom di panda (dengan contoh) \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T01:42:29+00:00","dateModified":"2023-07-22T01:42:29+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa apakah ada kolom di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-kolom-tersebut-ada\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memeriksa apakah ada 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\/2487"}],"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=2487"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2487\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2487"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2487"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2487"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}