Tame every date format into one standard
Scan any dataset for date columns, detect the formats in use (even mixed formats within the same column), flag ambiguous dates like 03/04/2024, and standardize everything to ISO 8601 with consistent timezone handling.
Create a skill called "Date Whisperer". When I give you a dataset (CSV, Excel, or point you at a database table), scan every column for potential date values — including strings, integers that look like Unix timestamps, and Excel serial numbers. For each date column found, report: the detected format(s), any mixed formats within the same column, ambiguous dates where MM/DD and DD/MM are both valid interpretations, and timezone information if present. Then standardize all dates to ISO 8601 (YYYY-MM-DD or YYYY-MM-DDTHH:MM:SSZ). Flag any dates that can't be resolved without human input. Maintain a format registry so recurring data sources from the same vendor get auto-detected next time.
Dates are the #1 data cleaning headache. Is 01/02/2024 January 2nd or
February 1st? Is that Excel serial number 45292 a date or an ID? This skill
profiles every column that might contain dates, detects the format(s) in use,
flags anything ambiguous, and converts everything to a consistent standard.
Fix broken CSVs before they break your pipeline
Drop any CSV on your Claw and get a clean, validated file back. It detects encoding issues, mixed delimiters, malformed rows, broken quoting, BOM markers, and type mismatches — then fixes everything and tells you what it changed.
Turn messy spreadsheets into clean, analyzable data
Handles the spreadsheets from hell — merged cells, multiple header rows, color-coded data, footnotes mixed with values, data starting at cell B7. Extracts clean tabular data from Excel files without forcing you to reverse-engineer the formatting first.
Update pricing across all your Airbnb listings without clicking through each one
Automate bulk rate changes across multiple Airbnb listings using your Claw. Useful for seasonal pricing updates, last-minute discounts, or syncing rates after a change in your hosting strategy.
Email and calendar without leaving your terminal
Full Gmail control via the gog CLI. Read, send, search, organize emails. Create events, set reminders, RSVP to invitations. All from natural language or CLI commands.