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

Question

For each program, how many people have a Programming Skill knowledge of less than 4? Report one row for each existing program.

df1['ProgSkills'<4].groupby(by=df1['Program']).count()

Error message:

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

Data frame:

DeepSpace · Accepted Answer · 2021-02-16 23:37:21Z

1

df1['ProgSkills'<4]

This literally compares the string ProgSkills to the number 4.

You meant to do

df1[df1['ProgSkills']<4]

Which will compare each value in the ProgSkills column to the number 4.

answered Feb 16, 2021 at 23:37

DeepSpace

82.2k12 gold badges119 silver badges166 bronze badges

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

1 Answer 1