{"id":3005,"date":"2023-07-19T16:28:39","date_gmt":"2023-07-19T16:28:39","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/"},"modified":"2023-07-19T16:28:39","modified_gmt":"2023-07-19T16:28:39","slug":"pandas-dikelompokkan-ke-kerangka-data","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/","title":{"rendered":"Bagaimana mengonversi keluaran pandas groupby ke dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Tutorial ini menjelaskan cara mengonversi output pandas GroupBy ke pandas DataFrame.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Konversi keluaran Pandas GroupBy ke DataFrame<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang menunjukkan poin yang dicetak oleh pemain bola basket dari tim berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><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', 'B', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ': ['G', 'G', 'F', 'C', 'G', 'F', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [5, 7, 7, 10, 12, 22, 15, 10]})\n\n<span style=\"color: #008080;\">#view DataFrame<\/span>\n<span style=\"color: #008000;\">print<\/span> (df)\n\n  team position points\n0 AG 5\n1 AG 7\n2AF 7\n3 AC 10\n4 BG 12\n5 BF 22\n6 BF 15\n7 BF 10\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung jumlah pemain, dikelompokkan berdasarkan <strong>tim<\/strong> dan <strong>posisi<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#count number of players, grouped by team and position\n<span style=\"color: #000000;\">group = 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<\/span>\n#viewoutput\n<span style=\"color: #000000;\"><span style=\"color: #008000;\">print<\/span> (group)\n\nteam position\nAC 1\n      F 1\n      G2\nBF 3\n      G 1\ndtype: int64\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari outputnya kita bisa melihat jumlah pemain yang dikelompokkan berdasarkan <strong>tim<\/strong> dan <strong>posisinya<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, katakanlah kita ingin keluaran kita menampilkan nama tim di setiap baris seperti ini:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong>team position count\n0 AC 1\n1 AF 1\n2 AG 2\n3 BF 3\n4 BG 1\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Untuk mencapai hasil ini, kita cukup menggunakan <strong>reset_index()<\/strong> saat menjalankan GroupBy:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#count number of players, grouped by team and position\n<\/span>df_out = 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> (). <span style=\"color: #3366ff;\">reset_index<\/span> (name=' <span style=\"color: #ff0000;\">count<\/span> ')\n\n<span style=\"color: #008000;\"><span style=\"color: #008080;\">#viewoutput\n<\/span>print<\/span> (df_out)\n\n  team position count\n0 AC 1\n1 AF 1\n2 AG 2\n3 BF 3\n4 BG 1\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Outputnya sekarang muncul dalam format yang diinginkan.<\/span><\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa argumen <strong>nama<\/strong> di <strong>reset_index()<\/strong> menentukan nama kolom baru yang dihasilkan oleh GroupBy.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kami juga dapat mengonfirmasi bahwa hasilnya memang pandas DataFrame:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#display object type of df_out\n<\/span><span style=\"color: #008000;\">type<\/span> (df_out)\n\npandas.core.frame.DataFrame\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operasi GroupBy di pandas <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.groupby.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan operasi umum lainnya di panda:<\/span><\/p>\n<p><a href=\"https:\/\/statorials.org\/id\/jumlah-kumulatif-panda-per-grup\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung jumlah kumulatif per kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-dikelompokkan-berdasarkan-jumlah-unik\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung nilai unik berdasarkan kelompok<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-korelasi\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menghitung korelasi berdasarkan kelompok<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tutorial ini menjelaskan cara mengonversi output pandas GroupBy ke pandas DataFrame. Contoh: Konversi keluaran Pandas GroupBy ke DataFrame Misalkan kita memiliki panda DataFrame berikut yang menunjukkan poin yang dicetak oleh pemain bola basket dari tim berbeda: import pandas as pd #createDataFrame df = pd. DataFrame ({&#8216; team &#8216;: [&#8216;A&#8217;, &#8216;A&#8217;, &#8216;A&#8217;, &#8216;A&#8217;, &#8216;B&#8217;, &#8216;B&#8217;, &#8216;B&#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 mengonversi keluaran Pandas GroupBy ke DataFrame - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengonversi objek pandas GroupBy menjadi DataFrame pandas, dengan 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\/pandas-dikelompokkan-ke-kerangka-data\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana mengonversi keluaran Pandas GroupBy ke DataFrame - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengonversi objek pandas GroupBy menjadi DataFrame pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-19T16:28:39+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\/pandas-dikelompokkan-ke-kerangka-data\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/\",\"name\":\"Bagaimana mengonversi keluaran Pandas GroupBy ke DataFrame - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-19T16:28:39+00:00\",\"dateModified\":\"2023-07-19T16:28:39+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengonversi objek pandas GroupBy menjadi DataFrame pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana mengonversi keluaran pandas groupby ke dataframe\"}]},{\"@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 mengonversi keluaran Pandas GroupBy ke DataFrame - Statorials","description":"Tutorial ini menjelaskan cara mengonversi objek pandas GroupBy menjadi DataFrame pandas, dengan 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\/pandas-dikelompokkan-ke-kerangka-data\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana mengonversi keluaran Pandas GroupBy ke DataFrame - Statorials","og_description":"Tutorial ini menjelaskan cara mengonversi objek pandas GroupBy menjadi DataFrame pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/","og_site_name":"Statorials","article_published_time":"2023-07-19T16:28:39+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\/pandas-dikelompokkan-ke-kerangka-data\/","url":"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/","name":"Bagaimana mengonversi keluaran Pandas GroupBy ke DataFrame - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-19T16:28:39+00:00","dateModified":"2023-07-19T16:28:39+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengonversi objek pandas GroupBy menjadi DataFrame pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-dikelompokkan-ke-kerangka-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana mengonversi keluaran pandas groupby ke dataframe"}]},{"@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\/3005"}],"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=3005"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3005\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3005"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3005"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}