{"id":972,"date":"2023-07-28T03:40:23","date_gmt":"2023-07-28T03:40:23","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-excel\/"},"modified":"2023-07-28T03:40:23","modified_gmt":"2023-07-28T03:40:23","slug":"panda-membaca-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-excel\/","title":{"rendered":"Panduan utama: cara membaca file excel dengan pandas"},"content":{"rendered":"

<\/p>\n

\n

File Excel adalah salah satu cara paling umum untuk menyimpan data. Untungnya, fungsi pandas read_excel()<\/a> memudahkan membaca file Excel.<\/span><\/p>\n

Tutorial ini menjelaskan beberapa cara membaca file Excel dengan Python menggunakan pandas.<\/span><\/p>\n

Contoh 1: Membaca file Excel ke dalam pandas DataFrame<\/strong><\/span><\/h3>\n

Misalkan kita memiliki file Excel berikut:<\/span> <\/p>\n

\"\"<\/p>\n

Kode berikut menunjukkan cara menggunakan fungsi read_excel()<\/strong> untuk mengimpor file Excel ini ke dalam pandas DataFrame:<\/span><\/p>\n

 import<\/span> pandas as<\/span> pd\n\n#import Excel file<\/span>\ndf = pd. read_excel<\/span> ('data.xlsx')\n\n#view DataFrame<\/span>\ndf\n\n        playerID team points\n0 1 Lakers 26\n1 2 Mavs 19\n2 3 Bucks 24\n3 4 Spurs 22\n<\/strong><\/pre>\n
 Contoh 2: Membaca file Excel dengan kolom indeks<\/strong><\/span><\/h3>\n
 Terkadang Anda mungkin juga memiliki file Excel yang salah satu kolomnya adalah kolom indeks:<\/span> <\/p>\n
\"\"<\/p>\n
 Dalam hal ini, Anda dapat menggunakan index_col<\/strong> untuk memberi tahu panda kolom mana yang akan digunakan sebagai kolom indeks saat mengimpor:<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#import Excel file, specifying the index column<\/span>\ndf = pd. read_excel<\/span> ('data.xlsx', index_col=' index<\/span> ')\n\n#view DataFrame<\/span>\ndf\n\n\tplayerID team points\nindex\t\t\t\n1 1 Lakers 26\n2 2 Mavs 19\n3 3 Bucks 24\n4 4 Spurs 22<\/strong><\/pre>\n
 Contoh 3: Membaca file Excel menggunakan nama sheet<\/strong><\/span><\/h3>\n
 Anda juga dapat membaca nama sheet tertentu dari file Excel ke dalam pandas DataFrame. Misalnya, pertimbangkan file Excel berikut:<\/span> <\/p>\n
\"\"<\/p>\n
 Untuk membaca sheet tertentu sebagai DataFrame pandas, Anda dapat menggunakan argumen sheet_name()<\/strong> :<\/span><\/p>\n
 import<\/span> pandas as<\/span> pd\n\n#import only second sheet<\/span>\ndf = pd. read_excel<\/span> ('data.xlsx', sheet_name=' second sheet<\/span> ')\n\n#view DataFrame\n<\/span>df\n\nplayerID team points\n0 1 Lakers 26\n1 2 Mavs 19\n2 3 Bucks 24\n3 4 Spurs 22\n<\/strong><\/pre>\n
 Kesalahan umum: menginstal xlrd<\/strong><\/span><\/h3>\n
 Saat Anda mencoba menggunakan fungsi read_excel()<\/strong> , Anda mungkin mengalami kesalahan berikut:<\/span><\/p>\n
 ImportError: Install xlrd >= 1.0.0 for Excel support\n<\/strong><\/pre>\n
 Dalam hal ini, Anda harus menginstal xlrd terlebih dahulu:<\/span><\/p>\n
 pip install xlrd<\/strong><\/pre>\n
 Setelah terinstal, Anda dapat menggunakan fungsi read_excel()<\/strong> .<\/span><\/p>\n
 Sumber daya tambahan<\/strong><\/span><\/h3>\n
 Cara membaca file CSV dengan Pandas<\/a>
 Cara mengekspor Pandas DataFrame ke Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
File Excel adalah salah satu cara paling umum untuk menyimpan data. Untungnya, fungsi pandas read_excel() memudahkan membaca file Excel. Tutorial ini menjelaskan beberapa cara membaca file Excel dengan Python menggunakan pandas. Contoh 1: Membaca file Excel ke dalam pandas DataFrame Misalkan kita memiliki file Excel berikut: Kode berikut menunjukkan cara menggunakan fungsi read_excel() untuk mengimpor […]<\/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":"\nPanduan Utama: Cara Membaca File Excel dengan Pandas<\/title>\n<meta name=\"description\" content=\"Panduan utama untuk membaca file Excel ke dalam pandas DataFrame, termasuk beberapa 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-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Panduan Utama: Cara Membaca File Excel dengan Pandas\" \/>\n<meta property=\"og:description\" content=\"Panduan utama untuk membaca file Excel ke dalam pandas DataFrame, termasuk beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-28T03:40:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pdimportexcel1.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=\"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-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-excel\/\",\"name\":\"Panduan Utama: Cara Membaca File Excel dengan Pandas\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-28T03:40:23+00:00\",\"dateModified\":\"2023-07-28T03:40:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Panduan utama untuk membaca file Excel ke dalam pandas DataFrame, termasuk beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Panduan utama: cara membaca file excel dengan pandas\"}]},{\"@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":"Panduan Utama: Cara Membaca File Excel dengan Pandas","description":"Panduan utama untuk membaca file Excel ke dalam pandas DataFrame, termasuk beberapa 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-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Panduan Utama: Cara Membaca File Excel dengan Pandas","og_description":"Panduan utama untuk membaca file Excel ke dalam pandas DataFrame, termasuk beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-28T03:40:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pdimportexcel1.png"}],"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-excel\/","url":"https:\/\/statorials.org\/id\/panda-membaca-excel\/","name":"Panduan Utama: Cara Membaca File Excel dengan Pandas","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-28T03:40:23+00:00","dateModified":"2023-07-28T03:40:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Panduan utama untuk membaca file Excel ke dalam pandas DataFrame, termasuk beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Panduan utama: cara membaca file excel dengan pandas"}]},{"@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\/972"}],"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=972"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/972\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=972"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=972"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=972"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}