{"id":4080,"date":"2023-07-13T17:46:21","date_gmt":"2023-07-13T17:46:21","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/"},"modified":"2023-07-13T17:46:21","modified_gmt":"2023-07-13T17:46:21","slug":"panda-membaca-kolom-nama-csv","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/","title":{"rendered":"Pandas: menetapkan nama kolom saat mengimpor file csv"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menentukan nama kolom DataFrame saat mengimpor file CSV ke pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>colnames = [' <span style=\"color: #ff0000;\">col1<\/span> ', ' <span style=\"color: #ff0000;\">col2<\/span> ', ' <span style=\"color: #ff0000;\">col3<\/span> ']\n\ndf = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #ff0000;\">my_data.csv<\/span> ', names=colnames)\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Argumen <strong>nama<\/strong> mengambil daftar nama yang ingin Anda gunakan untuk kolom di DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Dengan menggunakan argumen ini Anda juga memberi tahu panda untuk menggunakan baris pertama file CSV sebagai baris pertama DataFrame alih-alih menggunakannya sebagai baris header.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh: Tetapkan nama kolom saat mengimpor file CSV ke Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file CSV berikut bernama <strong>Players_data.csv<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-32479\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/headernone1.png\" alt=\"\" width=\"433\" height=\"385\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Dari file tersebut kita dapat melihat bahwa baris pertama tidak berisi nama kolom apa pun.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mengimpor file CSV menggunakan fungsi <strong>read_csv()<\/strong> , panda akan mencoba menggunakan nilai di baris pertama sebagai nama kolom untuk DataFrame:<\/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: #000000;\"><strong><span style=\"color: #008080;\">#import CSV file\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #ff0000;\">players_data.csv<\/span> ')\n\n<span style=\"color: #008080;\">#view resulting DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   At 22 10\n0 B 14 9\n1 C 29 6\n2 D 30 2\n3 E 22 9\n4 F 31 10\n<\/strong><\/span><\/b><\/pre>\n<p> <span style=\"color: #000000;\">Namun, kita bisa menggunakan argumen <strong>nama<\/strong> untuk menentukan nama kolom kita sendiri saat mengimpor file CSV:<\/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;\">#specify column names<\/span>\ncolnames = [' <span style=\"color: #ff0000;\">team<\/span> ', ' <span style=\"color: #ff0000;\">points<\/span> ', ' <span style=\"color: #ff0000;\">rebounds<\/span> ']\n\n<span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#import CSV file and use specified column names\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_csv<\/span> (' <span style=\"color: #ff0000;\">players_data.csv<\/span> ', names <span style=\"color: #ff0000;\">=<\/span> colnames)\n\n<span style=\"color: #008080;\">#view resulting DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points rebounds\n0 to 22 10\n1 B 14 9\n2 C 29 6\n3 D 30 2\n4 E 22 9\n5 F 31 10\n<\/strong><\/span><\/b><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris pertama file CSV tidak lagi digunakan sebagai baris header.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Sebaliknya, nama kolom yang kita tentukan menggunakan argumen <strong>nama<\/strong> sekarang digunakan sebagai nama kolom.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>read_csv()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.read_csv.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 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\/pandas-memiliki-tambahan-csv\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menambahkan data ke file CSV yang sudah ada<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/panda-read_csv-usecols\/\" target=\"_blank\" rel=\"noopener\">Pandas: cara menggunakan read_csv dengan argumen usecols<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menentukan nama kolom DataFrame saat mengimpor file CSV ke pandas: colnames = [&#8216; col1 &#8216;, &#8216; col2 &#8216;, &#8216; col3 &#8216;] df = pd. read_csv (&#8216; my_data.csv &#8216;, names=colnames) Argumen nama mengambil daftar nama yang ingin Anda gunakan untuk kolom di DataFrame. Dengan menggunakan argumen ini Anda juga [&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: mengatur nama kolom saat mengimpor file CSV - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengatur nama kolom 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-nama-csv\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: mengatur nama kolom saat mengimpor file CSV - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file CSV ke pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T17:46:21+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/headernone1.png\" \/>\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-membaca-kolom-nama-csv\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/\",\"name\":\"Pandas: mengatur nama kolom saat mengimpor file CSV - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T17:46:21+00:00\",\"dateModified\":\"2023-07-13T17:46:21+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file CSV ke pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: menetapkan nama kolom 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: mengatur nama kolom saat mengimpor file CSV - Statorials","description":"Tutorial ini menjelaskan cara mengatur nama kolom 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-nama-csv\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: mengatur nama kolom saat mengimpor file CSV - Statorials","og_description":"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file CSV ke pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/","og_site_name":"Statorials","article_published_time":"2023-07-13T17:46:21+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/headernone1.png"}],"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-membaca-kolom-nama-csv\/","url":"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/","name":"Pandas: mengatur nama kolom saat mengimpor file CSV - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T17:46:21+00:00","dateModified":"2023-07-13T17:46:21+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file CSV ke pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-kolom-nama-csv\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: menetapkan nama kolom 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\/4080"}],"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=4080"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4080\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4080"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4080"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4080"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}