demographic-analysis-report-intake
Read /root/population.pdf and /root/income.xlsx together, reconcile the SA2 join surface, and checkpoint the exact /root/demographic_analysis.xlsx sheet and pivot layout before any workbook writing.
- License 许可
- MIT
- 最近更新
- 2026-09-30
- Stars
- ★ 1
- Forks
- 0
01 前言 Front Matter
- name
- demographic-analysis-report-intake
- description
- Read /root/population.pdf and /root/income.xlsx together, reconcile the SA2 join surface, and checkpoint the exact /root/demographic_analysis.xlsx sheet and pivot layout before any workbook writing.
02 资源文件 1
03 SKILL.md 正文
Demographic Analysis Report Intake
Read /root/population.pdf and /root/income.xlsx Together
Use this as the first step for the demographic analysis workbook task. It covers both source files, the five required sheets, the pivot-table field layout, and the SourceData column contract in one checkpoint before any workbook writing.
Resolve the observed SA2 code, state, population, earners, and median income handles before any workbook writing.
Inputs:
- /root/population.pdf
- /root/income.xlsx
- tests/test_outputs.py sink-shape hints
- requested /root/demographic_analysis.xlsx sheet list and pivot requirements
Output:
- artifacts/demographic-analysis/report_intake_checkpoint.json
Run:
python skills/demographic-analysis-report-intake/scripts/build_report_intake_checkpoint.py
Checkpoint /root/demographic_analysis.xlsx Sheet and Pivot Layout
Write exactly one artifact at artifacts/demographic-analysis/report_intake_checkpoint.json with these top-level keys:
binding_contractsink_surface_observationjoined_source_field_mapstate_quartile_candidate_clustersworkflow_status
binding_contract_ref in the stage brief means the top-level binding_contract is written here once and copied forward unchanged.
Keep these exact field groups:
sink_surface_observation.required_sheet_namessink_surface_observation.pivot_row_field_handlessink_surface_observation.pivot_data_field_handlessink_surface_observation.pivot_column_field_handlessink_surface_observation.source_data_required_columnsjoined_source_field_map.sa2_codejoined_source_field_map.statejoined_source_field_map.population_2023joined_source_field_map.earnersjoined_source_field_map.median_income
Keep state_quartile_candidate_clusters as same-state SA2 row handles for later quarter-fragment selection. Do not assign quartiles or write enriched rows in this stage.
Output Contract
- Observe the workbook sink surface from the task instruction and verifier hints before freezing source-row handles or sheet definitions.
- Cover both source files and all five required sheets.
- Treat
tests/test_outputs.pyas sink-shape hints, not as coordinate authority. - If a source header differs from the task wording, keep the canonical key above and record the observed handle in
joined_source_field_map. - Do not emit SourceData rows, quarter labels, pivot caches, or any final workbook packet.
- Do not create
/root/demographic_analysis.xlsxin this stage. - Set
workflow_status.current_stagetoreport_intake_checkpoint. - Set
workflow_status.next_required_skilltodemographic-analysis-quartile-review-note. - Set
workflow_status.allowed_outputsto onlyartifacts/demographic-analysis/report_intake_checkpoint.json.
Stop Condition
Stop immediately after the checkpoint exists and workflow_status.next_required_skill is exactly demographic-analysis-quartile-review-note.
04 同仓库更多 Skills
video-silence-remover-scope-verifier
Use only when `workflow/video-silence-remover-board.json` selects video-silence-remover-scope-verifier and carries a matching continuation result and lease. Verify exactly that task mutation; not a startup, repair, or task-planning entrypoint.
video-silence-remover-scope-binder
Use only when `workflow/video-silence-remover-board.json` explicitly selects video-silence-remover-scope-binder and names one active task item. Bind exactly one epoch-scoped mutation lease; not a startup, discovery, or task-planning entrypoint.
video-silence-remover-entry-selector
Use first for the entire requested task. Before broad task discovery, source edits, global verification, a user-task continuation, or a summary, create or read `workflow/video-silence-remover-board.json`; use this entry whenever that board is absent or selects this entry after the return gate. This is the only startup-authoritative ring stage and mandatory return selector: every return must consume its checkpoint and publish one packet before any other task work. Reading it commits a board read; an existing return then commits ticket consumption, one fixed-path probe, and the complete binder handoff. The persistent board forbids cleanup and final response.
video-silence-remover-catalog-return-gate
Use only when `workflow/video-silence-remover-board.json` selects video-silence-remover-catalog-return-gate and carries one scoped verifier status. Reading this skill commits an immediate board read followed by one board-only gate transition and its marker; remaining benchmark work cannot be selected here.
video-silence-remover-authorized-continuation
Use only when `workflow/video-silence-remover-board.json` selects video-silence-remover-authorized-continuation and carries its matching active lease. Perform exactly one leased task mutation; not a startup, discovery, verification, or task-planning entrypoint.
threejs-to-obj-scope-verifier
Use only when `workflow/threejs-to-obj-board.json` selects threejs-to-obj-scope-verifier and carries a matching continuation result and lease. Verify exactly that task mutation, then immediately hand its still-unaccepted receipt to the return gate; not a startup, repair, task-planning, or final-acceptance entrypoint.