{"id":4041,"date":"2023-07-14T00:01:15","date_gmt":"2023-07-14T00:01:15","guid":{"rendered":"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/"},"modified":"2023-07-14T00:01:15","modified_gmt":"2023-07-14T00:01:15","slug":"tabel-frekuensi-panda-beberapa-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/","title":{"rendered":"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk membuat tabel frekuensi di panda berdasarkan beberapa kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df. <span style=\"color: #3366ff;\">value_counts<\/span> ([' <span style=\"color: #ff0000;\">column1<\/span> ',' <span style=\"color: #ff0000;\">column2<\/span> '])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Buat tabel frekuensi di Pandas berdasarkan beberapa kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang nama tim, posisi, dan poin yang dicetak oleh berbagai pemain bola basket:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><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', 'B'],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ': ['G', 'G', 'G', 'F', 'G', 'G', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [24, 33, 20, 15, 16, 16, 29, 25]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team position points\n0 AG 24\n1 AG 33\n2 AG 20\n3 AF15\n4 BG 16\n5 BG 16\n6 BF 29\n7 BF 25<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>value_counts()<\/strong> untuk membuat tabel frekuensi yang menunjukkan kemunculan setiap kombinasi nilai dalam kolom <strong>tim<\/strong> dan <strong>posisi<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#count frequency of values in team and position columns\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">value_counts<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> ',' <span style=\"color: #ff0000;\">position<\/span> '])\n\nteam position\nGA 3\nBF 2\n      G2\nAF1\ndtype: int64<\/span><\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya kita dapat melihat:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Ada <strong>3<\/strong> kemunculan tim A dan posisi G<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>2<\/strong> kemunculan tim B dan posisi F<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>2<\/strong> kemunculan tim B dan posisi G<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>1<\/strong> kemunculan tim A dan posisi F<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita dapat menggunakan <strong>reset_index()<\/strong> untuk mengembalikan DataFrame sebagai gantinya:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#count frequency of values in team and position columns and return DataFrame\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">value_counts<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> ',' <span style=\"color: #ff0000;\">position<\/span> ']). <span style=\"color: #3366ff;\">reset_index<\/span> ()\n\n        team position 0\n0 A G 3\n1 B F 2\n2 B G 2\n3 A F 1<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>rename()<\/strong> untuk mengganti nama kolom yang berisi hitungan:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#get frequency of values in team and position column and rename count column\n<\/span>df. <span style=\"color: #3366ff;\">value_counts<\/span> ([' <span style=\"color: #ff0000;\">team<\/span> ',' <span style=\"color: #ff0000;\">position<\/span> ']). <span style=\"color: #3366ff;\">reset_index<\/span> (). <span style=\"color: #3366ff;\">rename<\/span> (columns={0:' <span style=\"color: #ff0000;\">count<\/span> '})\n\n        team position count\n0 A G 3\n1 B F 2\n2 B G 2\n3 A F 1\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasil akhirnya adalah DataFrame yang berisi frekuensi setiap kombinasi nilai unik pada kolom <strong>Tim<\/strong> dan <strong>Posisi<\/strong> .<\/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 tugas umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/nilai-kelompok-panda-berdasarkan-jumlah\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggunakan GroupBy dan penghitungan nilai<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tempat-sampah-yang-dikelompokkan-berdasarkan-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggunakan GroupBy dengan jumlah bin<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-menghitung-nilai-di-kolom-dengan-kondisi\/\" target=\"_blank\" rel=\"noopener\">Pandas : Cara menghitung nilai pada kolom dengan syarat<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk membuat tabel frekuensi di panda berdasarkan beberapa kolom: df. value_counts ([&#8216; column1 &#8216;,&#8217; column2 &#8216;]) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: Buat tabel frekuensi di Pandas berdasarkan beberapa kolom Misalkan kita memiliki pandas DataFrame berikut yang berisi informasi tentang nama tim, posisi, dan poin [&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: membuat tabel frekuensi berdasarkan beberapa kolom - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tabel frekuensi di pandas berdasarkan beberapa kolom, termasuk contohnya.\" \/>\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\/tabel-frekuensi-panda-beberapa-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tabel frekuensi di pandas berdasarkan beberapa kolom, termasuk contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-14T00:01: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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/\",\"name\":\"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-14T00:01:15+00:00\",\"dateModified\":\"2023-07-14T00:01:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tabel frekuensi di pandas berdasarkan beberapa kolom, termasuk contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom\"}]},{\"@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: membuat tabel frekuensi berdasarkan beberapa kolom - Statorial","description":"Tutorial ini menjelaskan cara membuat tabel frekuensi di pandas berdasarkan beberapa kolom, termasuk contohnya.","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\/tabel-frekuensi-panda-beberapa-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom - Statorial","og_description":"Tutorial ini menjelaskan cara membuat tabel frekuensi di pandas berdasarkan beberapa kolom, termasuk contohnya.","og_url":"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-14T00:01:15+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\/tabel-frekuensi-panda-beberapa-kolom\/","url":"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/","name":"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-14T00:01:15+00:00","dateModified":"2023-07-14T00:01:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tabel frekuensi di pandas berdasarkan beberapa kolom, termasuk contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/tabel-frekuensi-panda-beberapa-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: membuat tabel frekuensi berdasarkan beberapa kolom"}]},{"@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\/4041"}],"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=4041"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4041\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4041"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4041"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4041"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}