Delete rows with blank values in one particular column

Question

I am working on a large dataset  with some rows with NAs and others with blanks   df  lt - data frame ID   c 1 7                                               home pc   c     CB4 2DT    NE5 7TH    BY5 8IB    DH4 6PB   MP9 7GH   KN4 5GH                            start pc   c NA  Home    FC5 7YH   Home    CB3 5TH    BV6 5PB  NA                           end pc   c NA  CB5 4FG   Home      Home     NA     How do I remove the NAs and blanks in one go  in the start pc and end pc columns    I have in the past used   df lt - df -which is na df start pc            to remove the NAs - is there a similar command to remove the blanks

User · Answer

An easy approach would be making all the blank cells NA and only keeping complete cases  You might also look for na omit examples  It is a widely discussed topic   df df      lt -NA df lt -df complete cases df

User · Answer

df   is na df start pc    df start pc

User · Answer

Alternative solution can be to remove the rows with blanks in one variable    df  lt - subset df  VAR

User · Answer

An elegant solution with dplyr would be   df   gt       recode empty strings    by NAs   na if       gt       remove NAs   na omit

User · Answer

It is the same construct - simply test for empty strings rather than NA   Try this   df  lt - df -which df start pc             In fact  looking at your code  you don t need the which  but use the negation instead  so you can simplify it to   df  lt - df   df start pc           df  lt - df  is na df start pc       And  of course  you can combine these two statements as follows   df  lt - df   df start pc         is na df start pc        And simplify it even further with with   df  lt - with df  df   start pc         is na start pc         You can also test for non-zero string length using nzchar   df  lt - with df  df   nzchar start pc    is na start pc           Disclaimer  I didn t test any of this code  Please let me know if there are syntax errors anywhere

[r] Delete rows with blank values in one particular column

Examples related to r

Examples related to dataframe

Examples related to missing-data