Skip to content
Kitbay
Submit
Skill

pie-chart-data-analysis

MITUpdated on Nov 3, 20266,066GitHub stars

A capability sub-skill of SenseNova's Excel data-analysis workflow, written in Chinese.

What the skill teaches

A capability sub-skill of SenseNova's Excel data-analysis workflow, written in Chinese. It walks the agent through pandas code that reads an Excel workbook with several sheets or a CSV file, counts rows to decide how to handle large files, guesses which column holds categories and which holds amounts, fills merged cells and cleans values, then totals each category with its share of the whole. It draws a styled pie chart with matplotlib and writes the summary table and chart into an Excel report the user can download. The code is inline in the skill rather than in separate scripts.

Capabilities

  • Read multi-sheet Excel or CSV files with pandas
  • Detect category and value columns automatically
  • Total categories with percentage shares
  • Export a pie chart and summary into an Excel report