R：根据特定模式删除基于不同值的行 [英] R: Delete rows based on different values following a certain pattern

问题描述

我有以下数据集，我想删除包含值NA的所有行; NA; NA;我该怎么做？

I have the following dataset and I'd like to delete all the rows which contain the values NA; NA; NA; 0. How can I do that?

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

推荐答案

您可以尝试：

  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

这篇关于R：根据特定模式删除基于不同值的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！