AttributeError: 'float' object has no attribute 'isnumeric'

Question

I have a pandas df and I want to remove non-numeric values of col1.

If I use df[df.col1.apply(lambda x: x.isnumeric())], I get the following error:

AttributeError: 'float' object has no attribute 'isnumeric'

any suggestion on doing this efficiently in pandas?

strings have an isnumeric() attribute, but a float clearly doesn't need one because it has to be numeric. You probably have an Object column where some values are strings, and others are missing and NaN is a float, so add some error handling like if not pd.isnull(x). (But really you should do this with pd.to_numeric instead of Series.apply) — ALollz
– ALollz, Commented Apr 1, 2021 at 19:19

Qwerty · Accepted Answer · 2021-04-01 19:52:08Z

1

You could use standard method of strings isnumeric and apply it to each value in your id column:
Remove non-numeric rows in one column with pandas
Python replace non digit character in a dataframe

answered Apr 1, 2021 at 19:52

Qwerty

914 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1