Waseet logo
Let’s talk
← All work

Self-initiated demonstration · Synthetic data

Data cleaning studio

Clean 40 synthetic source rows, inspect exact-match duplicates, and review the information a careful process leaves unresolved.

Discuss a similar brief
TRY THE WORK

Explore the demonstration.

Changes stay in this browser session. No production records are affected.

Data cleaning studioLOCAL WORKSPACE

DEMO 02 / TRY THE WORK

Data cleaning studio

Messy source rows become traceable, reviewable records.

Self-initiated demonstration · Synthetic data
40Source rows
—Reviewed records
—Duplicates consolidated
—Unresolved records
Original values · edit any source row
SourceCompanyEmailRegion / dateEdit source
R01 ALDERWICK STUDIO HELLO@alderwick-studio.example north 2026/09/15
R02brackenmere systems hello@brackenmere-systems.example south 15 Sep 2026
R03Cobalt Fen Advisory hello@cobalt-fen-advisory.example east 2026-09-15
R04 NORTH QUAY WORKS hello@north-quay-works.example west 2026/09/15
R05willowbridge design HELLO@willowbridge-design.example north 15 Sep 2026
R06Merefield Research hello@merefield-research.example south 2026-09-15
R07 AMBER VALE SUPPLY hello@amber-vale-supply.example east 2026/09/15
R08pinehaven analytics hello@pinehaven-analytics.example west 03/04/2026
R09Slate Orchard Consulting HELLO@slate-orchard-consulting.example north 2026-09-15
R10 BIRCHLINE LEARNING hello@birchline-learning.example south 2026/09/15
R11copperbrook logistics hello@copperbrook-logistics.example east 15 Sep 2026
R12Larkspur Digital hello@larkspur-digital.example west 2026-09-15
R13 FERNHAVEN ENGINEERING Missing north 2026/09/15
R14oakmere events hello@oakmere-events.example south 15 Sep 2026
R15Reedstone Creative hello@reedstone-creative.example east 2026-09-15
R16 ELMSHORE SERVICES hello@elmshore-services.example west 2026/09/15
R17juniper fold planning HELLO@juniper-fold-planning.example north 15 Sep 2026
R18Clearwell Manufacturing hello@clearwell-manufacturing.example south 03/04/2026
R19 MARSHLIGHT STUDIO hello@marshlight-studio.example Missing2026/09/15
R20ashcombe solutions hello@ashcombe-solutions.example west 15 Sep 2026
R21Rowan Gate Learning HELLO@rowan-gate-learning.example north 2026-09-15
R22 CEDAR HOLLOW SUPPLY hello@cedar-hollow-supply.example south 2026/09/15
R23hawthorn path advisory hello@hawthorn-path-advisory.example east 2026-02-30
R24Silverfen MediaMissing west 2026-09-15
R25 BLUEWILLOW WORKSHOP HELLO@bluewillow-workshop.example north 2026/09/15
R26stonequay research hello@stonequay-research.example south 15 Sep 2026
R27Maple Lantern Services hello@maple-lantern-services.example east 2026-09-15
R28 HEDGEROW SYSTEMS hello@hedgerow-systems.example west No date supplied
R29wrenfield creative HELLO@wrenfield-creative.example north 15 Sep 2026
R30Cloudmere Planning hello@cloudmere-planning.example south 2026-09-15
R31Alderwick Studiohello@alderwick-studio.exampleNorth2026-09-15
R32Brackenmere Systemshello@brackenmere-systems.exampleSouth2026-09-15
R33Cobalt Fen Advisoryhello@cobalt-fen-advisory.exampleEast2026-09-15
R34North Quay Workshello@north-quay-works.exampleEast2026-09-15
R35Willowbridge Designhello@willowbridge-design.exampleNorth2026-09-15
R36Merefield Researchhello@merefield-research.exampleSouth2026-09-15
R37Amber Vale Supplyhello@amber-vale-supply.exampleEast2026-09-15
R38Pinehaven Analyticshello@pinehaven-analytics.exampleWest03/04/2026
R39Slate Orchard Consultinghello@slate-orchard-consulting.exampleNorth2026-09-15
R40Birchline Learninghello@birchline-learning.exampleSouth2026-09-15
Cleaning rules and limitations

Whitespace and casing are standardized; supported dates become ISO dates. Duplicate groups retain their source IDs. Missing and ambiguous values remain unresolved. Matching rules do not verify identities or supply missing information.

The brief

Turn a messy contact file into a traceable reviewed output without guessing missing facts or ambiguous dates.

My role

Synthetic source design, reproducible cleaning rules, validation, original interface and exports.

Inputs

  • 40 synthetic rows
  • Explicit casing, date, identity and review rules

Process

  • Preserve source IDs and input
  • Trim whitespace and normalize field casing
  • Normalize only valid unambiguous dates
  • Group exact normalized company and email matches
  • Retain unknowns and flag conflicting values
  • Reconcile the reviewed output with its source

Deliverables

  • Source CSV
  • Reviewed CSV
  • Per-row change log
  • Computed validation summary
  • Rules and limitations
  • Working cleanup studio

Tools

  • Pure TypeScript transformation
  • CSV and JSON export
  • Acceptance tests

Quality review

Inspect row-level changes, duplicate groups, the retained blank emails, and ambiguous dates. Exact company/email matches define duplicates; there is no fuzzy matching, external verification, inferred identity or silent missing-value fill.

Source rows · CSV ↓Reviewed rows · CSV ↓Change log · JSON ↓Validation summary · JSON ↓Rules and limitations ↓
Data cleaning studio: detailed view of sample records and controls
Data cleaning studio: detailed view of sample records and controls
Data cleaning studio: inspectable output and review state
Data cleaning studio: inspectable output and review state

What this illustrates

The records were deliberately created with formatting problems, duplicates, missing fields and ambiguous dates. Counts come from the running transformation.

Self-initiated work created for this portfolio with AI-assisted preparation. The files and working examples are available to inspect. No paid client engagement is implied.

See the related service ↗