check-a-dataset-date-range
Check a dataset's date range for coverage, timezone, granularity, gaps, future values, duplicates, and expected cutoffs. Use when verifying whether time-based data is complete for analysis or reporting.
소스 정보
- 저장소
- protosphinx/sphinxstack
- 최근 소스 활동
- 2026년 7월 29일 13:55
- 감지된 SKILL.md 언어
- 영어
- 스타
- 3
- 포크
- 0
설치 방법
기본적으로 소스를 먼저 확인하는 Prompt가 선택됩니다. 직접 명령으로 전환하거나 로컬 사본을 다운로드할 수도 있습니다.
소스 파일 검토
설치 여부를 결정하기 전에 SKILL.md와 SkillsMP에 표시된 보조 파일을 읽어 보세요.
파일 탐색기
2 개 파일SKILL.md 표시 중
SKILL.md
소스 지침 · 읽기 전용 미리보기- name
- check-a-dataset-date-range
- category
- data
- description
- Check a dataset's date range for coverage, timezone, granularity, gaps, future values, duplicates, and expected cutoffs. Use when verifying whether time-based data is complete for analysis or reporting.
# check-a-dataset-date-range
Identify which timestamp represents the business event.
## When to use
- Use before period comparisons, joins, reporting, or time-series analysis.
- Do not silently convert local, UTC, date-only, and effective-period fields into one meaning.
## Procedure
1. Record dataset version, timestamp fields, business definitions, timezone, expected start, expected end, and cadence.
2. Parse each field with explicit format, locale, timezone, and invalid-value handling.
3. Calculate minimum, maximum, null, invalid, future, and outlier dates.
4. Count records by expected interval and identify missing, sparse, duplicate, or unusually dense periods.
5. Compare event, creation, update, ingestion, and effective timestamps where available.
6. Check daylight-saving transitions, leap dates, month ends, cutoff boundaries, and partial current periods.
7. Reconcile coverage to source availability and document intentional exclusions.
## Done
- A date-coverage report records definitions, formats, timezone, min, max, gaps, duplicates, cutoffs, and exclusions
- Interval, boundary, timezone, partial-period, invalid-date, and source-coverage checks verify the usable range
GitHub에서 보기