How to remove all rows that have a numeric in the first (or any) column
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 at 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.