Zum Inhalt springen
Kitbay
Skill

excel-data-analysis-and-report-generation

MITAktualisiert am 3. Nov. 20266.066GitHub-Sterne

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

Was der Skill vermittelt

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.

Funktionen

  • 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