Excel 自动清洗与公式生成器

返回首页/表格数据/Excel 自动清洗与公式生成器

上传表格

质量报告

{
  "rows": 4,
  "columns": 4,
  "duplicateRows": 1,
  "profiles": [
    {
      "column": "name",
      "type": "text",
      "empty": 0,
      "emptyPercent": 0,
      "unique": 3,
      "duplicates": 1,
      "samples": [
        "Ada",
        "Lin",
        "Ming"
      ]
    },
    {
      "column": "department",
      "type": "text",
      "empty": 0,
      "emptyPercent": 0,
      "unique": 2,
      "duplicates": 1,
      "samples": [
        "Sales",
        "Ops"
      ]
    },
    {
      "column": "amount",
      "type": "number",
      "empty": 1,
      "emptyPercent": 25,
      "unique": 2,
      "duplicates": 1,
      "min": 1280,
      "max": 9999,
      "average": 4186.3333,
      "samples": [
        "1280",
        "9999"
      ]
    },
    {
      "column": "date",
      "type": "mixed",
      "empty": 0,
      "emptyPercent": 0,
      "unique": 3,
      "duplicates": 1,
      "samples": [
        "2026-05-01",
        "2026-05-02",
        "not-a-date"
      ]
    }
  ],
  "issues": [
    "amount: 1 empty value(s)",
    "date: mixed value types",
    "1 duplicate row(s)"
  ]
}

Excel 公式建议

列 name: =IF(TRIM(A2)="","缺失",TRIM(A2))
列 department: =IF(TRIM(B2)="","缺失",TRIM(B2))
列 amount: =IF(TRIM(C2)="","缺失",TRIM(C2))
列 date: =IF(TRIM(D2)="","缺失",TRIM(D2))

AI 增强

加载中...