{"id":4078,"date":"2023-07-13T18:11:11","date_gmt":"2023-07-13T18:11:11","guid":{"rendered":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/"},"modified":"2023-07-13T18:11:11","modified_gmt":"2023-07-13T18:11:11","slug":"pandas-baca-csv-abaikan-kolom-pertama","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/","title":{"rendered":"Pandas: abaikan kolom pertama saat mengimpor file csv"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk mengabaikan kolom pertama saat mengimpor file CSV ke pandas DataFrame:<\/span><\/p>\n

 with<\/span> open<\/span> (' basketball_data.csv<\/span> ') as<\/span> x:\n    ncols = len<\/span> ( x.readline<\/span> (). split<\/span> (' ,<\/span> '))\n\ndf = pd. read_csv<\/span> (' basketball_data.csv<\/span> ', usecols= range<\/span> (1,ncols))\n<\/strong><\/pre>\n
 Contoh khusus ini akan membaca setiap kolom file CSV bernama basket_data.csv<\/strong> menjadi DataFrame pandas, kecuali kolom pertama.<\/span><\/p>\n
 Dengan menggunakan kode ini, pertama-tama kita mencari jumlah kolom dalam file CSV dan menetapkannya ke variabel bernama ncols<\/strong> .<\/span><\/p>\n
 Selanjutnya, kita menggunakan argumen usecols<\/strong> untuk menentukan bahwa kita hanya ingin mengimpor kolom antara 1 (yaitu kolom kedua) dan kolom terakhir file CSV.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Abaikan kolom pertama saat mengimpor file CSV ke Pandas<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki file CSV berikut bernama basket_data.csv<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Kita dapat menggunakan sintaks berikut untuk mengimpor file CSV ke pandas DataFrame dan mengabaikan kolom pertama:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#calculate number of columns in CSV file\n<\/span>with open<\/span> (' basketball_data.csv<\/span> ') as<\/span> x:\n    ncols = len<\/span> ( x.readline<\/span> (). split<\/span> (' ,<\/span> '))\n\n#import all columns except first column into DataFrame\n<\/span>df = pd. read_csv<\/span> (' basketball_data.csv<\/span> ', usecols= range<\/span> (1,ncols))\n\n#view resulting DataFrame\n<\/span>print<\/span> (df)\n\n   rebound points\n0 22 10\n1 14 9\n2 29 6\n3 30 2\n<\/strong><\/span><\/b><\/pre>\n
 Perhatikan bahwa kolom pertama bernama team<\/strong> telah dihapus saat kami mengimpor file CSV ke pandas.<\/span><\/p>\n
 Perhatikan bahwa jika Anda sudah mengetahui jumlah total kolom dalam file CSV sebelumnya, Anda bisa langsung memasukkan nilai ini ke argumen usecols<\/strong> .<\/span><\/p>\n
 Misalnya kita sudah mengetahui bahwa ada tiga kolom di file CVS.<\/span><\/p>\n
 Kita bisa menggunakan sintaks berikut untuk mengimpor file CSV ke pandas DataFrame dan mengabaikan kolom pertama:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#import all columns except first column into DataFrame\n<\/span>df = pd. read_csv<\/span> (' basketball_data.csv<\/span> ', usecols= range<\/span> (1,3))\n\n#view resulting DataFrame\n<\/span>print<\/span> (df)\n\n   rebound points\n0 22 10\n1 14 9\n2 29 6\n3 30 2<\/strong><\/span><\/b><\/pre>\n
 Perhatikan bahwa kolom pertama bernama team<\/strong> telah dihapus saat kami mengimpor file CSV ke pandas.<\/span><\/p>\n
 Karena kita sudah mengetahui ada tiga kolom dalam file CSV, kita cukup menggunakan range(1,3)<\/strong> dalam argumen usecols<\/strong> .<\/span><\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas read_csv()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya dengan Python:<\/span><\/p>\n
 Pandas: Cara melewati baris saat membaca file CSV<\/a>
 Pandas: Cara menambahkan data ke file CSV yang sudah ada<\/a>
 Pandas: cara menggunakan read_csv dengan argumen usecols<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk mengabaikan kolom pertama saat mengimpor file CSV ke pandas DataFrame: with open (‘ basketball_data.csv ‘) as x: ncols = len ( x.readline (). split (‘ , ‘)) df = pd. read_csv (‘ basketball_data.csv ‘, usecols= range (1,ncols)) Contoh khusus ini akan membaca setiap kolom file CSV bernama basket_data.csv […]<\/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":"\nPandas: abaikan kolom pertama saat mengimpor file CSV - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengabaikan kolom pertama saat mengimpor file CSV ke 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\/pandas-baca-csv-abaikan-kolom-pertama\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: abaikan kolom pertama saat mengimpor file CSV - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengabaikan kolom pertama saat mengimpor file CSV ke pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T18:11:11+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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/\",\"url\":\"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/\",\"name\":\"Pandas: abaikan kolom pertama saat mengimpor file CSV - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T18:11:11+00:00\",\"dateModified\":\"2023-07-13T18:11:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengabaikan kolom pertama saat mengimpor file CSV ke pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: abaikan kolom pertama saat mengimpor file csv\"}]},{\"@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: abaikan kolom pertama saat mengimpor file CSV - Statorials","description":"Tutorial ini menjelaskan cara mengabaikan kolom pertama saat mengimpor file CSV ke 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\/pandas-baca-csv-abaikan-kolom-pertama\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: abaikan kolom pertama saat mengimpor file CSV - Statorials","og_description":"Tutorial ini menjelaskan cara mengabaikan kolom pertama saat mengimpor file CSV ke pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/","og_site_name":"Statorials","article_published_time":"2023-07-13T18:11:11+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":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/","url":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/","name":"Pandas: abaikan kolom pertama saat mengimpor file CSV - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T18:11:11+00:00","dateModified":"2023-07-13T18:11:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengabaikan kolom pertama saat mengimpor file CSV ke pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/pandas-baca-csv-abaikan-kolom-pertama\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: abaikan kolom pertama saat mengimpor file csv"}]},{"@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\/4078"}],"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=4078"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4078\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4078"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4078"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4078"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}