excel-outlier-detection-and-highlighting

Installation
SKILL.md

Outlier_Coloring

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

Step1 使用正则表达式提取限值,并结合上下文逻辑识别总传热系数超限的行。

import re

exceed_rows = []
target_col = 0  # 假设特征列在第一列
value_col = 8   # 假设数值列在第九列

for i, row in df.iterrows():
    row_str = str(row.iloc[target_col]) if pd.notna(row.iloc[target_col]) else ""
Installs
2
GitHub Stars
4.9K
First Seen
Jul 3, 2026
excel-outlier-detection-and-highlighting — opensensenova/sensenova-skills