{"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_minor":4,"nbformat":4,"cells":[{"cell_type":"code","source":"'''Standard imports'''\nimport numpy as np\nimport pandas as pd\nimport time\nfrom itertools import chain\nimport json\n\n'''Imports needed for mlb environment'''\nimport sys\nif 'kaggle_secrets' in sys.modules:\n    import mlb\n\n'''Sorted list of columns from public test data'''\nexample_test_labels = [\n    'awards',\n    'date',\n    'events',\n    'games',\n    'playerBoxScores',\n    'playerTwitterFollowers',\n    'rosters',\n    'standings',\n    'teamBoxScores',\n    'teamTwitterFollowers',\n    'transactions'\n]\nmissing_column = [\n    False,\n    False,\n    False,\n    False\n]\nis_missing_values = []\n\ncolumn_to_test = \"rosters\"\n'''Iterate through mlb environment'''\nif 'kaggle_secrets' in sys.modules:\n    # Make environment\n    env = mlb.make_env()\n    iter_test = env.iter_test()\n    # iterate through test data\n    for (test_df, sample_prediction_df) in iter_test:\n        # get date column from index if date is not column\n        if \"date\" not in list(test_df):\n            test_df = test_df.reset_index()\n            test_df = test_df.rename(columns={\"index\": \"date\"})\n        if len(pd.DataFrame(list(chain(*[json.loads(data) for data in test_df[column_to_test].copy().dropna().to_list()])))) == 0:\n            is_missing_values.append(True)\n        else:\n            is_missing_values.append(False)\n        env.predict(sample_prediction_df)   \nif np.any(np.array(is_missing_values)):\n    time.sleep(600.0)\n    raise ValueError\nprint(\"Complete.\")","metadata":{"_uuid":"8f2839f25d086af736a60e9eeb907d3b93b6e0e5","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","execution":{"iopub.status.busy":"2021-06-23T01:47:48.264231Z","iopub.execute_input":"2021-06-23T01:47:48.264645Z","iopub.status.idle":"2021-06-23T01:47:49.915978Z","shell.execute_reply.started":"2021-06-23T01:47:48.264557Z","shell.execute_reply":"2021-06-23T01:47:49.915265Z"},"trusted":true},"execution_count":null,"outputs":[]}]}