{"id":4076,"date":"2023-07-13T18:24:32","date_gmt":"2023-07-13T18:24:32","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/"},"modified":"2023-07-13T18:24:32","modified_gmt":"2023-07-13T18:24:32","slug":"panda-read_csv-usecols","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/","title":{"rendered":"Pandas: cara menggunakan read_csv dengan argumen usecols"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan argumen <strong>usecols<\/strong> dalam fungsi <strong>read_csv()<\/strong> untuk membaca kolom tertentu dari file CSV ke dalam pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Ada dua cara umum untuk menggunakan argumen ini:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Gunakan usecols dengan nama kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #ff0000;\">my_data.csv<\/span> ', usecols=[' <span style=\"color: #ff0000;\">this_column<\/span> ', ' <span style=\"color: #ff0000;\">that_column<\/span> '])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Gunakan usecols dengan posisi kolom<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df = pd. <span style=\"color: #3366ff;\">read_csv<\/span> ( <span style=\"color: #008000;\">'<\/span> <span style=\"color: #ff0000;\">my_data.csv<\/span> ', usecols=[ <span style=\"color: #008000;\">0,2<\/span> ])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan setiap metode dalam praktik dengan file CSV berikut yang disebut <strong>basket_data.csv<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-28596 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter1-1.jpg\" alt=\"\" width=\"435\" height=\"318\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Menggunakan usecols dengan nama kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengimpor file CSV dan hanya menggunakan kolom yang disebut &#8220;team&#8221; dan &#8220;rebounds&#8221;:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <b><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#import DataFrame and only use 'team' and 'rebounds' columns\n<\/span><strong>df = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #ff0000;\">basketball_data.csv<\/span> ', usecols=[' <span style=\"color: #ff0000;\">team<\/span> ',' <span style=\"color: #ff0000;\">rebounds<\/span> '])\n<\/strong>\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   team rebounds\n0 to 10\n1 B 9\n2 C 6\n3 D 2\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya kolom tim dan rebound yang diimpor karena ini adalah nama kolom yang kami tentukan dalam argumen <strong>usecols<\/strong> .<\/span><b> <\/b><\/p>\n<h2><span style=\"color: #000000;\"><strong>Contoh 2: Menggunakan usecols dengan posisi kolom<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengimpor file CSV dan hanya menggunakan kolom pada posisi indeks 0 dan 2:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <b><span style=\"color: #008000;\">import<\/span> pandas <span style=\"color: #008000;\">as<\/span> pd\n\n<span style=\"color: #008080;\">#import DataFrame and only use columns in index positions 0 and 2\n<\/span><strong>df = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #ff0000;\">basketball_data.csv<\/span> ' <span style=\"color: #008000;\">,<\/span> usecols=[ <span style=\"color: #008000;\">0,2<\/span> ])\n<\/strong>\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   team rebounds\n0 to 10\n1 B 9\n2 C 6\n3 D 2\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa hanya kolom tim dan rebound yang diimpor karena ini adalah kolom pada posisi indeks 0 dan 2, yang merupakan nilai yang kami tentukan dalam argumen <strong>usecols<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Kolom pertama file CSV memiliki posisi indeks 0.<\/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 dengan Python:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-melompati-barisan\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara melewati baris saat membaca file CSV<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-excel\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara membaca file Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara mengekspor DataFrame ke Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan argumen usecols dalam fungsi read_csv() untuk membaca kolom tertentu dari file CSV ke dalam pandas DataFrame. Ada dua cara umum untuk menggunakan argumen ini: Metode 1: Gunakan usecols dengan nama kolom df = pd. read_csv (&#8216; my_data.csv &#8216;, usecols=[&#8216; this_column &#8216;, &#8216; that_column &#8216;]) Metode 2: Gunakan usecols dengan posisi kolom df [&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 menggunakan read_csv dengan argumen usecols - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggunakan argumen usecols dengan fungsi read_csv di pandas untuk membaca kolom tertentu dari file CSV.\" \/>\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-read_csv-usecols\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menggunakan read_csv dengan argumen usecols - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggunakan argumen usecols dengan fungsi read_csv di pandas untuk membaca kolom tertentu dari file CSV.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T18:24:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter1-1.jpg\" \/>\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-read_csv-usecols\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/\",\"name\":\"Pandas: Cara menggunakan read_csv dengan argumen usecols - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T18:24:32+00:00\",\"dateModified\":\"2023-07-13T18:24:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggunakan argumen usecols dengan fungsi read_csv di pandas untuk membaca kolom tertentu dari file CSV.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menggunakan read_csv dengan argumen usecols\"}]},{\"@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 menggunakan read_csv dengan argumen usecols - Statorials","description":"Tutorial ini menjelaskan cara menggunakan argumen usecols dengan fungsi read_csv di pandas untuk membaca kolom tertentu dari file CSV.","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-read_csv-usecols\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menggunakan read_csv dengan argumen usecols - Statorials","og_description":"Tutorial ini menjelaskan cara menggunakan argumen usecols dengan fungsi read_csv di pandas untuk membaca kolom tertentu dari file CSV.","og_url":"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/","og_site_name":"Statorials","article_published_time":"2023-07-13T18:24:32+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter1-1.jpg"}],"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-read_csv-usecols\/","url":"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/","name":"Pandas: Cara menggunakan read_csv dengan argumen usecols - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T18:24:32+00:00","dateModified":"2023-07-13T18:24:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggunakan argumen usecols dengan fungsi read_csv di pandas untuk membaca kolom tertentu dari file CSV.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-read_csv-usecols\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menggunakan read_csv dengan argumen usecols"}]},{"@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\/4076"}],"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=4076"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4076\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4076"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4076"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4076"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}