<\/p>\n
Bir veri \u00e7er\u00e7evesindeki, ba\u015fka bir veri \u00e7er\u00e7evesinde e\u015fle\u015fen de\u011ferlere sahip olmayan t\u00fcm sat\u0131rlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in R’deki dplyr<\/a> paketindeki anti_join()<\/strong> fonksiyonunu kullanabilirsiniz.<\/span><\/p>\n Bu i\u015flev a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullan\u0131r:<\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir.<\/span><\/p>\n R’de a\u015fa\u011f\u0131daki iki veri \u00e7er\u00e7evesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span><\/p>\n \u0130kinci veri \u00e7er\u00e7evesinde e\u015fle\u015fen bir tak\u0131m bulunmayan ilk veri \u00e7er\u00e7evesindeki t\u00fcm sat\u0131rlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in anti_join()<\/strong> i\u015flevini kullanabiliriz:<\/span><\/p>\n \u0130lk veri \u00e7er\u00e7evesinden, ikinci veri \u00e7er\u00e7evesinde e\u015fle\u015fen bir tak\u0131m ad\u0131na sahip olmayan tam olarak iki tak\u0131m\u0131n oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n R’de a\u015fa\u011f\u0131daki iki veri \u00e7er\u00e7evesine sahip oldu\u011fumuzu varsayal\u0131m:<\/span><\/p>\n \u0130lk veri \u00e7er\u00e7evesindeki e\u015fle\u015fen bir tak\u0131ma ve<\/em> ikinci veri \u00e7er\u00e7evesindeki konuma sahip olmayan t\u00fcm sat\u0131rlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in anti_join()<\/strong> i\u015flevini kullanabiliriz:<\/span><\/p>\n \u0130lk veri \u00e7er\u00e7evesinden, ikinci veri \u00e7er\u00e7evesinde e\u015fle\u015fen bir tak\u0131m ad\u0131 ve<\/em> konumu olmayan tam olarak iki kay\u0131t oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde dplyr’de di\u011fer yayg\u0131n i\u015flevlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n Dplyr kullanarak dizine g\u00f6re s\u00fctunlar nas\u0131l se\u00e7ilir<\/a> Bir veri \u00e7er\u00e7evesindeki, ba\u015fka bir veri \u00e7er\u00e7evesinde e\u015fle\u015fen de\u011ferlere sahip olmayan t\u00fcm sat\u0131rlar\u0131 d\u00f6nd\u00fcrmek i\u00e7in R’deki dplyr paketindeki anti_join() fonksiyonunu kullanabilirsiniz. Bu i\u015flev a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullan\u0131r: anti_join(df1, df2, by= ‘ col_name ‘) A\u015fa\u011f\u0131daki \u00f6rnekler bu s\u00f6zdiziminin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir. \u00d6rnek 1: Bir s\u00fctunla anti_join() i\u015flevini kullanma R’de a\u015fa\u011f\u0131daki iki veri \u00e7er\u00e7evesine sahip oldu\u011fumuzu […]<\/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-2126","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n anti_join(df1, df2, by= ' col_name<\/span> ')<\/span>\n<\/strong><\/pre>\n \u00d6rnek 1: Bir s\u00fctunla anti_join() i\u015flevini kullanma<\/strong><\/span><\/h3>\n
#create data frames<\/span>\ndf1 <- data. frame<\/span> (team=c('A', 'B', 'C', 'D', 'E'),\n dots=c(12, 14, 19, 24, 36))\n\ndf2 <- data. frame<\/span> (team=c('A', 'B', 'C', 'F', 'G'),\n dots=c(12, 14, 19, 33, 17))<\/strong><\/pre>\n library<\/span> (dplyr)<\/span>\n\n#perform anti join using 'team' column<\/span>\nanti_join(df1, df2, by=' team<\/span> ')\n\n team points\n1 D 24\n2 E 36\n<\/strong><\/pre>\n \u00d6rnek 2: Birden fazla s\u00fctunla anti_join() i\u015flevini kullanma<\/strong><\/span><\/h3>\n
#create data frames<\/span>\ndf1 <- data. frame<\/span> (team=c('A', 'A', 'A', 'B', 'B', 'B'),\n position=c('G', 'G', 'F', 'G', 'F', 'C'),\n dots=c(12, 14, 19, 24, 36, 41))\n\ndf2 <- data. frame<\/span> (team=c('A', 'A', 'A', 'B', 'B', 'B'),\n position=c('G', 'G', 'C', 'G', 'F', 'F'),\n dots=c(12, 14, 19, 33, 17, 22))<\/strong><\/pre>\n library<\/span> (dplyr)<\/span>\n\n#perform anti join using 'team' and 'position' columns<\/span>\nanti_join(df1, df2, by=c(' team<\/span> ', ' position<\/span> '))\n\n team position points\n1 FY 19\n2 BC 41\n<\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h3>\n
Dplyr kullanarak birden fazla veri \u00e7er\u00e7evesi nas\u0131l birle\u015ftirilir<\/a>
Belirli bir dizeyi i\u00e7eren sat\u0131rlar\u0131 dplyr kullanarak nas\u0131l filtreleyebilirim?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"