csv-analyzing
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseCSV Analysis
CSV数据分析
A guide for analyzing CSV files.
一份用于分析CSV文件的指南。
Load All Data
加载全部数据
sql
SELECT * FROM 'data.csv';sql
SELECT * FROM 'data.csv';Select Specific Columns
选择特定列
sql
SELECT column1, column2, column3
FROM 'data.csv';sql
SELECT column1, column2, column3
FROM 'data.csv';Filter Rows
过滤行
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 *
FROM 'data.csv'
WHERE column1 = 'value';多条件过滤：
sql
SELECT *
FROM 'data.csv'
WHERE column1 = 'value'
AND column2 > 100;Combined Column and Row Filtering
列与行组合过滤
sql
SELECT column1, column2
FROM 'data.csv'
WHERE column1 LIKE '%keyword%'
AND column3 IS NOT NULL;sql
SELECT column1, column2
FROM 'data.csv'
WHERE column1 LIKE '%keyword%'
AND column3 IS NOT NULL;Filter by Row Number
按行号过滤
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;检索特定范围的行（例如，第11-20行）：
sql
SELECT *
FROM (
SELECT *, row_number() OVER () AS rn
FROM 'data.csv'
)
WHERE rn BETWEEN 11 AND 20;跳过前N行：
sql
SELECT *
FROM (
SELECT *, row_number() OVER () AS rn
FROM 'data.csv'
)
WHERE rn > 100;Additional SQL Features
其他SQL功能
Refer to the official documentation only when you need other features.
Reference Documentation: