An atomic column of data by design has exactly one mode, so if _any_ values are non-numeric then the entire column will be non-numeric. What does
str(VPN_Sheet1$HVA) tell you? It is likely either a factor or character data. On September 14, 2021 7:01:53 PM PDT, Gregg Powell via R-help <r-help@r-project.org> wrote: > > > >> Stuck on this problem - How does one remove all rows in a dataframe that >> have a numeric in the first (or any) column? >> > >> Seems straight forward - but I'm having trouble. >> > > >I've attempted to used: > >VPN_Sheet1 <- VPN_Sheet1[!is.numeric(VPN_Sheet1$HVA),] > >and > >VPN_Sheet1 <- VPN_Sheet1[!is.integer(VPN_Sheet1$HVA),] > >Neither work - Neither throw an error. > >class(VPN_Sheet1$HVA) returns: >[1] "list" > >So, the HVA column returns a list. > >> >> Data looks like the attached screen grab - >> > >> The ONLY rows I need to delete are the rows where there is a numeric in the >> HVA column. >> > >> There are some 5000+ rows in the actual data. >> > >> Would be grateful for a solution to this problem. > >How to get R to detect whether the value in column 1 is a number so the rows >with the number values can be deleted? >> > >> Thanks in advance to any and all willing to help on this problem. >> > >> Gregg Powell >> > >> Sierra Vista, AZ -- Sent from my phone. Please excuse my brevity. ______________________________________________ R-help@r-project.org mailing list -- To UNSUBSCRIBE and more, see 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.
