Re: [R] How to remove all rows that have a numeric in the first (or any) column
Lots of feedback on this. Will have to take some time after work today to
digest some of the more complex answers. Just wanted to say thank you though,
to all who took time to provide feedback. I'm very grateful.
I'll likely be back with a few additional questions.
Regards
Gregg
Sierra Vista, AZ
Sent from ProtonMail mobile
\ Original Message
On Sep 14, 2021, 22:43, Jeff Newmiller < jdnew...@dcn.davis.ca.us> wrote:
>
>
>
> FWIW I use them quite frequently, but not for the purpose of storing
> heterogeneous data... rather for holding complex objects of the same class.
>
> On September 14, 2021 10:25:54 PM PDT, Avi Gross via R-help
> wrote:
> >My apologies. My reply was to Andrew, not Gregg.
> >
> >Enough damage for one night. Here is hoping we finally understood a question
> >that could have been better phrased. list columns are not normally
> >considered common data structures but quite possibly will be more as time
> >goes on and the tools to handle them become better or at least better
> >understood.
> >
> >
> >-Original Message-
> >From: R-help On Behalf Of Avi Gross via R-help
> >Sent: Wednesday, September 15, 2021 1:23 AM
> >To: R-help@r-project.org
> >Subject: Re: \[R\] How to remove all rows that have a numeric in the first
> >(or any) column
> >
> >You are correct, Gregg, I am aware of that trick of asking something to not
> >be evaluated in certain ways.
> >
> >
> >
> >And you can indeed use base R to play with contents of beta as defined
> >above. Here is a sort of incremental demo:
> >
> >
> >
> >> sapply(mydf$beta, is.numeric)
> >
> >\[1\] FALSE TRUE TRUE FALSE
> >
> >> !sapply(mydf$beta, is.numeric)
> >
> >\[1\] TRUE FALSE FALSE TRUE
> >
> >> keeping <- !sapply(mydf$beta, is.numeric)
> >
> >> mydf\[keeping, \]
> >
> >\# A tibble: 2 x 2
> >
> >alpha beta
> >
> >
> >
> > 1 1
> >
> > 2 4
> >
> > > str(mydf\[keeping, \])
> >
> >tibble \[2 x 2\] (S3: tbl\_df/tbl/data.frame)
> >
> >$ alpha: int \[1:2\] 1 4
> >
> >$ beta :List of 2
> >
> >..$ : chr "Hello"
> >
> >..$ : chr "bye"
> >
> >
> >
> >Now for the bad news. The original request was for ANY column. But
> >presumably one way to do it, neither efficiently nor the best, would be to
> >loop on the names of all the columns and starting with the original
> >data.frame, whittle away at it column by column and adjust which column you
> >search each time until what is left had nothing numeric anywhere.
> >
> >
> >
> >Now if I was using dplyr, I wonder if there is a nice way to use rowwise()
> >to evaluate across a row.
> >
> >
> >
> >Using your technique I made the following data.frame:
> >
> >
> >
> >mydf <- data.frame(alpha=I(list("first", 2, 3.3, "Last")),
> >
> > beta=I(list(1, "second", 3.3, "Lasting")))
> >
> >
> >
> >> mydf
> >
> >alpha beta
> >
> >1 first 1
> >
> >2 2 second
> >
> >3 3.3 3.3
> >
> >4 Last Lasting
> >
> >
> >
> >Do we agree only the fourth row should be kept as the others have one or two
> >numeric values?
> >
> >
> >
> >Here is some code I cobbled together that seems to work:
> >
> >
> >
> >
> >
> >rowwise(mydf) %>%
> >
> > mutate(alphazoid=!is.numeric(unlist(alpha)),
> >
> > betazoid=!is.numeric(unlist(beta))) %>%
> >
> > filter(alphazoid & betazoid) -> result
> >
> >
> >
> >str(result)
> >
> >print(result)
> >
> >result\[\[1,1\]\]
> >
> >result\[\[1,2\]\]
> >
> >
> >
> >as.data.frame(result)
> >
> >
> >
> >The results are shown below that only the fourth row was kept:
> >
> >
> >
> >> rowwise(mydf) %>%
> >
> > + mutate(alphazoid=!is.numeric(unlist(alpha)),
> >
> > + betazoid=!is.numeric(unlist(beta))) %>%
> >
> > + filter(alphazoid & betazoid) -> result
> >
> >>
> >
> > > str(result)
> >
> >rowwise\_df \[1 x 4\] (S3: rowwise\_df/tbl\_df/tbl/data.frame)
> >
> >$ alpha :List of 1
> >
> >..$ : chr "Last"
> >
> >..- attr(\*, "class")= chr "AsIs"
> >
> &
Re: [R] How to remove all rows that have a numeric in the first (or any) column
FWIW I use them quite frequently, but not for the purpose of storing
heterogeneous data... rather for holding complex objects of the same class.
On September 14, 2021 10:25:54 PM PDT, Avi Gross via R-help
wrote:
>My apologies. My reply was to Andrew, not Gregg.
>
>Enough damage for one night. Here is hoping we finally understood a question
>that could have been better phrased. list columns are not normally considered
>common data structures but quite possibly will be more as time goes on and the
>tools to handle them become better or at least better understood.
>
>
>-Original Message-
>From: R-help On Behalf Of Avi Gross via R-help
>Sent: Wednesday, September 15, 2021 1:23 AM
>To: R-help@r-project.org
>Subject: Re: [R] How to remove all rows that have a numeric in the first (or
>any) column
>
>You are correct, Gregg, I am aware of that trick of asking something to not be
>evaluated in certain ways.
>
>
>
>And you can indeed use base R to play with contents of beta as defined above.
>Here is a sort of incremental demo:
>
>
>
>> sapply(mydf$beta, is.numeric)
>
>[1] FALSE TRUE TRUE FALSE
>
>> !sapply(mydf$beta, is.numeric)
>
>[1] TRUE FALSE FALSE TRUE
>
>> keeping <- !sapply(mydf$beta, is.numeric)
>
>> mydf[keeping, ]
>
># A tibble: 2 x 2
>
>alpha beta
>
>
>
> 1 1
>
> 2 4
>
> > str(mydf[keeping, ])
>
>tibble [2 x 2] (S3: tbl_df/tbl/data.frame)
>
>$ alpha: int [1:2] 1 4
>
>$ beta :List of 2
>
>..$ : chr "Hello"
>
>..$ : chr "bye"
>
>
>
>Now for the bad news. The original request was for ANY column. But presumably
>one way to do it, neither efficiently nor the best, would be to loop on the
>names of all the columns and starting with the original data.frame, whittle
>away at it column by column and adjust which column you search each time until
>what is left had nothing numeric anywhere.
>
>
>
>Now if I was using dplyr, I wonder if there is a nice way to use rowwise() to
>evaluate across a row.
>
>
>
>Using your technique I made the following data.frame:
>
>
>
>mydf <- data.frame(alpha=I(list("first", 2, 3.3, "Last")),
>
> beta=I(list(1, "second", 3.3, "Lasting")))
>
>
>
>> mydf
>
>alphabeta
>
>1 first 1
>
>2 2 second
>
>3 3.3 3.3
>
>4 Last Lasting
>
>
>
>Do we agree only the fourth row should be kept as the others have one or two
>numeric values?
>
>
>
>Here is some code I cobbled together that seems to work:
>
>
>
>
>
>rowwise(mydf) %>%
>
> mutate(alphazoid=!is.numeric(unlist(alpha)),
>
> betazoid=!is.numeric(unlist(beta))) %>%
>
> filter(alphazoid & betazoid) -> result
>
>
>
>str(result)
>
>print(result)
>
>result[[1,1]]
>
>result[[1,2]]
>
>
>
>as.data.frame(result)
>
>
>
>The results are shown below that only the fourth row was kept:
>
>
>
>> rowwise(mydf) %>%
>
> + mutate(alphazoid=!is.numeric(unlist(alpha)),
>
> + betazoid=!is.numeric(unlist(beta))) %>%
>
> + filter(alphazoid & betazoid) -> result
>
>>
>
> > str(result)
>
>rowwise_df [1 x 4] (S3: rowwise_df/tbl_df/tbl/data.frame)
>
>$ alpha:List of 1
>
>..$ : chr "Last"
>
>..- attr(*, "class")= chr "AsIs"
>
>$ beta :List of 1
>
>..$ : chr "Lasting"
>
>..- attr(*, "class")= chr "AsIs"
>
>$ alphazoid: logi TRUE
>
>$ betazoid : logi TRUE
>
>- attr(*, "groups")= tibble [1 x 1] (S3: tbl_df/tbl/data.frame)
>
>..$ .rows: list [1:1]
>
>.. ..$ : int 1
>
>.. ..@ ptype: int(0)
>
>> print(result)
>
># A tibble: 1 x 4
>
># Rowwise:
>
>alpha beta alphazoid betazoid
>
>> >
>
> 1 TRUE TRUE
>
>> result[[1,1]]
>
>[[1]]
>
>[1] "Last"
>
>
>
>> result[[1,2]]
>
>[[1]]
>
>[1] "Lasting"
>
>
>
>> as.data.frame(result)
>
>alphabeta alphazoid betazoid
>
>1 Last Lasting TRUE TRUE
>
>
>
>Of course, the temporary columns for alphazoid and betazoid can trivially be
>removed.
>
>
>
>
>
>
>
>
>
>From: Andrew Simmons
>Sent: Wednesday, September 15, 2021 12:44 AM
>To: Avi Gross
>Cc: Gregg Powell via R-help
>Subject: Re: [R] How to remove all rows that have a numeric in the
Re: [R] How to remove all rows that have a numeric in the first (or any) column
My apologies. My reply was to Andrew, not Gregg.
Enough damage for one night. Here is hoping we finally understood a question
that could have been better phrased. list columns are not normally considered
common data structures but quite possibly will be more as time goes on and the
tools to handle them become better or at least better understood.
-Original Message-
From: R-help On Behalf Of Avi Gross via R-help
Sent: Wednesday, September 15, 2021 1:23 AM
To: R-help@r-project.org
Subject: Re: [R] How to remove all rows that have a numeric in the first (or
any) column
You are correct, Gregg, I am aware of that trick of asking something to not be
evaluated in certain ways.
And you can indeed use base R to play with contents of beta as defined above.
Here is a sort of incremental demo:
> sapply(mydf$beta, is.numeric)
[1] FALSE TRUE TRUE FALSE
> !sapply(mydf$beta, is.numeric)
[1] TRUE FALSE FALSE TRUE
> keeping <- !sapply(mydf$beta, is.numeric)
> mydf[keeping, ]
# A tibble: 2 x 2
alpha beta
1 1
2 4
> str(mydf[keeping, ])
tibble [2 x 2] (S3: tbl_df/tbl/data.frame)
$ alpha: int [1:2] 1 4
$ beta :List of 2
..$ : chr "Hello"
..$ : chr "bye"
Now for the bad news. The original request was for ANY column. But presumably
one way to do it, neither efficiently nor the best, would be to loop on the
names of all the columns and starting with the original data.frame, whittle
away at it column by column and adjust which column you search each time until
what is left had nothing numeric anywhere.
Now if I was using dplyr, I wonder if there is a nice way to use rowwise() to
evaluate across a row.
Using your technique I made the following data.frame:
mydf <- data.frame(alpha=I(list("first", 2, 3.3, "Last")),
beta=I(list(1, "second", 3.3, "Lasting")))
> mydf
alphabeta
1 first 1
2 2 second
3 3.3 3.3
4 Last Lasting
Do we agree only the fourth row should be kept as the others have one or two
numeric values?
Here is some code I cobbled together that seems to work:
rowwise(mydf) %>%
mutate(alphazoid=!is.numeric(unlist(alpha)),
betazoid=!is.numeric(unlist(beta))) %>%
filter(alphazoid & betazoid) -> result
str(result)
print(result)
result[[1,1]]
result[[1,2]]
as.data.frame(result)
The results are shown below that only the fourth row was kept:
> rowwise(mydf) %>%
+ mutate(alphazoid=!is.numeric(unlist(alpha)),
+ betazoid=!is.numeric(unlist(beta))) %>%
+ filter(alphazoid & betazoid) -> result
>
> str(result)
rowwise_df [1 x 4] (S3: rowwise_df/tbl_df/tbl/data.frame)
$ alpha:List of 1
..$ : chr "Last"
..- attr(*, "class")= chr "AsIs"
$ beta :List of 1
..$ : chr "Lasting"
..- attr(*, "class")= chr "AsIs"
$ alphazoid: logi TRUE
$ betazoid : logi TRUE
- attr(*, "groups")= tibble [1 x 1] (S3: tbl_df/tbl/data.frame)
..$ .rows: list [1:1]
.. ..$ : int 1
.. ..@ ptype: int(0)
> print(result)
# A tibble: 1 x 4
# Rowwise:
alpha beta alphazoid betazoid
> >
1 TRUE TRUE
> result[[1,1]]
[[1]]
[1] "Last"
> result[[1,2]]
[[1]]
[1] "Lasting"
> as.data.frame(result)
alphabeta alphazoid betazoid
1 Last Lasting TRUE TRUE
Of course, the temporary columns for alphazoid and betazoid can trivially be
removed.
From: Andrew Simmons
Sent: Wednesday, September 15, 2021 12:44 AM
To: Avi Gross
Cc: Gregg Powell via R-help
Subject: Re: [R] How to remove all rows that have a numeric in the first (or
any) column
I'd like to point out that base R can handle a list as a data frame column,
it's just that you have to make the list of class "AsIs". So in your example
temp <- list("Hello", 1, 1.1, "bye")
data.frame(alpha = 1:4, beta = I(temp))
means that column "beta" will still be a list.
On Wed, Sep 15, 2021, 00:40 Avi Gross via R-help mailto:r-help@r-project.org> > wrote:
Calling something a data.frame does not make it a data.frame.
The abbreviated object shown below is a list of singletons. If it is a column
in a larger object that is a data.frame, then it is a list column which is
valid but can be ticklish to handle within base R but less so in the tidyverse.
For example, if I try to make a data.frame the normal way, the list gets made
into multiple columns and copied to each row. Not what was expected. I think
some tidyverse functionality does better.
Like this:
library(tidyverse)
temp=list("Hello", 1, 1.1, "bye")
Now making a data.frame has an odd result:
> mydf=data.frame(alpha=1:
Re: [R] How to remove all rows that have a numeric in the first (or any) column
You are correct, Gregg, I am aware of that trick of asking something to not be
evaluated in certain ways.
And you can indeed use base R to play with contents of beta as defined above.
Here is a sort of incremental demo:
> sapply(mydf$beta, is.numeric)
[1] FALSE TRUE TRUE FALSE
> !sapply(mydf$beta, is.numeric)
[1] TRUE FALSE FALSE TRUE
> keeping <- !sapply(mydf$beta, is.numeric)
> mydf[keeping, ]
# A tibble: 2 x 2
alpha beta
1 1
2 4
> str(mydf[keeping, ])
tibble [2 x 2] (S3: tbl_df/tbl/data.frame)
$ alpha: int [1:2] 1 4
$ beta :List of 2
..$ : chr "Hello"
..$ : chr "bye"
Now for the bad news. The original request was for ANY column. But presumably
one way to do it, neither efficiently nor the best, would be to loop on the
names of all the columns and starting with the original data.frame, whittle
away at it column by column and adjust which column you search each time until
what is left had nothing numeric anywhere.
Now if I was using dplyr, I wonder if there is a nice way to use rowwise() to
evaluate across a row.
Using your technique I made the following data.frame:
mydf <- data.frame(alpha=I(list("first", 2, 3.3, "Last")),
beta=I(list(1, "second", 3.3, "Lasting")))
> mydf
alphabeta
1 first 1
2 2 second
3 3.3 3.3
4 Last Lasting
Do we agree only the fourth row should be kept as the others have one or two
numeric values?
Here is some code I cobbled together that seems to work:
rowwise(mydf) %>%
mutate(alphazoid=!is.numeric(unlist(alpha)),
betazoid=!is.numeric(unlist(beta))) %>%
filter(alphazoid & betazoid) -> result
str(result)
print(result)
result[[1,1]]
result[[1,2]]
as.data.frame(result)
The results are shown below that only the fourth row was kept:
> rowwise(mydf) %>%
+ mutate(alphazoid=!is.numeric(unlist(alpha)),
+ betazoid=!is.numeric(unlist(beta))) %>%
+ filter(alphazoid & betazoid) -> result
>
> str(result)
rowwise_df [1 x 4] (S3: rowwise_df/tbl_df/tbl/data.frame)
$ alpha:List of 1
..$ : chr "Last"
..- attr(*, "class")= chr "AsIs"
$ beta :List of 1
..$ : chr "Lasting"
..- attr(*, "class")= chr "AsIs"
$ alphazoid: logi TRUE
$ betazoid : logi TRUE
- attr(*, "groups")= tibble [1 x 1] (S3: tbl_df/tbl/data.frame)
..$ .rows: list [1:1]
.. ..$ : int 1
.. ..@ ptype: int(0)
> print(result)
# A tibble: 1 x 4
# Rowwise:
alpha beta alphazoid betazoid
> >
1 TRUE TRUE
> result[[1,1]]
[[1]]
[1] "Last"
> result[[1,2]]
[[1]]
[1] "Lasting"
> as.data.frame(result)
alphabeta alphazoid betazoid
1 Last Lasting TRUE TRUE
Of course, the temporary columns for alphazoid and betazoid can trivially be
removed.
From: Andrew Simmons
Sent: Wednesday, September 15, 2021 12:44 AM
To: Avi Gross
Cc: Gregg Powell via R-help
Subject: Re: [R] How to remove all rows that have a numeric in the first (or
any) column
I'd like to point out that base R can handle a list as a data frame column,
it's just that you have to make the list of class "AsIs". So in your example
temp <- list("Hello", 1, 1.1, "bye")
data.frame(alpha = 1:4, beta = I(temp))
means that column "beta" will still be a list.
On Wed, Sep 15, 2021, 00:40 Avi Gross via R-help mailto:r-help@r-project.org> > wrote:
Calling something a data.frame does not make it a data.frame.
The abbreviated object shown below is a list of singletons. If it is a column
in a larger object that is a data.frame, then it is a list column which is
valid but can be ticklish to handle within base R but less so in the tidyverse.
For example, if I try to make a data.frame the normal way, the list gets made
into multiple columns and copied to each row. Not what was expected. I think
some tidyverse functionality does better.
Like this:
library(tidyverse)
temp=list("Hello", 1, 1.1, "bye")
Now making a data.frame has an odd result:
> mydf=data.frame(alpha=1:4, beta=temp)
> mydf
alpha beta..Hello. beta.1 beta.1.1 beta..bye.
1 1Hello 1 1.1bye
2 2Hello 1 1.1bye
3 3Hello 1 1.1bye
4 4Hello 1 1.1bye
But a tibble handles it:
> mydf=tibble(alpha=1:4, beta=temp)
> mydf
# A tibble: 4 x 2
alpha beta
1 1
2 2
3 3
4 4
So if the data does look like this, with a list column, but access can be
tricky as subsetting a list with [] returns a list and you need [[]].
I found a somehwh
Re: [R] How to remove all rows that have a numeric in the first (or any) column
I'd like to point out that base R can handle a list as a data frame column,
it's just that you have to make the list of class "AsIs". So in your example
temp <- list("Hello", 1, 1.1, "bye")
data.frame(alpha = 1:4, beta = I(temp))
means that column "beta" will still be a list.
On Wed, Sep 15, 2021, 00:40 Avi Gross via R-help
wrote:
> Calling something a data.frame does not make it a data.frame.
>
> The abbreviated object shown below is a list of singletons. If it is a
> column in a larger object that is a data.frame, then it is a list column
> which is valid but can be ticklish to handle within base R but less so in
> the tidyverse.
>
> For example, if I try to make a data.frame the normal way, the list gets
> made into multiple columns and copied to each row. Not what was expected. I
> think some tidyverse functionality does better.
>
> Like this:
>
> library(tidyverse)
> temp=list("Hello", 1, 1.1, "bye")
>
> Now making a data.frame has an odd result:
>
> > mydf=data.frame(alpha=1:4, beta=temp)
> > mydf
> alpha beta..Hello. beta.1 beta.1.1 beta..bye.
> 1 1Hello 1 1.1bye
> 2 2Hello 1 1.1bye
> 3 3Hello 1 1.1bye
> 4 4Hello 1 1.1bye
>
> But a tibble handles it:
>
> > mydf=tibble(alpha=1:4, beta=temp)
> > mydf
> # A tibble: 4 x 2
> alpha beta
>
> 1 1
> 2 2
> 3 3
> 4 4
>
> So if the data does look like this, with a list column, but access can be
> tricky as subsetting a list with [] returns a list and you need [[]].
>
> I found a somehwhat odd solution like this:
>
> mydf %>%
>filter(!map_lgl(beta, is.numeric)) -> mydf2
> # A tibble: 2 x 2
> alpha beta
>
> 1 1
> 2 4
>
> When I saved that result into mydf2, I got this.
>
> Original:
>
> > str(mydf)
> tibble [4 x 2] (S3: tbl_df/tbl/data.frame)
> $ alpha: int [1:4] 1 2 3 4
> $ beta :List of 4
> ..$ : chr "Hello"
> ..$ : num 1
> ..$ : num 1.1
> ..$ : chr "bye"
>
> Output when any row with a numeric is removed:
>
> > str(mydf2)
> tibble [2 x 2] (S3: tbl_df/tbl/data.frame)
> $ alpha: int [1:2] 1 4
> $ beta :List of 2
> ..$ : chr "Hello"
> ..$ : chr "bye"
>
> So if you try variations on your code motivated by what I show, good luck.
> I am sure there are many better ways but I repeat, it can be tricky.
>
> -Original Message-
> From: R-help On Behalf Of Jeff Newmiller
> Sent: Tuesday, September 14, 2021 11:54 PM
> To: Gregg Powell
> Cc: Gregg Powell via R-help
> Subject: Re: [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.pow...@protonmail.com> wrote:
> >Here is the output:
> >
> >> str(VPN_Sheet1$HVA)
> >List of 2174
> > $ : chr "Email: f...@fff.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 Oquil
Re: [R] How to remove all rows that have a numeric in the first (or any) column
Calling something a data.frame does not make it a data.frame.
The abbreviated object shown below is a list of singletons. If it is a column
in a larger object that is a data.frame, then it is a list column which is
valid but can be ticklish to handle within base R but less so in the tidyverse.
For example, if I try to make a data.frame the normal way, the list gets made
into multiple columns and copied to each row. Not what was expected. I think
some tidyverse functionality does better.
Like this:
library(tidyverse)
temp=list("Hello", 1, 1.1, "bye")
Now making a data.frame has an odd result:
> mydf=data.frame(alpha=1:4, beta=temp)
> mydf
alpha beta..Hello. beta.1 beta.1.1 beta..bye.
1 1Hello 1 1.1bye
2 2Hello 1 1.1bye
3 3Hello 1 1.1bye
4 4Hello 1 1.1bye
But a tibble handles it:
> mydf=tibble(alpha=1:4, beta=temp)
> mydf
# A tibble: 4 x 2
alpha beta
1 1
2 2
3 3
4 4
So if the data does look like this, with a list column, but access can be
tricky as subsetting a list with [] returns a list and you need [[]].
I found a somehwhat odd solution like this:
mydf %>%
filter(!map_lgl(beta, is.numeric)) -> mydf2 # A tibble: 2 x 2
alpha beta
1 1
2 4
When I saved that result into mydf2, I got this.
Original:
> str(mydf)
tibble [4 x 2] (S3: tbl_df/tbl/data.frame) $ alpha: int [1:4] 1 2 3 4 $ beta
:List of 4 ..$ : chr "Hello"
..$ : num 1
..$ : num 1.1
..$ : chr "bye"
Output when any row with a numeric is removed:
> str(mydf2)
tibble [2 x 2] (S3: tbl_df/tbl/data.frame) $ alpha: int [1:2] 1 4 $ beta :List
of 2 ..$ : chr "Hello"
..$ : chr "bye"
So if you try variations on your code motivated by what I show, good luck. I am
sure there are many better ways but I repeat, it can be tricky.
-Original Message-
From: R-help On Behalf Of Jeff Newmiller
Sent: Tuesday, September 14, 2021 11:54 PM
To: Gregg Powell
Cc: Gregg Powell via R-help
Subject: Re: [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
wrote:
>Here is the output:
>
>> str(VPN_Sheet1$HVA)
>List of 2174
> $ : chr "Email: f...@fff.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
> 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@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) c
Re: [R] How to remove all rows that have a numeric in the first (or any) column
Calling something a data.frame does not make it a data.frame.
The abbreviated object shown below is a list of singletons. If it is a column
in a larger object that is a data.frame, then it is a list column which is
valid but can be ticklish to handle within base R but less so in the tidyverse.
For example, if I try to make a data.frame the normal way, the list gets made
into multiple columns and copied to each row. Not what was expected. I think
some tidyverse functionality does better.
Like this:
library(tidyverse)
temp=list("Hello", 1, 1.1, "bye")
Now making a data.frame has an odd result:
> mydf=data.frame(alpha=1:4, beta=temp)
> mydf
alpha beta..Hello. beta.1 beta.1.1 beta..bye.
1 1Hello 1 1.1bye
2 2Hello 1 1.1bye
3 3Hello 1 1.1bye
4 4Hello 1 1.1bye
But a tibble handles it:
> mydf=tibble(alpha=1:4, beta=temp)
> mydf
# A tibble: 4 x 2
alpha beta
1 1
2 2
3 3
4 4
So if the data does look like this, with a list column, but access can be
tricky as subsetting a list with [] returns a list and you need [[]].
I found a somehwhat odd solution like this:
mydf %>%
filter(!map_lgl(beta, is.numeric)) -> mydf2
# A tibble: 2 x 2
alpha beta
1 1
2 4
When I saved that result into mydf2, I got this.
Original:
> str(mydf)
tibble [4 x 2] (S3: tbl_df/tbl/data.frame)
$ alpha: int [1:4] 1 2 3 4
$ beta :List of 4
..$ : chr "Hello"
..$ : num 1
..$ : num 1.1
..$ : chr "bye"
Output when any row with a numeric is removed:
> str(mydf2)
tibble [2 x 2] (S3: tbl_df/tbl/data.frame)
$ alpha: int [1:2] 1 4
$ beta :List of 2
..$ : chr "Hello"
..$ : chr "bye"
So if you try variations on your code motivated by what I show, good luck. I am
sure there are many better ways but I repeat, it can be tricky.
-Original Message-
From: R-help On Behalf Of Jeff Newmiller
Sent: Tuesday, September 14, 2021 11:54 PM
To: Gregg Powell
Cc: Gregg Powell via R-help
Subject: Re: [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
wrote:
>Here is the output:
>
>> str(VPN_Sheet1$HVA)
>List of 2174
> $ : chr "Email: f...@fff.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
> 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@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?
&g
Re: [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 wrote: >Here is the output: > >> str(VPN_Sheet1$HVA) >List of 2174 > $ : chr "Email: f...@fff.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 > 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@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. __ 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.
Re: [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@r-project.org> wrote: > Here is the output: > > > str(VPN_Sheet1$HVA) > List of 2174 > $ : chr "Email: f...@fff.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 < > jdnew...@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@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. > [[alternative HTML version deleted]] __ 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.
Re: [R] How to remove all rows that have a numeric in the first (or any) column
On Wed, 15 Sep 2021 02:01:53 + Gregg Powell via R-help 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. Do you mean that the HVA column *is* a list? It probably shouldn't be. It seems very likely that your data are all screwed up. The first thing to do is get your data properly organised. That could be difficult since you have apparently read them in from an Excel file, and Excel is a recipe for disaster. > > > > > Data looks like the attached screen grab - No attachment came through. Do read the posting guide. Most attachments are stripped by the mail handler. > > 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 If there are any non-numeric entries in a column then they *all* have to be non-numeric. Some of them *may* be interpretable as being numeric. If you apply as.numeric() to a column you'll get NA's for all entries that *cannot* be interpreted as numeric. So you may want to do something like (untested, of course): ok <- is.na(as.numeric(X[,"HVA"])) X <- X[ok,] where "X" is the data frame that you are dealing with. Good luck. cheers, Rolf Turner -- Honorary Research Fellow Department of Statistics University of Auckland Phone: +64-9-373-7599 ext. 88276 __ 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.
Re: [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: f...@fff.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 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@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. signature.asc Description: OpenPGP digital signature __ 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.
Re: [R] 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 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.
[R] How to remove all rows that have a numeric in the first (or any) column
> 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 signature.asc Description: OpenPGP digital signature __ 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.
