How can I create new columns with filter on the current column?

Asked Mar 09 '20 at 19:22

Active Mar 09 '20 at 19:22

Viewed 21 times

I am trying to bucket my own category for the dataset I have. Currently, I have a column rating that is somehow continuous, I want to create a new column called category and its value will depend on the values from rating. here are my codes:

st_df['Category'] = st_df['Rating'].map({(['Rating'] > 89): 4, (['Rating'] < 90): 3,
                                         (['Rating'] < 80): 2, (['Rating'] < 70): 1,
                                         (['Rating'] < 60): 0})

the error I have is: '>' not supported between instances of 'list' and 'int'

Thanks!

asked Mar 09 '20 at 19:22

Song Mei

https://stackoverflow.com/questions/19913659/pandas-conditional-creation-of-a-series-dataframe-column – xana Mar 09 '20 at 19:30
Please provide the entire error message, as well as a [mcve]. – AMC Mar 09 '20 at 20:01

How can I create new columns with filter on the current column?

0 Answers0