{"id":4086,"date":"2023-07-13T16:48:18","date_gmt":"2023-07-13T16:48:18","guid":{"rendered":"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/"},"modified":"2023-07-13T16:48:18","modified_gmt":"2023-07-13T16:48:18","slug":"panda-membaca-excel-dtype","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/","title":{"rendered":"Pandas: cara menentukan tipe saat mengimpor file excel"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Anda dapat menggunakan sintaks dasar berikut untuk menentukan tipe setiap kolom dalam DataFrame saat mengimpor file Excel ke pandas:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">my_data.xlsx<\/span> ',\n                 dtype = {' <span style=\"color: #ff0000;\">col1<\/span> ': <span style=\"color: #008000;\">str<\/span> , ' <span style=\"color: #ff0000;\">col2<\/span> ': <span style=\"color: #008000;\">float<\/span> , ' <span style=\"color: #ff0000;\">col3<\/span> ': <span style=\"color: #008000;\">int<\/span> })\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Argumen <b>dtype<\/b> menentukan tipe data yang harus dimiliki setiap kolom saat mengimpor file Excel ke dalam pandas DataFrame.<\/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: Tentukan Jenis Saat Mengimpor File Excel ke Pandas<\/strong><\/span><\/h2>\n<p> <span style=\"color: #000000;\">Katakanlah kita memiliki file Excel berikut bernama <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=\"510\" height=\"470\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Jika kita mengimpor file Excel menggunakan fungsi <strong>read_excel()<\/strong> , panda akan mencoba mengidentifikasi tipe data untuk setiap kolom secara otomatis:<\/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 Excel file\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">player_data.xlsx<\/span> ')\n\n<span style=\"color: #008080;\">#view resulting DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points rebound assists\n0 to 24 8 5\n1 B 20 12 3\n2 C 15 4 7\n3 D 19 4 8\n4 E 32 6 8\n5 F 13 7 9\n\n<span style=\"color: #008080;\">#view data type of each column\n<\/span><span style=\"color: #008000;\">print<\/span> ( <span style=\"color: #3366ff;\">df.dtypes<\/span> )\n\nteam object\nint64 dots\nrebounds int64\nassists int64\ndtype:object\n<\/strong><\/span><\/b><\/pre>\n<p> <span style=\"color: #000000;\">Dari hasilnya, kita dapat melihat bahwa kolom DataFrame memiliki tipe data berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>tim<\/strong> :objek<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>poin<\/strong> : int64<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>memantul<\/strong> : int64<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>bantuan<\/strong> : int64<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Namun, kita bisa menggunakan argumen <b>dtype<\/b> dalam fungsi <strong>read_excel()<\/strong> untuk menentukan tipe data yang harus dimiliki setiap kolom:<\/span><b> <\/b><\/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 Excel file and specify dtypes of columns\n<\/span>df = pd. <span style=\"color: #3366ff;\">read_excel<\/span> (' <span style=\"color: #ff0000;\">player_data.xlsx<\/span> ',\n                   dtype = {' <span style=\"color: #ff0000;\">team<\/span> ': <span style=\"color: #008000;\">str<\/span> , ' <span style=\"color: #ff0000;\">points<\/span> ': <span style=\"color: #008000;\">float<\/span> , ' <span style=\"color: #ff0000;\">rebounds<\/span> ': <span style=\"color: #008000;\">int<\/span> ,\n                            ' <span style=\"color: #ff0000;\">assists<\/span> ': <span style=\"color: #008000;\">float<\/span> })\n\n<span style=\"color: #008080;\">#view resulting DataFrame\n<\/span><span style=\"color: #008000;\">print<\/span> (df)\n\n  team points rebound assists\n0 A 24.0 8 5.0\n1 B 20.0 12 3.0\n2 C 15.0 4 7.0\n3 D 19.0 4 8.0\n4 E 32.0 6 8.0\n5 F 13.0 7 9.0\n\n<span style=\"color: #008080;\">#view data type of each column\n<\/span><span style=\"color: #008000;\">print<\/span> ( <span style=\"color: #3366ff;\">df.dtypes<\/span> )\n\nteam object\nfloat64 points\nrebounds int32\nassist float64\ndtype:object<\/strong><\/span><\/b><\/pre>\n<p><span style=\"color: #000000;\">Dari hasilnya, kita dapat melihat bahwa kolom DataFrame memiliki tipe data berikut:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>tim<\/strong> :objek<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>poin<\/strong> : float64<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>memantul<\/strong> : int32<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>bantuan<\/strong> : float64<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tipe data ini sesuai dengan yang kami tentukan menggunakan argumen <strong>dtype<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa dalam contoh ini kami telah menentukan tipe untuk setiap kolom di DataFrame.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Namun, Anda dapat memilih untuk menentukan jenis kolom tertentu saja dan membiarkan panda menyimpulkan jenis kolom lainnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Catatan<\/strong> : Anda dapat menemukan dokumentasi lengkap fungsi pandas <strong>read_excel()<\/strong> <a href=\"https:\/\/pandas.pydata.org\/docs\/reference\/api\/pandas.read_excel.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 di panda:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/panda-membaca-garis-lewati-excel\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara melewati baris saat membaca file Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/menggabungkan-beberapa-lembar-excel-panda\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menggabungkan beberapa lembar Excel<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tulis-beberapa-lembar-excel-pandas\/\" target=\"_blank\" rel=\"noopener\">Pandas: Cara menulis DataFrames di beberapa lembar Excel<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Anda dapat menggunakan sintaks dasar berikut untuk menentukan tipe setiap kolom dalam DataFrame saat mengimpor file Excel ke pandas: df = pd. read_excel (&#8216; my_data.xlsx &#8216;, dtype = {&#8216; col1 &#8216;: str , &#8216; col2 &#8216;: float , &#8216; col3 &#8216;: int }) Argumen dtype menentukan tipe data yang harus dimiliki setiap kolom saat mengimpor [&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 menentukan tipe saat mengimpor file Excel - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menentukan tipe kolom saat mengimpor file Excel ke pandas DataFrame, 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-excel-dtype\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pandas: Cara menentukan tipe saat mengimpor file Excel - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menentukan tipe kolom saat mengimpor file Excel ke pandas DataFrame, dengan sebuah contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-13T16:48:18+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-excel-dtype\/\",\"url\":\"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/\",\"name\":\"Pandas: Cara menentukan tipe saat mengimpor file Excel - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-13T16:48:18+00:00\",\"dateModified\":\"2023-07-13T16:48:18+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menentukan tipe kolom saat mengimpor file Excel ke pandas DataFrame, dengan sebuah contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pandas: cara menentukan tipe 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: Cara menentukan tipe saat mengimpor file Excel - Statorials","description":"Tutorial ini menjelaskan cara menentukan tipe kolom saat mengimpor file Excel ke pandas DataFrame, 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-excel-dtype\/","og_locale":"id_ID","og_type":"article","og_title":"Pandas: Cara menentukan tipe saat mengimpor file Excel - Statorials","og_description":"Tutorial ini menjelaskan cara menentukan tipe kolom saat mengimpor file Excel ke pandas DataFrame, dengan sebuah contoh.","og_url":"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/","og_site_name":"Statorials","article_published_time":"2023-07-13T16:48:18+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-excel-dtype\/","url":"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/","name":"Pandas: Cara menentukan tipe saat mengimpor file Excel - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-13T16:48:18+00:00","dateModified":"2023-07-13T16:48:18+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menentukan tipe kolom saat mengimpor file Excel ke pandas DataFrame, dengan sebuah contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/panda-membaca-excel-dtype\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pandas: cara menentukan tipe 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\/4086"}],"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=4086"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/4086\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=4086"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=4086"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=4086"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}