R:根据某一模式的不同值删除行

Question

我有以下数据集，我想删除所有包含NA；0值的行。我怎么能这么做？

NAME;   ID;     REFERENCE_YEAR; VALUE
NA;     NA;     NA;             0
ABANO;  767;    1859;           0
ABANO;  767;    1860;           -380
ABANO;  767;    1910;           47
NA;     NA;     NA;             0
ADAMS;  885;    1987;           0
ADAMS;  885;    1988;           -2
ADAMS;  2923;   1997;           NA
ADAMS;  2923;   1999;           NA
ADAMS;  2923;   2000;           NA
ADAMS;  2923;   2002;           NA
ADAMS;  2923;   2007;           NA
ADAMS;  2923;   2008;          -17
NA;     NA;     NA;             0
AEU.PIRCHLKAR;  504;    1981;   0
NA;     NA;     NA;             0
NA;     NA;     NA;             0

Answer 1

你可以试试：

  df[!(rowSums(is.na(df[,1:3]))==3 &!df[,4]),]
  #             NAME   ID REFERENCE_YEAR VALUE
  # 2          ABANO  767           1859     0
  # 3          ABANO  767           1860  -380
  # 4          ABANO  767           1910    47
  # 6          ADAMS  885           1987     0
  # 7          ADAMS  885           1988    -2
  # 8          ADAMS 2923           1997    NA
  # 9          ADAMS 2923           1999    NA
  # 10         ADAMS 2923           2000    NA
  # 11         ADAMS 2923           2002    NA
  # 12         ADAMS 2923           2007    NA
  # 13         ADAMS 2923           2008   -17
  # 15 AEU.PIRCHLKAR  504           1981     0

Answer 2

假设使用sep=读取数据“”

df[!apply(df,1,paste,collapse="")=="NA;NA;NA;0;",]