How/when did the n-word make the transition from derogatory term to term of endearment?

This particular word and its use in America is really fascinating and I’m hoping someone can help me (us) understand how it went from being a word used against people to a word used by the people for the people it was once used against. Are there any other words like this?