How to change one number in a dataframe?

Stephanie_Brady · February 10, 2021, 6:02pm

Hello, I would like to be able to change (correct) one number in this dataframe:

How can I change the Hours value in row 51 from an 8 to a 6?

Thanks in advance.

Kan_Nishida · February 11, 2021, 8:33pm

If you want to change the values based on the row number, then you can use row_number function.

so it should be something like this.

ifelse(row_number == 51, 6, Hours)

Stephanie_Brady · February 22, 2021, 5:10pm

Kan, thank you so much for the lead. I played around with this a bit and this is what worked for me!

Kan_Nishida · February 25, 2021, 5:50pm

Oh yes! We need the brackets! Thanks for the correction!