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

[Gregg Powell]

Here is the output:

> str(VPN_Sheet1$HVA)
List of 2174
 $ : chr "Email: fffd using fffffffffff.com"
 $ : num 1
 $ : chr "Eloisa Libas"
 $ : chr "Percival Esquejo"
 $ : chr "Louchelle Singh"
 $ : num 2
 $ : chr "Charisse Anne Tabarno, RN"
 $ : chr "Sol Amor Mucoy"
 $ : chr "Josan Moira Paler"
 $ : num 3
 $ : chr "Anna Katrina V. Alberto"
 $ : chr "Nenita Velarde"
 $ : chr "Eunice Arrances"
 $ : num 4
 $ : chr "Catherine Henson"
 $ : chr "Maria Carla Daya"
 $ : chr "Renee Ireine Alit"
 $ : num 5
 $ : chr "Marol Joseph Domingo - PS"
 $ : chr "Kissy Andrea Arriesgado"
 $ : chr "Pia B Baluyut, RN"
 $ : num 6
 $ : chr "Gladys Joy Tan"
 $ : chr "Frances Zarzua"
 $ : chr "Fairy Jane Nery"
 $ : num 7
 $ : chr "Gladys Tijam, RMT"
 $ : chr "Sarah Jane Aramburo"
 $ : chr "Eve Mendoza"
 $ : num 8
 $ : chr "Gloria Padolino"
 $ : chr "Joyce Pearl Javier"
 $ : chr "Ayza Padilla"
 $ : num 9
 $ : chr "Walfredson Calderon"
 $ : chr "Stephanie Anne Militante"
 $ : chr "Rennua Oquilan"
 $ : num 10
 $ : chr "Neil John Nery"
 $ : chr "Maria Reyna Reyes"
 $ : chr "Rowella Villegas"
 $ : num 11
 $ : chr "Katelyn Mendiola"
 $ : chr "Maria Riza Mariano"
 $ : chr "Marie Vallianne Carantes"
 $ : num 12

‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐‐

On Tuesday, September 14th, 2021 at 8:32 PM, Jeff Newmiller <jdnewmil using dcn.davis.ca.us> wrote:

> 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.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 509 bytes
Desc: OpenPGP digital signature
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20210915/678b14a1/attachment.sig>