I’m currently trying to clean up a database and create unique ids for each parent. For each parent there’s been duplicate accounts that have been created – one for each of their students. For example, a parent enters in their name one year with an alias and the next without, those are seen as two different accounts. These ids would allow me to create one parent account for all of their kids.

My Dataframe look quite like this. I would like to drop column since it contains a error message.