Verified Agent Skill record

Line Chart Visualization

This skill documents a Python workflow for loading Excel data, identifying a header row, cleaning numeric fields, deriving categories and scores, performing standardized KMeans clustering and cross-tabulation, and producing trend, distribution, proportion, and cluster visualizations. It saves the chart to output_chart.png and the cleaned table to output_table.xlsx.

Tasks

Load structured Excel data from input_data.xlsx, identify a header row containing the documented target columns, forward-fill group values, extract numeric values from value_col1, and remove rows without usable value_col1 data.
Create the documented derived fields, including level and comprehensive_score, then standardize available numeric features and apply KMeans clustering when those features exist.
Produce the documented four-panel visualization when the relevant fields are available: a line-chart trend comparison, a value-distribution histogram, a level-proportion pie chart, and a cluster scatter plot.
Save the chart as output_chart.png and the cleaned data as output_table.xlsx, then report the documented local file links.

Inputs

An Excel workbook at the documented path input_data.xlsx.
Workbook sheets that can be read with pandas.read_excel.
Data containing, where applicable, the placeholder columns group_col, value_col1, and value_col2.

Outputs

A multi-panel chart saved as output_chart.png.
Cleaned and augmented data saved as output_table.xlsx.
Printed local file links for the chart and cleaned data.

Limitations and checks

The documented column names group_col, value_col1, and value_col2 are explicitly presented as placeholder examples and must be adapted to the workbook.
The category thresholds, score rules, KMeans cluster count, and plot labels are example logic rather than documented domain-specific settings.
Several analysis and visualization steps run only when their referenced columns or derived fields are present.
The source documents an installation location but provides no installation instructions or installation commands.
The source does not document supported platforms.
Confirm that input_data.xlsx can be opened and that the selected workbook sheets are readable before processing.
Confirm that a header row containing all documented target placeholder columns is found, or record that the workflow will continue with the original column structure.
Confirm that value_col1 is converted to numeric data and that rows lacking usable value_col1 values are removed as documented.