\u00d6rne\u011fin, Excel’de a\u015fa\u011f\u0131daki veri k\u00fcmesine sahipsek toplam sat\u0131\u015flar\u0131 b\u00f6lgeye g\u00f6re h\u0131zl\u0131 bir \u015fekilde \u00f6zetlemek i\u00e7in bir pivot tablo kullanabiliriz:<\/span> <\/p>\n Bu bize \u015funu s\u00f6yl\u00fcyor:<\/span><\/p>\n Veya b\u00f6lgeye g\u00f6re ortalama sat\u0131\u015flar gibi ba\u015fka bir \u00f6l\u00e7\u00fcmle \u00f6zetleyebiliriz:<\/span> <\/p>\n Dplyr<\/a> paketindeki group_by()<\/strong> ve Summary()<\/strong> i\u015flevlerini kullanarak R’de benzer pivot tablolar\u0131 h\u0131zl\u0131 bir \u015fekilde olu\u015fturabildi\u011fimiz ortaya \u00e7\u0131kt\u0131.<\/span><\/p>\n Bu e\u011fitimde bunun nas\u0131l yap\u0131laca\u011f\u0131na dair birka\u00e7 \u00f6rnek sunulmaktad\u0131r.<\/span><\/p>\n \u00d6ncelikle Excel’den \u00f6nceki \u00f6rneklerde kulland\u0131\u011f\u0131m\u0131z veri k\u00fcmesinin ayn\u0131s\u0131n\u0131 R’de olu\u015ftural\u0131m:<\/span><\/p>\n Daha sonra dplyr paketini y\u00fckleyelim ve b\u00f6lgeye g\u00f6re gruplamak ve b\u00f6lgeye g\u00f6re sat\u0131\u015flar\u0131n toplam\u0131n\u0131 bulmak i\u00e7in group_by()<\/strong> ve Summary()<\/strong> i\u015flevlerini kullanal\u0131m:<\/span><\/p>\n Bu say\u0131lar\u0131n Excel giri\u015f \u00f6rne\u011finde g\u00f6sterilen say\u0131larla e\u015fle\u015fti\u011fini g\u00f6rebiliriz.<\/span><\/p>\n B\u00f6lgelere g\u00f6re ortalama sat\u0131\u015flar\u0131 da hesaplayabiliriz:<\/span><\/p>\n Yine bu say\u0131lar \u00f6nceki Excel \u00f6rne\u011finde g\u00f6sterilen say\u0131larla e\u015fle\u015fir.<\/span><\/p>\n Birden fazla de\u011fi\u015fkene g\u00f6re de grupland\u0131rabilece\u011fimizi unutmay\u0131n. \u00d6rne\u011fin, b\u00f6lgeye ve<\/em> cihaz t\u00fcr\u00fcne g\u00f6re grupland\u0131r\u0131lm\u0131\u015f sat\u0131\u015flar\u0131n toplam\u0131n\u0131 bulabiliriz:<\/span><\/p>\n R’de D\u00dc\u015eEYARA (Excel’e benzer) nas\u0131l yap\u0131l\u0131r<\/a> Excel’de pivot tablolar , verileri grupland\u0131rman\u0131n ve \u00f6zetlemenin kolay bir yolunu sa\u011flar. \u00d6rne\u011fin, Excel’de a\u015fa\u011f\u0131daki veri k\u00fcmesine sahipsek toplam sat\u0131\u015flar\u0131 b\u00f6lgeye g\u00f6re h\u0131zl\u0131 bir \u015fekilde \u00f6zetlemek i\u00e7in bir pivot tablo kullanabiliriz: Bu bize \u015funu s\u00f6yl\u00fcyor: A B\u00f6lgesinde toplam 51 sat\u0131\u015f ger\u00e7ekle\u015fti B B\u00f6lgesinde toplam 85 sat\u0131\u015f ger\u00e7ekle\u015fti C B\u00f6lgesi toplam 140 sat\u0131\u015f ger\u00e7ekle\u015ftirdi Veya b\u00f6lgeye […]<\/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-1443","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot1.png\")
<\/p>\n\n
![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/pivot2.png\")
<\/p>\n \u00d6rnek: R’de PivotTable’lar olu\u015fturma<\/strong><\/span><\/h3>\n
#create data frame<\/span>\ndf <- data. frame<\/span> (region=c('A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C', 'C'),\n device=c('X', 'X', 'Y', 'X', 'Y', 'Y', 'X', 'X', 'Y', 'Y'),\n sales=c(12, 18, 21, 22, 34, 29, 38, 36, 34, 32))\n\n#view data frame\n<\/span>df\n\n region device sales\n1AX 12\n2AX18\n3 AY 21\n4 BX22\n5 BY 34\n6 BY 29\n7 CX 38\n8CX36\n9 CY 34\n10 CY 32\n<\/strong><\/pre>\n library<\/span> (dplyr)<\/span>\n<\/span><\/span>\n#find sum of sales by region<\/span>\ndf %>%\n group_by<\/span> (region) %>% \n summarize<\/span> (sum_sales = sum<\/span> (sales))\n\n# A tibble: 3 x 2\n region sum_sales\n \n1 to 51\n2 B 85\n3 C 140<\/strong><\/pre>\n #find average sales by region<\/span>\ndf %>%\n group_by<\/span> (region) %>% \n summarize<\/span> (mean_sales = mean<\/span> (sales))\n\n# A tibble: 3 x 2\n region mean_sales\n \n1 to 17 \n2 B 28.3\n3 C 35<\/strong><\/pre>\n #find sum of sales by region and device type<\/span>\ndf %>%\n group_by<\/span> (region, device) %>% \n summarize<\/span> (sum_sales = sum<\/span> (sales))\n\n# A tibble: 6 x 3\n# Groups: region [3]\n region device sum_sales\n \n1AX30\n2 AY 21\n3 BX22\n4 BY 63\n5 CX 74\n6 CY 66<\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
Tam K\u0131lavuz: R’de Veriler Nas\u0131l Grupland\u0131r\u0131l\u0131r ve \u00d6zetlenir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"