Data Processing
Transformateur CSV
Transformer et traiter les données CSV avec des opérations de colonnes, calculs et conversions de types de données. Exemples d'opérations: • Renommer une colonne: [{"type": "rename", "column": "ancien_nom", "new_name": "nouveau_nom"}] • Ajouter une colonne calculée: [{"type": "add_column", "new_column": "total", "formula": "prix * quantite"}] • Supprimer une colonne: [{"type": "remove_column", "remove_column": "colonne_a_supprimer"}] • Convertir le type de donnée: [{"type": "convert_type", "convert_column": "age", "target_type": "number"}] • Calculer des valeurs: [{"type": "calculate", "target_column": "total", "expression": "prix * taxe + frais_port"}] • Filtrer les lignes: [{"type": "filter_values", "filter_column": "statut", "operator": "equals", "value": "actif"}]
Démarrage rapide
Appelez cet outil depuis votre code en trois langages.
# 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/fr/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'