<\/p>\n
Veri temizleme,<\/strong> ham verilerin<\/a> analize veya model olu\u015fturmaya uygun verilere d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi s\u00fcrecini ifade eder.<\/span><\/p>\n \u00c7o\u011fu durumda, bir veri k\u00fcmesini “temizlemek”, eksik de\u011ferlerle ve yinelenen verilerle u\u011fra\u015fmay\u0131 i\u00e7erir.<\/span><\/p>\n R’de bir veri k\u00fcmesini “temizlemek” i\u00e7in en yayg\u0131n y\u00f6ntemler \u015funlard\u0131r:<\/span><\/p>\n Y\u00f6ntem 1: Eksik de\u011ferleri olan sat\u0131rlar\u0131 kald\u0131r\u0131n<\/strong><\/span><\/p>\n Y\u00f6ntem 2: Eksik de\u011ferleri ba\u015fka bir de\u011ferle de\u011fi\u015ftirin<\/strong><\/span><\/p>\n Y\u00f6ntem 3: Yinelenen Sat\u0131rlar\u0131 Kald\u0131rma<\/strong><\/span><\/p>\n A\u015fa\u011f\u0131daki \u00f6rnekler, \u00e7e\u015fitli basketbol oyuncular\u0131 hakk\u0131nda bilgi i\u00e7eren R’deki a\u015fa\u011f\u0131daki veri \u00e7er\u00e7evesiyle bu y\u00f6ntemlerin her birinin pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6stermektedir:<\/span><\/p>\n Herhangi bir s\u00fctunda eksik de\u011ferleri olan sat\u0131rlar\u0131 kald\u0131rmak i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/p>\n Yeni veri \u00e7er\u00e7evesinin eksik de\u011ferleri olan herhangi bir sat\u0131r i\u00e7ermedi\u011fini unutmay\u0131n.<\/span><\/p>\n Eksik de\u011ferleri her s\u00fctunun medyan de\u011feriyle de\u011fi\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/p>\n Her say\u0131sal s\u00fctundaki eksik de\u011ferlerin her birinin, s\u00fctunun medyan de\u011feriyle de\u011fi\u015ftirildi\u011fini unutmay\u0131n.<\/span><\/p>\n Eksik de\u011ferleri her s\u00fctunun ortalama de\u011feriyle de\u011fi\u015ftirmek i\u00e7in form\u00fcldeki medyan\u0131<\/strong> ortalamayla<\/strong> da de\u011fi\u015ftirebilece\u011finizi unutmay\u0131n.<\/span><\/p>\n Not<\/strong> : Drop_na()<\/strong> i\u015flevi o paketten geldi\u011finden bu \u00f6rnekte Tidyr<\/strong> paketini de y\u00fcklememiz gerekti.<\/span><\/p>\n Eksik de\u011ferleri her s\u00fctunun medyan de\u011feriyle de\u011fi\u015ftirmek i\u00e7in a\u015fa\u011f\u0131daki s\u00f6zdizimini kullanabiliriz:<\/span><\/p>\n \u0130kinci sat\u0131rdaki de\u011ferlerin her biri, birinci sat\u0131rdaki de\u011ferlerin kopyas\u0131 oldu\u011fundan, ikinci sat\u0131r\u0131n veri \u00e7er\u00e7evesinden kald\u0131r\u0131ld\u0131\u011f\u0131n\u0131 unutmay\u0131n.<\/span><\/p>\n Not<\/strong> : dplyr Different()<\/strong> i\u015flevine ili\u015fkin t\u00fcm belgeleri burada<\/a> bulabilirsiniz.<\/span><\/p>\n A\u015fa\u011f\u0131daki e\u011fitimlerde R’de di\u011fer ortak g\u00f6revlerin nas\u0131l ger\u00e7ekle\u015ftirilece\u011fi a\u00e7\u0131klanmaktad\u0131r:<\/span><\/p>\n R’de veriler nas\u0131l gruplan\u0131r ve \u00f6zetlenir<\/a> Veri temizleme, ham verilerin analize veya model olu\u015fturmaya uygun verilere d\u00f6n\u00fc\u015ft\u00fcr\u00fclmesi s\u00fcrecini ifade eder. \u00c7o\u011fu durumda, bir veri k\u00fcmesini “temizlemek”, eksik de\u011ferlerle ve yinelenen verilerle u\u011fra\u015fmay\u0131 i\u00e7erir. R’de bir veri k\u00fcmesini “temizlemek” i\u00e7in en yayg\u0131n y\u00f6ntemler \u015funlard\u0131r: Y\u00f6ntem 1: Eksik de\u011ferleri olan sat\u0131rlar\u0131 kald\u0131r\u0131n library (dplyr) #remove rows with any missing values df %>% na. […]<\/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-4178","post","type-post","status-publish","format-standard","hentry","category-rehber"],"yoast_head":"\n library<\/span> (dplyr)\n\n#remove rows with any missing values\n<\/span>df %>% na. omit<\/span> ()\n<\/strong><\/pre>\n library<\/span> (dplyr)\nlibrary<\/span> (tidyr)\n\n#replace missing values in each numeric column with median value of column\n<\/span>df %>% mutate(across(where(is. numeric<\/span> ), ~replace_na(., median(., na. rm<\/span> = TRUE<\/span> ))))\n<\/strong><\/pre>\n library<\/span> (dplyr)\n\ndf %>% distinct(. keep_all<\/span> = TRUE<\/span> )\n<\/strong><\/pre>\n #create data frame\n<\/span>df <- data. frame<\/span> (team=c('A', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I'),\n points=c(4, 4, NA, 8, 6, 12, 14, 86, 13, 8),\n rebounds=c(9, 9, 7, 6, 8, NA, 9, 14, 12, 11),\n assists=c(2, 2, NA, 7, 6, 6, 9, 10, NA, 14))\n\n#view data frame\n<\/span>df\n\n team points rebound assists\n1 to 4 9 2\n2 to 4 9 2\n3 B NA 7 NA\n4 C 8 6 7\n5 D 6 8 6\n6 E 12 NA 6\n7 F 14 9 9\n8 G 86 14 10\n9:13:12 NA\n10 I 8 11 14\n<\/strong><\/pre>\n \u00d6rnek 1: Eksik de\u011ferleri olan sat\u0131rlar\u0131 silin<\/strong><\/span><\/h2>\n
library<\/span> (dplyr)\n\n#remove rows with missing values\n<\/span>new_df <- df %>% na. omit<\/span> ()\n\n#view new data frame\n<\/span>new_df\n\n team points rebound assists\n1 to 4 9 2\n2 to 4 9 2\n4 C 8 6 7\n5 D 6 8 6\n7 F 14 9 9\n8 G 86 14 10\n10 I 8 11 14<\/strong><\/pre>\n \u00d6rnek 2: Eksik de\u011ferleri ba\u015fka bir de\u011ferle de\u011fi\u015ftirin<\/strong><\/span><\/h2>\n
library<\/span> (dplyr)\nlibrary<\/span> (tidyr)\n\n#replace missing values in each numeric column with median value of column\n<\/span>new_df <-df %>% mutate(across(where(is. numeric<\/span> ),~replace_na(.,median(.,na. rm<\/span> = TRUE<\/span> )))) \n\n#view new data frame\n<\/span>new_df\n\n team points rebound assists\n1 to 4 9 2.0\n2 to 4 9 2.0\n3 B 8 7 6.5\n4 C 8 6 7.0\n5 D 6 8 6.0\n6 E 12 9 6.0\n7 F 14 9 9.0\n8 G 86 14 10.0\n9:13 12 6.5\n10 I 8 11 14.0<\/strong><\/pre>\n \u00d6rnek 3: Yinelenen sat\u0131rlar\u0131 kald\u0131r\u0131n<\/strong><\/span><\/h2>\n
library<\/span> (dplyr)\n\n#remove duplicate rows\n<\/span>new_df <- df %>% distinct(. keep_all<\/span> = TRUE<\/span> )\n\n#view new data frame\n<\/span>new_df\n\n team points rebound assists\n1 to 4 9 2\n2 B NA 7 NA\n3 C 8 6 7\n4 D 6 8 6\n5 E 12 NA 6\n6 F 14 9 9\n7 G 86 14 10\n8:13:12 NA\n9 I 8 11 14<\/strong><\/pre>\n Ek kaynaklar<\/strong><\/span><\/h2>\n
R’de \u00f6zet tablolar nas\u0131l olu\u015fturulur<\/a>
R’de eksik de\u011ferleri olan sat\u0131rlar nas\u0131l silinir<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"