{"id":2467,"date":"2023-07-22T03:47:15","date_gmt":"2023-07-22T03:47:15","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/"},"modified":"2023-07-22T03:47:15","modified_gmt":"2023-07-22T03:47:15","slug":"panda-rata-rata-kolom-yang-dipilih","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/","title":{"rendered":"Cara menghitung rata-rata kolom yang dipilih di pandas"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk menghitung nilai baris rata-rata untuk kolom yang dipilih di pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Hitung nilai rata-rata baris untuk semua kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">mean<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Hitung nilai baris rata-rata untuk kolom tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col3<\/span> ']]. <span style=\"color: #3366ff;\">mean<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan pandas DataFrame berikut:<\/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\n<\/span>df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">points<\/span> ': [14, 19, 9, 21, 25, 29, 20, 11],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9, 9, 4],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5, 9, 12]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tpoints assists rebounds\n0 14 5 11\n1 19 7 8\n2 9 7 10\n3 21 9 6\n4 25 12 6\n5 29 9 5\n6 20 9 9\n7 11 4 12<\/b><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Metode 1: Hitung nilai rata-rata baris untuk semua kolom<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat kolom baru di DataFrame yang menampilkan nilai baris rata-rata untuk semua kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#define new column that shows the average row value for all columns<\/span>\ndf[' <span style=\"color: #ff0000;\">average_all<\/span> '] = df. <span style=\"color: #3366ff;\">mean<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame<\/span>\ndf\n\n\tpoints assists rebounds average_all\n0 14 5 11 10.000000\n1 19 7 8 11.333333\n2 9 7 10 8.666667\n3 21 9 6 12.000000\n4 25 12 6 14.333333\n5 29 9 5 14.333333\n6 20 9 9 12.666667\n7 11 4 12 9.000000\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata baris pertama dihitung sebagai berikut: (14+5+11) \/ 3 = <strong>10<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata baris kedua dihitung sebagai berikut: (19+7+8) \/ 3 = <strong>11.33<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Metode 2: Hitung nilai baris rata-rata untuk kolom tertentu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Kode berikut menunjukkan cara menghitung nilai baris rata-rata hanya untuk kolom &#8220;poin&#8221; dan &#8220;rebounds&#8221;:<\/span><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #008080;\">#define new column that shows average of row values for points and rebounds columns\n<\/span>df[' <span style=\"color: #ff0000;\">avg_points_rebounds<\/span> '] = df[[' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> ']]. <span style=\"color: #3366ff;\">mean<\/span> (axis= <span style=\"color: #008000;\">1<\/span> )\n\n<span style=\"color: #008080;\">#view updated DataFrame\n<\/span>df\n\n        points assists rebounds avg_points_rebounds\n0 14 5 11 12.5\n1 19 7 8 13.5\n2 9 7 10 9.5\n3 21 9 6 13.5\n4 25 12 6 15.5\n5 29 9 5 17.0\n6 20 9 9 14.5\n7 11 4 12 11.5<\/span>\n<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata \u201cpoin\u201d dan \u201crebound\u201d pada baris pertama dihitung sebagai berikut: (14+11) \/ 2 = <strong>12.5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Nilai rata-rata \u201cpoin\u201d dan \u201crebound\u201d pada baris kedua dihitung sebagai berikut: (19+8) \/ 2 = <strong>13.5<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/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 dengan Python:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/ukuran-sedang-dengan-python\/\" target=\"_blank\" rel=\"noopener\">Cara menghitung mean terpangkas dengan Python<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rata-rata-geometris-python\/\" target=\"_blank\" rel=\"noopener\">Cara Menghitung Rata-Rata Geometris dengan Python<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/pandas-mengganti-nilai-di-kolom-berdasarkan-negara-bagian\/\" target=\"_blank\" rel=\"noopener\">Cara mengganti nilai pada kolom Pandas berdasarkan kondisi<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk menghitung nilai baris rata-rata untuk kolom yang dipilih di pandas DataFrame: Metode 1: Hitung nilai rata-rata baris untuk semua kolom df. mean (axis= 1 ) Metode 2: Hitung nilai baris rata-rata untuk kolom tertentu df[[&#8216; col1 &#8216;, &#8216; col3 &#8216;]]. mean (axis= 1 ) Contoh berikut menunjukkan cara menggunakan [&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>Cara menghitung rata-rata kolom yang dipilih di Pandas \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata kolom yang dipilih di panda, 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\/panda-rata-rata-kolom-yang-dipilih\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menghitung rata-rata kolom yang dipilih di Pandas \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung rata-rata kolom yang dipilih di panda, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T03:47:15+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\/panda-rata-rata-kolom-yang-dipilih\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/\",\"name\":\"Cara menghitung rata-rata kolom yang dipilih di Pandas \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T03:47:15+00:00\",\"dateModified\":\"2023-07-22T03:47:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung rata-rata kolom yang dipilih di panda, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata kolom yang dipilih di pandas\"}]},{\"@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":"Cara menghitung rata-rata kolom yang dipilih di Pandas \u2013 Statorials","description":"Tutorial ini menjelaskan cara menghitung rata-rata kolom yang dipilih di panda, 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\/panda-rata-rata-kolom-yang-dipilih\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata kolom yang dipilih di Pandas \u2013 Statorials","og_description":"Tutorial ini menjelaskan cara menghitung rata-rata kolom yang dipilih di panda, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/","og_site_name":"Statorials","article_published_time":"2023-07-22T03:47:15+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\/panda-rata-rata-kolom-yang-dipilih\/","url":"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/","name":"Cara menghitung rata-rata kolom yang dipilih di Pandas \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T03:47:15+00:00","dateModified":"2023-07-22T03:47:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung rata-rata kolom yang dipilih di panda, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-rata-rata-kolom-yang-dipilih\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata kolom yang dipilih di pandas"}]},{"@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\/2467"}],"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=2467"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2467\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2467"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2467"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2467"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}