{"id":1158,"date":"2023-07-27T11:30:10","date_gmt":"2023-07-27T11:30:10","guid":{"rendered":"https:\/\/statorials.org\/id\/impor-excel-ke-r\/"},"modified":"2023-07-27T11:30:10","modified_gmt":"2023-07-27T11:30:10","slug":"impor-excel-ke-r","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/impor-excel-ke-r\/","title":{"rendered":"Cara mengimpor file excel ke r (langkah demi langkah)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk mengimpor file Excel ke R adalah dengan menggunakan fungsi <strong>read_excel()<\/strong> dari <a href=\"https:\/\/readxl.tidyverse.org\/\" target=\"_blank\" rel=\"noopener noreferrer\">paket readxl<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <strong><span style=\"color: #000000;\">read_excel(jalur, lembar = NULL)<\/span><\/strong><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>jalur:<\/strong> jalur ke file xls\/xlsx<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>sheet:<\/strong> Lembar untuk dibaca. Ini bisa berupa nama sheet atau posisi sheet. Jika ini tidak ditentukan, lembar pertama dibaca.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh penggunaan fungsi ini untuk mengimpor file Excel ke R.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: mengimpor file Excel ke R<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah saya memiliki file Excel yang disimpan di lokasi berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>C:\\Pengguna\\Bob\\Desktop\\data.xlsx<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">File tersebut berisi data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-11600 \" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importerexcel1.png\" alt=\"Impor Excel ke R\" width=\"403\" height=\"343\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengimpor file Excel ini ke R:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#install and load readxl package<\/span>\n<span style=\"color: #993300;\">install.packages<\/span> (' <span style=\"color: #008000;\">readxl<\/span> ')\n<span style=\"color: #993300;\">library<\/span> (readxl)\n\n<span style=\"color: #008080;\">#import Excel file into R\n<\/span>data &lt;- read_excel(' <span style=\"color: #008000;\">C:\\\\Users\\\\Bob\\\\Desktop\\\\data.xlsx<\/span> ')\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kami menggunakan garis miring terbalik ganda (\\\\) di jalur file untuk menghindari kesalahan umum berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #993300;\">Error: '\\U' used without hex digits in character string starting \"\"C:\\U\"<\/span>\n<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat menggunakan kode berikut untuk memvisualisasikan data dengan cepat:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <span style=\"color: #000000;\"><strong><span style=\"color: #008080;\">#view entire dataset\n<span style=\"color: #000000;\">data\n\n#A tibble: 5 x 3\n team points assists\n &lt;chr&gt; &lt;dbl&gt; &lt;dbl&gt;\n1 A 78 12\n2 B 85 20\n3 C 93 23\n4 D 90 8\n5 E 91 14<\/span><\/span>\n<\/strong><\/span><\/pre>\n<p> <span style=\"color: #000000;\">Kita dapat melihat bahwa R mengimpor file Excel dan secara otomatis menentukan bahwa <em>tim<\/em> adalah variabel string sedangkan <em>poin<\/em> dan <em>assist<\/em> adalah variabel numerik.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara mengimpor jenis file lain ke R:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/impor-csv-ke-r\/\" target=\"_blank\" rel=\"noopener\">Cara mengimpor file CSV ke R<\/a><br \/> <span style=\"color: #000000;\"><a href=\"https:\/\/statorials.org\/id\/impor-sas-ke-r\/\" target=\"_blank\" rel=\"noopener\">Cara mengimpor file SAS ke R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/memasukkan-data-ke-r\/\" target=\"_blank\" rel=\"noopener\">Cara memasukkan data mentah secara manual di R<\/a><br \/><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk mengimpor file Excel ke R adalah dengan menggunakan fungsi read_excel() dari paket readxl . Fungsi ini menggunakan sintaks berikut: read_excel(jalur, lembar = NULL) Emas: jalur: jalur ke file xls\/xlsx sheet: Lembar untuk dibaca. Ini bisa berupa nama sheet atau posisi sheet. Jika ini tidak ditentukan, lembar pertama dibaca. Tutorial ini memberikan contoh [&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>Cara Mengimpor File Excel ke R (Langkah demi Langkah) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara cepat mengimpor file Excel ke R, dengan contoh langkah demi langkah.\" \/>\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\/impor-excel-ke-r\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Mengimpor File Excel ke R (Langkah demi Langkah) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara cepat mengimpor file Excel ke R, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/impor-excel-ke-r\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T11:30:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importerexcel1.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\/impor-excel-ke-r\/\",\"url\":\"https:\/\/statorials.org\/id\/impor-excel-ke-r\/\",\"name\":\"Cara Mengimpor File Excel ke R (Langkah demi Langkah) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T11:30:10+00:00\",\"dateModified\":\"2023-07-27T11:30:10+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara cepat mengimpor file Excel ke R, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/impor-excel-ke-r\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/impor-excel-ke-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/impor-excel-ke-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengimpor file excel ke r (langkah demi langkah)\"}]},{\"@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":"Cara Mengimpor File Excel ke R (Langkah demi Langkah) - Statologi","description":"Tutorial ini menjelaskan cara cepat mengimpor file Excel ke R, dengan contoh langkah demi langkah.","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\/impor-excel-ke-r\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Mengimpor File Excel ke R (Langkah demi Langkah) - Statologi","og_description":"Tutorial ini menjelaskan cara cepat mengimpor file Excel ke R, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/impor-excel-ke-r\/","og_site_name":"Statorials","article_published_time":"2023-07-27T11:30:10+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/importerexcel1.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\/impor-excel-ke-r\/","url":"https:\/\/statorials.org\/id\/impor-excel-ke-r\/","name":"Cara Mengimpor File Excel ke R (Langkah demi Langkah) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T11:30:10+00:00","dateModified":"2023-07-27T11:30:10+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara cepat mengimpor file Excel ke R, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/impor-excel-ke-r\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/impor-excel-ke-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/impor-excel-ke-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengimpor file excel ke r (langkah demi langkah)"}]},{"@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\/1158"}],"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=1158"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1158\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}