{"id":4131,"date":"2023-07-13T09:33:03","date_gmt":"2023-07-13T09:33:03","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/"},"modified":"2023-07-13T09:33:03","modified_gmt":"2023-07-13T09:33:03","slug":"panda-membaca-nama-kolom-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/","title":{"rendered":"Pandas: mengatur nama kolom saat mengimpor file excel"},"content":{"rendered":"

<\/p>\n

\n

Anda dapat menggunakan sintaks dasar berikut untuk menentukan nama kolom DataFrame saat mengimpor file Excel ke panda:<\/span><\/p>\n

 colnames = [' col1<\/span> ', ' col2<\/span> ', ' col3<\/span> ']\n\ndf = pd. read_excel<\/span> (' my_data.xlsx<\/span> ', names=colnames)\n<\/strong><\/pre>\n
 Argumen nama<\/strong> mengambil daftar nama yang ingin Anda gunakan untuk kolom di DataFrame.<\/span><\/p>\n
 Dengan menggunakan argumen ini Anda juga memberi tahu panda untuk menggunakan baris pertama file Excel sebagai baris pertama DataFrame alih-alih menggunakannya sebagai baris header.<\/span><\/p>\n
 Contoh berikut menunjukkan cara menggunakan sintaksis ini dalam praktiknya.<\/span><\/p>\n
 Contoh: Menetapkan nama kolom saat mengimpor file Excel ke Pandas<\/strong><\/span><\/h2>\n
 Katakanlah kita memiliki file Excel berikut bernama Players_data.xlsx<\/strong> :<\/span> <\/p>\n
\"\"<\/p>\n
 Dari file tersebut kita dapat melihat bahwa baris pertama tidak berisi nama kolom apa pun.<\/span><\/p>\n
 Jika kita mengimpor file Excel menggunakan fungsi read_excel()<\/strong> , panda akan mencoba menggunakan nilai di baris pertama sebagai nama kolom untuk DataFrame:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#import Excel file\n<\/span>df = pd. read_excel<\/span> (' players_data.xlsx<\/span> ')\n\n#view resulting DataFrame\n<\/span>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
 Namun, kita bisa menggunakan argumen nama<\/strong> untuk menentukan nama kolom kita sendiri saat mengimpor file Excel:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#specify column names<\/span>\ncolnames = [' team<\/span> ', ' points<\/span> ', ' rebounds<\/span> ']\n\n#import Excel file and use specified column names\n<\/span>df = pd. read_excel<\/span> (' players_data.xlsx<\/span> ', names =<\/span> colnames)\n\n#view resulting DataFrame\n<\/span>print<\/span> (df)\n\n  team points rebounds\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
 Perhatikan bahwa baris pertama file Excel tidak lagi digunakan sebagai baris header.<\/span><\/p>\n
 Sebaliknya, nama kolom yang kita tentukan menggunakan argumen nama<\/strong> sekarang digunakan sebagai nama kolom.<\/span><\/p>\n
 Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas read_excel()<\/strong> di sini<\/a> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h2>\n
 Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di panda:<\/span><\/p>\n
 Pandas: Cara membaca file Excel dengan sel yang digabungkan<\/a>
 Pandas: abaikan kolom tertentu saat mengimpor file Excel<\/a>
 Pandas: Cara menentukan tipe saat mengimpor file Excel<\/a>
 Pandas: Cara melewati baris saat membaca file Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
Anda dapat menggunakan sintaks dasar berikut untuk menentukan nama kolom DataFrame saat mengimpor file Excel ke panda: colnames = [‘ col1 ‘, ‘ col2 ‘, ‘ col3 ‘] df = pd. read_excel (‘ my_data.xlsx ‘, names=colnames) Argumen nama mengambil daftar nama yang ingin Anda gunakan untuk kolom di DataFrame. Dengan menggunakan argumen ini Anda juga […]<\/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: mengatur nama kolom saat mengimpor file Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file Excel 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-nama-kolom-excel\/\" \/>\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 Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file Excel ke pandas, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T09:33:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne1.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-nama-kolom-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/\",\"name\":\"Pandas: mengatur nama kolom saat mengimpor file Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T09:33:03+00:00\",\"dateModified\":\"2023-07-13T09:33:03+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file Excel ke pandas, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: mengatur nama kolom saat mengimpor file excel\"}]},{\"@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 Excel - Statorials","description":"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file Excel 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-nama-kolom-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: mengatur nama kolom saat mengimpor file Excel - Statorials","og_description":"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file Excel ke pandas, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T09:33:03+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/ne1.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-nama-kolom-excel\/","url":"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/","name":"Pandas: mengatur nama kolom saat mengimpor file Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T09:33:03+00:00","dateModified":"2023-07-13T09:33:03+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengatur nama kolom saat mengimpor file Excel ke pandas, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-nama-kolom-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: mengatur nama kolom saat mengimpor file excel"}]},{"@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\/4131"}],"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=4131"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4131\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}