{"id":3528,"date":"2023-07-17T00:35:05","date_gmt":"2023-07-17T00:35:05","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/"},"modified":"2023-07-17T00:35:05","modified_gmt":"2023-07-17T00:35:05","slug":"pandas-memeriksa-apakah-nilai-di-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/","title":{"rendered":"Pandas: cara memeriksa apakah ada nilai di kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk memeriksa apakah ada nilai tertentu di kolom DataFrame pandas:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Periksa apakah ada nilai di kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>22 <span style=\"color: #008000;\">in<\/span> df[' <span style=\"color: #ff0000;\">my_column<\/span> ']. <span style=\"color: #3366ff;\">values<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Periksa apakah ada beberapa nilai di kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[' <span style=\"color: #ff0000;\">my_column<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([44, 45, 22]). <span style=\"color: #3366ff;\">any<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan 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<\/span>\ndf = 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<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Periksa apakah ada nilai di kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memeriksa apakah nilai <strong>22<\/strong> ada di kolom <strong>poin<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if 22 exists in the 'points' column<\/span>\n22 <span style=\"color: #008000;\">in<\/span> df[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">values<\/span>\n\nTrue<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Outputnya mengembalikan <strong>True<\/strong> , yang memberitahu kita bahwa nilai <strong>22<\/strong> ada di kolom <strong>poin<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa menggunakan sintaks yang sama dengan kolom string.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kode berikut memperlihatkan cara memeriksa apakah string &#8220;J&#8221; ada di kolom <strong>tim<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if 'J' exists in the 'team' column<\/span>\n'J' <span style=\"color: #008000;\">in<\/span> df[' <span style=\"color: #ff0000;\">team<\/span> ']. <span style=\"color: #3366ff;\">values<\/span>\n\nFalse<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Outputnya mengembalikan <strong>False<\/strong> , yang memberitahu kita bahwa string &#8220;J&#8221; tidak ada di kolom <b>Team<\/b> .<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Periksa apakah ada salah satu dari beberapa nilai di kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memeriksa apakah ada nilai dalam daftar [44, 45, 22] yang ada di kolom <strong>poin<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if 44, 45 or 22 exist in the 'points' column<\/span>\ndf[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([44, 45, 22]). <span style=\"color: #3366ff;\">any<\/span> ()\n\nTrue<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Outputnya mengembalikan <strong>True<\/strong> , yang memberi tahu kita bahwa setidaknya salah satu nilai dalam daftar [44, 45, 22] ada di kolom <strong>poin<\/strong> DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa menggunakan sintaks yang sama dengan kolom string.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kode berikut menunjukkan cara memeriksa apakah string dari daftar [&#8216;J&#8217;, &#8216;K&#8217;, &#8216;L&#8217;] ada di kolom <strong>tim<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#check if J, K, or L exists in the 'team' column<\/span>\ndf[' <span style=\"color: #ff0000;\">team<\/span> ']. <span style=\"color: #3366ff;\">isin<\/span> ([' <span style=\"color: #ff0000;\">J<\/span> ',' <span style=\"color: #ff0000;\">K<\/span> ',' <span style=\"color: #ff0000;\">L<\/span> ']). <span style=\"color: #3366ff;\">any<\/span> () \nFalse<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Outputnya mengembalikan <strong>False<\/strong> , yang memberi tahu kita bahwa tidak ada string dalam daftar yang ada di kolom <b>tim<\/b> .<\/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 operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-menjatuhkan-baris-dengan-syarat\/\" target=\"_blank\" rel=\"noopener\">Cara menghapus baris di Pandas DataFrame berdasarkan kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-memfilter-beberapa-kondisi\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter Pandas DataFrame pada berbagai kondisi<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tidak-ada-panda\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan filter \u201cTIDAK DALAM\u201d di Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk memeriksa apakah ada nilai tertentu di kolom DataFrame pandas: Metode 1: Periksa apakah ada nilai di kolom 22 in df[&#8216; my_column &#8216;]. values Metode 2: Periksa apakah ada beberapa nilai di kolom df[&#8216; my_column &#8216;]. isin ([44, 45, 22]). any () Contoh berikut menunjukkan cara menggunakan setiap metode dalam [&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: Cara memeriksa apakah ada nilai di kolom - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah nilai tertentu ada di kolom di panda, 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-nilai-di-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara memeriksa apakah ada nilai di kolom - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memeriksa apakah nilai tertentu ada di kolom di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-17T00:35:05+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-nilai-di-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/\",\"name\":\"Pandas: Cara memeriksa apakah ada nilai di kolom - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-17T00:35:05+00:00\",\"dateModified\":\"2023-07-17T00:35:05+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memeriksa apakah nilai tertentu ada di kolom di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara memeriksa apakah ada nilai di kolom\"}]},{\"@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: Cara memeriksa apakah ada nilai di kolom - Statologi","description":"Tutorial ini menjelaskan cara memeriksa apakah nilai tertentu ada di kolom di panda, 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-nilai-di-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara memeriksa apakah ada nilai di kolom - Statologi","og_description":"Tutorial ini menjelaskan cara memeriksa apakah nilai tertentu ada di kolom di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-17T00:35:05+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-nilai-di-kolom\/","url":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/","name":"Pandas: Cara memeriksa apakah ada nilai di kolom - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-17T00:35:05+00:00","dateModified":"2023-07-17T00:35:05+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memeriksa apakah nilai tertentu ada di kolom di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-memeriksa-apakah-nilai-di-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara memeriksa apakah ada nilai di kolom"}]},{"@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\/3528"}],"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=3528"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3528\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3528"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3528"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3528"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}