This tab allows you to quickly validate your data using simple rules. You can enter rules in the text area below. Write one rule per line.
Suppose that the name of the column that you want to check is weigth and that you want to highlight all rows where weight.is greater than 5. This can be done like so:
Rows where weight is greater than 5 will be highlighted in the table below.
If you want to test several rules, you need to write one rule per line:
You can use the text box below to enter simple modification rules to apply to your data.
As an example suppose you are working with data on wages, and you have to topcode the yearly earnings to 60000 euro. This can be done like so:
It is also possible to set the offending values to NA, and then impute these values using the next tab of the app.