{"id":4305,"date":"2023-07-12T03:26:27","date_gmt":"2023-07-12T03:26:27","guid":{"rendered":"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/"},"modified":"2023-07-12T03:26:27","modified_gmt":"2023-07-12T03:26:27","slug":"persentase-tabel-silang-panda","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/","title":{"rendered":"Pandas: cara membuat tab silang dengan persentase"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan argumen <strong>normalisasi<\/strong> dalam fungsi pandas <strong>crosstab()<\/strong> untuk membuat tab silang yang menampilkan nilai persentase, bukan angka:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">col1<\/span> , df. <span style=\"color: #3366ff;\">col2<\/span> , normalize=' <span style=\"color: #ff0000;\">index<\/span> ')\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Argumen normalisasi menerima tiga argumen berbeda:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>all<\/strong> : Menampilkan persentase relatif terhadap semua nilai.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>indeks<\/strong> : Menampilkan persentase sebagai total nilai baris.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>Kolom<\/strong> : Menampilkan persentase sebagai total nilai kolom.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik dengan pandas DataFrame berikut:<\/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', 'B', 'B', 'B', 'B', 'C', 'C', 'C', 'C '],\n                   ' <span style=\"color: #ff0000;\">position<\/span> ':['G', 'G', 'F', 'G', 'F', 'F', 'F', 'G', 'G', 'F', 'F'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [22, 25, 24, 39, 34, 20, 18, 17, 20, 19, 22]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   team position points\n0 AG 22\n1 AG 25\n2 AF 24\n3 BG 39\n4 BF 34\n5 BF 20\n6 BF 18\n7 GC 17\n8 GC 20\n9 CF 19\n10 CF 22\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut tampilan tab silang default untuk jumlah pemain per tim dan posisi:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\"><span style=\"color: #008080;\">#create crosstab that displays count by team and position<\/span>\n<span style=\"color: #000000;\">p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> )\n\nposition F G\nteam\t\t\nAT 12\nB 3 1\nC 2 2<\/span>\n<\/span><\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Buat tab silang dengan persentase relatif terhadap semua nilai<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>crosstab()<\/strong> dengan argumen <strong>normalize=all<\/strong> untuk membuat tab silang yang menampilkan persentase setiap nilai relatif terhadap jumlah total semua nilai:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\"><span style=\"color: #008080;\">#create crosstab that displays counts as percentage relative to total count\n<\/span><\/span>p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> , normalize=' <span style=\"color: #ff0000;\">all<\/span> ')\n\nposition F G\nteam\t\t\nA 0.090909 0.181818\nB 0.272727 0.090909\nC 0.181818 0.181818\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain tim A di posisi F mewakili <strong>9,09%<\/strong> dari total pemain.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain Tim A di posisi G mewakili <strong>18,18%<\/strong> dari total pemain.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Buat tab silang dengan persentase terhadap total baris<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>crosstab()<\/strong> dengan argumen <strong>normalize=index<\/strong> untuk membuat tab silang yang menampilkan persentase setiap nilai relatif terhadap total baris:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\"><span style=\"color: #008080;\">#create crosstab that displays counts as percentage relative to row totals\n<\/span><\/span>p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> , normalize=' <span style=\"color: #ff0000;\">index<\/span> ')\n\nposition F G\nteam\t\t\nA 0.333333 0.666667\nB 0.750000 0.250000\nC 0.500000 0.500000\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain di posisi F mewakili <strong>33,33%<\/strong> dari total pemain tim A.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain di posisi F mewakili <strong>75%<\/strong> dari total pemain di tim B.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain di posisi F mewakili <strong>50%<\/strong> dari total pemain di tim C.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: Buat tab silang dengan persentase terhadap total kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan fungsi <strong>crosstab()<\/strong> dengan argumen <strong>normalize=columns<\/strong> untuk membuat tab silang yang menampilkan persentase setiap nilai relatif terhadap total kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008000;\"><span style=\"color: #008080;\">#create crosstab that displays counts as percentage relative to column totals\n<\/span><\/span>p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> , normalize=' <span style=\"color: #ff0000;\">columns<\/span> ')\n\nposition F G\nteam\t\t\nA 0.166667 0.4\nB 0.500000 0.2\nC 0.333333 0.4\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Berikut cara menafsirkan hasilnya:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\">Pemain tim A mewakili <strong>16,67%<\/strong> dari total pemain dengan posisi F.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain tim B mewakili <strong>50%<\/strong> dari total pemain dengan posisi F.<\/span><\/li>\n<li> <span style=\"color: #000000;\">Pemain tim C mewakili <strong>33,33%<\/strong> dari total pemain dengan posisi F.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>crosstab()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/pandas-docs\/stable\/reference\/api\/pandas.crosstab.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 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 argumen normalisasi dalam fungsi pandas crosstab() untuk membuat tab silang yang menampilkan nilai persentase, bukan angka: p.d. crosstab (df. col1 , df. col2 , normalize=&#8217; index &#8216;) Argumen normalisasi menerima tiga argumen berbeda: all : Menampilkan persentase relatif terhadap semua nilai. indeks : Menampilkan persentase sebagai total nilai baris. Kolom : Menampilkan [&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 membuat tab silang dengan persentase - Statorial<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara membuat tab silang di panda dan menampilkan persentase dalam sel, beserta 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\/persentase-tabel-silang-panda\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara membuat tab silang dengan persentase - Statorial\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara membuat tab silang di panda dan menampilkan persentase dalam sel, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T03:26:27+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\/persentase-tabel-silang-panda\/\",\"url\":\"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/\",\"name\":\"Pandas: Cara membuat tab silang dengan persentase - Statorial\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T03:26:27+00:00\",\"dateModified\":\"2023-07-12T03:26:27+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara membuat tab silang di panda dan menampilkan persentase dalam sel, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara membuat tab silang dengan persentase\"}]},{\"@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 membuat tab silang dengan persentase - Statorial","description":"Tutorial ini menjelaskan cara membuat tab silang di panda dan menampilkan persentase dalam sel, beserta 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\/persentase-tabel-silang-panda\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara membuat tab silang dengan persentase - Statorial","og_description":"Tutorial ini menjelaskan cara membuat tab silang di panda dan menampilkan persentase dalam sel, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/","og_site_name":"Statorials","article_published_time":"2023-07-12T03:26:27+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\/persentase-tabel-silang-panda\/","url":"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/","name":"Pandas: Cara membuat tab silang dengan persentase - Statorial","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T03:26:27+00:00","dateModified":"2023-07-12T03:26:27+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara membuat tab silang di panda dan menampilkan persentase dalam sel, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persentase-tabel-silang-panda\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara membuat tab silang dengan persentase"}]},{"@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\/4305"}],"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=4305"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4305\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}