large-file-conditional-formatting
根据Excel总行数自动切换Parquet加速读取,计算特定维度的时间序列平均值,并使用openpyxl输出带有条件格式(如低于均值标绿)和自定义样式的分析报告。
Install / Use
npx skills add OpenSenseNova/SenseNova-Skills --skill threshold-cell-coloringInstalls into whichever agent you are using.
SKILL.md
Installable skill definition
Quality Score
Category
AutomationSupported Platforms
Our assessment of large-file-conditional-formatting
large-file-conditional-formatting scores 87/100 on our quality scale, 1648th of 2,790 Automation skills we index.
Its SKILL.md is 3.6 KB long, well organised into 12 sections with 3 code examples: a solid amount of guidance for an agent.
With 5,691 GitHub stars, it is one of the more widely adopted skills in the catalogue.
Maintenance, license and trust
- The repository was last updated about 2 months ago, so large-file-conditional-formatting is actively maintained.
- Our last check on 2026-11-02 found the source still online.
- It is released under the MIT license, a permissive license that allows use, modification and commercial use with attribution.
- Its trust signals score 100/100, with no cautions. These come from repository metadata, not a code audit — read the skill file before letting an agent act on it.
Safety scan
No issues foundOur scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful.
AI review by kimi-k2.7-code on 2026-09-27. Automated pattern scan on 2026-09-27. It catches known dangerous patterns, not every risk — read a skill before letting an agent act on it.
large-file-conditional-formatting compared with similar skills
All 4 of these similar skills score higher than large-file-conditional-formatting; compare them before choosing.
| Skill | Score | Stars | Updated | Format |
|---|---|---|---|---|
| large-file-conditional-formatting (this skill)by OpenSenseNova | 87 | 5.7k | 59d ago | SKILL.md |
| Agent-Reachby Panniantong | 100 | 112.3k | 8d ago | CLAUDE.md |
| rufloby ruvnet | 100 | 81.9k | today | CLAUDE.md |
| headroomby headroomlabs-ai | 100 | 79.8k | today | CLAUDE.md |
| Claude-Code-Game-Studiosby Donchitos | 100 | 39.7k | 7d ago | CLAUDE.md |
Frequently asked questions
- How do I install large-file-conditional-formatting?
- Run
npx skills add OpenSenseNova/SenseNova-Skills --skill large-file-conditional-formatting. The install tabs above show the steps for each supported agent. - Which AI agents does large-file-conditional-formatting work with?
- It is written for Universal, as a SKILL.md file. Other agents that read the same format can often use it too.
- Is large-file-conditional-formatting safe to use?
- Our scan of the whole file found no instruction hijacking, hidden characters, credential access, data exfiltration or destructive commands. An AI review of the same text found nothing harmful. It is MIT-licensed and scores 100/100 on trust signals. Skills are instructions an agent will follow, so read the file before installing it and do not approve commands you do not understand.
- Is large-file-conditional-formatting still maintained?
- The repository was last updated about 2 months ago, so large-file-conditional-formatting is actively maintained.
Skill content
View source on GitHubname: large-file-conditional-formatting description: "根据Excel总行数自动切换Parquet加速读取,计算特定维度的时间序列平均值,并使用openpyxl输出带有条件格式(如低于均值标绿)和自定义样式的分析报告。"
Skill Steps
Note: This sub-skill covers one step of the Excel analysis workflow. For the full pipeline (file reading, row counting, large-file optimization, export), see the parent workflow SKILL.md.
Step1 读取文件并统计所有 sheet 的行数,汇总后打印总行数,用于判断是否需要大文件加速。
import pandas as pd
import openpyxl
file_path = "input_data.xlsx"
# 获取所有sheet名称
wb = openpyxl.load_workbook(file_path, read_only=True)
sheet_names = wb.sheetnames
print("Sheet列表:", sheet_names)
print("Sheet数量:", len(sheet_names))
# 统计每个sheet的行数
total_rows = 0
for name in sheet_names:
df_temp = pd.read_excel(file_path, sheet_name=name, header=None)
rows = len(df_temp)
total_rows += rows
print(f"Sheet '{name}': {rows} 行")
print(f"\n总行数 = {total_rows}")
Step2 提取目标实体的时间序列数据,计算平均值,并构建包含比较结果的结构化 DataFrame。
target_entity = 'Target_Entity' # 占位示例,如 'US'
# 提取目标行数据 (假设第0列为实体名称)
target_row = df[df[0] == target_entity]
# 提取时间标签和对应数值 (假设第6行为表头,1:10列为数据)
time_labels = df.iloc[6, 1:10].tolist()
target_values = target_row.iloc[0, 1:10].tolist()
target_values_numeric = [float(v) for v in target_values]
# 计算平均值
avg_value = sum(target_values_numeric) / len(target_values_numeric)
# 构建结果 DataFrame
result_data = {
'时间维度': time_labels,
'指标数值': target_values_numeric,
'是否低于平均值': [v < avg_value for v in target_values_numeric]
}
result_df = pd.DataFrame(result_data)
Step3 使用 openpyxl 将分析结果保存为 Excel 文件,应用精细的样式控制(加粗标题、边框、居中对齐),并对低于平均值的行进行条件格式填充(标绿)。
from openpyxl import Workbook
from openpyxl.styles import PatternFill, Font, Alignment, Border, Side
wb = Workbook()
ws = wb.active
ws.title = "指标分析报告"
# 定义样式
green_fill = PatternFill(start_color="92D050", end_color="92D050", fill_type="solid")
header_fill = PatternFill(start_color="4472C4", end_color="4472C4", fill_type="solid")
header_font = Font(bold=True, color="FFFFFF")
thin_border = Border(
left=Side(style='thin'), right=Side(style='thin'),
top=Side(style='thin'), bottom=Side(style='thin')
)
# 设置主标题
ws.merge_cells('A1:D1')
ws['A1'] = f"目标实体指标分析 - 平均值: {avg_value:.2f}"
ws['A1'].font = Font(bold=True, size=14)
ws['A1'].alignment = Alignment(horizontal='center')
# 设置表头
headers = ['时间维度', '指标数值', '与平均值比较', '是否标绿']
for col, header in enumerate(headers, 1):
cell = ws.cell(row=3, column=col, value=header)
cell.fill = header_fill
cell.font = header_font
cell.alignment = Alignment(horizontal='center')
cell.border = thin_border
# 写入数据并应用条件格式
for i, row_data in result_df.iterrows():
row_num = i + 4
time_label = row_data['时间维度']
value = row_data['指标数值']
below_avg = row_data['是否低于平均值']
# 写入各列数据
ws.cell(row=row_num, column=1, value=time_label).alignment = Alignment(horizontal='center')
ws.cell(row=row_num, column=2, value=value).alignment = Alignment(horizontal='center')
diff = value - avg_value
ws.cell(row=row_num, column=3, value=f"{diff:+.2f}").alignment = Alignment(horizontal='center')
ws.cell(row=row_num, column=4, value="是" if below_avg else "否").alignment = Alignment(horizontal='center')
# 添加边框并根据条件标绿整行
for col in range(1, 5):
cell = ws.cell(row=row_num, column=col)
cell.border = thin_border
if below_avg:
cell.fill = green_fill
# 调整列宽
ws.column_dimensions['A'].width = 15
ws.column_dimensions['B'].width = 20
ws.column_dimensions['C'].width = 18
ws.column_dimensions['D'].width = 12
output_path = "output_report.xlsx"
wb.save(output_path)
print(f"分析报告已保存至: {output_path}")
Related Skills
Agent-Reach
112.3kGive your AI agent eyes to see the entire internet. Read & search Twitter, Reddit, YouTube, GitHub, Bilibili, XiaoHongShu — one CLI, zero API fees.
ruflo
81.9k🌊 The original agent harness. Deploy intelligent multi-player swarms, coordinate autonomous workflows, and build conversational AI systems. Features adaptive memory, self-learning intelligence, federation, vector RAG integration, and native Claude Code / Codex / Hermes and many more Integrated
headroom
79.8kCompress tool outputs, logs, files, and RAG chunks before they reach the LLM. 20% fewer tokens for coding agents, 60-95% fewer tokens for JSON, same answers. Library, proxy, MCP server.
Claude-Code-Game-Studios
39.7kTurn Claude Code into a full game dev studio — 49 AI agents, 72 workflow skills, and a complete coordination system mirroring real studio hierarchy.
Languages
Trust signals
From repository metadata: license, adoption, age and documentation. Not a code audit — see the Safety scan above for what the skill file itself contains.
