<\/p>\n
R’de grup ba\u015f\u0131na k\u00fcm\u00fclatif toplam\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz:<\/span><\/p>\n Y\u00f6ntem 1: Base R’yi kullan\u0131n<\/strong><\/span><\/p>\n Y\u00f6ntem 2: dplyr’\u0131 kullan\u0131n<\/strong><\/span><\/p>\n Y\u00f6ntem 3: data.table’\u0131 kullanma<\/strong><\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, R’deki a\u015fa\u011f\u0131daki veri \u00e7er\u00e7evesiyle her y\u00f6ntemin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, ma\u011fazaya<\/strong> g\u00f6re grupland\u0131r\u0131lm\u0131\u015f sat\u0131\u015flar\u0131n<\/strong> k\u00fcm\u00fclatif toplam\u0131n\u0131 hesaplamak i\u00e7in R veritaban\u0131 ave()<\/strong> i\u015flevinin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n Cum_sales<\/strong> ad\u0131 verilen yeni s\u00fctun, ma\u011fazaya<\/strong> g\u00f6re grupland\u0131r\u0131lm\u0131\u015f k\u00fcm\u00fclatif sat\u0131\u015f<\/strong> toplam\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, ma\u011fazaya<\/strong> g\u00f6re grupland\u0131r\u0131lm\u0131\u015f k\u00fcm\u00fclatif sat\u0131\u015f<\/strong> toplam\u0131n\u0131 hesaplamak i\u00e7in R’deki dplyr paketindeki \u00e7e\u015fitli i\u015flevlerin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n Cum_sales<\/strong> ad\u0131 verilen yeni s\u00fctun, ma\u011fazaya<\/strong> g\u00f6re grupland\u0131r\u0131lm\u0131\u015f k\u00fcm\u00fclatif sat\u0131\u015f<\/strong> toplam\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, ma\u011fazaya<\/strong> g\u00f6re grupland\u0131r\u0131lm\u0131\u015f k\u00fcm\u00fclatif sat\u0131\u015f<\/strong> toplam\u0131n\u0131 hesaplamak i\u00e7in R’deki data.table paketindeki \u00e7e\u015fitli i\u015flevlerin nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n Cum_sales<\/strong> ad\u0131 verilen yeni s\u00fctun, ma\u011fazaya<\/strong> g\u00f6re grupland\u0131r\u0131lm\u0131\u015f k\u00fcm\u00fclatif sat\u0131\u015f<\/strong> toplam\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/p>\n Not<\/strong> : Her \u00fc\u00e7 y\u00f6ntem de ayn\u0131 sonucu verir. Ancak dplyr ve data.table y\u00f6ntemleri a\u015f\u0131r\u0131 b\u00fcy\u00fck veri \u00e7er\u00e7eveleriyle \u00e7al\u0131\u015f\u0131rken daha h\u0131zl\u0131 olma e\u011filiminde olacakt\u0131r.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde R’de di\u011fer yayg\u0131n hesaplamalar\u0131n nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n R’de gruba g\u00f6re toplam nas\u0131l hesaplan\u0131r<\/a> R’de grup ba\u015f\u0131na k\u00fcm\u00fclatif toplam\u0131 hesaplamak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz: Y\u00f6ntem 1: Base R’yi kullan\u0131n df$cum_sum <- ave(df$values_var, df$group_var, FUN=cumsum) Y\u00f6ntem 2: dplyr’\u0131 kullan\u0131n library (dplyr) df %>% group_by(group_var) %>% mutate(cum_sum = cumsum(values_var)) Y\u00f6ntem 3: data.table’\u0131 kullanma library (data.table) setDT(df)[, cum_sum := cumsum(values_var), group_var] A\u015fa\u011f\u0131daki \u00f6rnekler, R’deki a\u015fa\u011f\u0131daki veri \u00e7er\u00e7evesiyle her y\u00f6ntemin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 […]<\/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":[],"class_list":["post-3928","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n df$cum_sum <- ave(df$values_var, df$group_var, FUN=cumsum)\n<\/strong><\/pre>\n
library<\/span> (dplyr)\n\ndf %>% group_by(group_var) %>% mutate(cum_sum = cumsum(values_var))\n<\/strong><\/pre>\n library<\/span> (data.table)\n\nsetDT(df)[, cum_sum := cumsum(values_var), group_var] \n<\/strong><\/pre>\n #create data frame\n<\/span>df <- data. frame<\/span> (store=rep(c(' A<\/span> ', ' B<\/span> ', ' C<\/span> '), each= 4<\/span> ),\n sales=c(3, 4, 4, 2, 5, 8, 9, 7, 6, 8, 3, 2))\n\n#view data frame\n<\/span>df\n\n blind sales\n1 to 3\n2 to 4\n3 to 4\n4 to 2\n5 B 5\n6 B 8\n7 B 9\n8 B 7\n9 C 6\n10 C 8\n11 C 3\n12 C 2\n<\/strong><\/pre>\n \u00d6rnek 1: R taban\u0131n\u0131 kullanarak grup ba\u015f\u0131na k\u00fcm\u00fclatif toplam\u0131 hesaplay\u0131n<\/strong><\/span><\/h2>\n
#add column to show cumulative sales by store\n<\/span>df$cum_sales <- ave(df$sales, df$store, FUN=cumsum)\n\n#view updated data frame\n<\/span>df\n\n store sales cum_sales\n1 to 3 3\n2 to 4 7\n3 to 4 11\n4 to 2 13\n5 B 5 5\n6 B 8 13\n7 B 9 22\n8 B 7 29\n9 C 6 6\n10 C 8 14\n11 C 3 17\n12 C 2 19<\/strong><\/pre>\n \u00d6rnek 2: dplyr kullanarak grup ba\u015f\u0131na k\u00fcm\u00fclatif toplam\u0131 hesaplama<\/strong><\/span><\/h2>\n
library<\/span> (dplyr)\n\n#add column to show cumulative sales by store\n<\/span>df %>% group_by(store) %>% mutate(cum_sales = cumsum(sales))\n\n#view updated data frame\n<\/span>df\n\n# A tibble: 12 x 3\n# Groups: store [3]\n store sales cum_sales\n \n 1 to 3 3\n 2 to 4 7\n 3 to 4 11\n 4 to 2 13\n 5 B 5 5\n 6 B 8 13\n 7 B 9 22\n 8 B 7 29\n 9 C 6 6\n10 C 8 14\n11 C 3 17\n12 C 2 19\n<\/strong><\/pre>\n \u00d6rnek 3: data.table’\u0131 kullanarak gruba g\u00f6re k\u00fcm\u00fclatif toplam\u0131 hesaplama<\/strong><\/span><\/h2>\n
library<\/span> (data.table)\n\n#add column to show cumulative sales by store\n<\/span>setDT(df)[, cum_sales := cumsum(sales), store] \n\n#view updated data frame\n<\/span>df\n\n store sales cum_sales\n 1: A 3 3\n 2: A 4 7\n 3: A 4 11\n 4: A 2 13\n 5: B 5 5\n 6: B 8 13\n 7: B 9 22\n 8: B 7 29\n 9: C 6 6\n10: C 8 14\n11: C 3 17\n12: C 2 19<\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
R’de grup ba\u015f\u0131na ortalama nas\u0131l hesaplan\u0131r<\/a>
R’de gruba g\u00f6re standart sapma nas\u0131l hesaplan\u0131r<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"