I have a table like below and I want to find duplicates values in few columns . so finding duplicate is working but if any is coming thrice or four time then every time it should show duplicate.
df <- data.frame(ID =c("DEV2962","KTN2252","KTN2252","ANA2548","DEV2698","HRT2921",NA,"KTN2624","ANA2548","ITI2535","DEV2732","HRT2837","ANA2548","KTN2542","ANA2813","ITI2210"),
city=c("del","mum","nav","pun","bang","chen","triv","vish","del","mum","bang","vish","bhop","kol","noi","gurg"),
Name= c("dev,akash","singh,rahul","abbas,salman","lal,ram","singh,nkunj","sharma,nikita","ali,sarman","singh,kunal","tomar,lakhan","thakur,praveen","ali,sarman","khan,zuber","singh,giriraj","sharma,lokesh","sharma,nikita","sharma,nikita"))
colss <- c("ID","Name")
df <- df %>% mutate(
across(.cols= colss,
.fns = duplicated,
.names = "{c(1,9)}. unique {col}"))
The output should show all values as if it comes more than once.
ID | city | Name | 1. duplicate_id | 9. duplicate_Name |
---|---|---|---|---|
DEV2962 | del | dev,akash | ||
KTN2252 | mum | singh,rahul | duplicate_id | |
KTN2252 | nav | abbas,salman | duplicate_id | |
ANA2548 | pun | lal,ram | duplicate_id | |
DEV2698 | bang | singh,nkunj | ||
HRT2921 | chen | sharma,nikita | duplicate_name | |
triv | ali,sarman | duplicate_name | ||
KTN2624 | vish | singh,kunal | ||
ANA2548 | del | tomar,lakhan | duplicate_id | |
ITI2535 | mum | thakur,praveen | ||
DEV2732 | bang | ali,sarman | duplicate_name | |
HRT2837 | vish | khan,zuber | ||
ANA2548 | bhop | singh,giriraj | duplicate_id | |
KTN2542 | kol | sharma,lokesh | ||
ANA2813 | noi | sharma,nikita | duplicate_name | |
ITI2210 | gurg | sharma,nikita | duplicate_name |