dynamic-large-file-parquet-analysis

by OpenSenseNova5.8k

动态统计Excel总行数，当数据量过大（≥10000行）时自动转换为Parquet格式加速读取，并对指定目标列进行条件筛选、分类汇总与结果导出，适用于超大体积Excel文件的快速读取与统计分析。

Install

The skill file stays in the publisher's repository.

Paste the copied command in a terminal. It installs this SKILL.md into that agent.

npx skills add OpenSenseNova/SenseNova-Skills --skill table-theme-styling -a cursor -y

Download skill skills/sn-da-excel-workflow/capability/excel-table-styling/table-theme-styling/SKILL.md on GitHub

Related skills

View all

Questions

How do I install dynamic-large-file-parquet-analysis?: Download skills/sn-da-excel-workflow/capability/excel-table-styling/table-theme-styling/SKILL.md from the publisher, or copy the path and open the repository. PlugMCP lists the skill and does not host the file.
Where does dynamic-large-file-parquet-analysis live?: The publisher keeps it at https://github.com/OpenSenseNova/SenseNova-Skills.
Which agents can use dynamic-large-file-parquet-analysis?: Claude, Cursor, and Codex can read a SKILL.md you add from the publisher's repository.

name: dynamic-large-file-parquet-analysis description: "动态统计Excel总行数，当数据量过大（≥10000行）时自动转换为Parquet格式加速读取，并对指定目标列进行条件筛选、分类汇总与结果导出，适用于超大体积Excel文件的快速读取与统计分析。"

Skill Steps

This sub-skill covers one capability of the Excel workflow. For reading/counting/Parquet optimization, see the parent workflow SKILL.md.

Step1 动态读取数据（Parquet加速或常规读取）。

# 若已加载 sn-da-large-file-analysis 技能，将 Excel 文件转换为 Parquet 格式加速读取
if 'da_large_file_analysis' in globals():
    # 假设 sn-da-large-file-analysis 转换后生成了 parquet 文件
    parquet_path = 'auto_converted_data.parquet'
    df = pd.read_parquet(parquet_path)
    print("已使用 Parquet 格式加速读取大文件。")
else:
    df = pd.read_excel(file_path, sheet_name='Sheet1', header=0)
    print("文件较小，使用常规方式读取。")