Working on data cleaning activity, I have 100k observation data and I have to replace the duplication in one of the variable. the duplication is possible by spelling mistakes too. Consider a table id fruits price 1 grape 100 2 orange 120 3 grepe 110 4 apple 200 5 grapes 90 6 appll 190 how the above data will be cleaned and should be as below id fruits price 1 grapes 100 2 orange 120 3 grapes 110 4 apple 200 5 grapes 90 6 apple 190 Consider same way I have to clean 100k of data, how it is cleansed? Thanks in Advance....
... View more