AI Data Cleaning Assistant
by deedeepratiwi
A production-style app that automates messy CSV cleanup: upload a file, profile it, generate AI-backed cleaning steps, apply deterministic transformations, and download a cleaned dataset with a human-readable report. Turns a repetitive, error-prone task into a repeatable pipeline with tests, an API, and Cloud Run deployment. LLM acts as planner, cleaning engine is deterministic for reliability.
An AI-powered data cleaning assistant that accepts CSV or Excel via web UI or API, analyzes dataset structure and data quality issues, generates cleaning suggestions using intelligent detection, and applies transformations deterministically. You get a cleaned dataset plus a human-readable report of what changed.
Why it's useful: Raw tabular data is often messy: inconsistent column names, missing values, mixed types, duplicates. This project turns that into a repeatable pipeline: the LLM acts as a planner (suggesting what to do), while the cleaning engine is deterministic and testable. The repo includes unit tests, integration tests, E2E tests (Playwright), OpenAPI-first design, Docker, and deployment to Google Cloud Run.
Features: Column standardization (snake_case), non-value detection (ERROR/UNKNOWN → NaN), string normalization, smart type casting (numeric, datetime), duplicate removal, null handling, ID-column protection. The system uses MCP-style boundaries: structured JSON in/out between the LLM and the execution layer.
Tech stack: FastAPI (Python), React + TypeScript, OpenAI-compatible LLM, Pandas, SQLite/Postgres, OpenAPI, Docker, GitHub Actions, GCP Cloud Run.
Related content
Build and Deploy a Full-Stack App with AI Coding Assistants
In this workshop we'll build the classic Snake game as a full-stack web app, end to end. A coding assistant does most of the work. We'll: generate a React frontend with Lovable wr…
June 23, 2026
To-Do List Agent
A reference project from the AI Engineering Buildcamp: an agent that interacts with a simple to-do list application. Built with Lovable for the frontend and FastAPI (Python) for t…
December 15, 2025
What Is an AI Engineer? 2026 Role, Skills and Responsibilities Based on 1,000+ Job Descriptions
Learn what an AI engineer is in 2026: responsibilities, skills, tools, and real-world use cases based on analysis of 1,000+ AI engineer job descriptions.
March 04, 2026