Data Cleaner

Input Data (JSON)

Cleaning Rules

Example Input

[
  {
    "name": "  John Doe  ",
    "email": "[email protected]",
    "age": "25",
    "notes": "",
    "status": null
  },
  {
    "name": "Jane Smith",
    "email": "[email protected]",
    "age": "30",
    "phone": "+1-123-456-7890",
    "status": "active"
  }
]

Example Cleaning Operations:

Trim whitespace from all text fields
Normalize email addresses to lowercase
Convert age strings to numbers
Remove empty or null fields
Fill missing status with "inactive"
Remove duplicate records