Remove rows if a specific columns contains anything other than numbers?

Question

I have a dataframe like this:

df:

col1    col2
 1        4
 4       ab1
 5       1s,2
 6        5
 3        24
 5        xy

If col2 contains any character other than numbers drop those rows from the data frame.

The final dataframe will look like:

col1    col2
 1        4
 6        5
 3        24

How to do it using pandas in effictive way ?

`df = df[df.id2.str.contains(r'^[0-9]$')]` – meW Jan 15 '19 at 12:44 — meW, Jan 15 '19 at 12:44
`df = df[df.col2.str.encode('utf-8').isna()]` – shaik moeed Jan 15 '19 at 13:05 — shaik moeed, Jan 15 '19 at 13:05

score 0 · Answer 1 · answered Jan 15 '19 at 12:44

0

Try this

df=df[df.col2.apply(lambda x: x.isnumeric())]

answered Jan 15 '19 at 12:44

Indent

1 Answers1