How to do data cleansing using spark SQL

can someone guide on this.