Insight

Clean lab data for machine learning

The Smart Preprocessor, an AI assistant node in STOCHOS Flow, profiles a lab dataset, takes cleaning instructions in plain language, and generates an sklearn and pandas pipeline you can inspect before it runs. The cleaning recipe becomes an explicit, rerunnable step instead of knowledge that lives in one person's head.

Built for R&D datasets that arrive with mixed units, missing values, and readings that cannot physically be true.

Request a Demo STOCHOS Flow
The cleaning problem

The cleaning steps live in someone's head

Lab datasets rarely arrive ready for modeling. Units differ between instruments, values are missing, a pressure column holds negative readings that are physically impossible, and two sensors report nearly the same signal in separate columns. Cleaning all of that eats days, and the sequence of fixes usually exists nowhere except in the memory of whoever did it last.

That has two costs. The work repeats every time new data lands, and nobody can verify what was done: which rows were dropped, which gaps were filled, which columns were rescaled before the model ever saw them.

A raw laboratory data table with mixed units, blank cells, and one value boxed in red, standing in for the inconsistencies that make a fresh export unready for modelling.
A raw lab export: mixed units, missing values, and inconsistent scales, none of it ready for a model.
Smart Preprocessor

The recipe becomes a pipeline you can rerun

Inside STOCHOS Flow, the Smart Preprocessor profiles the dataset first (column types, ranges, gaps, correlations), then combines presets with instructions you write the way you would brief a colleague:

What you can ask for
> one-hot encode the categorical columns
> flag negative pressure values
> drop features correlated above 0.95
> interpolate the gaps
> scale the rest

From those instructions it generates a preprocessing pipeline in sklearn and pandas, as code you inspect before it runs. The assistant only prepares the data; prediction stays with the DIM-GP models downstream. In the episode demo, a raw thermal-spray dataset went in and a documented, model-ready table came out, every transformation visible as a pipeline step.

Because the recipe is code, it reruns unchanged on the next batch. The cleaning knowledge stops being tribal and becomes part of the project file.

A three-node STOCHOS Flow diagram: a Lab Data node feeds a Smart Preprocessor node, which outputs to an Export CSV or Excel node.
Lab data enters the Smart Preprocessor and leaves as a clean dataset, built by a pipeline you can read and rerun on the next batch.

Common questions

01How do I know what it changed in my data?

The steps are generated as sklearn and pandas code, and you review that code before anything runs. Every transformation is a named pipeline step, not a hidden operation inside a model.

02Does the assistant need a cloud LLM?

No. STOCHOS Flow is local-first: AI assistance runs on a local LLM via Ollama, with cloud models optional where you want them. Your data stays on your infrastructure.

03What happens when the next batch arrives?

You rerun the same pipeline. The recipe is saved with the workflow, so new data goes through identical steps. If the data has changed, you edit the instructions and regenerate instead of starting over.

Related pages

STOCHOS Flow

The workflow environment the Smart Preprocessor is part of, from data loading to deployment.

How STOCHOS works

The DIM-GP model that trains on your data once it is clean.

Keep up with a high-throughput lab

When automation moves the bottleneck from the bench to planning, a model proposes the next plate.

News and Guides

Every guide and insight we have published, in one place.

Next step

Stop re-cleaning the same dataset

Bring a messy export from your lab. We will profile it live and show the pipeline your instructions produce.

Request a Demo STOCHOS Flow

Local-first. Your data stays on your infrastructure.

Partners, customers, and research collaborators
AnsysCADFEMSimuTech GroupMEScoTSNEBoschZFGEMUDLRAdler LackeMankiewiczDuluxPlixxentFraunhoferHochschule NiederrheinFUELL Lab AutomationHumotionUniversitaet HamburgRobert Bosch Stiftung