Click here to Skip to main content
15,918,596 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I tried to create a bin using pandas but it shows the type conversion error.

What I have tried:

Here is the code:
bins= [0,10,15,30,50,100]
df['Pack Ranges']=pd.cut(df['Basepacksize'],bins)

Here is the Error

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

How to solve this error
Updated 9-Dec-22 5:49am
Richard MacCutchan 9-Dec-22 11:46am    
There is nothing in the code you have posted that relates to the error message. Which line does the message say is in error?
Anirudh Sudarsan 9-Dec-22 12:48pm    
in this line
df['Pack Ranges']=pd.cut(df['Basepacksize'],bins)
Richard MacCutchan 9-Dec-22 12:51pm    
Wht does df['Basepacksize'] refer to?
Anirudh Sudarsan 9-Dec-22 13:02pm    
df['Basepacksize'] refers to the column stored in data frame named as df. also this error also occurs when the variable name is changed to df1 for eg:
df1['Pack Ranges']=pd.cut(df['Basepacksize'].bins)

1 solution

We can't tell from that code fragment even where the error might be occurring, so we can't help you without a lot more information.
However, you can probably work it out for yourself is you look at the error message carefully, and read this: How to Write Code to Solve a Problem, A Beginner's Guide Part 2: Syntax Errors[^]

You should expect to get syntax errors every day, probably many times a day while you are coding - we all do regardless of how much experience we have! Sometimes, we misspell a variable, or a keyword; sometimes we forget to close a string or a code block. Sometimes the cat walks over your keyboard and types something really weird. Sometimes we just forget how many parameters a method call needs.

We all make mistakes.

And because we all do it, we all have to fix syntax errors - and it's a lot quicker to learn how and fix them yourself than to wait for someone else to fix them for you! So invest a little time in learning how to read error messages, and how to interpret your code as written in the light of what the compiler is telling you is wrong - it really is trying to be helpful!
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900