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

multi-file-excel-parquet-analysis

Count rows across Excel sheets and generate categorical statistics with Parquet.

2|Updated May 19, 2026
Search Tags:#report generation#visualization#pandas#excel#parquet#data profiling#categorical statistics
One-click install
npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill multi-file-excel-parquet-analysis-aiyinluya
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: multi-file-excel-parquet-analysis
Source: https://github.com/aiyinluya/SenseNova-Skills-Studio/tree/main/skills/sn-da-excel-workflow/capability/excel-reading/multi-file-reading
Command: npx skills add https://github.com/aiyinluya/SenseNova-Skills-Studio --skill multi-file-excel-parquet-analysis-aiyinluya

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill helps you read multi-sheet Excel files, estimate dataset scale, and produce categorical statistics with a shareable visualization and report, so you can stop manual counting and accelerate downstream analysis.

Core Features & Use Cases

  • Multi-sheet Excel row counting: Iterates through all sheets and totals row counts to assess data size.
  • Large-file workflow with Parquet: Supports converting/reading data via Parquet for more scalable processing.
  • Categorical frequency & proportion analysis: Computes counts and percentages for a chosen target column (e.g., status/result categories).
  • Output deliverables: Generates a pie chart image and an Excel summary report for easy review and download.

Use case: You receive a workbook containing many sheets and a categorical field such as "状态" or "剪裁结果"; you want a quick dataset scale check plus a distribution report for decision-making.

Quick Start

Ask the AI to analyze the attached multi-sheet Excel file by counting rows across all sheets, converting to Parquet if needed, then generating categorical statistics and a pie-chart report for the target column.

Frequently Asked Questions about multi-file-excel-parquet-analysis

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

FAQPage Schema
How do I count rows across multiple Excel sheets and generate a categorical summary?▼

Parquet processing converts multi-sheet Excel data into a scalable columnar format, enabling efficient partial reads for large dataset scale estimation before performing categorical distribution analysis and generating downstream reports.

Does this approach work for large multi-sheet Excel files that need partial reads?▼

It generates a pie chart image visualizing categorical distributions and an Excel summary report containing row counts and classification proportions, providing shareable outputs for quick dataset review and decision-making.

Can I compute categorical frequency and proportion for a specific column across all sheets?▼

Yes, you can compute categorical frequency and proportion for a specific target column across all sheets, quantifying classification distributions like status or result categories to produce an automated visualization and Excel report.

What is the best way to convert multi-sheet Excel files to Parquet for data profiling?▼

The best way to convert multi-sheet Excel files to Parquet for data profiling is through sheet iteration and Parquet-based downstream analysis, which accelerates large dataset processing and categorical statistics generation.

Related Skills

Explore More Data & Analytics Skills→
MichaelYang-lyxMichaelYang-lyx
110

excel-multi-sheet-dynamic-analysis

Analyze multi-sheet Excel workbooks to identify target columns and generate cross-sheet reports.

Community
Intermediate
zm2231zm2231

data-analysis

Analyze CSV, Excel, or JSON datasets to extract statistics and generate charts.

Community
Advanced
Jignesh-PonamwarJignesh-Ponamwar
5

data-analysis

Analyze tabular datasets with pandas to uncover insights and data-quality issues.

Community
Advanced
MichaelYang-lyxMichaelYang-lyx
110

multi-file-excel-parquet-analysis

Read multi-sheet Excel files, count rows per sheet, and export Parquet reports.

Community
Advanced