CleanFrame Lite

Upload messy CSV data → get a cleaner, analysis-ready version in seconds

---

Overview

CleanFrame Lite is a tiny, local-first web app for quick tabular data cleanup.

It is built for the boring but common part of analytics work:

• inconsistent column names
• whitespace issues
• null-like junk values
• numbers stored as text
• dates stored inconsistently
• duplicate rows

The goal is simple:

reduce the friction between “I have data” and “I can actually use it”

---

Live App

Add your deployed Streamlit link here once live:

Open CleanFrame Lite

---

What It Does

CleanFrame Lite applies a small set of deterministic cleaning rules:

• standardises column names
• trims whitespace from string values
• converts common null-like values to actual nulls
• attempts lightweight type inference for numeric and date columns
• removes exact duplicate rows

This is intentionally constrained and opinionated.

No accounts. No database. No pipeline orchestration. No overengineering.

---

Why This Exists

A lot of analysis work starts with cleanup, not insights.

That cleanup is often repetitive, manual, and annoying:

• fix headers
• trim spaces
• replace junk nulls
• convert types
• remove duplicates
• export and move on

CleanFrame Lite is a small proof-of-execution tool aimed at that exact friction.

---

Repo Structure

cleanframe-lite/
├── app.py
├── cleaning.py
├── requirements.txt
├── .gitignore
└── README.md

Run Locally'

python -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt
streamlit run app.py

Run Locally (uv)

This project uses uv for fast, minimal Python environment management.

Install uv (if needed)

pip install uv

On Windows PowerShell:

python -m venv .venv
.venv\Scripts\Activate.ps1
pip install -r requirements.txt
streamlit run app.py

Deploy to Streamlit Community Cloud

1. Push this repo to GitHub
2. Sign in to Streamlit Community Cloud
3. Create a new app
4. Select this repo and branch
5. Set the main file path to:

app.py

6. Deploy
7. Copy the generated app URL into the Live App section above