4707229d41b18ac74ff186bf9a6874035c378719,common.py,,update_loglosses,#,69

Before Change

    test_logloss = log_loss(test_data["target"].as_matrix(), submission_test_data["probability"].as_matrix())

    // TODO: Get the postgres submission id
    cursor.execute("UPDATE submissions SET validation_logloss={} AND test_logloss={} WHERE id = "{}"".format(validation_logloss, test_logloss, ))
    postgres_db.commit()
    cursor.close()
    postgres_db.close()

After Change

    test_data.sort_values("id", inplace=True)

    // Calculate logloss
    submission_validation_data = submission.loc[submission["id"].isin(validation_data["id"].as_matrix())].copy()
    submission_validation_data.sort_values("id", inplace=True)
    submission_test_data = submission.loc[submission["id"].isin(test_data["id"].as_matrix())].copy()
    submission_test_data.sort_values("id", inplace=True)
    validation_logloss = log_loss(validation_data["target"].as_matrix(), submission_validation_data["probability"].as_matrix())
    test_logloss = log_loss(test_data["target"].as_matrix(), submission_test_data["probability"].as_matrix())

    // Get the submission Postgres id
    query = "SELECT s.id FROM submissions s INNER JOIN users u ON s.user_id = u.id WHERE u.username = "{}" AND s.inserted_at = "{}"".format(mongo_submission["username"], mongo_submission["created"])
    cursor.execute(query)
    submission_id = cursor.fetchone()[0]

    query = "UPDATE submissions SET validation_logloss={}, test_logloss={} WHERE id = "{}"".format(validation_logloss, test_logloss, submission_id)
    cursor.execute(query)
    print("Updated {} with validation_logloss={} and test_logloss={}".format(submission_id, validation_logloss, test_logloss))
    postgres_db.commit()
    cursor.close()

Instances