I’m facing the following problem: in a column of my dataset I have the city (Naturalidade) name and in the next column the state (UFProponenet). However, some line of the city has the state’s name together, like in the figure (see first line). How do we remove it, knowing it will always have two letters and be located at the end of the column text?

Thanks
Rick