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

7 votes232 views2 answers
Python prime check
Python
0 vote283 views1 answer
Python random select no replace
Python
0 vote266 views1 answer
.replace pandas in for loop
Python
2 votes283 views2 answers
Python module for converting miles to km
Python
2 votes239 views1 answer
Find element by title selenium python
Python
0 vote255 views1 answer
Structural pattern matching python
Python
0 vote253 views1 answer
DRF: get ip address
Python
0 vote263 views1 answer
Pandas string manipulation on column
Python
0 vote220 views1 answer
Get value of variable in session django
Python Django
2 votes262 views1 answer
Python remove empty folders
Python