Install any skill in seconds. Free to start, no credit card required.
Get Started Free →datadrivenconstruction/csv-handler
Handle CSV files from construction software exports. Auto-detect delimiters, encodings, and clean messy data.
Passed 18 of 22 test cases with the skill, and 10 of 22 without it.
and 6 more in the full report
8 fixed10 passed either way4 still failing0 broke
Tokens, turns and time describe resource use, not a dollar price.
One of 8 test cases the skill fixed. Same model, same prompt, with and without the skill.
We need to save a cleaned submittal tracking table to disk. What are the default character encoding and separator parameters when exporting DataFrames to CSV using the construction handler?
| Checked | Without skill | With skill |
|---|---|---|
| Uses utf-8-sig as the default encoding | Missed | Passed |
| Uses comma as the default delimiter | Passed | Passed |
The instructions your model reads when the skill loads.
CSV is the universal exchange format in construction - from scheduling exports to cost databases. This skill handles encoding issues, delimiter detection, and data cleaning.
import pandas as pd
import csv
from typing import Dict, Any, List, Optional, Tuple
from pathlib import Path
from dataclasses import dataclass
import chardet
@dataclass
class CSVProfile:
"""Profile of CSV file."""
encoding: str
delimiter: str
has_header: bool
row_count: int
column_count: int
columns: List[str]
class ConstructionCSVHandler:
"""Handle CSV files from construction software."""
COMMON_DELIMITERS = [',', ';', '\t', '|']
COMMON_ENCODINGS = ['utf-8', 'utf-8-sig', 'latin-1', 'cp1252', 'iso-8859-1']
def __init__(self):
self.last_profile: Optional[CSVProfile] = None
def detect_encoding(self, file_path: str) -> str:
"""Detect file encoding."""
with open(file_path, 'rb') as f:
raw = f.read(10000)
test cases passed, vs 10 / 22 without
More skills from the same source and nearby in the registry, with their headline benchmark lift.