{"id":4085,"date":"2023-07-13T17:02:22","date_gmt":"2023-07-13T17:02:22","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/"},"modified":"2023-07-13T17:02:22","modified_gmt":"2023-07-13T17:02:22","slug":"panda-membaca-garis-lewati-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/","title":{"rendered":"Pandas: cara melewati baris saat membaca file excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan metode berikut untuk melewati baris saat membaca file Excel ke dalam pandas DataFrame:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Metode 1: Lewati baris tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#import DataFrame and skip row in index position 2\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ', skiprows=[ <span style=\"color: #008000;\">2<\/span> ])\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 2: Mengabaikan Beberapa Baris Tertentu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#import DataFrame and skip rows in index positions 2 and 4\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ' <span style=\"color: #008000;\">, skiprows=[2,4<\/span> <span style=\"color: #008000;\">]<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Metode 3: abaikan N baris pertama<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#import DataFrame and skip first 2 rows\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ', skiprows= <span style=\"color: #008000;\">2<\/span> )<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Contoh berikut menunjukkan cara menggunakan masing-masing metode dalam praktik dengan file Excel berikut yang disebut <strong>player_data.xlsx<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-32506 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter-excel1.png\" alt=\"\" width=\"497\" height=\"457\" srcset=\"\" sizes=\"\"><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 1: Abaikan baris tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengimpor file Excel dan mengabaikan baris pada posisi indeks 2:<\/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;\">#import DataFrame and skip row in index position 2\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">player_data.xlsx<\/span> ', skiprows=[ <span style=\"color: #008000;\">2<\/span> ])\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points rebound assists\n0 to 24 8 5\n1 C 15 4 7\n2 D 19 4 8\n3 E 32 6 8\n4 F 13 7 9\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris pada posisi indeks 2 (dengan tim &#8216;B&#8217;) diabaikan saat mengimpor file Excel ke pandas DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Baris pertama file Excel dianggap sebagai baris 0.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 2: Mengabaikan beberapa baris tertentu<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengimpor file Excel dan mengabaikan baris di posisi indeks 2 dan 4:<\/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;\">#import DataFrame and skip rows in index positions 2 and 4\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">player_data.xlsx<\/span> ', skiprows=[ <span style=\"color: #008000;\">2,4<\/span> ] <span style=\"color: #008000;\">)<\/span>\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points rebound assists\n0 to 24 8 5\n1 C 15 4 7\n2 E 32 6 8\n3 F 13 7 9\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa baris di posisi indeks 2 dan 4 (dengan tim &#8220;B&#8221; dan &#8220;D&#8221;) diabaikan saat mengimpor file Excel ke pandas DataFrame.<\/span><\/p>\n<h2> <span style=\"color: #000000;\"><strong>Contoh 3: abaikan N baris pertama<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk mengimpor file Excel dan mengabaikan dua baris pertama:<\/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;\">#import DataFrame and skip first 2 rows\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">player_data.xlsx<\/span> ', skiprows= <span style=\"color: #008000;\">2<\/span> )\n\n<span style=\"color: #008080;\">#view DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n   B 20 12 3\n0 C 15 4 7\n1 D 19 4 8\n2 E 32 6 8\n3 F 13 7 9\n<\/b><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dua baris pertama file Excel telah dilewati dan baris berikutnya yang tersedia (dengan tim &#8220;B&#8221;) telah menjadi baris header DataFrame.<\/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-membaca-excel\/\" target=\"_blank\" rel=\"noopener\">Cara membaca file Excel dengan Pandas<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ekspor-kerangka-data-panda-ke-excel\/\" target=\"_blank\" rel=\"noopener\">Cara mengekspor Pandas DataFrame ke Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tabel-numpy-di-csv\/\">Cara mengekspor array NumPy ke file CSV<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan metode berikut untuk melewati baris saat membaca file Excel ke dalam pandas DataFrame: Metode 1: Lewati baris tertentu #import DataFrame and skip row in index position 2 df = pd. read_excel (&#8216; my_data.xlsx &#8216;, skiprows=[ 2 ]) Metode 2: Mengabaikan Beberapa Baris Tertentu #import DataFrame and skip rows in index positions 2 [&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: Cara melewati baris saat membaca file Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara melewati baris saat membaca file Excel ke dalam pandas DataFrame, dengan 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-garis-lewati-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara melewati baris saat membaca file Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara melewati baris saat membaca file Excel ke dalam pandas DataFrame, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T17:02:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter-excel1.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-garis-lewati-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/\",\"name\":\"Pandas: Cara melewati baris saat membaca file Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T17:02:22+00:00\",\"dateModified\":\"2023-07-13T17:02:22+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara melewati baris saat membaca file Excel ke dalam pandas DataFrame, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara melewati baris saat membaca 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: Cara melewati baris saat membaca file Excel - Statorials","description":"Tutorial ini menjelaskan cara melewati baris saat membaca file Excel ke dalam pandas DataFrame, dengan 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-garis-lewati-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara melewati baris saat membaca file Excel - Statorials","og_description":"Tutorial ini menjelaskan cara melewati baris saat membaca file Excel ke dalam pandas DataFrame, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-13T17:02:22+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/sauter-excel1.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-garis-lewati-excel\/","url":"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/","name":"Pandas: Cara melewati baris saat membaca file Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T17:02:22+00:00","dateModified":"2023-07-13T17:02:22+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara melewati baris saat membaca file Excel ke dalam pandas DataFrame, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara melewati baris saat membaca 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\/4085"}],"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=4085"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4085\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4085"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4085"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4085"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}