[Answer]-South migration – How to handle inconsistent data when adding a unique constraint

Take a look at South’s data migrations. You’ll have to write a method that converts the data to your specifications (and ideally a reverse method for rolling back changes, though for something like this task it’s not always possible).