{"id":2353,"date":"2023-07-22T15:45:51","date_gmt":"2023-07-22T15:45:51","guid":{"rendered":"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/"},"modified":"2023-07-22T15:45:51","modified_gmt":"2023-07-22T15:45:51","slug":"indeks-grup-panda-berdasarkan","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/","title":{"rendered":"Pandas: cara mengelompokkan berdasarkan indeks dan melakukan perhitungan"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan metode berikut untuk mengelompokkan berdasarkan satu atau beberapa kolom indeks di panda dan melakukan penghitungan:<\/span><\/p>\n

Metode 1: Kelompokkan berdasarkan kolom indeks<\/strong><\/span><\/p>\n

 df. groupby<\/span> (' index1<\/span> ')[' numeric_column<\/span> ']. max<\/span> ()\n<\/strong><\/pre>\n
 Metode 2: Kelompokkan berdasarkan beberapa kolom indeks<\/strong><\/span><\/p>\n
 df. groupby<\/span> ([' index1<\/span> ',' index2<\/span> '])[' numeric_column<\/span> ']. sum<\/span> ()<\/strong><\/pre>\n
 Metode 3: Kelompokkan berdasarkan Kolom Indeks dan Kolom Reguler<\/strong><\/span><\/p>\n
 df. groupby<\/span> ([' index1<\/span> ',' numeric_column1<\/span> '])[' numeric_column2<\/span> ']. nunique<\/span> ()<\/strong><\/pre>\n
 Contoh berikut menunjukkan cara menggunakan setiap metode dengan panda DataFrame berikut yang memiliki MultiIndex:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#createDataFrame\n<\/span>df = pd. DataFrame<\/span> ({' team<\/span> ': ['A', 'A', 'A', 'A', 'A', 'B', 'B', 'B', 'B', 'B'],\n                   ' position<\/span> ': ['G', 'G', 'G', 'F', 'F', 'G', 'G', 'F', 'F', 'F'],\n                   ' points<\/span> ': [7, 7, 7, 19, 16, 9, 10, 10, 8, 8],\n                   ' rebounds<\/span> ': [8, 8, 8, 10, 11, 12, 13, 13, 15, 11]})\n\n#set 'team' column to be index column\n<\/span>df. set_index<\/span> ([' team<\/span> ', ' position<\/span> '], inplace= True<\/span> )\n\n#view DataFrame\n<\/span>df\n\n\t\t rebound points\nteam position\t\t\nA G 7 8\n        G 7 8\n        G 7 8\n        F 19 10\n        F 16 11\nB G 9 12\n        G 10 13\n        F 10 13\n        F 8 15\n        F 8 11\n<\/strong><\/span><\/pre>\n
 Metode 1: Kelompokkan berdasarkan kolom indeks<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mencari nilai maksimum kolom “poin”, yang dikelompokkan berdasarkan kolom indeks “posisi”:<\/span><\/p>\n
 #find max value of 'points' grouped by 'position index column\ndf. groupby<\/span> (' position<\/span> ')[' points<\/span> ']. max<\/span> ()\n\nposition\nF 19\nG 10\nName: points, dtype: int64<\/span>\n<\/span><\/strong><\/pre>\n
 Metode 2: Kelompokkan berdasarkan beberapa kolom indeks<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mencari jumlah kolom “poin”, yang dikelompokkan berdasarkan kolom indeks “tim” dan “posisi”:<\/span><\/p>\n
 #find max value of 'points' grouped by 'position index column\ndf. groupby<\/span> ([' team<\/span> ', ' position<\/span> '])[' points<\/span> ']. sum<\/span> ()\n\nteam position\nAF35\n      G21\nBF 26\n      G 19\nName: points, dtype: int64<\/span><\/span><\/strong><\/pre>\n
 Metode 3: Kelompokkan berdasarkan Kolom Indeks dan Kolom Reguler<\/strong><\/span><\/h3>\n
 Kode berikut menunjukkan cara mencari jumlah nilai unik pada kolom “rebound”, yang dikelompokkan berdasarkan kolom indeks “tim” dan kolom “poin” biasa:<\/span><\/p>\n
 #find max value of 'points' grouped by 'position index column\ndf. groupby<\/span> ([' team<\/span> ', ' points<\/span> '])[' rebounds<\/span> ']. nunique<\/span> ()\n\nteam points\nAt 7 1\n      16 1\n      19 1\nB 8 2\n      9 1\n      10 1\nName: rebounds, dtype: int64<\/span><\/span><\/strong><\/pre>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n
 Cara menghitung nilai unik di panda<\/a>
 Cara meratakan MultiIndex di Pandas<\/a>
 Cara mengubah satu atau lebih nilai indeks di Pandas<\/a>
 Cara mereset indeks di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan metode berikut untuk mengelompokkan berdasarkan satu atau beberapa kolom indeks di panda dan melakukan penghitungan: Metode 1: Kelompokkan berdasarkan kolom indeks df. groupby (‘ index1 ‘)[‘ numeric_column ‘]. max () Metode 2: Kelompokkan berdasarkan beberapa kolom indeks df. groupby ([‘ index1 ‘,’ index2 ‘])[‘ numeric_column ‘]. sum () Metode 3: Kelompokkan berdasarkan […]<\/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: Cara mengelompokkan berdasarkan indeks dan menghitung - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengelompokkan berdasarkan kolom indeks di panda dan kemudian melakukan perhitungan, 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\/indeks-grup-panda-berdasarkan\/\" \/>\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 indeks dan menghitung - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengelompokkan berdasarkan kolom indeks di panda dan kemudian melakukan perhitungan, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T15:45:51+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\/indeks-grup-panda-berdasarkan\/\",\"url\":\"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/\",\"name\":\"Pandas: Cara mengelompokkan berdasarkan indeks dan menghitung - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T15:45:51+00:00\",\"dateModified\":\"2023-07-22T15:45:51+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengelompokkan berdasarkan kolom indeks di panda dan kemudian melakukan perhitungan, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengelompokkan berdasarkan indeks dan melakukan perhitungan\"}]},{\"@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 indeks dan menghitung - Statologi","description":"Tutorial ini menjelaskan cara mengelompokkan berdasarkan kolom indeks di panda dan kemudian melakukan perhitungan, 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\/indeks-grup-panda-berdasarkan\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengelompokkan berdasarkan indeks dan menghitung - Statologi","og_description":"Tutorial ini menjelaskan cara mengelompokkan berdasarkan kolom indeks di panda dan kemudian melakukan perhitungan, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/","og_site_name":"Statorials","article_published_time":"2023-07-22T15:45:51+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\/indeks-grup-panda-berdasarkan\/","url":"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/","name":"Pandas: Cara mengelompokkan berdasarkan indeks dan menghitung - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T15:45:51+00:00","dateModified":"2023-07-22T15:45:51+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengelompokkan berdasarkan kolom indeks di panda dan kemudian melakukan perhitungan, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengelompokkan berdasarkan indeks dan melakukan perhitungan"}]},{"@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\/2353"}],"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=2353"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2353\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2353"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2353"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2353"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}