How to use Spotless Data?

Lookup Rules

Lookup rules check a field against a predefined set of data stored in a separate CSV file.

 

Blank records can be automatically populated using a lookalike model to complete missing data from the reference set. If blanks are not filled, they can be skipped or excluded as normal.

 

If strings fall outside the prescribed characteristics the following options are available:

 

You can also easily update the reference file used by the lookup validation using the pyspotless client.


 

from pyspotljss import SpotlessClient


spotless = SpotlessClient(access_token='<SPOTLESS TOKEN HERE>')


Spotless.update_reference_rule_file(self, <RULE URL HERE>, file)