skills.rest
aiyinluya
aiyinluyaCOMMUNITY
Explore all skills by this author →
GitHub

chart-embedded-export

Clean Excel data, compute crosstabs, and export charts as PNG and SVG.

2|Updated May 19, 2026
Search Tags:#visualization#excel#data cleaning#report export#crosstab#embedded charts#python pandas
One-click install
npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill chart-embedded-export-aiyinluya
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: chart-embedded-export
Source: https://github.com/aiyinluya/SenseNova-Skills-Studio/tree/main/skills/sn-da-excel-workflow/capability/excel-result-export/chart-embedded-export
Command: npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill chart-embedded-export-aiyinluya

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It turns messy, structured Excel-like data into clean category distributions, multi-dimensional cross analysis, and a complete downloadable report with embedded high-resolution visualizations.

Core Features & Use Cases

  • Data cleaning & category mapping: Fills merged cells, sanitizes text with regex, converts numeric fields, and builds a category-mapping function from field patterns.
  • Cross-tab and aggregation analytics: Produces crosstabs with totals and computes group-level summary statistics (sum/mean/min/max).
  • Exportable results + visuals: Exports the analyzed dataset to Excel, generates a sandbox download link, and creates a 4-in-1 chart panel (pie, bar, box, histogram) exported as PNG and SVG with multilingual font support.

Quick Start

Ask the AI to run chart-embedded-export to clean the dataset, compute category distributions and cross analysis for the chosen group fields, export analysis_result.xlsx, and generate comprehensive_chart.png/.svg with an embedded Markdown report.

Frequently Asked Questions about chart-embedded-export

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

FAQPage Schema
How do I generate Excel reports with embedded high-resolution charts from raw tabular data?▼

You can generate Excel reports with embedded charts by running automated data cleaning, pandas crosstab aggregation, and multi-format visualization export to produce downloadable analysis_result.xlsx and comprehensive_chart.png/svg files.

What is the best way to clean messy Excel data for crosstab analysis and category distribution?▼

Cleaning messy Excel data for crosstab analysis involves filling merged cells, sanitizing text with regex, converting numeric fields, and building category-mapping functions from field patterns to ensure deterministic structured tabular data.

Can I create multi-dimensional aggregation statistics with totals using python pandas for large files?▼

Yes, you can compute multi-dimensional aggregation statistics with totals using pandas crosstab with margin totals, alongside group-level summary statistics including sum, mean, min, and max for large-file processing workflows.

Does this data cleaning and visualization workflow support multilingual font rendering in exported charts?▼

The data cleaning and visualization workflow supports multilingual font rendering, generating 4-in-1 chart panels with pie, bar, box, and histogram visuals exported as high-resolution PNG and SVG files.

How do I export crosstab results and visualizations to get a sandbox download link?▼

You export crosstab results by asking the AI to process your dataset, which computes category distributions and generates a sandbox download link containing the analyzed Excel file alongside embedded high-resolution chart visuals.

What are the limitations of automated Excel data cleaning for cross-sectional statistics?▼

Automated Excel data cleaning for cross-sectional statistics requires deterministic structured tabular data input and applies regex sanitization, meaning irregular unstructured formats or unsupported file types may not process correctly without prior manual preparation.

Related Skills

Explore More Data & Analytics Skills→
iOfficeAIiOfficeAI
31.8k

xlsx

Create, edit, and analyze Excel spreadsheets with pandas and openpyxl.

Official
Advanced
jaechang-hitsjaechang-hits
298

Plotly Interactive Plots

Generate interactive Plotly charts with hover, zoom, and pan.

Community
Intermediate
aiyinluyaaiyinluya
2

category-filtering-and-difficulty-analysis

Analyzes Excel categories and computes multidimensional difficulty scores from text signals.

Community
Intermediate
MichaelYang-lyxMichaelYang-lyx
110

excel-statistical-viz-large-file

Analyze large Excel datasets with pandas, numpy, matplotlib, and scipy.

Community
Advanced