weltby Ergodic Sign inGet started
All use cases

How Much Is a Home Near a Metro Station Worth?

From the sale date, the building's age, the distance to the nearest MRT station, the number of shops nearby and the location, what's the price per unit area? It puts a number on what living near the metro is worth.

Use caseFinancePredictionModel evaluation

The table

414 home sales in Sindian District, New Taipei City, with date, house age, distance to the MRT, convenience stores and coordinates, and the price per unit area. It's in Welt's research catalogue as Real Estate Valuation, Sindian District, 414 rows by 7 columns, licensed CC BY 4.0. The catalogue measures its signal at 0.65. At 414 rows and 6 features, TabICLv2, Kumo Tabular Medium, Mitra-v2 and TabDPT 1.3 take the table as it is.

Walkthrough

  1. 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="real estate valuation Sindian", 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)
  2. 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)
  3. 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", "tabdpt-1.3"])
        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

A price per areaFor any home in the district.
The metro effectSee how price falls with distance to the station.
Small data handledEvery model in the collection can take 414 rows.

Try it

Use Open with to run the research datasets notebook in Colab, Kaggle or Jupyter and search for "real estate valuation Sindian", or run the code above after pip install "welt-client[parquet]".