Clinical Data Validator

A Python ETL script for validating clinical trial patient data. Reads raw CSV data, applies validation rules, and outputs clean JSON and a detailed error report.

Tech Stack

• Python 3.14
• Pandas — CSV parsing and data processing
• JSON — structured output format

Validation Rules

• All required fields must be present (id, full_name, age, diagnosis, enrolled_at, trial_id)
• Age must be between 0 and 120
• Enrollment date must follow YYYY-MM-DD format

How to Run

pip install pandas colorama
python validator.py

Output

• valid_patients.json — clean, validated records only
• validation_report.json — full report with errors per invalid row