agentsclimarketplace

Python excel stats pie chart to word

Skill ECNU-ICALK/AutoSkill/SkillBank/Users/chinese_gpt3.5_8_GLM4.7/python_excel_stats_pie_chart_to_word

AutoSkill: Experience-Driven Lifelong Learning via Skill Self-Evolution

Install
npx -y skills add ECNU-ICALK/AutoSkill --skill python_excel_stats_pie_chart_to_word

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

One thing to look at

  • no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.

What its author says it does

Copied from the file, not written here

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.md

2.5 KB, as published. Nobody here has run it

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列数据频率统计并可视化
  • 代码不含中文

Keep looking

Skills are one crate of 328,083. Ordering is by how many stacks a row turns up in, so the top of any crate is what has actually been picked rather than what has the most stars.