{"id":3721,"date":"2023-07-15T22:47:03","date_gmt":"2023-07-15T22:47:03","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/"},"modified":"2023-07-15T22:47:03","modified_gmt":"2023-07-15T22:47:03","slug":"panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/","title":{"rendered":"Pandas: dapatkan baris yang tidak ada di dataframe lain"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk mendapatkan baris dari DataFrame panda yang tidak ada di DataFrame lain:<\/span><\/p>\n

 #merge two DataFrames and create indicator column<\/span>\ndf_all = df1. merge<\/span> ( df2.drop_duplicates<\/span> (), on=[' col1<\/span> ',' col2<\/span> '],\n                   how=' left<\/span> ', indicator= True<\/span> )\n\n#create DataFrame with rows that exist in first DataFrame only<\/span>\ndf1_only = df_all[df_all[' _merge<\/span> '] == ' left_only<\/span> ']<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Mendapatkan baris di Pandas DataFrame yang tidak ada di DataFrame lain<\/strong><\/h2>\n
 Mari kita asumsikan kita memiliki dua panda DataFrames berikut:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#create first DataFrame\ndf1 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'B', 'C', 'D', 'E'], \n                    ' points<\/span> ': [12, 15, 22, 29, 24]}) \n\nprint<\/span> (df1)\n\n  team points\n0 to 12\n1 B 15\n2 C 22\n3 D 29\n4 E 24\n\n#create second DataFrame\n<\/span>df2 = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'D', 'F', 'G', 'H'],\n                    ' points<\/span> ': [12, 29, 15, 19, 10]})\n\nprint<\/span> (df2)\n\n  team points\n0 to 12\n1 D 29\n2 F 15\n3 G 19\n4:10 a.m.\n<\/span><\/span><\/strong><\/pre>\n
 Kita dapat menggunakan sintaks berikut untuk menggabungkan dua DataFrame dan membuat kolom indikator untuk menunjukkan baris mana yang dimiliki setiap DataFrame:<\/span><\/span><\/p>\n
 #merge two DataFrames and create indicator column\n<\/span>df_all = df1. merge<\/span> ( df2.drop_duplicates<\/span> (), on=[' team<\/span> ',' points<\/span> '],\n                   how=' left<\/span> ', indicator= True<\/span> )\n\n#view result\n<\/span>print<\/span> (df_all)<\/strong><\/pre>\n
 Kita kemudian dapat menggunakan sintaks berikut untuk mendapatkan hanya baris dari DataFrame pertama yang tidak ada di DataFrame kedua:<\/span><\/span><\/p>\n
 #create DataFrame with rows that exist in first DataFrame only\n<\/span>df1_only = df_all[df_all[' _merge<\/span> '] == ' left_only<\/span> ']\n\n#view DataFrame\n<\/span>print<\/span> (df1_only)\n\n  team points _merge\n1 B 15 left_only\n2 C 22 left_only\n4 E 24 left_only\n<\/strong><\/pre>\n
 Terakhir, kita dapat menghapus kolom _merge<\/strong> jika kita ingin:<\/span><\/p>\n
 #drop '_merge' column\n<\/span>df1_only = df1_only. drop<\/span> (' _merge<\/span> ', axis= 1<\/span> )\n\n#view DataFrame\n<\/span>print<\/span> (df1_only)\n\n  team points\n1 B 15\n2 C 22\n4 E 24<\/span><\/span><\/strong><\/pre>\n
 Hasilnya adalah DataFrame yang semua barisnya ada di DataFrame pertama tetapi tidak di DataFrame kedua.<\/span><\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Bagaimana cara menambahkan kolom dari satu DataFrame ke DataFrame lainnya di Pandas<\/a>
 Bagaimana mengubah urutan kolom di Pandas<\/a>
 Cara mengurutkan kolom berdasarkan nama di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk mendapatkan baris dari DataFrame panda yang tidak ada di DataFrame lain: #merge two DataFrames and create indicator column df_all = df1. merge ( df2.drop_duplicates (), on=[‘ col1 ‘,’ col2 ‘], how=’ left ‘, indicator= True ) #create DataFrame with rows that exist in first DataFrame only df1_only = […]<\/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: Dapatkan baris yang tidak ada di DataFrame lain - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mendapatkan baris di DataFrame pandas yang tidak ada di DataFrame lain, 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-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Dapatkan baris yang tidak ada di DataFrame lain - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mendapatkan baris di DataFrame pandas yang tidak ada di DataFrame lain, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-15T22:47:03+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-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/\",\"name\":\"Pandas: Dapatkan baris yang tidak ada di DataFrame lain - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-15T22:47:03+00:00\",\"dateModified\":\"2023-07-15T22:47:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mendapatkan baris di DataFrame pandas yang tidak ada di DataFrame lain, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: dapatkan baris yang tidak ada di dataframe lain\"}]},{\"@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: Dapatkan baris yang tidak ada di DataFrame lain - Statorials","description":"Tutorial ini menjelaskan cara mendapatkan baris di DataFrame pandas yang tidak ada di DataFrame lain, 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-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Dapatkan baris yang tidak ada di DataFrame lain - Statorials","og_description":"Tutorial ini menjelaskan cara mendapatkan baris di DataFrame pandas yang tidak ada di DataFrame lain, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-15T22:47:03+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-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/","url":"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/","name":"Pandas: Dapatkan baris yang tidak ada di DataFrame lain - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-15T22:47:03+00:00","dateModified":"2023-07-15T22:47:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mendapatkan baris di DataFrame pandas yang tidak ada di DataFrame lain, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-mendapatkan-baris-yang-tidak-ada-di-kerangka-data-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: dapatkan baris yang tidak ada di dataframe lain"}]},{"@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\/3721"}],"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=3721"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3721\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3721"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3721"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3721"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}