Python adding values to column base on conditions of another column

Question

df = pd.DataFrame([['KALLANG/WHAMPOA', '2 ROOM', '01 TO 03', 47.0, 'IMPROVED', 92000.0, 0],
 ['QUEENSTOWN', '2 ROOM', '01 TO 03', 45.0, 'STANDARD', 185000.0, 0],
 ['QUEENSTOWN', '2 ROOM', '01 TO 03', 45.0, 'STANDARD', 205500.0, 0],
 ['TOA PAYOH', '2 ROOM', '01 TO 03', 45.0, 'IMPROVED', 248000.0, 0],
 ['JURONG WEST', '2 ROOM', '01 TO 03', 44.0, 'MODEL A', 181000.0, 0]], columns=['town', 
'flat_type', 'storey_range', 'floor_area_sqm', 'flat_model', 'resale_price', 'Points'])

How can I add value to the column points based on a condition like "town"=="QUEENSTOWN. I am trying to do a complex ranking system.

df[(df['town'] == 'QUEENSTOWN')]['Points']+5

I tried this but it doesn't update the main dataframe

bitflip · Accepted Answer · 2022-09-20 19:08:41Z

2

You can use .loc for that

df.loc[df['town'] == 'QUEENSTOWN', 'Points'] += 5

https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.loc.html

edited Sep 20, 2022 at 19:08

answered Sep 20, 2022 at 19:07

bitflip

3,7391 gold badge6 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python adding values to column base on conditions of another column

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related