Data Audit
Testing & Qualitydata-auditData Audit is an Agent Skill for testing & quality published in the brycewang-stanford/Auto-Empirical-Research-Skills repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.
Scans notebooks for data file references and verifies each file exists on disk. Use when checking for broken data paths.
How to use this skill
Bring this guide into your coding agent with a prompt tailored to the tool you use.
- Open your project in Codex.
- Copy and paste the prompt below.
- Review files and risks before approving any action.
Inspect the Agent Skill at https://github.com/brycewang-stanford/Auto-Empirical-Research-Skills/blob/HEAD/skills/29-quarcs-lab-project20XXy/dot-claude/skills/data-audit/SKILL.md and all supporting files. Report provenance, permissions, scripts, dependencies, and security risks. Propose an exact installation into .agents/skills/data-audit, but wait for my approval before writing files or running scripts.
Copying this prompt does not install or run the skill. Review third-party files before use.
Audit Data References
Scan all notebooks for data file references and verify they exist on disk.
Steps
-
Scan all
.ipynbfiles innotebooks/for data loading patterns:- Python:
pd.read_csv(...),pd.read_stata(...),pd.read_excel(...),pd.read_parquet(...),open(...),np.loadtxt(...) - R:
read.csv(...),read_csv(...),read.dta(...),haven::read_dta(...),readxl::read_excel(...),load(...) - Stata:
use "...",import delimited "...",import excel "...",insheet using "..." - Also check the
.mdJupytext pairs for the same patterns
- Python:
-
Extract every referenced file path and normalize it:
- Resolve relative paths from the notebook's directory (
notebooks/) - Resolve paths using
DATA_DIR,RAW_DATA_DIRfromconfig.py/config.R
- Resolve relative paths from the notebook's directory (
-
Check that each referenced file exists in
data/rawData/ordata/ -
Scan
data/rawData/anddata/for all data files present on disk -
Report three categories:
Resolved — referenced and found:
- File path, which notebook references it, line/cell number
Broken — referenced but not found:
- File path as written in code, which notebook, suggested fix (closest matching file, or note that it may need to be downloaded)
Undocumented — on disk but never referenced by any notebook:
- File path in
data/rawData/ordata/that no notebook loads
-
Print a summary: total references, resolved, broken, undocumented files
Error handling
- If no notebooks exist, report "No notebooks found" and stop.
- If
data/rawData/does not exist, warn but continue checkingdata/.