{"id":2363,"date":"2023-07-22T14:46:55","date_gmt":"2023-07-22T14:46:55","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/"},"modified":"2023-07-22T14:46:55","modified_gmt":"2023-07-22T14:46:55","slug":"pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/","title":{"rendered":"Pandas: cara mengganti nilai pada kolom berdasarkan kondisi"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk mengganti nilai di kolom pandas DataFrame berdasarkan kondisi:<\/span><\/p>\n

 #replace values in 'column1' that are greater than 10 with 20<\/span>\ndf. loc<\/span> [df[' column1<\/span> '] > 10, ' column1<\/span> '] = 20\n<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh 1: Ganti nilai pada kolom berdasarkan suatu kondisi<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' position<\/span> ': ['G', 'G', 'F', 'F', 'G', 'G', 'F', 'F'],\n                   ' points<\/span> ': [5, 7, 7, 9, 12, 13, 9, 14],\n                   ' assists<\/span> ': [3, 8, 2, 6, 6, 5, 9, 5]})\n\n#view DataFrame\n<\/span>df\n\n\tteam position points assists\n0 A G 5 3\n1 A G 7 8\n2 A F 7 2\n3 A F 9 6\n4 B G 12 6\n5 B G 13 5\n6 B F 9 9\n7 B F 14 5       \n<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan kode berikut untuk mengganti setiap nilai pada kolom “poin” yang lebih besar dari 10 dengan nilai 20:<\/span><\/p>\n
 #replace any values in 'points' column greater than 10 with 20\n<\/span>df. loc<\/span> [df[' points<\/span> '] > 10, ' points<\/span> '] = 20\n\n#view updated DataFrame\n<\/span>df\n\n\tteam position points assists\n0 A G 5 3\n1 A G 7 8\n2 A F 7 2\n3 A F 9 6\n4 B G 20 6\n5 B G 20 5\n6 B F 9 9\n7 B F 20 5\n<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa masing-masing dari tiga nilai pada kolom \u201cpoin\u201d yang lebih besar dari 10 telah diganti dengan nilai 20.<\/span><\/p>\n
 Contoh 2: Ganti nilai dalam kolom berdasarkan beberapa kondisi<\/strong><\/span><\/h3>\n
 Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\ndf = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'],\n                   ' position<\/span> ': ['G', 'G', 'F', 'F', 'G', 'G', 'F', 'F'],\n                   ' points<\/span> ': [5, 7, 7, 9, 12, 13, 9, 14],\n                   ' assists<\/span> ': [3, 8, 2, 6, 6, 5, 9, 5]})\n\n#view DataFrame\n<\/span>df\n\n\tteam position points assists\n0 A G 5 3\n1 A G 7 8\n2 A F 7 2\n3 A F 9 6\n4 B G 12 6\n5 B G 13 5\n6 B F 9 9\n7 B F 14 5       \n<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan kode berikut untuk mengganti setiap nilai di kolom “posisi” yang poinnya kurang dari 10 atau<\/em> assistnya kurang dari 5 dengan string “Buruk”:<\/span><\/p>\n
 #replace string in 'position' column with 'bad' if points < 10 or assists < 5\ndf. loc<\/span> [(df[' points<\/span> '] < 10) |<\/span> (df[' assists<\/span> '] < 5), ' position<\/span> '] = ' Bad<\/span> '\n\n#view updated DataFrame\n<\/span>df\n\n        team position points assists\n0 A Bad 5 3\n1 A Bad 7 8\n2 A Bad 7 2\n3 A Bad 9 6\n4 B G 20 6\n5 B G 20 5\n6 B Bad 9 9\n7 B F 20 5\n<\/span><\/span><\/strong><\/pre>\n
 Demikian pula, kita dapat menggunakan kode berikut untuk mengganti setiap nilai di kolom “posisi” yang poinnya kurang dari 10 dan<\/i> lintasannya kurang dari 5 dengan string “Buruk”:<\/span><\/p>\n
 #replace string in 'position' column with 'bad' if points < 10 and assists < 5\ndf. loc<\/span> [(df[' points<\/span> '] < 10) &<\/span> (df[' assists<\/span> '] < 5), ' position<\/span> '] = ' Bad<\/span> '\n\n#view updated DataFrame\n<\/span>df\n\n        team position points assists\n0 A Bad 5 3\n1 A G 7 8\n2 A Bad 7 2\n3 A F 9 6\n4 B G 12 6\n5 B G 13 5\n6 B F 9 9\n7 B F 14 5<\/span><\/span><\/strong><\/pre>\n
 Perhatikan bahwa dua baris di mana poin kurang dari 10 dan<\/em> assist kurang dari 5 memiliki nilai “posisi” diganti dengan string “Buruk”.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Cara memilih baris berdasarkan beberapa kondisi di Pandas<\/a>
 Cara membuat kolom baru berdasarkan kondisi di Pandas<\/a>
 Cara memfilter Pandas DataFrame pada berbagai kondisi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk mengganti nilai di kolom pandas DataFrame berdasarkan kondisi: #replace values in ‘column1’ that are greater than 10 with 20 df. loc [df[‘ column1 ‘] > 10, ‘ column1 ‘] = 20 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: Ganti nilai pada kolom berdasarkan suatu […]<\/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":"\nPandas: Cara mengganti nilai pada kolom berdasarkan kondisi - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti nilai pada kolom pandas DataFrame berdasarkan suatu kondisi, termasuk 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-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengganti nilai pada kolom berdasarkan kondisi - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti nilai pada kolom pandas DataFrame berdasarkan suatu kondisi, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T14:46:55+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-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\",\"name\":\"Pandas: Cara mengganti nilai pada kolom berdasarkan kondisi - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T14:46:55+00:00\",\"dateModified\":\"2023-07-22T14:46:55+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti nilai pada kolom pandas DataFrame berdasarkan suatu kondisi, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengganti nilai pada kolom berdasarkan kondisi\"}]},{\"@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 mengganti nilai pada kolom berdasarkan kondisi - Statorials","description":"Tutorial ini menjelaskan cara mengganti nilai pada kolom pandas DataFrame berdasarkan suatu kondisi, termasuk 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-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengganti nilai pada kolom berdasarkan kondisi - Statorials","og_description":"Tutorial ini menjelaskan cara mengganti nilai pada kolom pandas DataFrame berdasarkan suatu kondisi, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/","og_site_name":"Statorials","article_published_time":"2023-07-22T14:46:55+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-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/","url":"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/","name":"Pandas: Cara mengganti nilai pada kolom berdasarkan kondisi - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T14:46:55+00:00","dateModified":"2023-07-22T14:46:55+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti nilai pada kolom pandas DataFrame berdasarkan suatu kondisi, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengganti nilai pada kolom berdasarkan kondisi"}]},{"@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\/2363"}],"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=2363"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2363\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}