{"id":911,"date":"2023-07-28T08:30:34","date_gmt":"2023-07-28T08:30:34","guid":{"rendered":"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/"},"modified":"2023-07-28T08:30:34","modified_gmt":"2023-07-28T08:30:34","slug":"buat-panda-berdasarkan-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/","title":{"rendered":"Cara membuat kolom baru berdasarkan kondisi di pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan beberapa contoh cara melakukannya menggunakan DataFrame berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd\n<span style=\"color: #107d3f;\">import<\/span> numpy <span style=\"color: #107d3f;\">as<\/span> np\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({'rating': [90, 85, 82, 88, 94, 90, 76, 75, 87, 86],\n                   'points': [25, 20, 14, 16, 27, 20, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, 8, 5, 7, 6, 9, 9, 5],\n                   'rebounds': [11, 8, 10, 6, 6, 9, 6, 10, 10, 7]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<span style=\"color: #000000;\">df\n<\/span>\n<\/span>rating points assists rebounds\n0 90 25 5 11\n1 85 20 7 8\n2 82 14 7 10\n3 88 16 8 6\n4 94 27 5 6\n5 90 20 7 9\n6 76 12 6 6\n7 75 15 9 10\n8 87 14 9 10\n9 86 19 5 7\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Buat kolom baru dengan nilai biner<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat kolom baru bernama &#8220;Baik&#8221; dengan nilai &#8220;ya&#8221; jika poin pada baris tertentu lebih besar dari 20 dan &#8220;tidak&#8221; jika sebaliknya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create new column titled 'Good'<\/span>\ndf['Good'] = np. <span style=\"color: #3366ff;\">where<\/span> (df['points']&gt;20, ' <span style=\"color: #008000;\">yes<\/span> ', ' <span style=\"color: #008000;\">no<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame<\/span> \ndf\n\n        rating points assists rebounds Good\n0 90 25 5 11 yes\n1 85 20 7 8 no\n2 82 14 7 10 no\n3 88 16 8 6 no\n4 94 27 5 6 yes\n5 90 20 7 9 no\n6 76 12 6 6 no\n7 75 15 9 10 no\n8 87 14 9 10 no\n9 86 19 5 7 no\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Buat kolom baru dengan banyak nilai<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat kolom baru bernama &#8220;Bagus&#8221; yang nilainya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u201cYa\u201d jika poin \u2265 25<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201cMungkin\u201d jika 15 \u2264 poin &lt; 25<\/span><\/li>\n<li> <span style=\"color: #000000;\">\u201cTidak\u201d jika poin &lt;15<\/span><\/li>\n<\/ul>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#define function for classifying players based on points<\/span>\n<span style=\"color: #008000;\">def<\/span> f(row):\n    <span style=\"color: #008000;\">if<\/span> row['points'] &lt; 15:\n        val = 'no'\n    <span style=\"color: #008000;\">elif<\/span> row['points'] &lt; 25:\n        val = 'maybe'\n    <span style=\"color: #008000;\">else<\/span> :\n        val = 'yes'\n    <span style=\"color: #008000;\">return<\/span> val\n\n<span style=\"color: #008080;\">#create new column 'Good' using the function above<\/span>\ndf['Good'] = df. <span style=\"color: #3366ff;\">apply<\/span> (f, axis=1)\n\n<span style=\"color: #008080;\">#view DataFrame<\/span> \ndf\n\n        rating points assists rebounds Good\n0 90 25 5 11 yes\n1 85 20 7 8 maybe\n2 82 14 7 10 no\n3 88 16 8 6 maybe\n4 94 27 5 6 yes\n5 90 20 7 9 maybe\n6 76 12 6 6 no\n7 75 15 9 10 maybe\n8 87 14 9 10 no\n9 86 19 5 7 maybe\n<\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Buat kolom baru berdasarkan perbandingan dengan kolom yang sudah ada<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat kolom baru bernama &#8220;assist_more&#8221; yang nilainya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">\u201cYa\u201d jika assist &gt; rebound.<\/span><\/li>\n<li> <span style=\"color: #000000;\">&#8216;Tidak&#8217; sebaliknya.<\/span><\/li>\n<\/ul>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create new column titled 'assist_more'<\/span>\n<span style=\"color: #000000;\">df['assist_more']<\/span> = np. <span style=\"color: #3366ff;\">where<\/span> (df['assists']&gt;df['rebounds'], ' <span style=\"color: #008000;\">yes<\/span> ', ' <span style=\"color: #008000;\">no<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame<\/span> \ndf\n\n        rating points assists rebounds assist_more\n0 90 25 5 11 no\n1 85 20 7 8 no\n2 82 14 7 10 no\n3 88 16 8 6 yes\n4 94 27 5 6 no\n5 90 20 7 9 no\n6 76 12 6 6 no\n7 75 15 9 10 no\n8 87 14 9 10 no\n9 86 19 5 7 no<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><em><span style=\"color: #000000;\">Anda dapat menemukan lebih banyak tutorial Python di sini .<\/span><\/em><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu. Tutorial ini memberikan beberapa contoh cara melakukannya menggunakan DataFrame berikut: import pandas as pd import numpy as np #createDataFrame df = pd. DataFrame ({&#8216;rating&#8217;: [90, 85, 82, 88, 94, 90, 76, 75, 87, 86], &#8216;points&#8217;: [25, 20, 14, 16, 27, 20, 12, [&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 membuat kolom baru berdasarkan kondisi di Pandas<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana cara membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.\" \/>\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\/buat-panda-berdasarkan-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara membuat kolom baru berdasarkan kondisi di Pandas\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana cara membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T08:30:34+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\/buat-panda-berdasarkan-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/\",\"name\":\"Cara membuat kolom baru berdasarkan kondisi di Pandas\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T08:30:34+00:00\",\"dateModified\":\"2023-07-28T08:30:34+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana cara membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara membuat kolom baru berdasarkan kondisi di pandas\"}]},{\"@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 membuat kolom baru berdasarkan kondisi di Pandas","description":"Penjelasan sederhana cara membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.","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\/buat-panda-berdasarkan-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara membuat kolom baru berdasarkan kondisi di Pandas","og_description":"Penjelasan sederhana cara membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.","og_url":"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-28T08:30:34+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\/buat-panda-berdasarkan-kolom\/","url":"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/","name":"Cara membuat kolom baru berdasarkan kondisi di Pandas","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T08:30:34+00:00","dateModified":"2023-07-28T08:30:34+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana cara membuat kolom baru di pandas DataFrame berdasarkan kondisi tertentu.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/buat-panda-berdasarkan-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara membuat kolom baru berdasarkan kondisi di pandas"}]},{"@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\/911"}],"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=911"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/911\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=911"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=911"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}