line-chart-visualization

Cluster Excel data and generate multi-dimensional trend and distribution charts.

110|3|Updated Feb 26, 2026
One-click install
npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill line-chart-visualization-michaelyang-lyx
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: line-chart-visualization
Source: https://github.com/MichaelYang-lyx/AIDABench/tree/main/skills/sn-da-excel-workflow/capability/excel-data-visualization/line-chart-visualization
Command: npx skills add https://github.com/MichaelYang-lyx/AIDABench --skill line-chart-visualization-michaelyang-lyx

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

本技能将结构化数据从 Excel/表格源中提取、进行缺失值处理与特征清洗,并执行聚类分析,生成包含趋势对比、分布特征与参数敏感性的多维度可视化图表,帮助用户快速理解数据结构与潜在分组。

Core Features & Use Cases

  • 数据加载与动态表头识别:支持大文件的 Parquet 转换以提升处理效率,自动识别有效数据区域。
  • 特征工程与聚类分析:执行数据标准化、缺失值处理与 KMeans 等聚类,输出综合评分及聚类标签。
  • 多维可视化输出:生成趋势对比、分布特征与聚类分布等图表,辅助多维度决策和参数敏感性分析。 Use Case: 对多源表格数据进行趋势对比、异常点识别以及群组结构发现,以支持业务洞察与策略规划。

Quick Start

Run the line-chart-visualization workflow on your Excel dataset to generate charts and a cleaned data output.

Frequently Asked Questions about line-chart-visualization

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I visualize multi-dimensional trends and clusters in Excel data?

To visualize multi-dimensional trends and clusters in Excel data, you can use a workflow that loads structured spreadsheets, cleans missing values, applies KMeans clustering, and generates trend, distribution, and sensitivity charts.

What is the best way to identify group structures in large spreadsheet datasets?

Identifying group structures in large spreadsheet datasets is best achieved through clustering analysis, which standardizes features, handles missing values, and applies KMeans to output cluster labels and distribution visualizations.

Can I use pandas and scikit-learn to clean Excel files and generate trend charts?

Yes, you can use pandas and scikit-learn to clean Excel files and generate trend charts by loading structured data, performing feature engineering, applying clustering, and visualizing results with seaborn or matplotlib.

Does this data analysis approach support large Excel files for cross-sectional comparisons?

This data analysis approach supports large Excel files for cross-sectional comparisons by converting spreadsheets to Parquet for efficient processing, dynamically identifying headers, and generating multi-dimensional visualizations.

How do I perform parameter sensitivity analysis on structured spreadsheet data?

To perform parameter sensitivity analysis on structured spreadsheet data, the workflow executes feature engineering and clustering, then outputs visualizations that highlight distribution characteristics and parameter sensitivities across clusters.