Skip to content
Skills Library
Data & analytics · Analysis

csv-summary

/csv-summary

Summarize a CSV file into summary.md with its row count, a total for every numeric column and a table of negative values by row. Use when the user asks to summarize, total or sanity-check a CSV file, or asks for a summary.md of tabular data.

Repository
SOTACOMMAND ↗
Licence
Apache-2.0
Last repository change
12.11.2026

Assessment and security

100/ 100Class: good
Format25 / 25
Frontmatter with name and description, valid name, description up to 1,024 characters, name matching the folder.
Discoverability25 / 25
Description explains when to use the skill, has a reasonable length and uses third person.
Content35 / 35
At least 150 words and at most 500 lines, headings, step lists, examples or code.
Hygiene15 / 15
No placeholders such as TODO, no Windows paths, with a licence.
Riskno signals detected in the scan
Files in this package
1
Scripts
0
HTML comments
0
URLs in SKILL.md
0
Deprecation

No signals detected. Repository changed on 12.11.2026, without references to retired models or APIs.

Licence

Apache-2.0, otwarta: można używać i zmieniać, z zachowaniem licencji i informacji o zmianach.

What it does and when to use it

Summarize a CSV file into summary.md with its row count, a total for every numeric column and a table of negative values by row. Use when the user asks to summarize, total or sanity-check a CSV file, or asks for a summary.md of tabular data.

Original author description

Summarize a CSV file into summary.md with its row count, a total for every numeric column and a table of negative values by row. Use when the user asks to summarize, total or sanity-check a CSV file, or asks for a summary.md of tabular data.

How it works

  1. Read the file
  2. Decide which columns are numeric
  3. Total the numeric columns
  4. Flag negative values
  5. Write summary.md
Original SKILL.md headings · 54 lines, 402 words
SKILL.md preview
---
name: csv-summary
description: Summarize a CSV file into summary.md with its row count, a total for every numeric column and a table of negative values by row. Use when the user asks to summarize, total or sanity-check a CSV file, or asks for a summary.md of tabular data.
license: Apache-2.0
metadata:
  version: "0.1.0"
  status: experimental
  pack: example
  min-tier: low
  roles: builder, researcher
  gate: none
---

# CSV summary

Read the CSV file the user names. If they name none and the working directory holds exactly one `.csv` file, use that one. Write the summary to `summary.md` in the working directory unless the user asks for another path. Then reply with one line giving the row count and the path you wrote.

## Read the file

- The first row is the header. Every later row that isn't blank is a data row.
- Fields are separated by commas. A field in double quotes can contain commas, and `""` inside quotes is one literal quote.
- Trim spaces around each field.
- Number the data rows from 1: the first row after the header is row 1.

## Decide which columns are numeric

- A column is numeric when every non-empty cell in it is a plain number: an optional leading `-`, digits, and optionally a decimal point followed by digits, such as `12`, `-3`, `4.50` or `-0.25`.
- Empty cells don't make a column non-numeric. Any other text does, including currency symbols, thousands separators and dates.
- A column whose cells are all empty is not numeric.

## Total the numeric columns

- Add every non-empty cell of each numeric column.
- Write each total with as many decimal places as the most precise cell in that column: `4.5` and `1.25` total `5.75`, and `12` and `30` total `42`.
- Don't use thousands separators. Write a negative total with a leading `-`.
- Add each column a second time before you write its total, and fix any difference.

## Flag negative values

List every cell of a numeric column whose value is below zero, ordered by row and then by column. Copy each value exactly as the file writes it.

## Write summary.md

Use exactly this structure, with one totals row per numeric column in header order:

```markdown
# Summary of <file name>

- Rows: <number of data rows>
- Columns: <number of columns>

## Column totals

| Column | Total |
|---|---|
| <column> | <total> |

## Negative values

| Row | Column | Value |
|---|---|---|
| <row number> | <column> | <value as written> |
```

When no value is negative, write `None.` on the line after the `## Negative values` heading instead of that table. When no column is numeric, write `None.` after the `## Column totals` heading instead of that table.

Versions

The database has no other skills named csv-summary.

Database snapshot: 13.11.2026 · package version 78283081e7fb (SHA-256 digest of the entire package)

Downloads in the last 30 days: 0 · ranking

Report a problem with this skill: harmful content, incorrect descriptions or an author’s removal request.

Similar skills

  • 100csv-profile
    Profiles a CSV file and reports column types, null rates, distinct counts, and duplicate rows. Use when the user asks to inspect, sanity-check, or summarize the shape of a CSV or TSV file before analyzing it.
  • 100d3-data-table
    How to build an interactive HTML data table driven by D3.js v6 with sortable columns, row highlighting, cross-component selection, and formatted values. Use this skill when building tabular displays alongside D3 charts, especially when the table needs to stay in sync with chart interactions.
  • 100csv-pipeline
    Process, transform, analyze, and report on CSV and JSON data files. Use when the user needs to filter rows, join datasets, compute aggregates, convert formats, deduplicate, or generate summary reports from tabular data. Works with any CSV, TSV, or JSON Lines file.
  • 100csv-tools
    Inspect, filter, aggregate, and clean CSV/TSV data with Python. Use when users hand over a .csv/.tsv file or paste tabular data and want a quick look, column stats, filtering, sorting, deduping, group-by sums/counts, or cleanup — without needing a full spreadsheet. Triggers on…
  • 100csv-manual-export
    CSV Manual Export: a UTF-8 CSV template from a confirmed field list, empty by default, with no invented columns or values. Use for an import, staging or handoff file.
  • 100csv-manual-export
    CSV Manual Export: a UTF-8 CSV template from a confirmed field list, empty by default, with no invented columns or values. Use for an import, staging or handoff file.

Feedback and reports

Your message goes to Bartosz Sokoliński. An email address is needed only for a reply. See the privacy policy.