Data Processing
CSV转换器
转换和处理CSV数据,支持列操作、计算和数据类型转换。 操作示例: • 重命名列: [{"type": "rename", "column": "旧列名", "new_name": "新列名"}] • 添加计算列: [{"type": "add_column", "new_column": "总计", "formula": "价格 * 数量"}] • 删除列: [{"type": "remove_column", "remove_column": "要删除的列名"}] • 转换数据类型: [{"type": "convert_type", "convert_column": "年龄", "target_type": "number"}] • 计算值: [{"type": "calculate", "target_column": "总计", "expression": "价格 * 税率 + 运费"}] • 过滤行: [{"type": "filter_values", "filter_column": "状态", "operator": "equals", "value": "激活"}]
file· 文件结果打开工具
快速开始
用三种语言从你的代码中调用此工具。
cURL
# 1) Request a presigned URL → returns { uploadUrl, storageKey }
curl -X POST 'https://api.elysiatools.com/api/upload/presign/csv-transformer' \
-H 'Content-Type: application/json' \
-d '{"filename":"csvFile.ext","contentType":"application/octet-stream","size":12345}'
# 2) PUT the file bytes directly to the presigned uploadUrl
curl -X PUT '<presigned uploadUrl>' \
--data-binary @/path/to/file.ext
# 3) Call the tool, passing the returned storageKey for each file field
curl -X POST 'https://api.elysiatools.com/zh/api/tools/csv-transformer' \
-F 'csvFile=uploads/2026/01/01/your-tool-1700000000000-abc123.ext' \
-F 'transformations=[{"type": "rename", "column": "姓名", "new_name": "学生姓名"}, {"type": "convert_type", "convert_column": "年龄", "target_type": "integer"}]' \
-F 'outputFormat=csv' \
-F 'includeHeader=true' \
-F 'handleErrors=keep_original' \
-F 'errorHandling=log'