[R] How to remove all rows that have a numeric in the first (or any) column

[Jeff Newmiller]

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 using 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.