<\/p>\n
R’deki iki veri \u00e7er\u00e7evesini sat\u0131r adlar\u0131na g\u00f6re birle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz:<\/span><\/p>\n By=0<\/strong> arg\u00fcman\u0131n\u0131 kullanarak R’ye veri bloklar\u0131n\u0131n sat\u0131r adlar\u0131n\u0131 kullanarak birle\u015ftirmek istedi\u011fimizi s\u00f6yleyebiliriz.<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, her y\u00f6ntemin a\u015fa\u011f\u0131daki iki veri \u00e7er\u00e7evesiyle nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, sat\u0131r adlar\u0131n\u0131 kullanarak iki veri \u00e7er\u00e7evesinde i\u00e7 birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir:<\/span><\/p>\n Birle\u015ftirilmi\u015f son veri \u00e7er\u00e7evesinde yaln\u0131zca sat\u0131r adlar\u0131 her iki veri \u00e7er\u00e7evesine ait olan sat\u0131rlar\u0131n tutuldu\u011funu unutmay\u0131n.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, sat\u0131r adlar\u0131n\u0131 kullanarak iki veri \u00e7er\u00e7evesinde sol birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir:<\/span><\/p>\n \u0130lk veri \u00e7er\u00e7evesindeki t\u00fcm sat\u0131rlar\u0131n son birle\u015ftirilmi\u015f veri \u00e7er\u00e7evesinde tutuldu\u011funu unutmay\u0131n.<\/span><\/p>\n A\u015fa\u011f\u0131daki kod, sat\u0131r adlar\u0131n\u0131 kullanarak iki veri \u00e7er\u00e7evesinde d\u0131\u015f birle\u015ftirmenin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fini g\u00f6sterir:<\/span><\/p>\n Her iki veri \u00e7er\u00e7evesindeki t\u00fcm sat\u0131rlar\u0131n, birle\u015ftirilmi\u015f son veri \u00e7er\u00e7evesinde tutuldu\u011funu unutmay\u0131n.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde R’de di\u011fer yayg\u0131n veri \u00e7er\u00e7evesi i\u015flevlerinin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n R’de sola birle\u015ftirme nas\u0131l yap\u0131l\u0131r<\/a> R’deki iki veri \u00e7er\u00e7evesini sat\u0131r adlar\u0131na g\u00f6re birle\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullanabilirsiniz: #inner join merge(df1, df2, by= 0 ) #left join merge(df1, df2, by= 0 , all. x = TRUE ) #outerjoin merge(df1, df2, by= 0 , all= TRUE ) By=0 arg\u00fcman\u0131n\u0131 kullanarak R’ye veri bloklar\u0131n\u0131n sat\u0131r adlar\u0131n\u0131 kullanarak birle\u015ftirmek istedi\u011fimizi s\u00f6yleyebiliriz. A\u015fa\u011f\u0131daki \u00f6rnekler, […]<\/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-3058","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n #inner join<\/span>\nmerge(df1, df2, by= 0<\/span> )\n\n#left join<\/span>\nmerge(df1, df2, by= 0<\/span> , all. x<\/span> = TRUE<\/span> )\n\n#outerjoin<\/span>\nmerge(df1, df2, by= 0<\/span> , all= TRUE<\/span> )\n<\/strong><\/pre>\n #create first data frame\ndf1 <- data. frame<\/span> (points=c(99, 90, 86, 88, 95),\n assists=c(33, 28, 31, 39, 34))\n\nrownames(df1) <- c(1, 2, 3, 4, 5)\n\ndf1\n\n assist points\n1 99 33\n2 90 28\n3 86 31\n4 88 39\n5 95 34<\/span>\n\n#create second data frame\ndf2 <- data. frame<\/span> (rebounds=c(17, 15, 22, 26, 25),\n blocks=c(7, 7, 15, 12, 14))\n\nrownames(df2) <- c(3, 4, 5, 6, 7)\n\ndf2\n\n rebound blocks\n3 17 7\n4 15 7\n5 22 15\n6 26 12\n7 25 14\n<\/span><\/span><\/strong><\/pre>\n \u00d6rnek 1: Sat\u0131r adlar\u0131n\u0131 kullanarak i\u00e7 birle\u015ftirme ger\u00e7ekle\u015ftirin<\/strong><\/span><\/h3>\n
#perform inner join using row names<\/span>\nmerge(df1, df2, by= 0<\/span> )\n\n Row.names points assists rebounds blocks\n1 3 86 31 17 7\n2 4 88 39 15 7\n3 5 95 34 22 15\n<\/strong><\/span><\/pre>\n \u00d6rnek 2: Sat\u0131r adlar\u0131n\u0131 kullanarak sola birle\u015ftirme i\u015flemi ger\u00e7ekle\u015ftirin<\/strong><\/span><\/h3>\n
#perform left join using row names<\/span>\nmerge(df1, df2, by= 0<\/span> , all. x<\/span> = TRUE<\/span> )\n\n Row.names points assists rebounds blocks\n1 1 99 33 NA NA\n2 2 90 28 NA NA\n3 3 86 31 17 7\n4 4 88 39 15 7\n5 5 95 34 22 15\n<\/strong><\/span><\/pre>\n \u00d6rnek 3: Sat\u0131r adlar\u0131n\u0131 kullanarak d\u0131\u015f birle\u015ftirme ger\u00e7ekle\u015ftirin<\/strong><\/span><\/h3>\n
#perform outer join using row names<\/span>\nmerge(df1, df2, by= 0<\/span> , all= TRUE<\/span> )\n\n Row.names points assists rebounds blocks\n1 1 99 33 NA NA\n2 2 90 28 NA NA\n3 3 86 31 17 7\n4 4 88 39 15 7\n5 5 95 34 22 15\n6 6 NA NA 26 12\n7 7 NA NA 25 14\n<\/strong><\/span><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
R’de D\u00dc\u015eEYARA nas\u0131l yap\u0131l\u0131r<\/a>
R’de veri \u00e7er\u00e7evesine sat\u0131rlar nas\u0131l eklenir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"