{"cells":[{"metadata":{},"cell_type":"markdown","source":"#  Measure your score by logloss\n\n`../input/submission/submission.csv`  \nChange to your submission.csv\n\n**warning**  \nThe resulting score is not accurate to the third decimal place"},{"metadata":{"trusted":true},"cell_type":"code","source":"import pandas as pd\nimport numpy as np","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"def logloss(true_label, predicted, eps=1e-15):\n    p = np.clip(predicted, eps, 1 - eps)\n    if true_label == 1:\n        return -np.log(p)\n    return -np.log(1 - p)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true},"cell_type":"code","source":"tourney_result = pd.read_csv('../input/google-cloud-ncaa-march-madness-2020-division-1-mens-tournament/MDataFiles_Stage1/MNCAATourneyCompactResults.csv')\nsubmission_result = pd.read_csv('../input/submission/submission.csv')\n\nlogloss_results = []\n\nfor column_name, item in submission_result.iterrows():\n    ids = item['ID'].split('_')\n\n    result = -1\n\n    record = tourney_result[\n        (tourney_result['Season'] == int(ids[0])) & \n        (tourney_result['WTeamID'] == int(ids[1])) & \n        (tourney_result['LTeamID'] == int(ids[2]))]\n    if record.shape[0] > 0:\n        result = 1\n\n    record = tourney_result[\n        (tourney_result['Season'] == int(ids[0])) & \n        (tourney_result['WTeamID'] == int(ids[2])) & \n        (tourney_result['LTeamID'] == int(ids[1]))]\n    if record.shape[0] > 0:\n        result = 0\n        \n\n    if result > -1:\n        logloss_results.append(round(logloss(result, item['Pred']), 6))\n        \n\nprint('score', sum(logloss_results)/len(logloss_results))\n","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"language":"python","display_name":"Python 3","name":"python3"},"language_info":{"pygments_lexer":"ipython3","nbconvert_exporter":"python","version":"3.6.4","file_extension":".py","codemirror_mode":{"name":"ipython","version":3},"name":"python","mimetype":"text/x-python"}},"nbformat":4,"nbformat_minor":4}