{"id":3208,"date":"2023-07-18T16:36:45","date_gmt":"2023-07-18T16:36:45","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/"},"modified":"2023-07-18T16:36:45","modified_gmt":"2023-07-18T16:36:45","slug":"panda-menghitung-kombinasi-unik-dari-dua-kolom","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/","title":{"rendered":"Pandas: cara menghitung kombinasi unik dua kolom"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks berikut untuk menghitung jumlah kombinasi unik di dua kolom dalam pandas DataFrame:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> ']]. <span style=\"color: #3366ff;\">value_counts<\/span> (). <span style=\"color: #3366ff;\">reset_index<\/span> (name=' <span style=\"color: #ff0000;\">count<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: menghitung kombinasi unik dua kolom di Pandas<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki panda DataFrame berikut yang menunjukkan <strong>tim<\/strong> dan <strong>posisi<\/strong> 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;\">#create dataFrame<\/span>\ndf = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['Mavs', 'Mavs', 'Mavs', 'Mavs',\n                            'Heat', 'Heat', 'Heat', 'Heat'],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ': ['Guard', 'Guard', 'Guard', 'Forward',\n                                'Guard', 'Forward', 'Forward', 'Guard']})\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n        team position\n0 Mavs Guard\n1 Mavs Guard\n2 Mavs Guard\n3 Mavs Forward\n4 Heat Guard\n5 Heat Forward\n6 Heat Forward\n7 Heat Guard<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk menghitung jumlah kombinasi <strong>tim<\/strong> dan <strong>posisi<\/strong> unik:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">position<\/span> ']]. <span style=\"color: #3366ff;\">value_counts<\/span> (). <span style=\"color: #3366ff;\">reset_index<\/span> (name=' <span style=\"color: #ff0000;\">count<\/span> ')\n\n        team position count\n0 Mavs Guard 3\n1 Heat Forward 2\n2 Heat Guard 2\n3 Mavs Forward 1\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 kombinasi Mavs-Guard.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terdapat <strong>2<\/strong> kemunculan kombinasi Heat-Forward.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Ada <strong>2<\/strong> kemunculan kombinasi Heat-Guard.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Terdapat <strong>1<\/strong> kemunculan kombinasi Mavs-Forward.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa Anda juga dapat mengurutkan hasil dalam urutan menaik atau menurun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Misalnya, kita dapat menggunakan kode berikut untuk mengurutkan hasil dalam <strong>urutan<\/strong> angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df[[' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">position<\/span> ']]. <span style=\"color: #3366ff;\">value_counts<\/span> (ascending= <span style=\"color: #008000;\">True<\/span> ). <span style=\"color: #3366ff;\">reset_index<\/span> (name=' <span style=\"color: #ff0000;\">count<\/span> ')\n\n        team position count\n0 Mavs Forward 1\n1 Heat Forward 2\n2 Heat Guard 2\n3 Mavs Guard 3<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Hasil sekarang diurutkan berdasarkan angka, dari yang terkecil hingga yang terbesar.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>value_counts()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.Series.value_counts.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 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\/jumlah-tabel-pivot-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membuat tabel pivot dengan jumlah nilai<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks berikut untuk menghitung jumlah kombinasi unik di dua kolom dalam pandas DataFrame: df[[&#8216; col1 &#8216;, &#8216; col2 &#8216;]]. value_counts (). reset_index (name=&#8217; count &#8216;) Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya. Contoh: menghitung kombinasi unik dua kolom di Pandas Misalkan kita memiliki panda DataFrame berikut yang menunjukkan tim dan [&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: Cara menghitung kombinasi unik dua kolom \u2013 Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kombinasi unik di dua kolom di pandas DataFrame, 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\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menghitung kombinasi unik dua kolom \u2013 Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghitung jumlah kombinasi unik di dua kolom di pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-18T16:36:45+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-menghitung-kombinasi-unik-dari-dua-kolom\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/\",\"name\":\"Pandas: Cara menghitung kombinasi unik dua kolom \u2013 Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-18T16:36:45+00:00\",\"dateModified\":\"2023-07-18T16:36:45+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghitung jumlah kombinasi unik di dua kolom di pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menghitung kombinasi unik dua 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: Cara menghitung kombinasi unik dua kolom \u2013 Statologi","description":"Tutorial ini menjelaskan cara menghitung jumlah kombinasi unik di dua kolom di pandas DataFrame, 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\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menghitung kombinasi unik dua kolom \u2013 Statologi","og_description":"Tutorial ini menjelaskan cara menghitung jumlah kombinasi unik di dua kolom di pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/","og_site_name":"Statorials","article_published_time":"2023-07-18T16:36:45+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-menghitung-kombinasi-unik-dari-dua-kolom\/","url":"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/","name":"Pandas: Cara menghitung kombinasi unik dua kolom \u2013 Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-18T16:36:45+00:00","dateModified":"2023-07-18T16:36:45+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghitung jumlah kombinasi unik di dua kolom di pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-menghitung-kombinasi-unik-dari-dua-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menghitung kombinasi unik dua 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\/3208"}],"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=3208"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/3208\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=3208"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=3208"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=3208"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}