R help - Jan 2022 - Remove

Hi All,

I want  remove row(s) that contains a character string in an integer column
or  a digit in a character column

Sample data
dat1 <-read.table(text="Name, Age, Weight
 Alex,  20,  13X
 Bob,   25,  142
 Carol, 24,  120
 John,  3BC,  175
 Katy,  35,  160
 Jack3, 34,  140",sep=",",header=TRUE,stringsAsFactors=F)

If the Age/Weight column contains any character(s) then remove
if the Name  column contains any  digit then remove that row

Desired output

   Name   Age weight
1   Bob     25    142
2   Carol   24    120
3   Katy    35    160

Thank you,

	[[alternative HTML version deleted]]

Hello,

This question is repeated [1].

[1] https://stat.ethz.ch/pipermail/r-help/2022-January/473663.html

Rui Barradas

?s 02:20 de 29/01/2022, Val escreveu:
> Hi All,
> 
> I want  remove row(s) that contains a character string in an integer column
> or  a digit in a character column
> 
> Sample data
> dat1 <-read.table(text="Name, Age, Weight
>   Alex,  20,  13X
>   Bob,   25,  142
>   Carol, 24,  120
>   John,  3BC,  175
>   Katy,  35,  160
>   Jack3, 34,  140",sep=",",header=TRUE,stringsAsFactors=F)
> 
> If the Age/Weight column contains any character(s) then remove
> if the Name  column contains any  digit then remove that row
> 
> Desired output
> 
>     Name   Age weight
> 1   Bob     25    142
> 2   Carol   24    120
> 3   Katy    35    160
> 
> Thank you,
> 
> 	[[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.