PDF Table Validator

Validate extracted PDF tables for data quality issues and get detailed quality reports.

What it does

This actor takes extracted PDF table data and validates it for common quality issues:

• Empty cells: Identifies cells that are null, undefined, or empty strings
• Suspicious numbers: Flags very long decimals that might be OCR errors
• Inconsistent columns: Detects tables with varying column counts across rows
• Arithmetic checks (optional): Checks for sum relationships between cells

Input

Option 1: Pre-extracted table data (recommended)

{
  "tableData": "{\"data\":[[\"Item\",\"Price\",\"Qty\",\"Total\"],[\"Apple\",\"1.50\",\"10\",\"15.00\"],[\"Banana\",\"0.75\",\"5\",\"3.75\"]],\"rows\":3,\"columns\":4}",
  "includeArithmeticChecks": false
}

Option 2: PDF URLs (table extraction not yet implemented)

{
  "pdfUrls": ["https://example.com/table.pdf"]
}

Output

Returns a validation report with:

• detectedIssues: Array of issues found with type, severity, and position
• totalIssues: Total count of issues
• qualityScore: 0-100 score (100 = perfect quality)
• summary: Overview of quality level (high/medium/low)

Example

Input:

{
  "tableData": "{\"data\":[[\"A\",\"B\",\"Sum\"],[\"10\",\"20\",\"30\"],[\"5\",\"5\",\"11\"]],\"rows\":3,\"columns\":3}",
  "includeArithmeticChecks": true
}

Output:

{
  "source": "pre_extracted",
  "tableData": {...},
  "validationReport": {
    "hasArithmeticChecks": true,
    "detectedIssues": [
      {
        "type": "sum_mismatch",
        "severity": "medium",
        "description": "Last cell (11) may not match sum of previous cells (10.00)",
        "cellPosition": "R3C3"
      }
    ],
    "totalIssues": 1,
    "highConfidenceCells": 5,
    "lowConfidenceCells": 1,
    "qualityScore": 95,
    "summary": {
      "totalCells": 9,
      "issuesFound": 1,
      "qualityLevel": "high"
    }
  }
}

Usage

1. Get your Apify API token from Apify Console
2. Install the Apify CLI: npm install -g apify-cli
3. Login: apify login
4. Build and push: apify push .
5. Run: apify run --actor-id your-username/pdf-table-validator

License

MIT