{"id":3700,"date":"2023-07-16T01:36:44","date_gmt":"2023-07-16T01:36:44","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/"},"modified":"2023-07-16T01:36:44","modified_gmt":"2023-07-16T01:36:44","slug":"panda-mengurangi-dua-kerangka-data","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/","title":{"rendered":"Pandas: cara mengurangi dua dataframes"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk mengurangi satu pandas DataFrame dari yang lain:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df1. <span style=\"color: #3366ff;\">subtract<\/span> (df2)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Jika Anda memiliki kolom karakter di setiap DataFrame, Anda mungkin perlu memindahkannya ke kolom indeks setiap DataFrame terlebih dahulu:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df1. <span style=\"color: #3366ff;\">set_index<\/span> (' <span style=\"color: #ff0000;\">char_column<\/span> '). <span style=\"color: #3366ff;\">subtract<\/span> ( <span style=\"color: #3366ff;\">df2.set_index<\/span> (' <span style=\"color: #ff0000;\">char_column<\/span> '))<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap sintaksis dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Kurangi dua Pandas DataFrames (hanya kolom numerik)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua panda DataFrames berikut yang hanya memiliki kolom numerik:<\/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: #000000;\"><span style=\"color: #008080;\">\n<span style=\"color: #000000;\"><span style=\"color: #008080;\">#create first DataFrame\n<\/span>df1 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ': [5, 17, 7, 19, 12, 13, 9, 24],\n                    ' <span style=\"color: #ff0000;\">assists<\/span> ': [4, 7, 7, 6, 8, 7, 10, 11]})\n\n<span style=\"color: #008000;\">print<\/span> (df1)\n\n   assist points\n0 5 4\n1 17 7\n2 7 7\n3 19 6\n4 12 8\n5 13 7\n6 9 10\n7 24 11\n\n<span style=\"color: #008080;\">#create second DataFrame\n<\/span>df2 = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ': [4, 22, 10, 3, 7, 8, 12, 10],\n                    ' <span style=\"color: #ff0000;\">assists<\/span> ': [3, 5, 5, 4, 7, 14, 9, 5]})\n\n<span style=\"color: #008000;\">print<\/span> (df2)\n\n   assist points\n0 4 3\n1 22 5\n2 10 5\n3 3 4\n4 7 7\n5 8 14\n6 12 9\n7 10 5\n<\/span><\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengurangi nilai yang sesuai antara dua DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#subtract corresponding values between the two DataFrames<\/span>\ndf1. <span style=\"color: #3366ff;\">subtract<\/span> (df2)\n\n\tassist points\n0 1 1\n1 -5 2\n2 -3 2\n3 16 2\n4 5 1\n5 5 -7\n6 -3 1\n7 14 6\n<\/strong><\/span><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Kurangi dua Pandas DataFrames (campuran kolom karakter dan numerik)<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki dua panda DataFrames berikut yang masing-masing memiliki kolom karakter bernama <strong>team<\/strong> :<\/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: #000000;\"><span style=\"color: #008080;\">\n#create first DataFrame\n<\/span>df1 = 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> ': [5, 17, 7, 19, 12, 13, 9, 24],\n                    ' <span style=\"color: #ff0000;\">assists<\/span> ': [4, 7, 7, 6, 8, 7, 10, 11]})\n\n<span style=\"color: #008000;\">print<\/span> (df1)\n\n  team points assists\n0 to 5 4\n1 B 17 7\n2 C 7 7\n3 D 19 6\n4 E 12 8\n5 F 13 7\n6 G 9 10\n7:24 a.m. 11\n\n<span style=\"color: #008080;\">#create second DataFrame\n<\/span>df2 = 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> ': [4, 22, 10, 3, 7, 8, 12, 10],\n                    ' <span style=\"color: #ff0000;\">assists<\/span> ': [3, 5, 5, 4, 7, 14, 9, 3]})\n\n<span style=\"color: #008000;\">print<\/span> (df2)\n\n  team points assists\n0 to 4 3\n1 B 22 5\n2 C 10 5\n3 D 3 4\n4 E 7 7\n5 F 8 14\n6 G 12 9\n7:10 a.m. 3<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara memindahkan kolom <strong>tim<\/strong> ke kolom indeks setiap DataFrame, lalu mengurangi nilai yang sesuai antara kedua DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\">#move 'team' column to index of each DataFrame and subtract corresponding values\n<\/span>df1. <span style=\"color: #3366ff;\">set_index<\/span> (' <span style=\"color: #ff0000;\">team<\/span> '). <span style=\"color: #3366ff;\">subtract<\/span> ( <span style=\"color: #3366ff;\">df2.set_index<\/span> (' <span style=\"color: #ff0000;\">team<\/span> '))\n\n\tassist points\nteam\t\t\nAt 1 1\nB-52\nC -3 2\nD 16 2\nE 5 1\nF 5 -7\nG -3 1\nH 14 8\n<\/span><\/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> <a href=\"https:\/\/statorials.org\/id\/perbedaan-panda-antara-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mencari selisih antara dua kolom<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/perbedaan-panda-antar-baris\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mencari perbedaan antara dua garis<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kolom\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara mengurangi dua kolom<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk mengurangi satu pandas DataFrame dari yang lain: df1. subtract (df2) Jika Anda memiliki kolom karakter di setiap DataFrame, Anda mungkin perlu memindahkannya ke kolom indeks setiap DataFrame terlebih dahulu: df1. set_index (&#8216; char_column &#8216;). subtract ( df2.set_index (&#8216; char_column &#8216;)) Contoh berikut menunjukkan cara menggunakan setiap sintaksis dalam praktiknya. [&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 mengurangi dua DataFrames - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurangi nilai antara dua panda DataFrames, 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-kerangka-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengurangi dua DataFrames - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurangi nilai antara dua panda DataFrames, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T01:36:44+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-kerangka-data\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/\",\"name\":\"Pandas: Cara mengurangi dua DataFrames - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T01:36:44+00:00\",\"dateModified\":\"2023-07-16T01:36:44+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurangi nilai antara dua panda DataFrames, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengurangi dua dataframes\"}]},{\"@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 mengurangi dua DataFrames - Statorials","description":"Tutorial ini menjelaskan cara mengurangi nilai antara dua panda DataFrames, 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-kerangka-data\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengurangi dua DataFrames - Statorials","og_description":"Tutorial ini menjelaskan cara mengurangi nilai antara dua panda DataFrames, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/","og_site_name":"Statorials","article_published_time":"2023-07-16T01:36:44+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-kerangka-data\/","url":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/","name":"Pandas: Cara mengurangi dua DataFrames - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T01:36:44+00:00","dateModified":"2023-07-16T01:36:44+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurangi nilai antara dua panda DataFrames, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mengurangi-dua-kerangka-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengurangi dua dataframes"}]},{"@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\/3700"}],"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=3700"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3700\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}