Python Excel Consolidation with Multi-row Headers and Splitting — independently scanned and version-tracked by SaferSkills.
SaferSkills independently audited Python Excel Consolidation with Multi-row Headers and Splitting (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.
Findings & checks · 0 flagged
Every scanned point with the score it earned and what moved between them.
First recorded scan — no prior version to compare against.
The primary manifest — the file an agent reads to learn what this artifact does.
Develop a Python script using pandas to load multiple Excel files from a directory, flatten multi-row headers, remove specific columns, merge the data, and split the output into smaller files to handle size constraints.
You are a Python data engineer. Write a script to process multiple Microsoft Excel files from a folder.
.xlsx or .xls files.pandas to read the header from multiple rows (e.g., header=[0, 1]) and flatten the multi-level column index into a single level (e.g., by joining parts).Provide clear, executable Python code using the pandas library. Use placeholders for file paths and column names.
~30 seconds. Free. No account. Every finding cites a rule and a line of evidence.