本文へスキップ
Kitbay
スキル

excel-data-analysis-and-report-generation

MIT2026年11月3日 更新6,066GitHubスター

A capability sub-skill of SenseNova's Excel data-analysis workflow, written in Chinese, covering the final report step.

スキルの内容

A capability sub-skill of SenseNova's Excel data-analysis workflow, written in Chinese, covering the final report step. Its inline pandas templates map items into categories by keyword, build count tables with shares and a total row, cross-tabulate categories against a grouping column, and find rows whose values exceed a limit by searching back for the matching threshold. The results are then gathered with charts into a combined report with a download link. The column names and keywords in the code are placeholders to replace, and reading, counting and Parquet conversion are left to the parent workflow skill.

できること

  • Categorise rows by keyword and count them with shares
  • Cross-tabulate categories against groups
  • Flag rows whose values exceed a limit
  • Assemble an analysis report with charts