Fix import sorting in tests/conftest.py to satisfy CI

Transition data layer to local CSV using pandas

Refactor app with security fixes, error handling, and type safety