{"id":3535,"date":"2023-07-16T23:40:03","date_gmt":"2023-07-16T23:40:03","guid":{"rendered":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/"},"modified":"2023-07-16T23:40:03","modified_gmt":"2023-07-16T23:40:03","slug":"kelompok-panda-berdasarkan-beberapa-agregasi","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/","title":{"rendered":"Pandas: cara menggunakan groupby dengan banyak agregasi"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menggunakan groupby dengan beberapa agregasi di panda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">team<\/span> '). <span style=\"color: #3366ff;\">agg<\/span> (\n    mean_points=(' <span style=\"color: #ff0000;\">points<\/span> ', np. <span style=\"color: #3366ff;\">mean<\/span> ),\n    sum_points=(' <span style=\"color: #ff0000;\">points<\/span> ', np. <span style=\"color: #3366ff;\">sum<\/span> ),\n    std_points=(' <span style=\"color: #ff0000;\">points<\/span> ', np. <span style=\"color: #3366ff;\">std<\/span> ))\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Rumus khusus ini mengelompokkan baris DataFrame berdasarkan variabel yang disebut <b>team<\/b> dan kemudian menghitung beberapa ringkasan statistik untuk variabel yang disebut <strong>points<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Menggunakan Groupby dengan Banyak Agregasi di Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang berbagai pemain bola basket:<\/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<\/strong><strong><span style=\"color: #008080;\">#createDataFrame\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Mavs', 'Mavs', 'Heat', 'Heat', 'Heat'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [18, 22, 19, 14, 14, 11],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   team points assists\n0 Mavs 18 5\n1 Mavs 22 7\n2 Mavs 19 7\n3 Heat 14 9\n4 Heat 14 12\n5 Heat 11 9\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengelompokkan baris DataFrame berdasarkan <strong>team<\/strong> , lalu menghitung rata-rata, jumlah, dan deviasi standar <strong>poin<\/strong> untuk setiap tim:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\">import<\/span> numpy <span style=\"color: #008000;\">as<\/span> np\n\n<span style=\"color: #008080;\">#group by team and calculate mean, sum, and standard deviation of points\n<\/span><\/strong><strong>df. <span style=\"color: #3366ff;\">groupby<\/span> (' <span style=\"color: #ff0000;\">team<\/span> '). <span style=\"color: #3366ff;\">agg<\/span> (\n    mean_points=(' <span style=\"color: #ff0000;\">points<\/span> ', np. <span style=\"color: #3366ff;\">mean<\/span> ),\n    sum_points=(' <span style=\"color: #ff0000;\">points<\/span> ', np. <span style=\"color: #3366ff;\">sum<\/span> ),\n    std_points=(' <span style=\"color: #ff0000;\">points<\/span> ', np. <span style=\"color: #3366ff;\">std<\/span> ))\n\n      mean_points sum_points std_points\nteam\t\t\t\nHeat 13.000000 39 1.732051\nMavs 19.666667 59 2.081666<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasilnya menampilkan mean, jumlah, dan deviasi standar variabel <strong>poin<\/strong> untuk setiap <strong>tim<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Anda dapat menggunakan sintaks serupa untuk melakukan pengelompokan dan menghitung agregasi sebanyak yang Anda inginkan.<\/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 panda umum lainnya:<\/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 untuk menggunakan groupby dengan beberapa agregasi di panda: df. groupby (&#8216; team &#8216;). agg ( mean_points=(&#8216; points &#8216;, np. mean ), sum_points=(&#8216; points &#8216;, np. sum ), std_points=(&#8216; points &#8216;, np. std )) Rumus khusus ini mengelompokkan baris DataFrame berdasarkan variabel yang disebut team dan kemudian menghitung beberapa ringkasan [&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 menggunakan Groupby dengan banyak agregasi - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan groupby() dengan beberapa agregasi di panda, termasuk sebuah 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\/kelompok-panda-berdasarkan-beberapa-agregasi\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggunakan Groupby dengan banyak agregasi - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan groupby() dengan beberapa agregasi di panda, termasuk sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-16T23:40: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=\"1 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-beberapa-agregasi\/\",\"url\":\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/\",\"name\":\"Pandas: Cara menggunakan Groupby dengan banyak agregasi - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-16T23:40:03+00:00\",\"dateModified\":\"2023-07-16T23:40:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan groupby() dengan beberapa agregasi di panda, termasuk sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggunakan groupby dengan banyak agregasi\"}]},{\"@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 menggunakan Groupby dengan banyak agregasi - Statorials","description":"Tutorial ini menjelaskan cara menggunakan groupby() dengan beberapa agregasi di panda, termasuk sebuah 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\/kelompok-panda-berdasarkan-beberapa-agregasi\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggunakan Groupby dengan banyak agregasi - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan groupby() dengan beberapa agregasi di panda, termasuk sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/","og_site_name":"Statorials","article_published_time":"2023-07-16T23:40:03+00:00","author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/","url":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/","name":"Pandas: Cara menggunakan Groupby dengan banyak agregasi - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-16T23:40:03+00:00","dateModified":"2023-07-16T23:40:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan groupby() dengan beberapa agregasi di panda, termasuk sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-beberapa-agregasi\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggunakan groupby dengan banyak agregasi"}]},{"@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\/3535"}],"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=3535"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3535\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3535"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3535"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3535"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}