Implement a utility function for parsing URLs and determining their component count to facilitate reusability across multiple scripts

This issue is related to the PR #68
Duplicate lines:
- lines 196 - 198 in the script `github_repo_request_local.py`
- lines 194 -196 in the script `initial_data_preparation.py`

Start by comparing lines 196–198 in github_repo_request_local.py with lines 194–196 in initial_data_preparation.py, as referenced in the issue and PR #68. Identify the shared URL parsing and component-counting behavior, then verify that both scripts use the reusable utility while preserving their existing results.

Written by the indexing model from the issue text.