category-filtering-and-difficulty-analysis

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

2|Updated May 19, 2026
One-click install
npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill category-filtering-and-difficulty-analysis-aiyinluya
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: category-filtering-and-difficulty-analysis
Source: https://github.com/aiyinluya/SenseNova-Skills-Studio/tree/main/skills/sn-da-excel-workflow/capability/excel-data-filtering/category-filtering
Command: npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill category-filtering-and-difficulty-analysis-aiyinluya

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you classify Excel records into custom categories, run cross-tab/stacked analyses by groups, and evaluate the difficulty/quality of text content with a multidimensional scoring approach.

Core Features & Use Cases

  • Custom category mapping & distribution analysis: Convert raw category values into higher-level groups and generate counts plus share visualizations (bar + pie).
  • Cross analysis by subgroup: Build crosstabs and stacked bar charts to compare category distributions across a grouping column.
  • Multidimensional difficulty scoring & rating: Compute a综合评分 using signals like text length, term/keyword presence, numeric existence, and regex-based features, then output difficulty levels (高/中/低).

Quick Start

Use the category-filtering-and-difficulty-analysis skill to analyze an Excel file by mapping the target category column into custom “big categories”, then generate distribution charts, a cross-analysis chart, and a difficulty/grade summary from the specified text column.

Frequently Asked Questions about category-filtering-and-difficulty-analysis

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

FAQPage Schema
How do I cross-analyze Excel category distributions by subgroup?

Cross-analyze Excel category distributions by building crosstabs and stacked bar charts to compare category frequencies across a specified grouping column. The Skill maps raw values into higher-level groups and visualizes subgroup comparisons.

What is text difficulty scoring and how does it evaluate content quality?

Text difficulty scoring evaluates content quality by computing a comprehensive score using text length, keyword and regex signals, and numeric existence. It maps the resulting score against tier thresholds to output high, medium, or low difficulty levels.

Can I map raw Excel category values into higher-level custom groups for analysis?

Yes, you can map raw Excel category values into higher-level custom groups for analysis. The Skill applies category mapping logic to convert raw values, then generates distribution counts and share visualizations using bar and pie charts.

Does this Skill require Python to load Excel data for category aggregation?

Yes, this Skill requires Python-based data loading to import Excel datasets for category aggregation. It uses Python to execute value_counts and crosstab statistical counting, along with category mapping logic for multidimensional office analytics.

What is the best way to visualize multi-class distribution statistics from an Excel file?

The best way to visualize multi-class distribution statistics from an Excel file is to generate bar and pie charts after aggregating custom categories. This Skill produces share visualizations and stacked bar charts to compare distributions across subgroups.

Why use regex and keyword signals for text difficulty evaluation in Excel datasets?

Regex and keyword signals provide multidimensional feature extraction for text difficulty evaluation in Excel datasets. Combining these signals with text length and numeric existence generates a comprehensive score that accurately tiers content into high, medium, or low difficulty.