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

1 vote104 views1 answer
Cmd run ps1 file in background
Python
78 votes106 views6 answers
Save dataframe as csv
Python
1 vote102 views1 answer
Add text to the middle of the window tkinter
Python
0 vote99 views1 answer
%%writefile jupyter notebook
Python
12 votes110 views3 answers
Python program to add two numbers with user input
Python
7 votes119 views4 answers
Qr code in python
Python
2 votes106 views1 answer
Torch device
Python
0 vote109 views1 answer
Python querystring parse
Python
12 votes114 views5 answers
Python turtle documentation
Python
1 vote132 views1 answer
How to check if python has been added to path
Python