Reports from tables

pacpio-team/reports-from-tables
Copy project link
Public
Anyone can see and download this project, even without signing in.
Owner: Pacpio Team Made by the Pacpio team
Made by the Pacpio team
Report

Use it with your AI

Works in Claude, ChatGPT or any other AI

  1. Step 1: Connect your AI

    Do it once. It takes a minute.

    Connect your AI

  2. Step 2: Ask your AI

    Paste this into your chat:

    What does the Pacpio project pacpio-team/reports-from-tables do?

Make a copy Sign in to get your own project to change. Download a copy All files in one ZIP. The copy doesn’t update by itself.

SKILL.md

1.3 KB · 27 lines
Copy the text
Download this file
name description
describe-table Describes a table, columns and types, period, row count, missing values, duplicates, totals; use first for any new table.

Describe table

Use when: a table is new, or the user asks "what is in this file".

Input

A file in data/ or a pasted table.

Steps

  1. Read the table. For a long one, read it in parts and keep running counts.
  2. For each column: type (text, number, date, yes/no), an example, how many empty cells, how many distinct values (for text columns), minimum and maximum (for numbers and dates).
  3. Rows: total count; exact duplicates, if any; the period from the earliest to the latest date.
  4. Totals of number columns with the number of rows counted, by knowledge/counting-rules.md.
  5. Save reports/<table>-profile.md (note "Profile: ").
  6. Answer with three lines: what the table is, the period and row count, what looks worth checking.

    7. Output

    A table: Column | Type | Example | Empty | Distinct or range | Notes. Then rows, period, totals, and "Worth checking".

    Edge cases

    • Two columns with the same name: say so; refer to them by position until the user renames them.
    • A column with mixed content (numbers and text): type "mixed", count each kind, and flag it for data-check.
    • No dates at all: no period; say the table is a snapshot.
---name: describe-tabledescription: Describes a table, columns and types, period, row count, missing values, duplicates, totals; use first for any new table.---# Describe tableUse when: a table is new, or the user asks "what is in this file".## InputA file in `data/` or a pasted table.## Steps1. Read the table. For a long one, read it in parts and keep running counts.2. For each column: type (text, number, date, yes/no), an example, how many empty cells, how many distinct values (for text columns), minimum and maximum (for numbers and dates).3. Rows: total count; exact duplicates, if any; the period from the earliest to the latest date.4. Totals of number columns with the number of rows counted, by `knowledge/counting-rules.md`.5. Save `reports/<table>-profile.md` (note "Profile: <table>").6. Answer with three lines: what the table is, the period and row count, what looks worth checking.## OutputA table: Column | Type | Example | Empty | Distinct or range | Notes. Then rows, period, totals, and "Worth checking".## Edge cases- Two columns with the same name: say so; refer to them by position until the user renames them.- A column with mixed content (numbers and text): type "mixed", count each kind, and flag it for `data-check`.- No dates at all: no period; say the table is a snapshot.