Community Data Process
v1.0.0北汽社群数据导出：数据清洗 → 数据校对 → 数据合并。 从客户群导出文件中筛选温冷一期和试点店标签数据， 校对关键指标一致性，增量合并到 BI_社群数据上传表。 统计日期使用源文件创建时间（下载日期）。 每天 00:55 自动执行。
⭐ 0· 104·1 current·1 all-time
MIT-0
Download zip
LicenseMIT-0 · Free to use, modify, and redistribute. No attribution required.
Security Scan
OpenClaw
Benign
high confidencePurpose & Capability
Name/description describe exporting, cleaning, auditing and merging Excel data from customer-group exports; the included run.py implements precisely those actions (find latest export in Downloads, filter by labels, validate numeric columns, map and append rows to BI file). No unrelated credentials, binaries, or services are requested.
Instruction Scope
SKILL.md and run.py both operate on local Excel files in the user's Downloads folder and on a local BI Excel file. The script uses file creation time as the 'download date', reads/writes only local files, and writes a small result text file to Downloads. There is a minor robustness issue (column selection by index and a hard-coded Windows-style Downloads path) that could cause incorrect behavior if source files differ, but it is scope-consistent rather than malicious.
Install Mechanism
No install spec and no external downloads — instruction-only plus a Python script. Dependencies are standard (Python 3.11+, pandas, openpyxl). Nothing is fetched from arbitrary URLs or installed system-wide.
Credentials
The skill requires no environment variables, credentials, or config paths. The script exclusively accesses local files in the Downloads directory and writes output there; requested access is proportional to the stated file-processing task.
Persistence & Privilege
always:false (default) and no mechanism to persist or modify other skills or global agent settings. The script writes its own result file in Downloads but does not alter other skills or request elevated privileges. Autonomous invocation is allowed by platform default but does not combine with other privilege escalations here.
Assessment
This skill appears to do what it says: local Excel processing (filter → audit → merge) with no network calls or credential access. Before installing or enabling autonomous runs, test it on copies of your files: it uses the Windows-style Downloads path and selects columns by index (position), so mismatched column orders or non-Windows environments may cause errors or incorrect mappings. It appends rows without de-duplication, so running multiple times can create duplicates — keep backups of the BI file. Also note it writes a small result file (.baic_community_result.txt) to Downloads. If you plan to run it automatically, schedule only after confirming mappings are correct and that the Downloads folder contains the expected filenames and column layout.Like a lobster shell, security has layers — review code before you run it.
latestvk970b3nkj3hb38ykrkvsc9bn6983at8q
License
MIT-0
Free to use, modify, and redistribute. No attribution required.