What Should This Car Cost?
From its make, body style, dimensions, engine and fuel economy, what price does this car's spec suggest? With only 201 cars and 68 columns, it shows how foundation models handle small, wide tables.
The table
201 cars with make, body style, dimensions, engine size, horsepower and fuel economy, and their list price. It's in Welt's research catalogue as Automobile Specifications and Prices, Fixed Version, 201 rows by 69 columns, licensed CC0. The catalogue measures its signal at 0.87. At 201 rows and 68 features, TabICLv2, Kumo Tabular Medium and Mitra-v2 take the table as it is. The others can't take a table this size, so the walkthrough leaves them out.
Walkthrough
Load it from the catalogue
Find the table, read its recorded target and print the column names.
import pandas as pd from welt import Client with Client() as client: item = client.research_datasets(q="automobile specifications prices", limit=1)["items"][0] info = client.research_dataset(item["id"]) data = client.load_research_dataset(item["id"]) target = info["targets"][0] target = target["name"] if isinstance(target, dict) else target print([column["name"] for column in info["schema"]], target)Pick the rows
Set aside 20 rows to predict at the end, and keep the rest for the models to learn from.
known = data.dropna(subset=[target]) new_rows = known.sample(20, random_state=1) table = known.drop(new_rows.index)Compare the models and predict
The models compete on the same folds against a simple guess, then the top-ranked one is fitted on the whole table. RMSE and MAE are average errors in the target's own units, so lower is better. The last table puts each prediction next to the real answer.
with Client() as client: evaluation = client.evaluate(table, target, task="regression", seed=7, models=["tabicl-v2", "kumo-medium", "mitra-v2"]) model = evaluation.fit() print(evaluation.summary()[["name", "rank", "rmse_mean", "mae_mean"]]) features = new_rows.drop(columns=target) print(pd.DataFrame({"actual": new_rows[target].values, "predicted": model.predict(features)}))
What you get
Try it
Use Open with to run the research datasets notebook in Colab, Kaggle or Jupyter and search for "automobile specifications prices", or run the code above after pip install "welt-client[parquet]".
Open with
- Type
- Use case
- Area
- Customers
- Question
- What Should This Car Cost?
- Model
- TabICLv2, Kumo Tabular Medium, Mitra-v2
- Data
- Automobile Specifications and Prices, Fixed Version, 201 rows
- For
- Car dealers, buyers and pricing analysts
- Licence
- CC0