{"id":893,"date":"2023-07-28T10:02:57","date_gmt":"2023-07-28T10:02:57","guid":{"rendered":"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/"},"modified":"2023-07-28T10:02:57","modified_gmt":"2023-07-28T10:02:57","slug":"kolom-panda-rata-rata","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/","title":{"rendered":"Cara menghitung rata-rata kolom di pandas"},"content":{"rendered":"

<\/p>\n

\n

Seringkali Anda mungkin tertarik untuk menghitung rata-rata satu atau lebih kolom di pandas DataFrame. Untungnya, Anda dapat melakukan ini dengan mudah di panda menggunakan fungsi Mean()<\/a> .<\/span><\/p>\n

Tutorial ini menunjukkan beberapa contoh penggunaan fungsi ini.<\/span><\/p>\n

Contoh 1: Temukan rata-rata satu kolom<\/strong><\/span><\/h3>\n

Misalkan kita memiliki panda DataFrame berikut:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\nimport<\/span> numpy as<\/span> np\n\n#createDataFrame<\/span>\ndf = pd.DataFrame({'player': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J '],\n                   'points': [25, 20, 14, 16, 27, 20, 12, 15, 14, 19],\n                   'assists': [5, 7, 7, 8, 5, 7, 6, 9, 9, 5],\n                   'rebounds': [np.nan, 8, 10, 6, 6, 9, 6, 10, 10, 7]})\n\n#view DataFrame<\/span> \ndf\n\n        player points assists rebounds\n0 A 25 5 NaN\n1 B 20 7 8.0\n2 C 14 7 10.0\n3 D 16 8 6.0\n4 E 27 5 6.0\n5 F 20 7 9.0\n6 G 12 6 6.0\n7:15 9 10.0\n8 I 14 9 10.0\n9 D 19 5 7.0\n<\/strong><\/pre>\n
 Kita dapat mencari rata-rata kolom berlabel “poin” menggunakan sintaks berikut:<\/span><\/p>\n
 df['points']. mean<\/span> ()\n\n18.2<\/strong><\/pre>\n
 Fungsi Mean() juga akan mengecualikan NA secara default. Misalnya, jika kita menemukan rata-rata kolom \u201crebound\u201d, nilai pertama \u201cNaN\u201d akan dikeluarkan dari penghitungan:<\/span><\/p>\n
 df['rebounds']. mean<\/span> ()\n\n8.0\n<\/strong><\/pre>\n
 Jika Anda mencoba mencari rata-rata kolom yang bukan numerik, Anda akan menerima pesan kesalahan:<\/span><\/p>\n
 df['player'].<\/span> mean<\/span> ()<\/span>\n<\/span>\nTypeError: Could not convert ABCDEFGHIJ to numeric\n<\/strong><\/pre>\n
 Contoh 2: Temukan rata-rata beberapa kolom<\/strong><\/span><\/h3>\n
 Kita dapat menemukan rata-rata beberapa kolom menggunakan sintaks berikut:<\/span><\/p>\n
 #find mean of points and rebounds columns<\/span>\ndf[['rebounds', 'points']]. mean<\/span> ()\n\nrebounds 8.0\npoints 18.2\ndtype:float64\n<\/strong><\/pre>\n
 Contoh 3: Temukan rata-rata semua kolom<\/strong><\/span><\/h3>\n
 Kita juga dapat mencari rata-rata semua kolom numerik menggunakan sintaks berikut:<\/span><\/p>\n
 #find mean of all numeric columns in DataFrame<\/span>\ndf. mean<\/span> ()\n\npoints 18.2\nassists 6.8\nrebounds 8.0\ndtype:float64\n<\/strong><\/pre>\n
 Perhatikan bahwa fungsi Mean() hanya akan mengabaikan kolom yang bukan numerik.<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara menghitung median di panda<\/a>
 Cara menghitung jumlah kolom di Pandas<\/a>
 Bagaimana menemukan nilai maksimum kolom di Pandas<\/p>\n","protected":false},"excerpt":{"rendered":"
Seringkali Anda mungkin tertarik untuk menghitung rata-rata satu atau lebih kolom di pandas DataFrame. Untungnya, Anda dapat melakukan ini dengan mudah di panda menggunakan fungsi Mean() . Tutorial ini menunjukkan beberapa contoh penggunaan fungsi ini. Contoh 1: Temukan rata-rata satu kolom Misalkan kita memiliki panda DataFrame berikut: import pandas as pd import numpy as np […]<\/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":"\nCara menghitung rata-rata kolom di panda \u2013 Statorials<\/title>\n<meta name=\"description\" content=\"Penjelasan sederhana tentang cara menghitung rata-rata satu atau lebih kolom di pandas DataFrame.\" \/>\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\/kolom-panda-rata-rata\/\" \/>\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 di panda \u2013 Statorials\" \/>\n<meta property=\"og:description\" content=\"Penjelasan sederhana tentang cara menghitung rata-rata satu atau lebih kolom di pandas DataFrame.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T10:02:57+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\/kolom-panda-rata-rata\/\",\"url\":\"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/\",\"name\":\"Cara menghitung rata-rata kolom di panda \u2013 Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T10:02:57+00:00\",\"dateModified\":\"2023-07-28T10:02:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Penjelasan sederhana tentang cara menghitung rata-rata satu atau lebih kolom di pandas DataFrame.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menghitung rata-rata kolom 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 di panda \u2013 Statorials","description":"Penjelasan sederhana tentang cara menghitung rata-rata satu atau lebih kolom di pandas DataFrame.","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\/kolom-panda-rata-rata\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menghitung rata-rata kolom di panda \u2013 Statorials","og_description":"Penjelasan sederhana tentang cara menghitung rata-rata satu atau lebih kolom di pandas DataFrame.","og_url":"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/","og_site_name":"Statorials","article_published_time":"2023-07-28T10:02:57+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\/kolom-panda-rata-rata\/","url":"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/","name":"Cara menghitung rata-rata kolom di panda \u2013 Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T10:02:57+00:00","dateModified":"2023-07-28T10:02:57+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Penjelasan sederhana tentang cara menghitung rata-rata satu atau lebih kolom di pandas DataFrame.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kolom-panda-rata-rata\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menghitung rata-rata kolom 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\/893"}],"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=893"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/893\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=893"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=893"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=893"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}