{"id":4311,"date":"2023-07-12T02:24:28","date_gmt":"2023-07-12T02:24:28","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/"},"modified":"2023-07-12T02:24:28","modified_gmt":"2023-07-12T02:24:28","slug":"kelompok-panda-berdasarkan-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/","title":{"rendered":"Pandas: cara mengelompokkan dua kolom dan agregat"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut dengan fungsi <strong>groupby()<\/strong> di panda untuk mengelompokkan berdasarkan dua kolom dan menggabungkan kolom lainnya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">var1<\/span> ',' <span style=\"color: #ff0000;\">var2<\/span> '])[' <span style=\"color: #ff0000;\">var3<\/span> ']. <span style=\"color: #3366ff;\">mean<\/span> ()\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengelompokkan DataFrame berdasarkan kolom <strong>var1<\/strong> dan <strong>var2<\/strong> , lalu menghitung rata-rata kolom <strong>var3<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Contoh berikut menunjukkan cara mengelompokkan pada dua kolom dan mengagregasi menggunakan pandas DataFrame berikut:<\/span><\/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\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'A', 'B', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ': ['G', 'G', 'F', 'F', 'F', 'G', 'G', 'G', 'G', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [15, 22, 24, 25, 20, 35, 34, 19, 14, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team position points\n0 AG 15\n1 AG 22\n2 AF 24\n3 AF 25\n4 AF 20\n5 BG 35\n6 BG 34\n7 BG 19\n8 BG 14\n9 BF 12\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Kelompokkan dua kolom dan hitung rata-rata kolom lainnya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung nilai rata-rata kolom <strong>poin<\/strong> , yang dikelompokkan berdasarkan kolom <strong>tim<\/strong> dan <strong>posisi<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate mean of points grouped by team and position columns\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">position<\/span> '])[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">mean<\/span> ()\n\nteam position\nAF23.0\n      G 18.5\nBF 12.0\n      G 25.5\nName: points, dtype: float64\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai rata-rata poin pemain tim A di posisi F adalah <strong>23<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai rata-rata poin pemain tim A di posisi G adalah <strong>18,5<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Kelompokkan dua kolom dan hitung maksimum kolom lainnya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung nilai maksimum kolom <strong>poin<\/strong> , yang dikelompokkan berdasarkan kolom <strong>tim<\/strong> dan <strong>posisi<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate max of points grouped by team and position columns\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">position<\/span> '])[' <span style=\"color: #ff0000;\">points<\/span> ']. <span style=\"color: #3366ff;\">max<\/span> ()\n\nteam position\nAF25\n      G22\nBF 12\n      G 35\nName: points, dtype: int64\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai poin maksimal pemain tim A di posisi F adalah <strong>25<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Nilai poin maksimal pemain tim A di posisi G adalah <strong>22<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Kelompokkan berdasarkan dua kolom dan hitung kemunculannya<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung kemunculan setiap kombinasi kolom <strong>tim<\/strong> dan <strong>posisi<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#count occurrences of each combination of team and position columns\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">position<\/span> ']). <span style=\"color: #3366ff;\">size<\/span> ()\n\nteam position\nAF3\n      G2\nBF 1\n      G4\ndtype: int64\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada <b>3<\/b> pemain di tim A di posisi F.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <b>2<\/b> pemain di tim A di posisi G.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\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\/panda-dikelompokkan-berdasarkan-jumlah-unik\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai unik menggunakan Pandas GroupBy<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/grup-panda-dengan-melamar\/\" target=\"_blank\" rel=\"noopener\">Cara menerapkan fungsi ke Pandas Groupby<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-batang-grup-panda\/\" target=\"_blank\" rel=\"noopener\">Cara Membuat Plot Batang dari Pandas GroupBy<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut dengan fungsi groupby() di panda untuk mengelompokkan berdasarkan dua kolom dan menggabungkan kolom lainnya: df. groupby ([&#8216; var1 &#8216;,&#8217; var2 &#8216;])[&#8216; var3 &#8216;]. mean () Contoh khusus ini mengelompokkan DataFrame berdasarkan kolom var1 dan var2 , lalu menghitung rata-rata kolom var3 . Contoh berikut menunjukkan cara mengelompokkan pada dua [&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 mengelompokkan berdasarkan dua kolom dan menggabungkan - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi groupby() di panda dengan dua kolom dan digabungkan berdasarkan metrik tertentu, 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\/kelompok-panda-berdasarkan-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: cara mengelompokkan berdasarkan dua kolom dan menggabungkan - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan fungsi groupby() di panda dengan dua kolom dan digabungkan berdasarkan metrik tertentu, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T02:24:28+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\/kelompok-panda-berdasarkan-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/\",\"name\":\"Pandas: cara mengelompokkan berdasarkan dua kolom dan menggabungkan - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T02:24:28+00:00\",\"dateModified\":\"2023-07-12T02:24:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan fungsi groupby() di panda dengan dua kolom dan digabungkan berdasarkan metrik tertentu, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengelompokkan dua kolom dan agregat\"}]},{\"@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 mengelompokkan berdasarkan dua kolom dan menggabungkan - Statorial","description":"Tutorial ini menjelaskan cara menggunakan fungsi groupby() di panda dengan dua kolom dan digabungkan berdasarkan metrik tertentu, 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\/kelompok-panda-berdasarkan-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: cara mengelompokkan berdasarkan dua kolom dan menggabungkan - Statorial","og_description":"Tutorial ini menjelaskan cara menggunakan fungsi groupby() di panda dengan dua kolom dan digabungkan berdasarkan metrik tertentu, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-12T02:24:28+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\/kelompok-panda-berdasarkan-dua-kolom\/","url":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/","name":"Pandas: cara mengelompokkan berdasarkan dua kolom dan menggabungkan - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T02:24:28+00:00","dateModified":"2023-07-12T02:24:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan fungsi groupby() di panda dengan dua kolom dan digabungkan berdasarkan metrik tertentu, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengelompokkan dua kolom dan agregat"}]},{"@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\/4311"}],"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=4311"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4311\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4311"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4311"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4311"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}