df = pd. read_csv<\/span> (' basketball_data.csv<\/span> ', usecols= lambda<\/span> x:x !=<\/span> ' rebounds<\/span> ')<\/strong>\n<\/pre>\n Contoh khusus ini akan membaca setiap kolom dari file CSV bernama basket_data.csv<\/strong> ke dalam DataFrame pandas, kecuali untuk kolom bernama rebounds<\/strong> .<\/span><\/p>\n Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n Contoh: Hapus kolom tertentu saat mengimpor file CSV ke Pandas<\/strong><\/span><\/h2>\n Katakanlah kita memiliki file CSV berikut bernama basket_data.csv<\/strong> :<\/span> <\/p>\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter1-1.jpg\")
<\/p>\n
Kita dapat menggunakan sintaks berikut untuk mengimpor file CSV ke pandas dan menghapus kolom yang disebut bouncing<\/strong> selama impor:<\/span><\/p>\n import<\/span> pandas as<\/span> pd\n\n#import all columns except 'rebounds' into DataFrame\n<\/span>df = pd. read_csv<\/span> (' basketball_data.csv<\/span> ', usecols= lambda<\/span> x:x !=<\/span> ' rebounds<\/span> ')\n\n#view resulting DataFrame\n<\/span>print<\/span> (df)\n\n team points\n0 to 22\n1 B 14\n2 C 29\n3 D 30<\/strong><\/b><\/pre>\n Perhatikan bahwa kolom pentalan<\/strong> telah dihapus saat kami mengimpor file CSV ke pandas.<\/span><\/p>\n Jika Anda ingin menghapus beberapa kolom saat mengimpor, Anda dapat menggunakan operator not in<\/strong> sebagai berikut:<\/span><\/p>\n import<\/span> pandas as<\/span> pd\n\n#import all columns except 'team' and 'rebounds' into DataFrame\n<\/span>df=pd. read_csv<\/span> (' basketball_data.csv<\/span> ', usecols= lambda<\/span> x:x not in<\/span> [' team<\/span> ', ' rebounds<\/span> '])\n\n#view resulting DataFrame\n<\/span>print<\/span> (df)\n\n points\n0 22\n1 14\n2 29\n3 30<\/strong><\/b><\/pre>\n Perhatikan bahwa kolom tim<\/strong> dan rebound<\/strong> keduanya dihapus saat kami mengimpor file CSV ke pandas.<\/span><\/p>\n Perhatikan bahwa Anda dapat memasukkan nama kolom sebanyak yang Anda inginkan dalam daftar mengikuti operator not in<\/strong> untuk menghapus kolom sebanyak yang Anda inginkan saat mengimpor file CSV.<\/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 menghapus kolom tertentu saat mengimpor file CSV ke pandas DataFrame: df = pd. read_csv (‘ basketball_data.csv ‘, usecols= lambda x:x != ‘ rebounds ‘) Contoh khusus ini akan membaca setiap kolom dari file CSV bernama basket_data.csv ke dalam DataFrame pandas, kecuali untuk kolom bernama rebounds . Contoh berikut […]<\/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":"\n
Pandas: hapus kolom tertentu saat mengimpor file CSV - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menghapus kolom tertentu saat mengimpor file CSV ke pandas, 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\/panda-membaca-kolom-drop-csv\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: hapus kolom tertentu saat mengimpor file CSV - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menghapus kolom tertentu saat mengimpor file CSV ke pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T18:20:22+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-membaca-kolom-drop-csv\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/\",\"name\":\"Pandas: hapus kolom tertentu saat mengimpor file CSV - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T18:20:22+00:00\",\"dateModified\":\"2023-07-13T18:20:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menghapus kolom tertentu saat mengimpor file CSV ke pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: hapus kolom tertentu 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: hapus kolom tertentu saat mengimpor file CSV - Statologi","description":"Tutorial ini menjelaskan cara menghapus kolom tertentu saat mengimpor file CSV ke pandas, 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\/panda-membaca-kolom-drop-csv\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: hapus kolom tertentu saat mengimpor file CSV - Statologi","og_description":"Tutorial ini menjelaskan cara menghapus kolom tertentu saat mengimpor file CSV ke pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/","og_site_name":"Statorials","article_published_time":"2023-07-13T18:20:22+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-membaca-kolom-drop-csv\/","url":"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/","name":"Pandas: hapus kolom tertentu saat mengimpor file CSV - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T18:20:22+00:00","dateModified":"2023-07-13T18:20:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menghapus kolom tertentu saat mengimpor file CSV ke pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-kolom-drop-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: hapus kolom tertentu 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\/4077"}],"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=4077"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4077\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}