{"id":4308,"date":"2023-07-12T03:04:28","date_gmt":"2023-07-12T03:04:28","guid":{"rendered":"https:\/\/statorials.org\/id\/persilangan-panda-tri\/"},"modified":"2023-07-12T03:04:28","modified_gmt":"2023-07-12T03:04:28","slug":"persilangan-panda-tri","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/persilangan-panda-tri\/","title":{"rendered":"Pandas: cara mengurutkan nilai di tab silang"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk mengurutkan baris atau kolom di tab silang Pandas:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Urutkan tab silang berdasarkan nilai baris<\/strong><\/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> ). <span style=\"color: #3366ff;\">sort_index<\/span> (axis= <span style=\"color: #008000;\">0<\/span> , ascending= <span style=\"color: #008000;\">False<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Urutkan tab silang berdasarkan nilai kolom<\/strong><\/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> ). <span style=\"color: #3366ff;\">sort_index<\/span> (axis= <span style=\"color: #008000;\">1<\/span> , ascending= <span style=\"color: #008000;\">False<\/span> )\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode ini dalam praktik dengan tab silang pandas 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<span style=\"color: #000000;\"><span style=\"color: #008080;\">\n#create crosstab to display count of players by team and position\n<\/span>my_crosstab = pd. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> )\n\n<span style=\"color: #008080;\">#view crosstab\n<\/span><span style=\"color: #008000;\">print<\/span> (my_crosstab)\n\n<\/span>FG position\nteam          \nAT 12\nB 3 1\nC 2 2\n<\/strong><\/pre>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Urutkan tab silang berdasarkan nilai baris<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengurutkan baris tab silang berdasarkan nilai kolom <strong>tim<\/strong> dalam urutan menurun (Z ke A):<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create crosstab with rows sorted from Z to A\n<\/span>p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> ). <span style=\"color: #3366ff;\">sort_index<\/span> (axis= <span style=\"color: #008000;\">0<\/span> , ascending= <span style=\"color: #008000;\">False<\/span> )\n\nposition F G\nteam\t\t\nC 2 2\nB 3 1\nAT 12\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris tab silang sekarang diurutkan berdasarkan nilai <strong>tim<\/strong> dalam urutan abjad terbalik.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>crosstab()<\/strong> menampilkan nilai baris crosstab dalam urutan abjad (A sampai Z) secara default.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Urutkan tab silang berdasarkan nilai kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks berikut untuk mengurutkan kolom tab silang berdasarkan nilai kolom <strong>tim<\/strong> dalam urutan menurun (Z hingga A):<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create crosstab with columns sorted from Z to A\n<\/span>p.d. <span style=\"color: #3366ff;\">crosstab<\/span> (df. <span style=\"color: #3366ff;\">team<\/span> , df. <span style=\"color: #3366ff;\">position<\/span> ). <span style=\"color: #3366ff;\">sort_index<\/span> (axis= <span style=\"color: #008000;\">1<\/span> , ascending= <span style=\"color: #008000;\">False<\/span> )\n\nG F position\nteam\t\t\nAt 2 1\nB 1 3\nC 2 2\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kolom tab silang sekarang diurutkan berdasarkan nilai <b>posisi<\/b> dalam urutan abjad terbalik.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Fungsi <strong>crosstab()<\/strong> menampilkan nilai kolom crosstab dalam urutan abjad (A sampai Z) secara default.<\/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\/persentase-tabel-silang-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membuat tab silang dengan persentase<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/aggfunc-tabel-silang-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggunakan aggfunc di fungsi crosstab()<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/meja-silang-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara Membuat Plot Batang dari Tab Silang<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk mengurutkan baris atau kolom di tab silang Pandas: Metode 1: Urutkan tab silang berdasarkan nilai baris p.d. crosstab (df. col1 , df. col2 ). sort_index (axis= 0 , ascending= False ) Metode 2: Urutkan tab silang berdasarkan nilai kolom p.d. crosstab (df. col1 , df. col2 ). sort_index (axis= [&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 mengurutkan nilai di tab silang - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengurutkan tab silang Pandas berdasarkan nilai baris dan kolom, 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\/persilangan-panda-tri\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara mengurutkan nilai di tab silang - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengurutkan tab silang Pandas berdasarkan nilai baris dan kolom, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/persilangan-panda-tri\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-12T03:04:28+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\/persilangan-panda-tri\/\",\"url\":\"https:\/\/statorials.org\/id\/persilangan-panda-tri\/\",\"name\":\"Pandas: Cara mengurutkan nilai di tab silang - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-12T03:04:28+00:00\",\"dateModified\":\"2023-07-12T03:04:28+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengurutkan tab silang Pandas berdasarkan nilai baris dan kolom, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/persilangan-panda-tri\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/persilangan-panda-tri\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/persilangan-panda-tri\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara mengurutkan nilai di tab silang\"}]},{\"@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 mengurutkan nilai di tab silang - Statorials","description":"Tutorial ini menjelaskan cara mengurutkan tab silang Pandas berdasarkan nilai baris dan kolom, 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\/persilangan-panda-tri\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara mengurutkan nilai di tab silang - Statorials","og_description":"Tutorial ini menjelaskan cara mengurutkan tab silang Pandas berdasarkan nilai baris dan kolom, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/persilangan-panda-tri\/","og_site_name":"Statorials","article_published_time":"2023-07-12T03:04:28+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\/persilangan-panda-tri\/","url":"https:\/\/statorials.org\/id\/persilangan-panda-tri\/","name":"Pandas: Cara mengurutkan nilai di tab silang - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-12T03:04:28+00:00","dateModified":"2023-07-12T03:04:28+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengurutkan tab silang Pandas berdasarkan nilai baris dan kolom, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/persilangan-panda-tri\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/persilangan-panda-tri\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/persilangan-panda-tri\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara mengurutkan nilai di tab silang"}]},{"@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\/4308"}],"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=4308"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4308\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4308"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4308"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4308"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}