{"id":1159,"date":"2023-07-27T11:20:41","date_gmt":"2023-07-27T11:20:41","guid":{"rendered":"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/"},"modified":"2023-07-27T11:20:41","modified_gmt":"2023-07-27T11:20:41","slug":"r-ekspor-ke-excel","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/","title":{"rendered":"Cara mengekspor bingkai data ke file excel di r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Cara termudah untuk mengekspor bingkai data ke file Excel di R adalah dengan menggunakan fungsi <strong>write_xlsx()<\/strong> dari <a href=\"https:\/\/cran.r-project.org\/web\/packages\/writexl\/writexl.pdf\" target=\"_blank\" rel=\"noopener noreferrer\">paket writexl<\/a> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Fungsi ini menggunakan sintaks berikut:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>write_xlsx(x, jalur)<\/strong><\/span><\/p>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x:<\/strong> Nama blok data yang akan diekspor<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>path:<\/strong> nama file untuk menulis<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Tutorial ini memberikan contoh penggunaan fungsi ini untuk mengekspor bingkai data ke file Excel di R.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh: Ekspor bingkai data ke file Excel di R<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki bingkai data berikut di R:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#create data frame<\/span>\ndf &lt;- data.frame(team=c('A', 'B', 'C', 'D', 'E'),\n                 points=c(78, 85, 93, 90, 91),\n                 assists=c(12, 20, 23, 8, 14))\n\n<span style=\"color: #008080;\">#view data frame\n<\/span>df\n\n  team points assists\n1 A 78 12\n2 B 85 20\n3 C 93 23\n4 D 90 8\n5 E 91 14<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Kode berikut menunjukkan cara mengekspor bingkai data ini ke file Excel di R:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#install and load writexl package\n<span style=\"color: #000000;\"><span style=\"color: #993300;\">install.packages<\/span> (' <span style=\"color: #008000;\">writexl<\/span> ')<\/span>\n<span style=\"color: #000000;\"><span style=\"color: #993300;\">library<\/span> (writexl)<\/span>\n\n<\/span>write_xlsx(df, ' <span style=\"color: #008000;\">C:\\Users\\Bob\\Desktop\\data.xlsx<\/span> ')<\/strong><\/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><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Bingkai data sekarang tersedia sebagai file Excel di desktop saya. Seperti inilah tampilan filenya:<\/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=\"Ekspor bingkai data ke file Excel di R\" width=\"450\" height=\"383\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <a href=\"https:\/\/statorials.org\/id\/impor-excel-ke-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara mengimpor file Excel ke R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/impor-csv-ke-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara mengimpor file CSV ke R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/ekspor-bingkai-data-ke-csv-di-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara mengekspor kerangka data ke file CSV di R<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Cara termudah untuk mengekspor bingkai data ke file Excel di R adalah dengan menggunakan fungsi write_xlsx() dari paket writexl . Fungsi ini menggunakan sintaks berikut: write_xlsx(x, jalur) Emas: x: Nama blok data yang akan diekspor path: nama file untuk menulis Tutorial ini memberikan contoh penggunaan fungsi ini untuk mengekspor bingkai data ke file Excel di [&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 mengekspor bingkai data ke file Excel di R<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengekspor bingkai data dari file R ke Excel.\" \/>\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\/r-ekspor-ke-excel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengekspor bingkai data ke file Excel di R\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengekspor bingkai data dari file R ke Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T11:20:41+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\/r-ekspor-ke-excel\/\",\"url\":\"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/\",\"name\":\"Cara mengekspor bingkai data ke file Excel di R\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T11:20:41+00:00\",\"dateModified\":\"2023-07-27T11:20:41+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengekspor bingkai data dari file R ke Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengekspor bingkai data ke file excel di r\"}]},{\"@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 mengekspor bingkai data ke file Excel di R","description":"Tutorial ini menjelaskan cara mengekspor bingkai data dari file R ke Excel.","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\/r-ekspor-ke-excel\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengekspor bingkai data ke file Excel di R","og_description":"Tutorial ini menjelaskan cara mengekspor bingkai data dari file R ke Excel.","og_url":"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/","og_site_name":"Statorials","article_published_time":"2023-07-27T11:20:41+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\/r-ekspor-ke-excel\/","url":"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/","name":"Cara mengekspor bingkai data ke file Excel di R","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T11:20:41+00:00","dateModified":"2023-07-27T11:20:41+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengekspor bingkai data dari file R ke Excel.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/r-ekspor-ke-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengekspor bingkai data ke file excel di r"}]},{"@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\/1159"}],"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=1159"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1159\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1159"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1159"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1159"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}