{"id":1107,"date":"2023-07-27T15:43:32","date_gmt":"2023-07-27T15:43:32","guid":{"rendered":"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/"},"modified":"2023-07-27T15:43:32","modified_gmt":"2023-07-27T15:43:32","slug":"data-harian-dikumpulkan-dalam-r","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/","title":{"rendered":"Cara menggabungkan data harian menjadi data bulanan dan tahunan di r"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Terkadang Anda mungkin ingin menggabungkan data harian menjadi data mingguan, bulanan, atau tahunan di R.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara melakukannya dengan mudah menggunakan paket <strong>lubridate<\/strong> dan <strong>dplyr<\/strong> .<\/span><\/p>\n<h2> <strong>Contoh: Gabungkan data harian di R<\/strong><\/h2>\n<p> <span style=\"color: #000000;\">Misalkan kita memiliki kerangka data berikut di R yang menunjukkan penjualan harian suatu barang selama 100 hari berturut-turut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #008080;\">#make this example reproducible\n<\/span>set.seed(1)\n<span style=\"color: #008080;\">\n#create data frame<\/span>\ndf &lt;- data.frame(date = <span style=\"color: #3366ff;\">as.Date<\/span> (\" <span style=\"color: #008000;\">2020-12-01<\/span> \") + 0:99,\n                 sales = <span style=\"color: #3366ff;\">runif<\/span> (100, 20, 50))\n\n<span style=\"color: #008080;\">#view first six rows<\/span>\nhead(df)\n\n        dirty date\n1 2020-12-01 27.96526\n2 2020-12-02 31.16372\n3 2020-12-03 37.18560\n4 2020-12-04 47.24623\n5 2020-12-05 26.05046\n6 2020-12-06 46.95169<\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Untuk menggabungkan data ini, kita dapat menggunakan fungsi <a href=\"https:\/\/lubridate.tidyverse.org\/reference\/round_date.html\" target=\"_blank\" rel=\"noopener noreferrer\">floor_date()<\/a> dari paket <strong>lubridate<\/strong> yang menggunakan sintaks berikut:<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #3366ff;\">floor_date<\/span> (x, unit)<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Emas:<\/span><\/p>\n<ul>\n<li> <span style=\"color: #000000;\"><strong>x:<\/strong> vektor objek tanggal.<\/span><\/li>\n<li> <span style=\"color: #000000;\"><strong>satuan:<\/strong> satuan waktu untuk dibulatkan. Pilihannya mencakup detik, menit, jam, hari, minggu, bulan, dua bulanan, kuartal, setengah tahun, dan tahun.<\/span><\/li>\n<\/ul>\n<p> <span style=\"color: #000000;\">Cuplikan kode berikut menunjukkan cara menggunakan fungsi ini dengan fungsi <a href=\"https:\/\/dplyr.tidyverse.org\/reference\/group_by.html\" target=\"_blank\" rel=\"noopener noreferrer\">group_by()<\/a> dan <a href=\"https:\/\/dplyr.tidyverse.org\/reference\/summarise.html\" target=\"_blank\" rel=\"noopener noreferrer\">ringkasan()<\/a> dalam paket <strong>dplyr<\/strong> untuk menemukan penjualan rata-rata berdasarkan minggu, bulan, dan tahun:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>Rata-rata penjualan per minggu<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\"><span style=\"color: #000000;\"><span style=\"color: #993300;\">library<\/span> (lubridate)<\/span>\n<span style=\"color: #000000;\"><span style=\"color: #993300;\">library<\/span> (dplyr)<\/span>\n\n#round dates down to week<\/span>\ndf$week &lt;- <span style=\"color: #3366ff;\">floor_date<\/span> (df$date, \" <span style=\"color: #008000;\">week<\/span> \")\n\n<span style=\"color: #008000;\"><span style=\"color: #008080;\">#find average sales per week\n<span style=\"color: #000000;\">df %&gt;%\n  <span style=\"color: #3366ff;\">group_by<\/span> (week) %&gt;%\n  <span style=\"color: #3366ff;\">summarize<\/span> (mean = <span style=\"color: #993300;\">mean<\/span> (sales))<\/span><\/span>\n\n<span style=\"color: #000000;\"># A tibble: 15 x 2\n   week means\n        \n 1 2020-11-29 33.9\n 2 2020-12-06 35.3\n 3 2020-12-13 39.0\n 4 2020-12-20 34.4\n 5 2020-12-27 33.6\n 6 2021-01-03 35.9\n 7 2021-01-10 37.8\n 8 2021-01-17 36.8\n 9 2021-01-24 32.8\n10 2021-01-31 33.9\n11 2021-02-07 34.1\n12 2021-02-14 41.6\n13 2021-02-21 31.8\n14 2021-02-28 35.2\n15 2021-03-07 37.1<\/span><\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rata-rata penjualan per bulan<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\"><span style=\"color: #993300;\">library<\/span> <span style=\"color: #000000;\">(lubridate)<\/span>\n<span style=\"color: #993300;\">library<\/span> <span style=\"color: #000000;\">(dplyr)<\/span>\n\n#round dates down to week<\/span>\ndf$month &lt;- <span style=\"color: #3366ff;\">floor_date<\/span> (df$date, \" <span style=\"color: #008000;\">month<\/span> \")\n\n<span style=\"color: #008000;\"><span style=\"color: #008080;\">#find average sales by month\n<span style=\"color: #000000;\">df %&gt;%<\/span>\n  <span style=\"color: #3366ff;\">group_by<\/span> <span style=\"color: #000000;\">(month) %&gt;%<\/span>\n  <span style=\"color: #3366ff;\">summarize<\/span> <span style=\"color: #000000;\">(mean =<\/span> <span style=\"color: #993300;\">mean<\/span> <span style=\"color: #000000;\">(sales))<\/span><\/span>\n\n<span style=\"color: #000000;\"># A tibble: 4 x 2\n  month mean\n       \n1 2020-12-01 35.3\n2 2021-01-01 35.6\n3 2021-02-01 35.2\n4 2021-03-01 37.0\n<\/span><\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\"><strong>Rata-rata penjualan per tahun<\/strong><\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 15px;\"> <strong><span style=\"color: #000000;\"><span style=\"color: #008080;\"><span style=\"color: #993300;\">library<\/span> <span style=\"color: #000000;\">(lubridate)<\/span>\n<span style=\"color: #993300;\">library<\/span> <span style=\"color: #000000;\">(dplyr)<\/span>\n\n#round dates down to week<\/span>\ndf$year &lt;- <span style=\"color: #3366ff;\">floor_date<\/span> (df$date, \" <span style=\"color: #008000;\">year<\/span> \")\n\n<span style=\"color: #008000;\"><span style=\"color: #008080;\">#find average sales by month\n<span style=\"color: #000000;\">df %&gt;%<\/span>\n  <span style=\"color: #3366ff;\">group_by<\/span> <span style=\"color: #000000;\">(year) %&gt;%<\/span>\n  <span style=\"color: #3366ff;\">summarize<\/span> <span style=\"color: #000000;\">(mean =<\/span> <span style=\"color: #993300;\">mean<\/span> <span style=\"color: #000000;\">(sales))\n\n# A tibble: 2 x 2\n  year means\n       \n1 2020-01-01 35.3\n2 2021-01-01 35.7<\/span><\/span>\n<\/span><\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa kita memilih untuk mengagregasi berdasarkan rata-rata, namun kita dapat menggunakan statistik ringkasan apa pun yang kita inginkan, seperti median, modus, maksimum, minimum, dll.<\/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 R:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/r-rata-rata-per-kelompok\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung mean per grup di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/jumlah-kumulatif-dalam-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara menghitung jumlah kumulatif di R<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/plot-deret-waktu-di-r\/\" target=\"_blank\" rel=\"noopener noreferrer\">Cara memplot deret waktu di R<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Terkadang Anda mungkin ingin menggabungkan data harian menjadi data mingguan, bulanan, atau tahunan di R. Tutorial ini menjelaskan cara melakukannya dengan mudah menggunakan paket lubridate dan dplyr . Contoh: Gabungkan data harian di R Misalkan kita memiliki kerangka data berikut di R yang menunjukkan penjualan harian suatu barang selama 100 hari berturut-turut: #make this example [&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 menggabungkan data harian menjadi data bulanan dan tahunan di R<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menggabungkan data harian menjadi tanggal mingguan, bulanan, dan tahunan di R, beserta contohnya.\" \/>\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\/data-harian-dikumpulkan-dalam-r\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara menggabungkan data harian menjadi data bulanan dan tahunan di R\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menggabungkan data harian menjadi tanggal mingguan, bulanan, dan tahunan di R, beserta contohnya.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-27T15:43:32+00:00\" \/>\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\/data-harian-dikumpulkan-dalam-r\/\",\"url\":\"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/\",\"name\":\"Cara menggabungkan data harian menjadi data bulanan dan tahunan di R\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-27T15:43:32+00:00\",\"dateModified\":\"2023-07-27T15:43:32+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menggabungkan data harian menjadi tanggal mingguan, bulanan, dan tahunan di R, beserta contohnya.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menggabungkan data harian menjadi data bulanan dan tahunan 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 menggabungkan data harian menjadi data bulanan dan tahunan di R","description":"Tutorial ini menjelaskan cara menggabungkan data harian menjadi tanggal mingguan, bulanan, dan tahunan di R, beserta contohnya.","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\/data-harian-dikumpulkan-dalam-r\/","og_locale":"id_ID","og_type":"article","og_title":"Cara menggabungkan data harian menjadi data bulanan dan tahunan di R","og_description":"Tutorial ini menjelaskan cara menggabungkan data harian menjadi tanggal mingguan, bulanan, dan tahunan di R, beserta contohnya.","og_url":"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/","og_site_name":"Statorials","article_published_time":"2023-07-27T15:43:32+00:00","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\/data-harian-dikumpulkan-dalam-r\/","url":"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/","name":"Cara menggabungkan data harian menjadi data bulanan dan tahunan di R","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-27T15:43:32+00:00","dateModified":"2023-07-27T15:43:32+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menggabungkan data harian menjadi tanggal mingguan, bulanan, dan tahunan di R, beserta contohnya.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/data-harian-dikumpulkan-dalam-r\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menggabungkan data harian menjadi data bulanan dan tahunan 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\/1107"}],"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=1107"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/1107\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=1107"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=1107"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=1107"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}