Omit rows containing specific column of NA

Question

I want to know how to omit NA values in a data frame  but only in some columns I am interested in   For example   DF  lt - data frame x   c 1  2  3   y   c 0  10  NA   z c NA  33  22     but I only want to omit the data where y is NA  therefore the result should be    x  y  z 1 1  0 NA 2 2 10 33   na omit seems delete all rows contain any NA   Can somebody help me out of this simple question   But if now I change the question like   DF  lt - data frame x   c 1  2  3 NA   y   c 1 0  10  NA   z c 43 NA  33  NA     If I want to omit only x na or z na  where can I put the   in function

User · Answer

Just try this  DF   gt   t   gt   na omit   gt   t  It transposes the data frame and omits null rows which were  columns  before transposition and then you transpose it back

User · Answer

Use is na  DF  lt - data frame x   c 1  2  3   y   c 0  10  NA   z c NA  33  22   DF  is na DF y

User · Answer

Omit row if either of two specific columns contain  lt NA gt    DF  is na DF x  amp  is na DF z

User · Answer

Try this   cc is na DF y  m which cc  c  TRUE    DF DF -m

User · Answer

Use  subset   DF  lt - data frame x   c 1  2  3   y   c 0  10  NA   z c NA  33  22   subset DF   is na y

User · Answer

You could use the complete cases function and put it into a function thusly   DF  lt - data frame x   c 1  2  3   y   c 0  10  NA   z c NA  33  22    completeFun  lt - function data  desiredCols      completeVec  lt - complete cases data   desiredCols     return data completeVec        completeFun DF   y       x  y  z   1 1  0 NA   2 2 10 33  completeFun DF  c  y    z        x  y  z   2 2 10 33   EDIT  Only return rows with no NAs  If you want to eliminate all rows with at least one NA in any column  just use the complete cases function straight up   DF complete cases DF         x  y  z   2 2 10 33   Or if completeFun is already ingrained in your workflow     completeFun DF  names DF

User · Answer

Hadley s tidyr just got this amazing function drop na  library tidyr  DF   gt   drop na y    x  y  z 1 1  0 NA 2 2 10 33

User · Answer

It is possible to use na omit for data table  na omit data  cols   c  quot x quot    quot z quot

[r] Omit rows containing specific column of NA

Examples related to r

Examples related to dataframe

Examples related to na