Gregg Powell
2021-Sep-15 03:38 UTC
[R] How to remove all rows that have a numeric in the first (or any) column
Here is the output:> str(VPN_Sheet1$HVA)List of 2174 $ : chr "Email: fffd at 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 at 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 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.-------------- 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>
Andrew Simmons
2021-Sep-15 03:48 UTC
[R] How to remove all rows that have a numeric in the first (or any) column
'is.numeric' is a function that returns whether its input is a numeric vector. It looks like what you want to do is VPN_Sheet1 <- VPN_Sheet1[!vapply(VPN_Sheet1$HVA, "is.numeric", NA), ] instead of VPN_Sheet1 <- VPN_Sheet1[!is.numeric(VPN_Sheet1$HVA), ] I hope this helps, and see ?vapply if necessary. On Tue, Sep 14, 2021 at 11:42 PM Gregg Powell via R-help < r-help at r-project.org> wrote:> Here is the output: > > > str(VPN_Sheet1$HVA) > List of 2174 > $ : chr "Email: fffd at 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 at 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 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.______________________________________________ > R-help at 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. >[[alternative HTML version deleted]]
Jeff Newmiller
2021-Sep-15 03:54 UTC
[R] How to remove all rows that have a numeric in the first (or any) column
You cannot apply vectorized operators to list columns... you have to use a map function like sapply or purrr::map_lgl to obtain a logical vector by running the function once for each list element: sapply( VPN_Sheet1$HVA, is.numeric ) On September 14, 2021 8:38:35 PM PDT, Gregg Powell <g.a.powell at protonmail.com> wrote:>Here is the output: > >> str(VPN_Sheet1$HVA) >List of 2174 > $ : chr "Email: fffd at 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 at 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 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.-- Sent from my phone. Please excuse my brevity.