Get Validation Predictions For Lesson 3 wandb

get_validation_preds.py

import wandb
import pandas as pd
from fastcore.all import Path

def val_pred_table(run_id, entity='wandb_course', proj='lemon-project'):
    "Get prediction table on the validation set for the lemon project."
    api = wandb.Api()
    path = api.artifact(f'{entity}/{proj}/run-{run_id}-predictions_table:v0').download()
    preds = (Path(path)/'predictions_table.table.json').read_json()
    return pd.DataFrame([{'pred':p, 'label':t}  for _,p,_,t in preds['data']])


if __name__ == '__main__':
    preds = val_pred_table('zxum4ef0')
    preds.to_excel(Path('Validtation_Predictions.xlsx'))

Spreadhseet simulation https://www.dropbox.com/s/apox0e22e8lk9wu/Validtation_Predictions_Simulation.xlsx?dl=0