Convert Datatype to Integer and drop rows with non integer type values

Question

I have a dataframe column whose curren ...

Corralien · Accepted Answer · 2021-09-06 15:29:52Z

3

Use pd.to_numeric with errors='coerce' parameter:

df['Sno'] = pd.to_numeric(df['Sno'], errors='coerce')
df = df[df['Sno'].notna()].astype({'Sno': int})

Output:

>>> df
   Sno  test
0   12     5
1   14     5
2   15     7
3   16     8
4   17     9

edited Sep 6, 2021 at 15:29

answered Sep 6, 2021 at 15:13

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

2 Comments

B2A3R9C9A Over a year ago

I obtain the following error on running the first line: raise IntCastingNaNError( pandas.errors.IntCastingNaNError: Cannot convert non-finite values (NA or inf) to integer

Corralien Over a year ago

Yes, you can do on any other column.

Collectives™ on Stack Overflow

Convert Datatype to Integer and drop rows with non integer type values

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related