\u00d6rne\u011fin, a\u015fa\u011f\u0131daki Excel elektronik tablosunda, bir oyuncunun tak\u0131m ad\u0131n\u0131, oyuncunun ad\u0131yla e\u015fle\u015ftirmek ve oyuncunun tak\u0131m\u0131n\u0131 d\u00f6nd\u00fcrmek i\u00e7in D\u00dc\u015eEYARA’y\u0131 kullanarak arayabiliriz:<\/span> <\/p>\n Bu i\u015flevi temel R’yi veya dplyr paketini kullanarak \u00e7o\u011faltabiliriz:<\/span><\/p>\n Base R’yi kullanma:<\/strong><\/span><\/p>\n Dplyr’\u0131 kullanma:<\/strong><\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, D\u00dc\u015eEYARA i\u015flevini Excel’den \u00e7o\u011faltmak i\u00e7in bu i\u015flevlerin her birinin R’de nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, merge()<\/strong> i\u015flevini kullanarak R taban\u0131nda D\u00dc\u015eEYARA benzeri bir i\u015flevin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir:<\/span><\/p>\n Bunun giri\u015f \u00f6rne\u011findeki D\u00dc\u015eEYARA i\u015fleviyle ayn\u0131 sonu\u00e7lar\u0131 d\u00f6nd\u00fcrd\u00fc\u011f\u00fcn\u00fc unutmay\u0131n. Ayr\u0131ca by<\/strong> arg\u00fcman\u0131n\u0131 kullanarak birle\u015ftirilecek birden fazla s\u00fctunu belirtebilece\u011finizi unutmay\u0131n.<\/span><\/p>\n Bunun Excel’deki D\u00dc\u015eEYARA i\u015fleviyle ayn\u0131 sonu\u00e7lar\u0131 d\u00f6nd\u00fcrd\u00fc\u011f\u00fcn\u00fc unutmay\u0131n. Ayr\u0131ca by<\/strong> arg\u00fcman\u0131n\u0131 kullanarak birle\u015ftirilecek birden fazla s\u00fctunu belirtebilece\u011finizi unutmay\u0131n.<\/span><\/p>\n Ayr\u0131ca e\u015fle\u015fmeyen e\u015fle\u015fmelerin g\u00f6r\u00fcnt\u00fclenmesini istiyorsan\u0131z left_join<\/strong> i\u015flevini kullanabilirsiniz.<\/span><\/p>\n R’de k\u00fcm\u00fclatif toplamlar nas\u0131l hesaplan\u0131r<\/a> Excel’deki D\u00dc\u015eEYARA i\u015flevi, bir tablodaki de\u011feri bir s\u00fctunda e\u015fle\u015ftirerek bulman\u0131z\u0131 sa\u011flar. \u00d6rne\u011fin, a\u015fa\u011f\u0131daki Excel elektronik tablosunda, bir oyuncunun tak\u0131m ad\u0131n\u0131, oyuncunun ad\u0131yla e\u015fle\u015ftirmek ve oyuncunun tak\u0131m\u0131n\u0131 d\u00f6nd\u00fcrmek i\u00e7in D\u00dc\u015eEYARA’y\u0131 kullanarak arayabiliriz: Bu i\u015flevi temel R’yi veya dplyr paketini kullanarak \u00e7o\u011faltabiliriz: Base R’yi kullanma: merge(df1, df2, by=” merge_column “) Dplyr’\u0131 kullanma: inner_join(df1, df2, by=” merge_column “) […]<\/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-1123","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n![\"\"](\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/vlookup_r2.png\")
<\/p>\n merge(df1, df2, by=\" merge_column<\/span> \")\n<\/strong><\/pre>\n inner_join(df1, df2, by=\" merge_column<\/span> \")<\/strong><\/pre>\n Base R kullanarak D\u00dc\u015eEYARA<\/strong><\/span><\/h3>\n
#create first data frame<\/span>\ndf1 <- data.frame(player= LETTERS<\/span> [1:15],\n team= rep<\/span> (c(' Mavs<\/span> ', ' Lakers<\/span> ', ' Rockets<\/span> '), each<\/span> =5))\n\n#create second data frame<\/span> \ndf2 <- data.frame(player= LETTERS<\/span> [1:15],\n points=c(14, 15, 15, 16, 8, 9, 16, 27, 30, 24, 14, 19, 8, 6, 5))\n\n#merge the two data frames\nmerge(df1, df2, by=\" player<\/span> \")\n\n player team points\n1 A Mavs 14\n2 B Mavs 15\n3C Mavs 15\n4D Mavs 16\n5 E Mavs 8\n6 F Lakers 9\n7G Lakers 16\n8 a.m. Lakers 27\n9 I Lakers 30\n10 J Lakers 24\n11K Rockets 14\n12L Rockets 19\n13 M Rockets 8\n14 N Rockets 6\n15 O Rockets 5<\/span><\/span><\/strong><\/pre>\n dplyr kullanarak D\u00dc\u015eEYARA<\/strong><\/span><\/h3>\n
library<\/span> (dplyr)<\/span>\n\n#create first data frame<\/span>\ndf1 <- data.frame(player= LETTERS<\/span> [1:15],\n team= rep<\/span> (c(' Mavs<\/span> ', ' Lakers<\/span> ', ' Rockets<\/span> '), each<\/span> =5))\n\n#create second data frame<\/span> \ndf2 <- data.frame(player= LETTERS<\/span> [1:15],\n points=c(14, 15, 15, 16, 8, 9, 16, 27, 30, 24, 14, 19, 8, 6, 5))\n\n#merge the two data frames using inner_join\n<\/span>inner_join(df1, df2, by=\" player<\/span> \")\n\n player team points\n1 A Mavs 14\n2 B Mavs 15\n3C Mavs 15\n4D Mavs 16\n5 E Mavs 8\n6 F Lakers 9\n7G Lakers 16\n8 a.m. Lakers 27\n9 I Lakers 30\n10 J Lakers 24\n11K Rockets 14\n12L Rockets 19\n13 M Rockets 8\n14 N Rockets 6\n15 O Rockets 5\n<\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
R’deki veriler nas\u0131l standartla\u015ft\u0131r\u0131l\u0131r<\/a>
R’de bir veri \u00e7er\u00e7evesine sat\u0131rlar nas\u0131l eklenir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"