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:
| Column | Type | Description |
customer_id | string | Unique customer identifier |
monthly_spend | float | Average monthly billing in USD |
tenure_months | integer | Number of months as active customer |
support_tickets | integer | Number of customer support interactions |
contract_type | categorical | "month-to-month", "annual", or "two-year" |
churned | binary (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:
- Schema Validation: Detects numerical, categorical, and datetime columns; drops meaningless unique identifiers (
customer_id). - Automated Imputation: Replaces missing values using median (numerical) and mode/indicator (categorical) methods.
- Smart Feature Engineering: Generates interaction terms (e.g.,
spend_per_tenure_month) and frequency encodings. - Leakage Guard: Automatically flags and isolates features correlated with the target through time travel or duplicate recording.
- 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
1to6to observe the churn probability spike from12%to78%. - 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
- Explore the REST API Reference for batch prediction endpoints.
- Check out the Official Python CLI to automate model generation in CI/CD.
- Try Doushi for Free and upload your first dataset today.
