{"id":3477,"date":"2023-07-17T07:04:18","date_gmt":"2023-07-17T07:04:18","guid":{"rendered":"https:\/\/statorials.org\/tr\/dplyr-kopyalari-bulma\/"},"modified":"2023-07-17T07:04:18","modified_gmt":"2023-07-17T07:04:18","slug":"dplyr-kopyalari-bulma","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/dplyr-kopyalari-bulma\/","title":{"rendered":"Dplyr kullanarak yinelenen \u00f6\u011feler nas\u0131l bulunur?"},"content":{"rendered":"

<\/p>\n

\n

Dplyr kullanarak bir veri \u00e7er\u00e7evesindeki yinelenen \u00f6\u011feleri bulmak i\u00e7in a\u015fa\u011f\u0131daki y\u00f6ntemleri kullanabilirsiniz:<\/span><\/p>\n

Y\u00f6ntem 1: T\u00fcm yinelenen sat\u0131rlar\u0131 g\u00f6ster<\/strong><\/span><\/p>\n

 library<\/span> (dplyr)\n\n#display all duplicate rows\n<\/span>df %>%\n  group_by_all() %>%\n  filter(n()> 1<\/span> ) %>%\n  A group()<\/strong><\/pre>\n
 Y\u00f6ntem 2: T\u00fcm yinelenen sat\u0131rlar i\u00e7in yinelenenlerin say\u0131s\u0131n\u0131 g\u00f6ster<\/strong><\/span><\/p>\n
 library<\/span> (dplyr)<\/span>\n\n#display duplicate count for all duplicated rows\n<\/span>df %>%\n  add_count(col1, col2, col3) %>%\n  filter(n> 1<\/span> ) %>%\n  distinct()\n<\/span><\/span><\/strong><\/pre>\n
 Bu e\u011fitimde her y\u00f6ntemin pratikte a\u015fa\u011f\u0131daki veri \u00e7er\u00e7evesiyle nas\u0131l kullan\u0131laca\u011f\u0131 a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n
 #create data frame\n<\/span>df <- data. frame<\/span> (team=c('A', 'A', 'A', 'A', 'B', 'B', 'B', 'B'),\n                 position=c('G', 'G', 'F', 'F', 'G', 'G', 'F', 'F'),\n                 points=c(10, 10, 8, 14, 15, 15, 17, 17))\n\n#view data frame\n<\/span>df\n\n  team position points\n1 AG 10\n2 AG 10\n3AF 8\n4 AF 14\n5 BG 15\n6 BG 15\n7 BF 17\n8 BF 17\n<\/strong><\/span><\/pre>\n
 \u00d6rnek 1: T\u00fcm yinelenen sat\u0131rlar\u0131 g\u00f6ster<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, veri \u00e7er\u00e7evesindeki t\u00fcm yinelenen sat\u0131rlar\u0131n nas\u0131l g\u00f6r\u00fcnt\u00fclenece\u011fini g\u00f6sterir:<\/span><\/p>\n
 library<\/span> (dplyr)<\/span>\n\n#display all duplicate rows in data frame\ndf %>%\n  group_by_all() %>%\n  filter(n()> 1<\/span> ) %>%\n  A group()\n\n# A tibble: 6 x 3\n  team position points\n        \n1 AG 10\n2 AG 10\n3 BG 15\n4 BG 15\n5 BF 17\n6 BF 17<\/span><\/span><\/strong><\/pre>\n
 Sonu\u00e7, her biri yinelenen sat\u0131r olan 6 sat\u0131r i\u00e7eren bir veri \u00e7er\u00e7evesidir.<\/span><\/p>\n
 Not<\/strong> : Yaln\u0131zca belirli s\u00fctunlarda hangi sat\u0131rlar\u0131n yinelenen de\u011ferlere sahip oldu\u011funu bilmek istiyorsan\u0131z, yaln\u0131zca ekip<\/strong> s\u00fctununda yinelenen de\u011ferlere sahip sat\u0131rlar\u0131 bulmak yerine group_by(team)<\/strong> gibi bir \u015fey kullanabilirsiniz.<\/span><\/p>\n
 \u00d6rnek 2: T\u00fcm yinelenen sat\u0131rlar i\u00e7in yinelenenlerin say\u0131s\u0131n\u0131 g\u00f6sterin<\/strong><\/span><\/h2>\n
 A\u015fa\u011f\u0131daki kod, veri \u00e7er\u00e7evesindeki t\u00fcm yinelenen sat\u0131rlar i\u00e7in yinelenen say\u0131n\u0131n nas\u0131l g\u00f6r\u00fcnt\u00fclenece\u011fini g\u00f6sterir:<\/span><\/p>\n
 library<\/span> (dplyr)\n\n#display duplicate count for each row\n<\/span>df %>%\n  add_count(team, position, points) %>%\n  filter(n> 1<\/span> ) %>%\n  distinct()\n\n  team position points n\n1 GA 10 2\n2 BG 15 2\n3 BF 17 2<\/strong><\/span><\/pre>\n
 S\u00fctun n,<\/strong> her sat\u0131r i\u00e7in toplam kopya say\u0131s\u0131n\u0131 g\u00f6r\u00fcnt\u00fcler.<\/span><\/span><\/p>\n
 \u00d6rne\u011fin:<\/span><\/p>\n