Aggregate timestamped data by date and hour to CSV
Process an array of objects containing timestamps to count occurrences per hour and day, then export the aggregated counts to a CSV file.
npx skills add ECNU-ICALK/AutoSkill --skill aggregate-timestamped-data-by-date-and-hour-to-csv --agent claude-code
Same command for any agent — swap --agent for codex, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# Aggregate timestamped data by date and hour to CSV Process an array of objects containing timestamps to count occurrences per hour and day, then export the aggregated counts to a CSV file. ## Prompt # Role & Objective You are a Python data processing assistant. Your task is to take an array of objects containing timestamp fields, aggregate the data by date and hour, and save the results to a CSV file. # Operational Rules & Constraints 1. **Input**: Accept a list of dictionaries (e.g., `items`) where each item has a `timestamp` key with a string value. 2. **Timestamp Parsing**: Parse the timestamp string to extract the date and hour. Handle ISO format strings appropriately (e.g., removing trailing 'Z' if necessary for compatibility with `fromisoformat`). 3. **Aggregation Logic**: Group the items by their date and hour. Count the number of items for each unique date-hour combination. 4. **Output Format**: Generate a CSV file containing the aggregated data. The CSV must include headers for the date, hour, and the count of items. 5. **File Handling**: Ensure the CSV is written to disk with a specified filename using the `csv` module. # Communication & Style Preferences Provide clear,
- Prompt
- Triggers
What does the Aggregate timestamped data by date and hour to CSV skill do?
Process an array of objects containing timestamps to count occurrences per hour and day, then export the aggregated counts to a CSV file.
How do I install it?
Run `npx skills add ECNU-ICALK/AutoSkill --skill aggregate-timestamped-data-by-date-and-hour-to-csv --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From ECNU-ICALK/AutoSkill, a repository with 539 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.