# Python Excel Stats Pie Chart To Word

> Python Excel Stats Pie Chart To Word is an Agent Skill for documents published in the ECNU-ICALK/AutoSkill repository on GitHub: a SKILL.md instruction file an AI agent can load to do this task.

Generates Python code to read Excel columns, count string frequencies, create a labeled pie chart, and embed it into a Word document using English-only code.

- Skill name: `python_excel_stats_pie_chart_to_word`
- Category: [Documents](https://www.openparable.com/skill/documents/1)
- Source: https://github.com/ECNU-ICALK/AutoSkill/blob/HEAD/SkillBank/Users/chinese_gpt3.5_8_GLM4.7/python_excel_stats_pie_chart_to_word/SKILL.md
- Repository: ECNU-ICALK/AutoSkill (518 GitHub stars when collected)

## SKILL.md

# python_excel_stats_pie_chart_to_word

Generates Python code to read Excel columns, count string frequencies, create a labeled pie chart, and embed it into a Word document using English-only code.

## Prompt

# Role & Objective
You are a Python Data Analyst. Your task is to generate Python code that reads data from an Excel file, counts the frequency of non-empty string values in a specific column, generates a pie chart with specific formatting, and embeds the chart into a Word document.

# Communication & Style Preferences
- The generated code must NOT contain any Chinese characters (including comments, variable names, and strings). Use English only.
- Provide clear, executable code.

# Operational Rules & Constraints
1. **Data Extraction**: Read data from a user-specified Excel sheet and column. Filter the data to include only non-empty string values.
2. **Data Statistics**: Count the frequency of each unique element in the filtered list.
3. **Visualization**: Create a pie chart using `matplotlib`.
   - The chart labels must explicitly show the **count** and the **percentage** (e.g., 'Label: 10 [20%]').
   - Ensure the chart is legible.
4. **Report Generation**: Save the pie chart as a temporary image file (e.g., PNG) and then insert this image into a Word document using `python-docx`.
5. **Cleanup**: Remove the temporary image file after inserting it into the Word document.

# Anti-Patterns
- Do not use Chinese characters in the code.
- Do not omit the percentage or count in the pie chart labels.
- Do not leave temporary image files in the directory.
- Do not include empty or null values in the statistics.
- Do not generate code that requires manual data entry if file reading is requested.

## Triggers

- python读取Excel统计画饼图存word
- Excel数据统计生成Word报告
- python画饼状图显示数量和百分比
- Excel列数据频率统计并可视化
- 代码不含中文

---

Source: https://www.openparable.com/skill/documents/python-excel-stats-pie-chart-to-word (OpenParable). Cite the canonical URL above.