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.6 KB · 27 lines
Copy the text
Download this file
name description
save-table Saves a pasted table as a clean CSV file in the project and adds it to the data index; use for "save this table", "here is my export".

Save table

Use when: the user pastes a table (from a spreadsheet, an export, a message) and wants it kept in the project.

Input

The pasted table, with a header row if there is one. A short name for it and the period it covers; ask in one question if missing.

Steps

  1. Detect the layout: separator (comma, semicolon, tab), header row, decimal separator, date format. Say what you detected.
  2. Write CSV: comma-separated, a header row, one row per line, values with commas or quotes inside double quotes, dates as YYYY-MM-DD, numbers without thousands separators and with a decimal point. Do not change the values themselves; do not add or drop rows.
  3. Count the rows and the columns and compare with the paste. Say the counts.
  4. Save data/<topic>-<period>.csv (note "Table: , rows"). Add a line to data/README.md: file, what it holds, period, rows, date added.
  5. Offer describe-table next.

Output

The file in data/, the index line, the row and column counts.

Edge cases

  • The paste is too long for one message: save in parts with append, header only in the first part; count the total rows at the end.
  • The decimal separator is a comma and the field separator is a semicolon: convert both and say so; values stay the same.
  • A totals row inside the paste: keep it out of the CSV and say so, or the sums will double.
  • No header: propose column names from the content and ask before saving.
---name: save-tabledescription: Saves a pasted table as a clean CSV file in the project and adds it to the data index; use for "save this table", "here is my export".---# Save tableUse when: the user pastes a table (from a spreadsheet, an export, a message) and wants it kept in the project.## InputThe pasted table, with a header row if there is one. A short name for it and the period it covers; ask in one question if missing.## Steps1. Detect the layout: separator (comma, semicolon, tab), header row, decimal separator, date format. Say what you detected.2. Write CSV: comma-separated, a header row, one row per line, values with commas or quotes inside double quotes, dates as YYYY-MM-DD, numbers without thousands separators and with a decimal point. Do not change the values themselves; do not add or drop rows.3. Count the rows and the columns and compare with the paste. Say the counts.4. Save `data/<topic>-<period>.csv` (note "Table: <name>, <n> rows"). Add a line to `data/README.md`: file, what it holds, period, rows, date added.5. Offer `describe-table` next.## OutputThe file in `data/`, the index line, the row and column counts.## Edge cases- The paste is too long for one message: save in parts with `append`, header only in the first part; count the total rows at the end.- The decimal separator is a comma and the field separator is a semicolon: convert both and say so; values stay the same.- A totals row inside the paste: keep it out of the CSV and say so, or the sums will double.- No header: propose column names from the content and ask before saving.