TypeError: '>' not supported between instances of 'str' and 'int' in pandas

Question

I am comparing two columns in a pandas DF, A and B like this:

df['A'].gt(df['B'])

but get this error:

TypeError: '>' not supported between instances of 'str' and 'int'

when I lookup the dtypes: df.dtypes

I see this output:

id: object
A: object
B: int64

when I look at 5 top records with do df.head()

I see this:

id    A   B
a1    2   2.353566677998
a2    4   4.454444231211
a3    3   6.777888665343
.....

how to solve this error:

TypeError: '>' not supported between instances of 'str' and 'int'

when doing this comparison:

df['A'].gt(df['B'])

Looks like many people are asking this but I couldn't find one that matches my issue!

Try df['A'] = pd.to_numeric(df['A'], errors='coerce') before comparison? — Quang Hoang
– Quang Hoang, Commented Dec 10, 2020 at 4:48

Alex Watt · Accepted Answer · 2020-12-10 04:50:02Z

2

Although the values are clearly integers when you look at the DataFrame, pandas uses object for str values - which from the error, is what you have. You can cast all of the values of the A column to integers though, and you should be good to go!

df["A"] = df["A"].astype(int)

answered Dec 10, 2020 at 4:50

Alex Watt

9375 silver badges14 bronze badges

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

2 Comments

alex r Over a year ago

this one returned an error "invalid literal for int() with base 10..." but thanks anyway Alex Watt

Cainã Max Couto da Silva Over a year ago

This is the correct answer. Please show the full message error you got @alexr. This is probably a ValueError, then it should show the first value that break the conversion. Also, try to use float instead of int.

Arie · Accepted Answer · 2022-11-23 09:41:53Z

0

Are you working with Google Colab? If thats the case, then do both: restart runtime and restart everything. It usually works.

answered Nov 23, 2022 at 9:41

Arie

561 silver badge5 bronze badges

Collectives™ on Stack Overflow

TypeError: '>' not supported between instances of 'str' and 'int' in pandas

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related