Using Faker library I have created a messy dataset and then cleaned it by pandas library in python in just few steps.