Subsetting dataset to include numerical values in a column

[mishabalyasin]

Can you put your question into reproducible example form (reprex)? It'll help everyone to answer your question most efficiently.

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…

The approach I'd take is to use regex to find lines where there is anything else other than numbers. It'll look something like this:

vec <- c("78443", "2445", "78789", "6dfg546")
grepl(pattern = "[a-zA-Z]", x = vec)
[1] FALSE FALSE FALSE  TRUE

You can use result to filter out any rows that contain letters.