Hi List, I use paste function to concatenate? 3 character columns together. when I run table to see that, I found 3 categories. How can I write script to trim NA in 2nd and 3rd group and set the first one as NA? Thanks, Kai NA NA NA? NA NA Adenocarcinoma NA Other NA [[alternative HTML version deleted]]
Hello,
Something like this?
df1 <- read.table(text = "
NA NA NA
NA NA Adenocarcinoma
NA Other NA")
df1
apply(df1, 1, function(x){
if(all(is.na(x))){
NA_character_
}else{
paste(x[!is.na(x)], collapse = "")
}
})
And please configure your e-mail client not to post in HTML format.
Hope this helps,
Rui Barradas
?s 22:07 de 02/06/21, Kai Yang via R-help escreveu:> Hi List,
> I use paste function to concatenate? 3 character columns together.
> when I run table to see that, I found 3 categories. How can I write script
to trim NA in 2nd and 3rd group and set the first one as NA?
> Thanks,
> Kai
> NA NA NA
> NA NA Adenocarcinoma
> NA Other NA
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>
Hi Rui,
I use the code to fix my problem:
try$newcol <- gsub(" NA", "", try$newcol)
But, I'll try your solution later.
Thank you for your help.
Kai On Wednesday, June 2, 2021, 02:08:18 PM PDT, Kai Yang via R-help
<r-help at r-project.org> wrote:
Hi List,
I use paste function to concatenate? 3 character columns together.
when I run table to see that, I found 3 categories. How can I write script to
trim NA in 2nd and 3rd group and set the first one as NA?
Thanks,
Kai
NA NA NA?
NA NA Adenocarcinoma
NA Other NA
??? [[alternative HTML version deleted]]
______________________________________________
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]]