skills.rest
SillyHippy
SillyHippyCOMMUNITY
Explore all skills by this author β†’
GitHub

enrich-csv

Adds AI-generated columns to CSV files by processing rows through the Zo API.

Updated Sep 5, 2026
Search Tags:#api#python#spreadsheet#csv#batch processing#enrichment#data automation
One-click install
npx skills add https://github.com/SillyHippy/zo-skills --skill enrich-csv-sillyhippy
Or copy as Structured Prompt for Agentβ–Ό
Please help me install this Agent Skill.
Skill: enrich-csv
Source: https://github.com/SillyHippy/zo-skills/tree/main/skills/zo-enrich-csv
Command: npx skills add https://github.com/SillyHippy/zo-skills --skill enrich-csv-sillyhippy

SYSTEM DOCUMENTATION & REQUIREMENTS

πŸ’‘ This Skill requires httpx.

What problem does it solve? Manually researching and filling in new data columns for large spreadsheets is slow and repetitive. This Skill automates CSV enrichment by generating a Python script that calls the Zo API for each row and writes results back incrementally. ## Core Features & Use Cases - AI-Generated Columns: Adds one or more new columns to any CSV based on a natural-language enrichment directive, with structured JSON schema output per row. - Row Filtering: Processes only rows matching an optional filter (e.g., "European countries only"), either via Python logic or prompt-based SKIP handling. - Idempotent Batch Processing: Runs up to 8 concurrent API calls, writes results to the CSV after each call, and safely resumes by skipping already-enriched rows. - Use Case: Given a CSV of countries, add an "estimated GDP 2025" column by having the script query the Zo API for each country and write values back in place. ## Quick Start Open a CSV file and ask Zo to enrich it with a new column, for example: "Enrich this CSV with 'capital city' for European countries only."

Frequently Asked Questions about enrich-csv

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I add AI-generated columns to a CSV file?β–Ό

Open the CSV and invoke the enrich-csv prompt with a directive describing the new column, such as "Add estimated GDP 2025". The Skill generates a Python script that calls the Zo API per row and writes results back to the CSV incrementally.

How do I enrich only specific rows in a CSV?β–Ό

Include a filter in your request, such as "for European countries only". The script either filters rows in Python when criteria are deterministic, or instructs the API to return SKIP for non-matching rows, leaving those cells empty.

Can I re-run the enrichment script after it fails or is interrupted?β–Ό

Yes, the generated script is idempotent. It only adds columns that do not already exist and skips rows that already have values in the target columns, so re-running resumes where it stopped without duplicating work.

What dependencies does the CSV enrichment script need?β–Ό

The script requires the httpx Python package, installed via pip install httpx, and the ZO_CLIENT_IDENTITY_TOKEN environment variable for authenticating requests to the Zo API endpoint.

Why does my CSV enrichment produce poor quality results?β–Ό

Low quality usually comes from a vague enrichment directive. Make the directive more specific, include examples of expected output format, and reduce BATCH_SIZE if timeout errors occur during concurrent API calls.

Related Skills

Explore More Data & Analytics Skills→
datheredathere
3.7k

csv-wrangling

Automate CSV data wrangling workflows with qsv for indexing, profiling, transforming, and exporting.

Official
Intermediate
szsip239szsip239
103

data-analyst

Execute SQL queries, process spreadsheets, and generate insights from datasets.

Community
Advanced
aiyinluyaaiyinluya
2

excel-outlier-detection-and-highlighting

Detect Excel outliers exceeding contextual limits and highlight formula error cells.

Community
Intermediate
databar-aidatabar-ai
3

databar-table-enrichment

Orchestrate table-based data enrichment workflows via MCP APIs.

Official
Advanced