wtf is dim-account-audit?

dim-account-audit is a Python tool that checks the quality of a CSV file and produces a readable report about what it found. You point it at a CSV, and it runs a set of checks covering the file's structure, how many values are missing, whether rows or key columns have duplicates, whether categorical fields contain only expected values, and whether numeric columns have unusual outliers. The tool was originally written to audit a specific dimension table called DimAccount.csv, used in data warehousing for account records, and it includes account-specific business rules such as checking that closed accounts have a closing date, that open accounts do not, that closing dates always come after opening dates, and that balances are not unexpectedly negative outside credit accounts. If your CSV does not have the columns those rules depend on, they are skipped automatically, so the generic checks like schema, completeness, and duplicates still work on any CSV file, not just account data. Running the tool is a matter of installing the Python requirements and calling a single script with the path to your CSV file. It produces three outputs: an HTML report with charts, a pass, warn, and fail breakdown, and an overall data quality score, a machine readable results file in JSON, and a CSV listing every row that failed or triggered a warning on any check, so you can go straight to the problem rows. You can control which checks run and how strict they are through a configuration file, where you set things like the primary key column, which date columns to check, which columns are allowed to have nulls, the allowed values for categorical fields, and the warning and failure thresholds for missing data. A sample dataset is included so you can see the tool working before pointing it at your own data. No license is stated in the README.