weltby Ergodic Sign inGet started
All use cases

Will This Kaggle Dataset Win a Medal?

From its usability score, files, size, keywords, views, downloads and dates, which medal will this dataset get, if any? Publishers want to know what makes a dataset useful to others.

Use caseTechnologyPredictionModel evaluation

The table

5,717 Kaggle datasets with usability, file count, size, keywords, views, downloads and dates, and the medal each received. It's in Welt's research catalogue as Hottest Kaggle Datasets, 5,717 rows by 15 columns, licensed CC0: Public Domain. The catalogue measures its signal at 0.44. At 5,717 rows and 14 features, TabICLv2 and Kumo Tabular Medium take the table as it is. The others can't take a table this size, so the walkthrough leaves them out.

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="hottest Kaggle datasets", 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. ROC AUC runs from 0.5, a coin toss, to 1, a perfect ranking, and a lower Brier score means the probabilities can be trusted more. The last table puts each prediction next to the real answer.

    with Client() as client:
        evaluation = client.evaluate(table, target, task="classification", seed=7,
                                     models=["tabicl-v2", "kumo-medium"])
        model = evaluation.fit()
    
    print(evaluation.summary()[["name", "rank", "roc_auc_mean", "brier_mean"]])
    features = new_rows.drop(columns=target)
    print(pd.DataFrame({"actual": new_rows[target].values, "predicted": model.predict(features),
                        "probability": model.predict_proba(features).max(axis=1)}))

What you get

A medal predictionWith a probability for each outcome.
What gets noticedCompare models to see which features matter.
Text columns handledKeywords and dates go in as they are.

Try it

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