I have a data frame like below, I want to check if for same id we have duplicate name.
and then mutate a new column.
df10 <- data.frame(id=c(9143,2357,4339,8927,9143,4285,2683,8217,3702,7857,3255,4262,8501,7111,2681,6970), name=c("xly,mnn","xab,Lan","mhy,mun","vgtu,mmc","ftu,sdh","kull,nnhu","hula,njam","mund,jiha","htfy,ntha","sghu,njui","sgyu,hytb","vdti,kula","mftyu,huta","mhuk,ghul","cday,bhsue","ajtu,nudj"))
the output should be like
| id |
name |
duplicate_name |
| 9143 |
xly,mnn |
1 |
| 2357 |
xab,Lan |
0 |
| 4339 |
mhy,mun |
0 |
| 8927 |
vgtu,mmc |
0 |
| 9143 |
ftu,sdh |
1 |
| 4285 |
kull,nnhu |
0 |
| 2683 |
hula,njam |
0 |
| 8217 |
mund,jiha |
0 |
| 3702 |
htfy,ntha |
0 |
| 7857 |
sghu,njui |
0 |
| 3255 |
sgyu,hytb |
0 |
| 4262 |
vdti,kula |
0 |
| 8501 |
mftyu,huta |
0 |
| 7111 |
mhuk,ghul |
0 |
| 2681 |
cday,bhsue |
0 |
| 6970 |
ajtu,nudj |
0 |