doushi.aiAI Builder
Back to all articles
Tutorials 2026-10-18 5 min read By Niklas Rotter

How to Turn Any CSV into a Production AI Model in 3 Minutes

Step-by-step guide to generating tabular AI models from raw CSV data using natural language prompts, automated feature engineering, and instant REST APIs.

Direct Answer / TL;DR: With doushi.ai, turning a tabular CSV dataset into a production AI model requires 3 simple steps: (1) Upload your CSV, Excel, or Parquet file; (2) Enter a natural language prompt describing your target prediction (e.g., "Predict whether a customer will churn based on activity and payment history"); (3) Click Submit. Within minutes, Doushi's agent cleans missing values, encodes categories, selects the top-performing algorithm (LightGBM, XGBoost, or Random Forest), and deploys a live REST API with sub-100ms inference.

Building machine learning models used to demand weeks of boilerplate code: pandas pipelines, missing data imputation, one-hot encoding, train-test splitting, hyperparameter search, Docker containerization, and setting up cloud inference servers with FastAPI.

doushi.ai eliminates this overhead completely. In this tutorial, we will take a raw customer dataset and deploy a production-ready predictive API in under 3 minutes.


Step 1: Prepare and Upload Your Dataset

Doushi supports tabular data in CSV, Excel (.xlsx), and Apache Parquet (.parquet) formats up to 25MB (free tier, higher limits for paid tiers) directly through the web UI.

For this guide, consider a standard customers.csv dataset with the following schema:

ColumnTypeDescription
customer_idstringUnique customer identifier
monthly_spendfloatAverage monthly billing in USD
tenure_monthsintegerNumber of months as active customer
support_ticketsintegerNumber of customer support interactions
contract_typecategorical"month-to-month", "annual", or "two-year"
churnedbinary (0/1)Target column indicating account churn

You do not need to clean missing values, remove nulls, or convert categorical text columns beforehand. Doushi's automated preprocessing pipeline inspects column statistics and handles anomalies automatically.


Step 2: Prompt the AI Agent in Plain English

Instead of writing configuration dictionaries or complex YAML files, simply describe your objective to the Doushi AI agent:

"Predict whether a customer will churn (column: churned) using their tenure, 
monthly spend, support ticket frequency, and contract type. Focus on maximizing 
precision to avoid false alarms."

Once submitted, Doushi launches an isolated, ephemeral Docker container in our ISO 27001-certified German data center (Frankfurt am Main). The autonomous agent performs:

  1. Schema Validation: Detects numerical, categorical, and datetime columns; drops meaningless unique identifiers (customer_id).
  2. Automated Imputation: Replaces missing values using median (numerical) and mode/indicator (categorical) methods.
  3. Smart Feature Engineering: Generates interaction terms (e.g., spend_per_tenure_month) and frequency encodings.
  4. Leakage Guard: Automatically flags and isolates features correlated with the target through time travel or duplicate recording.
  5. Algorithm Tournament: Evaluates competing model architectures:
    • LightGBM (Gradient Boosting)
    • XGBoost (Extreme Gradient Boosting)
    • Random Forest Classifier
    • CatBoost (Categorical Boosting)
    • Calibrated Logistic Regression

Within 45 seconds to a few minutes, the agent returns the resulting model on an out-of-fold holdout set, complete with ROC-AUC, F1-Score, and accuracy scores.


Step 3: Test Live with Browser Sliders

Before writing any integration code, you can immediately test how the model responds using Doushi's Interactive Live Simulator:

  • Drag the Support Tickets slider from 1 to 6 to observe the churn probability spike from 12% to 78%.
  • Toggle the Contract Type dropdown to "two-year" and watch churn risk drop significantly.

This gives product managers and domain experts full visibility into model behavior without needing data science expertise.


Step 4: Call Your Production REST API

Every generated model is automatically deployed to an autoscaling inference endpoint with an average response time of 75 milliseconds for cached models on the free tier.

Python Example

import requests

API_URL = "https://api.doushi.ai/<YOUR_PROJECT_ID>/predict"
API_KEY = "dsh_live_your_api_key_here"

headers = {
    "X-API-Key": API_KEY,
    "Content-Type": "application/json"
}

payload = {
    "monthly_spend": 89.50,
    "tenure_months": 14,
    "support_tickets": 4,
    "contract_type": "month-to-month"
}

response = requests.post(API_URL, json=payload, headers=headers)
prediction = response.json()

print(f"Churn Prediction: {prediction['prediction']}")
print(f"Churn Probability: {prediction['probability']:.2%}")
# Output: Churn Prediction: 1 (True), Churn Probability: 74.20%

cURL Example

curl -X POST https://api.doushi.ai/api/projects/ageg-2414-gaeg-21523qt/predict \
  -H "Content-Type: application/json" \
  -H "X-API-Key: <YOUR_API_KEY>" \
  -d '{"WorkstationGroupID":1,"OperatorID":136,"TranTime":50,"BreakTime":122,"Amount":53.88,"TNcash":false,"TNcard":true}'

Frequently Asked Questions (FAQ)

Can I export the trained model and Python code?

Yes! Doushi has a strict zero vendor lock-in guarantee. You can download the full Python script (Scikit-Learn / LightGBM pipeline) along with pickled weights (.joblib or .onnx (coming soon)) to run on your own servers at any time.

Where is my data processed and stored?

All compute and storage infrastructure resides in Frankfurt am Main, Germany (EU). Data is encrypted with AES-256 at rest and TLS 1.3 in transit, fully compliant with GDPR / DSGVO. Customer data is never shared or used to train public models.

How does Doushi differ from traditional AutoML tools?

Traditional AutoML platforms (like DataRobot or AWS SageMaker Canvas) require complex enterprise onboarding, manual parameter setup, and high license costs. Doushi provides an intuitive, conversational interface—like Lovable, but for Machine Learning—allowing anyone to train models in minutes for a fraction of the cost.


Next Steps

Related Topics
#AutoML#Tutorial#REST API#CSV to Model#Tabular Data
Live in 3 Minutes

Turn your dataset into an AI model today

Upload CSV/Parquet, enter a prompt, test with live browser sliders, and get a hosted REST API. Free to start.

Try For Free Read Docs