{"id":2407,"date":"2023-07-22T10:10:15","date_gmt":"2023-07-22T10:10:15","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/"},"modified":"2023-07-22T10:10:15","modified_gmt":"2023-07-22T10:10:15","slug":"panda-pilih-kolom-berdasarkan-indeks","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/","title":{"rendered":"Cara memilih kolom berdasarkan indeks di pandas dataframe"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin memilih kolom di pandas DataFrame berdasarkan nilai indeksnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin memilih kolom berdasarkan pengindeksan bilangan bulat, Anda dapat menggunakan fungsi <strong>.iloc<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika Anda ingin memilih kolom berdasarkan pengindeksan label, Anda dapat menggunakan fungsi <strong>.loc<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh cara menggunakan masing-masing fungsi ini dalam praktik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Pilih Kolom Berdasarkan Pengindeksan Integer<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat pandas DataFrame dan menggunakan <strong>.iloc<\/strong> untuk memilih kolom dengan nilai indeks integer <strong>3<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd<span style=\"color: #008080;\">\n\n#createDataFrame\n<span style=\"color: #000000;\">df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [11, 7, 8, 10, 13, 13],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5]})\n<span style=\"color: #000000;\"><span style=\"color: #008080;\">\n#view DataFrame\n<\/span>df\n\n\tteam points assists rebounds\n0 A 11 5 11\n1 To 7 7 8\n2 to 8 7 10\n3 B 10 9 6\n4 B 13 12 6\n5 B 13 9 5\n\n<\/span><span style=\"color: #008080;\">#select column with index position 3\n<\/span><span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">iloc<\/span> [:, 3]\n\n0 11\n1 8\n2 10\n3 6\n4 6\n5 5\nName: rebounds, dtype: int64<\/span><\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks serupa untuk memilih beberapa kolom:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select columns with index positions 1 and 3\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">iloc<\/span> [:, [1, 3]]\n\n\n        rebound points\n0 11 11\n1 7 8\n2 8 10\n3 10 6\n4 13 6\n5 13 5\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Atau kita dapat memilih semua kolom dalam suatu rentang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select columns with index positions in range 0 through 3\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">iloc<\/span> [:, 0:3]\n\n        team points assists\n0 to 11 5\n1 To 7 7\n2 to 8 7\n3 B 10 9\n4 B 13 12\n5 B 13 9<\/span><\/span><\/strong><\/pre>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Pilih Kolom Berdasarkan Pengindeksan Label<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara membuat pandas DataFrame dan menggunakan <strong>.loc<\/strong> untuk memilih kolom dengan label indeks <strong>&#8220;bouncing&#8221;<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #107d3f;\">import<\/span> pandas <span style=\"color: #107d3f;\">as<\/span> pd<span style=\"color: #008080;\">\n\n#createDataFrame\n<span style=\"color: #000000;\">df = pd. <span style=\"color: #3366ff;\">DataFrame<\/span> ({' <span style=\"color: #ff0000;\">team<\/span> ': ['A', 'A', 'A', 'B', 'B', 'B'],\n                   ' <span style=\"color: #ff0000;\">points<\/span> ': [11, 7, 8, 10, 13, 13],\n                   ' <span style=\"color: #ff0000;\">assists<\/span> ': [5, 7, 7, 9, 12, 9],\n                   ' <span style=\"color: #ff0000;\">rebounds<\/span> ': [11, 8, 10, 6, 6, 5]})\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span>df\n\n\tteam points assists rebounds\n0 A 11 5 11\n1 To 7 7 8\n2 to 8 7 10\n3 B 10 9 6\n4 B 13 12 6\n5 B 13 9 5\n\n<span style=\"color: #008080;\">#select column with index label 'rebounds'\n<\/span>df. <span style=\"color: #3366ff;\">loc<\/span> [:, ' <span style=\"color: #ff0000;\">rebounds<\/span> ']\n\n0 11\n1 8\n2 10\n3 6\n4 6\n5 5\nName: rebounds, dtype: int64<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan sintaks serupa untuk memilih beberapa kolom dengan label indeks berbeda:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select the columns with index labels 'points' and 'rebounds'\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [:,[' <span style=\"color: #ff0000;\">points<\/span> ',' <span style=\"color: #ff0000;\">rebounds<\/span> ']]\n\n\trebound points\n0 11 11\n1 7 8\n2 8 10\n3 10 6\n4 13 6\n5 13 5<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Atau kita dapat memilih semua kolom dalam suatu rentang:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#select columns with index labels between 'team' and 'assists'\n<span style=\"color: #000000;\">df. <span style=\"color: #3366ff;\">loc<\/span> [:, ' <span style=\"color: #ff0000;\">team<\/span> ':' <span style=\"color: #ff0000;\">assists<\/span> ']\n\n\tteam points assists\n0 to 11 5\n1 To 7 7\n2 to 8 7\n3 B 10 9\n4 B 13 12\n5 B 13 9<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Terkait:<\/strong><\/span> <a href=\"https:\/\/statorials.org\/id\/panda-loc-vs-iloc\/\" target=\"_blank\" rel=\"noopener\">Pandas loc vs iloc: apa bedanya?<\/a><\/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 operasi umum lainnya di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/indeks-grup-panda-berdasarkan\/\" target=\"_blank\" rel=\"noopener\">Cara mengelompokkan berdasarkan indeks dalam Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-memilih-baris-berdasarkan-indeks\/\" target=\"_blank\" rel=\"noopener\">Cara memilih baris berdasarkan indeks di Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-mendapatkan-nomor-baris\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara mendapatkan nomor baris di Pandas DataFrame<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jatuhkan-indeks-panda\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghapus kolom indeks di Pandas DataFrame<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin memilih kolom di pandas DataFrame berdasarkan nilai indeksnya. Jika Anda ingin memilih kolom berdasarkan pengindeksan bilangan bulat, Anda dapat menggunakan fungsi .iloc . Jika Anda ingin memilih kolom berdasarkan pengindeksan label, Anda dapat menggunakan fungsi .loc . Tutorial ini memberikan contoh cara menggunakan masing-masing fungsi ini dalam praktik. Contoh 1: Pilih [&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>Cara memilih kolom berdasarkan indeks di Pandas DataFrame - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara memilih kolom berdasarkan indeks di pandas DataFrame, dengan beberapa 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-pilih-kolom-berdasarkan-indeks\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara memilih kolom berdasarkan indeks di Pandas DataFrame - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara memilih kolom berdasarkan indeks di pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T10:10: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\/panda-pilih-kolom-berdasarkan-indeks\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/\",\"name\":\"Cara memilih kolom berdasarkan indeks di Pandas DataFrame - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T10:10:15+00:00\",\"dateModified\":\"2023-07-22T10:10:15+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara memilih kolom berdasarkan indeks di pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara memilih kolom berdasarkan indeks di pandas dataframe\"}]},{\"@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 memilih kolom berdasarkan indeks di Pandas DataFrame - Statorials","description":"Tutorial ini menjelaskan cara memilih kolom berdasarkan indeks di pandas DataFrame, dengan beberapa 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-pilih-kolom-berdasarkan-indeks\/","og_locale":"id_ID","og_type":"article","og_title":"Cara memilih kolom berdasarkan indeks di Pandas DataFrame - Statorials","og_description":"Tutorial ini menjelaskan cara memilih kolom berdasarkan indeks di pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/","og_site_name":"Statorials","article_published_time":"2023-07-22T10:10: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\/panda-pilih-kolom-berdasarkan-indeks\/","url":"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/","name":"Cara memilih kolom berdasarkan indeks di Pandas DataFrame - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T10:10:15+00:00","dateModified":"2023-07-22T10:10:15+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara memilih kolom berdasarkan indeks di pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-pilih-kolom-berdasarkan-indeks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara memilih kolom berdasarkan indeks di pandas dataframe"}]},{"@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\/2407"}],"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=2407"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2407\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}