{"id":1946,"date":"2023-07-24T08:42:58","date_gmt":"2023-07-24T08:42:58","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/"},"modified":"2023-07-24T08:42:58","modified_gmt":"2023-07-24T08:42:58","slug":"panda-mengurangi-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/","title":{"rendered":"Cara mengurangi dua kolom di pandas dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengurangi satu kolom dari kolom lain di pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#subtract column 'B' from column 'A'<\/span>\ndf[' <span style=\"color: #ff0000;\">AB<\/span> '] = df. <span style=\"color: #3366ff;\">A<\/span> - df. <span style=\"color: #3366ff;\">B\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Kurangi dua kolom di Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengurangi satu kolom dari kolom lain di pandas DataFrame dan menetapkan hasilnya ke kolom baru:<\/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;\">A<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' <span style=\"color: #ff0000;\">B<\/span> ': [5, 7, 8, 9, 12, 9, 12, 4],\n                   ' <span style=\"color: #ff0000;\">C<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n<span style=\"color: #008080;\">#subtract column B from column A<\/span>\ndf[' <span style=\"color: #ff0000;\">AB<\/span> '] = df. <span style=\"color: #3366ff;\">A<\/span> - df. <span style=\"color: #3366ff;\">B<\/span>\n\n<span style=\"color: #008080;\">#view DataFrame<\/span>\ndf\n\n        A B C AB\n0 25 5 11 20\n1 12 7 8 5\n2 15 8 10 7\n3 14 9 6 5\n4 19 12 6 7\n5 23 9 5 14\n6 25 12 9 13\n7 29 4 12 25\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kolom baru bernama &#8216; <strong>AB<\/strong> &#8216; menampilkan hasil pengurangan nilai pada kolom B dengan nilai pada kolom A.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Kurangi dua kolom yang nilainya hilang<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Jika kita mengurangi satu kolom dari kolom lain di pandas DataFrame dan ada nilai yang hilang di salah satu kolom, hasil pengurangan akan selalu berupa nilai yang hilang:<\/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<span style=\"color: #008000;\">import<\/span> numpy <span style=\"color: #008000;\">as<\/span> np\n\n<span style=\"color: #008080;\">#create DataFrame with some missing values<\/span>\n<span style=\"color: #000000;\">df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">A<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' <span style=\"color: #ff0000;\">B<\/span> ': [5, 7, np. <span style=\"color: #3366ff;\">no<\/span> , 9, 12, np. <span style=\"color: #3366ff;\">no<\/span> , 12, 4],\n                   ' <span style=\"color: #ff0000;\">C<\/span> ': [np. <span style=\"color: #3366ff;\">no<\/span> , 8, 10, 6, 6, 5, 9, 12]}) \n<\/span>\n<span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#subtract column B from column A<\/span>\ndf[' <span style=\"color: #ff0000;\">AB<\/span> '] = df. <span style=\"color: #3366ff;\">A<\/span> - df. <span style=\"color: #3366ff;\">B\n<\/span>\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tA B C AB\n0 25 5.0 NaN 20.0\n1 12 7.0 8.0 5.0\n2 15 NaN 10.0 NaN\n3 14 9.0 6.0 5.0\n4 19 12.0 6.0 7.0\n5 23 NaN 5.0 NaN\n6 25 12.0 9.0 13.0\n7 29 4.0 12.0 25.0\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika mau, Anda bisa mengganti semua nilai yang hilang di dataFrame dengan nol menggunakan fungsi <strong>df.fillna(0)<\/strong> sebelum mengurangi satu kolom dari kolom lainnya:<\/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<span style=\"color: #008000;\">import<\/span> numpy <span style=\"color: #008000;\">as<\/span> np\n\n<span style=\"color: #008080;\">#create DataFrame with some missing values<\/span>\n<span style=\"color: #000000;\">df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">A<\/span> ': [25, 12, 15, 14, 19, 23, 25, 29],\n                   ' <span style=\"color: #ff0000;\">B<\/span> ': [5, 7, np. <span style=\"color: #3366ff;\">no<\/span> , 9, 12, np. <span style=\"color: #3366ff;\">no<\/span> , 12, 4],\n                   ' <span style=\"color: #ff0000;\">C<\/span> ': [np. <span style=\"color: #3366ff;\">no<\/span> , 8, 10, 6, 6, 5, 9, 12]}) \n<\/span>\n<span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#replace all missing values with zeros\n<\/span>df = df. <span style=\"color: #3366ff;\">fillna<\/span> ( <span style=\"color: #008000;\">0<\/span> )\n\n<span style=\"color: #008080;\">#subtract column B from column A<\/span>\ndf[' <span style=\"color: #ff0000;\">AB<\/span> '] = df. <span style=\"color: #ff0000;\">A<\/span> - df. <span style=\"color: #ff0000;\">B<\/span>\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\tA B C AB\n0 25 5.0 0.0 20.0\n1 12 7.0 8.0 5.0\n2 15 0.0 10.0 15.0\n3 14 9.0 6.0 5.0\n4 19 12.0 6.0 7.0\n5 23 0.0 5.0 23.0\n6 25 12.0 9.0 13.0\n7 29 4.0 12.0 25.0<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/pandas-menambahkan-baris-ke-kerangka-data\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan baris ke Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tambahkan-array-numpy-ke-kerangka-data-pandas\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara menambahkan array Numpy ke Pandas DataFrame<\/a><br \/> Cara menghitung jumlah baris di Pandas DataFrame<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengurangi satu kolom dari kolom lain di pandas DataFrame: #subtract column &#8216;B&#8217; from column &#8216;A&#8217; df[&#8216; AB &#8216;] = df. A &#8211; df. B Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh 1: Kurangi dua kolom di Pandas Kode berikut menunjukkan cara mengurangi satu kolom dari kolom [&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 mengurangi dua kolom di Pandas DataFrame \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurangi dua 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\/panda-mengurangi-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengurangi dua kolom di Pandas DataFrame \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurangi dua kolom di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-24T08:42:58+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-mengurangi-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/\",\"name\":\"Cara mengurangi dua kolom di Pandas DataFrame \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-24T08:42:58+00:00\",\"dateModified\":\"2023-07-24T08:42:58+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurangi dua kolom di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengurangi dua kolom di pandas dataframe\"}]},{\"@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 mengurangi dua kolom di Pandas DataFrame \u2013 Statorials","description":"Tutorial ini menjelaskan cara mengurangi dua 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\/panda-mengurangi-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengurangi dua kolom di Pandas DataFrame \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara mengurangi dua kolom di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-24T08:42:58+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-mengurangi-dua-kolom\/","url":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/","name":"Cara mengurangi dua kolom di Pandas DataFrame \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-24T08:42:58+00:00","dateModified":"2023-07-24T08:42:58+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurangi dua kolom di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengurangi dua kolom di pandas dataframe"}]},{"@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\/1946"}],"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=1946"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1946\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1946"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1946"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1946"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}