Dataproofer For Mac

Dataproofer is a straightforward data analysis tool that can help you evaluate if your information is clean and reliable by running numerous predefined checks. Instead of performing the task manually, you get to use Dataproofer and eliminate the possibility of human error.

Right off the bat, Dataproofer offers you the possibility to load the files you want to analyze. The app can work with local files that use the XLSX, XLS, CSV, TSV, and PSV file format.

At the same time, you have the option to load Google Spreadsheets by providing the direct URL or their ID. Regardless of your choice, in the bottom area of the panel, you will be able to see the types of available checks.

Dataproofer can determine with your file includes numeric and string cells or if the core data contains errors (empty cells, duplicate/potentially missing rows, words or integer values at the upper limit).

Dataproofer can run statistical and geographic data tests: it can detect outliers from the mean or median, or identify invalid or void coordinates. Each test comes with an associated check box that you must tick if you want to apply it to your data file.

Once the Dataproofer app runs the checks, in the app’s main window you will be able to preview the file content, and view the result for each analysis. The app lets you know how many tests have been passed successfully and highlights the areas that require your attention.

To identify the portions that have triggered errors, just hover your mouse on top of each test name and Dataproofer will highlight the corresponding cells. Moreover, Dataproofer will provide a short description of each error, so you can determine what has to be done.

Dataproofer aims to automate the analysis procedure for data files in order to eliminate the need to perform this tedious task manually.

The Dataproofer utility can run predefined checks on any locally stored file or Google spreadsheet and presents its assessments in an easy to read manner.