Np where pandas with 3 choices

col         = 'consumption_energy'
conditions  = [ df2[col] >= 400, (df2[col] < 400) & (df2[col]> 200), df2[col] <= 200 ]
choices     = [ "high", 'medium', 'low' ]
    
df2["energy_class"] = np.select(conditions, choices, default=np.nan)


  consumption_energy energy_class
0                 459         high
1                 416         high
2                 186          low
3                 250       medium
4                 411         high
5                 210       medium
6                 343       medium
7                 328       medium
8                 208       medium
9                 223       medium

Source: stackoverflow.com

Similar codes

0 vote202 views1 answer
Bulk upload with dictionary or list in django moels
Python Django
0 vote214 views1 answer
Attributeerror: module
Python
1 vote164 views1 answer
If a number times a number is true python
Python
4 votes169 views1 answer
Round python with list
Python
0 vote176 views1 answer
Flask remove file after send_file
Python
0 vote187 views1 answer
-bash: /usr/local/bin/python3: no such file or directory
Python
1 vote197 views1 answer
Python convert file into list
Python
1 vote200 views1 answer
Flask form errors
Python Flask
12 votes188 views1 answer
Copy a dict in python
Python
39 votes187 views2 answers
Python how to add columns to a pandas dataframe
Python