{"id":890,"date":"2023-07-28T10:15:37","date_gmt":"2023-07-28T10:15:37","guid":{"rendered":"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/"},"modified":"2023-07-28T10:15:37","modified_gmt":"2023-07-28T10:15:37","slug":"bandingkan-dua-kerangka-data-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/","title":{"rendered":"Bagaimana membandingkan dua dataframes di pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali, Anda mungkin tertarik untuk membandingkan nilai antara dua panda DataFrames untuk menemukan persamaan dan perbedaannya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukannya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Membandingkan dua DataFrame di Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita mempunyai dua panda DataFrames berikut, yang masing-masing berisi data empat pemain bola basket:<\/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;\">#define DataFrame 1<\/span>\ndf1 = pd. <span style=\"color: #0000ff;\">DataFrame<\/span> ({'player': ['A', 'B', 'C', 'D'],\n                   'points': [12, 15, 17, 24],\n                   'assists': [4, 6, 7, 8]})\ndf1\n\n\n        player points assists\n0 to 12 4\n1 B 15 6\n2 C 17 7\n3 D 24 88\n\n<span style=\"color: #008080;\">#define DataFrame 2\n<\/span>df2 = pd. <span style=\"color: #0000ff;\">DataFrame<\/span> ({'player': ['A', 'B', 'C', 'D'],\n                    'points': [12, 24, 26, 29],\n                    'assists': [7, 8, 10, 13]})\ndf2\n\n\tplayer points assists\n0 to 12 7\n1 B 24 8\n2 C 26 10\n3 D 29 13\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Contoh 1: Cari tahu apakah kedua DataFrame itu sama.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama-tama kita dapat mengetahui apakah kedua DataFrame identik menggunakan fungsi <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.equals.html\" target=\"_blank\" rel=\"noopener\">DataFrame.equals()<\/a> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#see if two DataFrames are identical<\/span>\ndf1. <span style=\"color: #0000ff;\">equals<\/span> (df2)\n\nFalse<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kedua DataFrame tidak berisi nilai yang sama persis, sehingga fungsi ini mengembalikan <strong>False<\/strong> dengan benar.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Contoh 2: Temukan perbedaan statistik pemain antara kedua DataFrame.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menemukan perbedaan antara assist dan poin masing-masing pemain menggunakan fungsi pandas <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.DataFrame.subtract.html\" target=\"_blank\" rel=\"noopener\">subtract()<\/a> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#subtract df1 from df2<\/span>\ndf2. <span style=\"color: #0000ff;\">set_index<\/span> ('player'). <span style=\"color: #0000ff;\">subtract<\/span> (df1.set_index('player'))\n\n\tassist points\nplayer\t\t\nAt 0 3\nB 9 2\nC 9 3\nD 5 5\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Cara menafsirkannya adalah:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain A memiliki jumlah poin yang sama di kedua DataFrame, namun dia mendapat 3 assist lebih banyak di DataFrame 2.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain B memperoleh 9 poin lebih banyak dan 2 assist lebih banyak di DataFrame 2 dibandingkan dengan DataFrame 1.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain C memperoleh 9 poin lebih banyak dan 3 assist lebih banyak di DataFrame 2 dibandingkan dengan DataFrame 1.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain D mendapat 5 poin lebih banyak dan 5 assist lebih banyak di DataFrame 2 dibandingkan dengan DataFrame 1.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\"><strong>Contoh 3: Temukan semua baris yang hanya ada dalam satu DataFrame.<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mendapatkan daftar lengkap baris yang hanya muncul dalam satu DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#outer merge the two DataFrames, adding an indicator column called 'Exist'<\/span>\ndiff_df = pd. <span style=\"color: #0000ff;\">merge<\/span> (df1, df2, how=' <span style=\"color: #008000;\">outer<\/span> ', indicator=' <span style=\"color: #008000;\">Exist<\/span> ')\n\n<span style=\"color: #008080;\">#find which rows don't exist in both DataFrames\n<\/span>diff_df = diff_df. <span style=\"color: #0000ff;\">loc<\/span> [diff_df[' <span style=\"color: #008000;\">Exist<\/span> '] != ' <span style=\"color: #008000;\">both<\/span> ']\ndiff_df\n\n\tplayer points assists Exist\n0 A 12 4 left_only\n1 B 15 6 left_only\n2 C 17 7 left_only\n3 D 24 8 left_only\n4 A 12 7 right_only\n5 B 24 8 right_only\n6 C 26 10 right_only\n7 D 29 13 right_only\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dalam hal ini, kedua DataFrame tidak berbagi baris yang sama, sehingga ada total 8 baris yang hanya muncul di salah satu DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kolom berlabel &#8220;Ada&#8221; dengan mudah memberi tahu kita di DataFrame mana setiap baris muncul secara unik.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali, Anda mungkin tertarik untuk membandingkan nilai antara dua panda DataFrames untuk menemukan persamaan dan perbedaannya. Tutorial ini menjelaskan cara melakukannya. Contoh: Membandingkan dua DataFrame di Pandas Misalkan kita mempunyai dua panda DataFrames berikut, yang masing-masing berisi data empat pemain bola basket: import pandas as pd #define DataFrame 1 df1 = pd. DataFrame ({&#8216;player&#8217;: [&#8216;A&#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>Bagaimana membandingkan dua DataFrame di Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara membandingkan nilai antara dua DataFrames di Pandas.\" \/>\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\/bandingkan-dua-kerangka-data-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana membandingkan dua DataFrame di Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara membandingkan nilai antara dua DataFrames di Pandas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T10:15:37+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\/bandingkan-dua-kerangka-data-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/\",\"name\":\"Bagaimana membandingkan dua DataFrame di Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T10:15:37+00:00\",\"dateModified\":\"2023-07-28T10:15:37+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara membandingkan nilai antara dua DataFrames di Pandas.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana membandingkan dua dataframes 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":"Bagaimana membandingkan dua DataFrame di Pandas \u2013 Statorials","description":"Penjelasan sederhana tentang cara membandingkan nilai antara dua DataFrames di Pandas.","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\/bandingkan-dua-kerangka-data-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana membandingkan dua DataFrame di Pandas \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara membandingkan nilai antara dua DataFrames di Pandas.","og_url":"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-28T10:15:37+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\/bandingkan-dua-kerangka-data-panda\/","url":"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/","name":"Bagaimana membandingkan dua DataFrame di Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T10:15:37+00:00","dateModified":"2023-07-28T10:15:37+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara membandingkan nilai antara dua DataFrames di Pandas.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/bandingkan-dua-kerangka-data-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana membandingkan dua dataframes 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\/890"}],"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=890"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/890\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}