Hi,
Try:
Df1[duplicated(Df1),]
?Df1[duplicated(Df1,fromLast=TRUE),]
A.K.
----- Original Message -----
From: Arnaud Michel <michel.arnaud at cirad.fr>
To: R help <r-help at r-project.org>
Cc:
Sent: Tuesday, September 17, 2013 2:14 PM
Subject: [R] delete some lines of a dataframe
Hi
I have a dataframe Df1
dput(Df1)
structure(list(Mat = c(141, 141, 157, 157, 188, 188, 232, 232,
253, 253, 253, 254, 254, 254, 254, 256, 256, 264, 264), Prenom =
c("Pierre",
"Pierre", "Jean-Claude", "Jean-Claude",
"Jean-Louis", "Jean-Louis",
"Philippe", "Philippe", "Christophe",
"Christophe", "Christophe",
"Dominique", "Dominique", "Dominique",
"Dominique", "Pierre-Luc",
"Pierre-Luc", "Alain", "Alain"), Sexe =
c("Masculin", "Masculin",
"Masculin", "Masculin", "Masculin",
"Masculin", "Masculin", "Masculin",
"Masculin", "Masculin", "Masculin",
"Masculin", "Masculin", "Masculin",
"Masculin", "Masculin", "Masculin",
"Masculin", "Masculin"),
? ? DateNais = c("23/08/1946", "23/08/1946",
"11/08/1945", "11/08/1945",
? ? "09/04/1948", "09/04/1948", "01/05/1946",
"01/05/1946", "11/02/1951",
? ? "11/02/1951", "11/02/1951", "21/10/1949",
"21/10/1949", "21/10/1949",
? ? "21/10/1949", "25/06/1946", "25/06/1946",
"13/03/1949", "13/03/1949"
? ? )), .Names = c("Mat", "Prenom", "Sexe",
"DateNais"), row.names = c("207",
"208", "232", "233", "288",
"289", "373", "374", "412",
"413",
"414", "415", "416", "417",
"418", "420", "421", "436",
"437"
), class = "data.frame")
I want to extract of Df1 2 other dataframes :
1) delete the first line for each values of Mat
? ? ? Mat? ? ? Prenom? ? Sexe? DateNais
208 141? ? ? Pierre Masculin 23/08/1946
233 157 Jean-Claude Masculin 11/08/1945
289 188? Jean-Louis Masculin 09/04/1948
374 232? ? Philippe Masculin 01/05/1946
413 253? Christophe Masculin 11/02/1951
414 253? Christophe Masculin 11/02/1951
416 254? Dominique Masculin 21/10/1949
417 254? Dominique Masculin 21/10/1949
418 254? Dominique Masculin 21/10/1949
421 256? Pierre-Luc Masculin 25/06/1946
437 264? ? ? Alain Masculin 13/03/1949
2) delete the last line for each values of Mat
? ? Mat? ? ? Prenom? ? Sexe? DateNais
207 141? ? ? Pierre Masculin 23/08/1946
232 157 Jean-Claude Masculin 11/08/1945
288 188? Jean-Louis Masculin 09/04/1948
373 232? ? Philippe Masculin 01/05/1946
412 253? Christophe Masculin 11/02/1951
413 253? Christophe Masculin 11/02/1951
415 254? Dominique Masculin 21/10/1949
416 254? Dominique Masculin 21/10/1949
417 254? Dominique Masculin 21/10/1949
420 256? Pierre-Luc Masculin 25/06/1946
436 264? ? ? Alain Masculin 13/03/1949
Any ideas ?
-- Michel ARNAUD
Charg? de mission aupr?s du DRH
DGDRD-Drh - TA 174/04
Av Agropolis 34398 Montpellier cedex 5
tel : 04.67.61.75.38
fax : 04.67.61.57.87
port: 06.47.43.55.31
______________________________________________
R-help at r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.