{"id":4233,"date":"2023-07-12T15:50:28","date_gmt":"2023-07-12T15:50:28","guid":{"rendered":"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/"},"modified":"2023-07-12T15:50:28","modified_gmt":"2023-07-12T15:50:28","slug":"grup-panda-dengan-mean-dan-std","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/","title":{"rendered":"Pandas: hitung mean &amp; std kolom di groupby"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghitung mean dan deviasi standar kolom setelah menggunakan operasi <strong>groupby()<\/strong> di pandas:<\/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> '], as_index= <span style=\"color: #008000;\">False<\/span> ). <span style=\"color: #3366ff;\">agg<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ':[' <span style=\"color: #ff0000;\">mean<\/span> ', ' <span style=\"color: #ff0000;\">std<\/span> ']})\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh khusus ini mengelompokkan baris DataFrame pandas berdasarkan nilai di kolom <strong>Tim<\/strong> , lalu menghitung mean dan deviasi standar dari nilai di kolom <strong>Poin<\/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><span style=\"color: #000000;\">Contoh: Hitung mean dan norma kolom di Pandas groupby<\/span><\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang berisi informasi tentang pemain bola basket dari tim yang berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <b><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#createDataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [12, 15, 17, 17, 19, 14, 15, 20, 24, 28],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 5, 7, 9, 10, 14, 13, 8, 2, 7]})\n                            \n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points assists\n0 to 12 5\n1 to 15 5\n2 To 17 7\n3 To 17 9\n4 B 19 10\n5 B 14 14\n6 B 15 13\n7 C 20 8\n8 C 24 2\n9 C 28 7\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung mean dan deviasi standar dari nilai-nilai pada kolom <strong>poin<\/strong> , yang dikelompokkan berdasarkan kolom <strong>tim<\/strong> :<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#calculate mean and standard deviation of points, grouped by team<\/span>\noutput = df. <span style=\"color: #3366ff;\">groupby<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> '], as_index= <span style=\"color: #008000;\">False<\/span> ). <span style=\"color: #3366ff;\">agg<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ':[' <span style=\"color: #ff0000;\">mean<\/span> ', ' <span style=\"color: #ff0000;\">std<\/span> ']})\n\n<span style=\"color: #008080;\">#view results<\/span>\n<span style=\"color: #008000;\">print<\/span> (output)\n\n  team points          \n         mean std\n0 A 15.25 2.362908\n1 B 16.00 2.645751\n2 C 24.00 4.000000\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Nilai rata-rata poin tim A adalah <strong>15,25<\/strong> .<\/span><\/li>\n<li> <span style=\"color: #000000;\">Standar deviasi poin Tim A adalah <strong>2.362908<\/strong> .<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kita juga bisa mengganti nama kolomnya agar hasilnya lebih mudah dibaca:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#rename columns\n<\/span>output.output. <span style=\"color: #3366ff;\">columns<\/span> = [' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">points_mean<\/span> ', ' <span style=\"color: #ff0000;\">points_std<\/span> ']\n\n<span style=\"color: #008080;\">#view updated results<\/span>\n<span style=\"color: #008000;\">print<\/span> (output)\n\n  team points_mean points_std\n0 A 15.25 2.362908\n1 B 16.00 2.645751\n2 C 24.00 4.000000\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap operasi pandas <strong>groupby()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.DataFrame.groupby.html\" target=\"_blank\" rel=\"noopener\">di sini<\/a> .<\/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 operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-jumlah\/\" target=\"_blank\" rel=\"noopener\">Cara melakukan penjumlahan GroupBy di Pandas<\/a><br \/><a href=\"https:\/\/statorials.org\/id\/kelompok-panda-berdasarkan-plot\/\" target=\"_blank\" rel=\"noopener\">Cara menggunakan Groupby dan Plot di Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-dikelompokkan-berdasarkan-jumlah-unik\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung nilai unik menggunakan GroupBy di Pandas<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby() di pandas: df. groupby ([&#8216; team &#8216;], as_index= False ). agg ({&#8216; points &#8216;:[&#8216; mean &#8216;, &#8216; std &#8216;]}) Contoh khusus ini mengelompokkan baris DataFrame pandas berdasarkan nilai di kolom Tim , lalu menghitung mean dan deviasi standar dari [&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: menghitung mean dan norma kolom di groupby - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby di pandas.\" \/>\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\/grup-panda-dengan-mean-dan-std\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: menghitung mean dan norma kolom di groupby - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby di pandas.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T15:50: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\/grup-panda-dengan-mean-dan-std\/\",\"url\":\"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/\",\"name\":\"Pandas: menghitung mean dan norma kolom di groupby - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T15:50:28+00:00\",\"dateModified\":\"2023-07-12T15:50:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby di pandas.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: hitung mean &amp; std kolom di groupby\"}]},{\"@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: menghitung mean dan norma kolom di groupby - Statologi","description":"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby di pandas.","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\/grup-panda-dengan-mean-dan-std\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: menghitung mean dan norma kolom di groupby - Statologi","og_description":"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby di pandas.","og_url":"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/","og_site_name":"Statorials","article_published_time":"2023-07-12T15:50: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\/grup-panda-dengan-mean-dan-std\/","url":"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/","name":"Pandas: menghitung mean dan norma kolom di groupby - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T15:50:28+00:00","dateModified":"2023-07-12T15:50:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung mean dan deviasi standar kolom setelah menggunakan operasi groupby di pandas.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/grup-panda-dengan-mean-dan-std\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: hitung mean &amp; std kolom di groupby"}]},{"@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\/4233"}],"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=4233"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4233\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}