I need some support with something simple but that is perplexing me a bit. I am trying to replace some values from an excel I am working with.
My values are from 1 to 5, but I'll like to replace them to Very Unsatisfied, Unsatisfied and so on. I run my code and it gives me no errors but for some reason it is not being replaced.
For some context, data is the name of my dataframe and CSAT is the column where te numerical values are. Nothing too crazy.
data["CSAT"].replace(to_replace=['5' , '4' , '3' , '2' , '1'] , value=['Very Satisfied' , 'Satisfied', 'Neutral', 'Unsatisfied' , 'Very Unsatisfied'])
I also tried
data["CSAT"].replace(['5' , '4' , '3' , '2' , '1'] , ['Very Satisfied' , 'Satisfied', 'Neutral', 'Unsatisfied' , 'Very Unsatisfied'])
Thank you for your help!