{"id":1264,"date":"2023-07-27T02:23:26","date_gmt":"2023-07-27T02:23:26","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/"},"modified":"2023-07-27T02:23:26","modified_gmt":"2023-07-27T02:23:26","slug":"panda-menggantikan-nilai","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/","title":{"rendered":"Cara mengganti nilai di pandas dataframe (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengganti nilai dalam satu atau lebih kolom pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.replace.html\" target=\"_blank\" rel=\"noopener noreferrer\">.replace()<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan beberapa contoh penggunaan praktis fungsi ini pada 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\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({'team': ['A', 'A', 'B', 'B', 'B', 'C', 'C'],\n                   'division':['E', 'W', 'E', 'E', 'W', 'W', 'E'],\n                   'rebounds': [11, 8, 7, 6, 6, 5, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\n  team division rebounds\n0 AE 11\n1 AW 8\n2 BE 7\n3 BE 6\n4 BW 6\n5 CW 5\n6 CE 12<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Ganti Nilai Tunggal di Seluruh DataFrame<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti satu nilai di seluruh DataFrame pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace 'E' with 'East'<\/span>\ndf = df. <span style=\"color: #3366ff;\">replace<\/span> ([' <span style=\"color: #008000;\">E<\/span> '],' <span style=\"color: #008000;\">East<\/span> ')\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\n  team division rebounds\n0 A East 11\n1 AW 8\n2 B East 7\n3 B East 6\n4 BW 6\n5 CW 5\n6 C East 12<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Ganti beberapa nilai di seluruh DataFrame<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti beberapa nilai di seluruh DataFrame pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace 'E' with 'East' and 'W' with 'West'<\/span>\ndf = df. <span style=\"color: #3366ff;\">replace<\/span> ([' <span style=\"color: #008000;\">E<\/span> ',' <span style=\"color: #008000;\">W<\/span> '],[' <span style=\"color: #008000;\">East<\/span> ',' <span style=\"color: #008000;\">West<\/span> '])\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\n        team division rebounds\n0 A East 11\n1 A West 8\n2 B East 7\n3 B East 6\n4 B West 6\n5 C West 5\n6 C East 12\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Ganti satu nilai dalam satu kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti satu nilai dalam satu kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace 6 with 0 in <em>rebounds<\/em> column<\/span>\ndf[' <span style=\"color: #008000;\">rebounds<\/span> '] = df[' <span style=\"color: #008000;\">rebounds<\/span> ']. <span style=\"color: #3366ff;\">replace<\/span> (6, 0)\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\n        team division rebounds\n0 A E 11\n1 A W 8\n2 B E 7\n3 B E 0\n4 B W 0\n5 C W 5\n6 C E 12\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 4: Ganti beberapa nilai dalam satu kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengganti beberapa nilai dalam satu kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#replace 6, 11, and 8 with 0, 1 and 2 in <em>rebounds<\/em> column<\/span>\ndf[' <span style=\"color: #008000;\">rebounds<\/span> '] = df[' <span style=\"color: #008000;\">rebounds<\/span> ']. <span style=\"color: #3366ff;\">replace<\/span> ([6, 11, 8], [0, 1, 2])\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #993300;\">print<\/span> (df)\n\nteam division rebounds\n0 A E 1\n1 A W 2\n2 B E 7\n3 B E 0\n4 B W 0\n5 C W 5\n6 C E 12\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n<p> Bagaimana cara mengganti nilai NaN dengan nol di Pandas<br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengganti-string-kosong-dengan-nan\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti string kosong dengan NaN di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nilai pada kolom berdasarkan kondisi di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengganti nilai dalam satu atau lebih kolom pandas DataFrame. Untungnya, hal ini mudah dilakukan dengan menggunakan fungsi .replace() . Tutorial ini memberikan beberapa contoh penggunaan praktis fungsi ini pada DataFrame berikut: import pandas as pd #createDataFrame df = pd. DataFrame ({&#8216;team&#8217;: [&#8216;A&#8217;, &#8216;A&#8217;, &#8216;B&#8217;, &#8216;B&#8217;, &#8216;B&#8217;, &#8216;C&#8217;, &#8216;C&#8217;], &#8216;division&#8217;:[&#8216;E&#8217;, &#8216;W&#8217;, &#8216;E&#8217;, [&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 Mengganti Nilai di Pandas DataFrame (dengan Contoh)<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengganti nilai dalam satu atau beberapa kolom pandas DataFrame, termasuk contohnya.\" \/>\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-menggantikan-nilai\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengganti Nilai di Pandas DataFrame (dengan Contoh)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengganti nilai dalam satu atau beberapa kolom pandas DataFrame, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T02:23:26+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\/panda-menggantikan-nilai\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/\",\"name\":\"Cara Mengganti Nilai di Pandas DataFrame (dengan Contoh)\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T02:23:26+00:00\",\"dateModified\":\"2023-07-27T02:23:26+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengganti nilai dalam satu atau beberapa kolom pandas DataFrame, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengganti nilai di pandas dataframe (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 Mengganti Nilai di Pandas DataFrame (dengan Contoh)","description":"Tutorial ini menjelaskan cara mengganti nilai dalam satu atau beberapa kolom pandas DataFrame, termasuk contohnya.","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-menggantikan-nilai\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengganti Nilai di Pandas DataFrame (dengan Contoh)","og_description":"Tutorial ini menjelaskan cara mengganti nilai dalam satu atau beberapa kolom pandas DataFrame, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/","og_site_name":"Statorials","article_published_time":"2023-07-27T02:23:26+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\/panda-menggantikan-nilai\/","url":"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/","name":"Cara Mengganti Nilai di Pandas DataFrame (dengan Contoh)","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T02:23:26+00:00","dateModified":"2023-07-27T02:23:26+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengganti nilai dalam satu atau beberapa kolom pandas DataFrame, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menggantikan-nilai\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengganti nilai di pandas dataframe (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\/1264"}],"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=1264"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1264\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}