csv-analyzing

Original：🇺🇸 English

Translated

Guide for querying and filtering CSV files using DuckDB SQL

1installs

Added on2026-02-21

NPX Install

npx skill4agent add totto2727-dotfiles/agents csv-analyzing

A guide for analyzing CSV files.

sql

SELECT * FROM 'data.csv';

sql

SELECT column1, column2, column3
FROM 'data.csv';

Retrieve only rows matching a specific condition:

sql

SELECT *
FROM 'data.csv'
WHERE column1 = 'value';

Filter with multiple conditions:

sql

SELECT *
FROM 'data.csv'
WHERE column1 = 'value'
  AND column2 > 100;

sql

SELECT column1, column2
FROM 'data.csv'
WHERE column1 LIKE '%keyword%'
  AND column3 IS NOT NULL;

Retrieve a specific range of rows (e.g., rows 11-20):

sql

SELECT *
FROM (
    SELECT *, row_number() OVER () AS rn
    FROM 'data.csv'
)
WHERE rn BETWEEN 11 AND 20;

Skip the first N rows:

sql

SELECT *
FROM (
    SELECT *, row_number() OVER () AS rn
    FROM 'data.csv'
)
WHERE rn > 100;

Refer to the official documentation only when you need other features.

Reference Documentation: