{"cells":[{"metadata":{"_uuid":"0992f782a7c8563d8986c3806339202d7649127e"},"cell_type":"markdown","source":"I've slightly edit the starter kernel and use it to plot the path of player verus time, and manually record the impact time of 34 concussions that involves two players. The timing may be a little off so feel free to point out labeling error."},{"metadata":{"trusted":true,"_uuid":"aa07e2fc6b7539c88767df4c356207e6eec59b0e"},"cell_type":"code","source":"import pandas as pd\nimport glob\nfrom plotly import offline\nimport plotly.graph_objs as go\n\n\npd.set_option('max.columns', None)\noffline.init_notebook_mode()\nconfig = dict(showLink=False)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"47523e07ecd62c05a20f0a2365d387bcf8c694a8","_cell_guid":"b1076dfc-b9ad-4769-8c92-a6c4dae69d19","trusted":true,"scrolled":false},"cell_type":"code","source":"\nvideo_review = pd.read_csv('../input/video_review.csv')\nvideo_review.head()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"01104bfe517d53739f9664c741e3a0e23fe1b8a2"},"cell_type":"code","source":"def load_layout():\n    \"\"\"\n    Returns a dict for a Football themed Plot.ly layout \n    \"\"\"\n    layout = dict(\n        title = \"Player Activity\",\n        plot_bgcolor='darkseagreen',\n        showlegend=True,\n        xaxis=dict(\n            autorange=False,\n            range=[0, 120],\n            showgrid=False,\n            zeroline=False,\n            showline=True,\n            linecolor='black',\n            linewidth=1,\n            mirror=True,\n            ticks='',\n            tickmode='array',\n            tickvals=[10,20, 30, 40, 50, 60, 70, 80, 90, 100, 110],\n            ticktext=['Goal', 10, 20, 30, 40, 50, 40, 30, 20, 10, 'Goal'],\n            showticklabels=True\n        ),\n        yaxis=dict(\n            title='',\n            autorange=False,\n            range=[-3.3,56.3],\n            showgrid=False,\n            zeroline=False,\n            showline=True,\n            linecolor='black',\n            linewidth=1,\n            mirror=True,\n            ticks='',\n            showticklabels=False\n        ),\n        shapes=[\n            dict(\n                type='line',\n                layer='below',\n                x0=0,\n                y0=0,\n                x1=120,\n                y1=0,\n                line=dict(\n                    color='white',\n                    width=2\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=0,\n                y0=53.3,\n                x1=120,\n                y1=53.3,\n                line=dict(\n                    color='white',\n                    width=2\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=10,\n                y0=0,\n                x1=10,\n                y1=53.3,\n                line=dict(\n                    color='white',\n                    width=10\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=20,\n                y0=0,\n                x1=20,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=30,\n                y0=0,\n                x1=30,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=40,\n                y0=0,\n                x1=40,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=50,\n                y0=0,\n                x1=50,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=60,\n                y0=0,\n                x1=60,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),dict(\n                type='line',\n                layer='below',\n                x0=70,\n                y0=0,\n                x1=70,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),dict(\n                type='line',\n                layer='below',\n                x0=80,\n                y0=0,\n                x1=80,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=90,\n                y0=0,\n                x1=90,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),dict(\n                type='line',\n                layer='below',\n                x0=100,\n                y0=0,\n                x1=100,\n                y1=53.3,\n                line=dict(\n                    color='white'\n                )\n            ),\n            dict(\n                type='line',\n                layer='below',\n                x0=110,\n                y0=0,\n                x1=110,\n                y1=53.3,\n                line=dict(\n                    color='white',\n                    width=10\n                )\n            )\n        ]\n    )\n    return layout\n\nlayout = load_layout()","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"37ee58079f16f8a2276bef23d6d897bb56f3fe8b"},"cell_type":"code","source":"# Loading and plotting functions\n\ndef load_plays_for_game(GameKey):\n    \"\"\"\n    Returns a dataframe of play data for a given game (GameKey)\n    \"\"\"\n    play_information = pd.read_csv('../input/play_information.csv')\n    play_information = play_information[play_information['GameKey'] == GameKey]\n    return play_information\n\n\ndef load_game_and_ngs(ngs_file=None, GameKey=None):\n    \"\"\"\n    Returns a dataframe of player movements (NGS data) for a given game\n    \"\"\"\n    if ngs_file is None:\n        print(\"Specifiy an NGS file.\")\n        return None\n    if GameKey is None:\n        print('Specify a GameKey')\n        return None\n    # Merge play data with NGS data    \n    plays = load_plays_for_game(GameKey)\n    ngs = pd.read_csv(ngs_file, low_memory=False)\n    merged = pd.merge(ngs, plays, how=\"inner\", on=[\"GameKey\", \"PlayID\", \"Season_Year\"])\n    return merged\n\n\ndef plot_play(game_df, PlayID, player1=None, player2=None, custom_layout=False):\n    \"\"\"\n    Plots player movements on the field for a given game, play, and two players\n    \"\"\"\n    game_df = game_df[game_df.PlayID==PlayID]\n    \n    GameKey=str(pd.unique(game_df.GameKey)[0])\n    HomeTeam = pd.unique(game_df.Home_Team_Visit_Team)[0].split(\"-\")[0]\n    VisitingTeam = pd.unique(game_df.Home_Team_Visit_Team)[0].split(\"-\")[1]\n    YardLine = game_df[(game_df.PlayID==PlayID) & (game_df.GSISID==player1)]['YardLine'].iloc[0]\n    \n    traces=[]   \n    if (player1 is not None) & (player2 is not None):\n        game_df = game_df[ (game_df['GSISID']==player1) | (game_df['GSISID']==player2)]\n        for player in pd.unique(game_df.GSISID):\n            player = int(player)\n            trace = go.Scatter(\n                x = game_df[game_df.GSISID==player].x,\n                y = game_df[game_df.GSISID==player].y,\n                text = game_df[game_df.GSISID==player].Time,\n                hoverinfo = 'text',\n                name='GSISID '+str(player),\n                mode='markers'\n            )\n            traces.append(trace)\n    else:\n        print(\"Specify GSISIDs for player1 and player2\")\n        return None\n    \n    if custom_layout is not True:\n        layout = load_layout()\n        layout['title'] =  HomeTeam + \\\n        ' vs. ' + VisitingTeam + \\\n        '<br>Possession: ' + \\\n        YardLine.split(\" \")[0] +'@'+YardLine.split(\" \")[1]\n    data = traces\n    fig = dict(data=data, layout=layout)\n    play_description = game_df[(game_df.PlayID==PlayID) & (game_df.GSISID==player1)].iloc[0][\"PlayDescription\"]\n    print(\"\\n\\n\\t\",play_description)\n    offline.iplot(fig, config=config)\n    ","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"886db0d144bfae99ec25f16d506a7031306f4e93"},"cell_type":"code","source":"time_data = ['2016-08-12 02:07:47:600','2016-08-20 21:04:15:800','2016-08-19 23:53:46.400','2016-08-28 00:28:47.600','2016-09-02 00:33:39.100',\n            '2016-09-02 00.13.24.200','2016-10-16 18:46:54.300','2016-10-16 19:38:01.400','2016-11-06 21:00:52.800','2016-11-20 20:41:57.200',\n            '2016-11-27 19:21:55.800','2016-11-27 20:32:16.000','2016-12-11 20:30:37.200','2016-12-16 04:19:02.700','2016-12-18 20:20:51.500',\n            '2016-12-18 20.55.49.100','2016-12-18 19:16:08.700','2016-12-20 03:19:55.100','2016-12-24 19:59:49.300','2017-08-18 01:39:15.000',\n            '2017-08-20 01:29:19.200','2017-08-20 01:42:36.800','2017-08-31 23:10:42.500','2017-09-01 01:24:07.800','2017-09-01 03:10:23.800',\n            '2017-09-08 03:10:57.300','','2017-10-01 15:39:58.200','2017-10-08 21:48:30.500','','2017-11-19 19:16:21.400','2017-11-26 18:59:23.700',\n            '2017-12-03 19:51:17.000','','2017-12-10 21:27:21.400','2017-12-15 02:03:15.800','2017-12-17 23:13:36.300']","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ca59b4ccd229410180e4c595a434a3fe294da046"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-pre.csv',GameKey=video_review['GameKey'][0]) #2016-08-12 02:07:47:600","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d68808558d297a6cd89a4e3076d4b1fa149324e7","scrolled":true},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][0], player1=float(video_review['GSISID'][0]), player2=float(video_review['Primary_Partner_GSISID'][0]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b367d077f45d8c63dc352cdd0f0657b9c2a1c231"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-pre.csv',GameKey=video_review['GameKey'][1]) #2016-08-20 21:04:15:800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"077d72483da2a5a640dd1bb6e7d232c7a5576d37"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][1], player1=float(video_review['GSISID'][1]), player2=float(video_review['Primary_Partner_GSISID'][1]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"11a7f149bb948fd049b3732903e4fc03606f3f45"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-pre.csv',GameKey=video_review['GameKey'][2]) #2016-08-19 23:53:46.400","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ed6acf649106af947cd178ba6fa9f8e266c85003"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][2], player1=float(video_review['GSISID'][2]), player2=float(video_review['Primary_Partner_GSISID'][2]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d4cb2a9f140b50759ccb729ea3c483384aa34ecf"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-pre.csv',GameKey=video_review['GameKey'][3]) #2016-08-28 00:28:47.600","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"scrolled":true,"_uuid":"1b4844c93e976dfecc28242d46703edc137b2e69"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][3], player1=float(video_review['GSISID'][3]), player2=float(video_review['Primary_Partner_GSISID'][3]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"1ed4a237b9e56794e4fea8d4127cac4845dcb814"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-pre.csv',GameKey=video_review['GameKey'][4]) #2016-09-02 00:33:39.100","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"82a558afef22ec5ba91bb90739c7fe46a19b0dbb"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][4], player1=float(video_review['GSISID'][4]), player2=float(video_review['Primary_Partner_GSISID'][4]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"54b40ac9a97bdd98d7c1db1ba34ab3c4cd86aedd"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-pre.csv',GameKey=video_review['GameKey'][5]) #2016-09-02 00.13.24.200","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"6ada7280e1fe5e7f8a5e11d71b586672c39d6eb3"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][5], player1=float(video_review['GSISID'][5]), player2=float(video_review['Primary_Partner_GSISID'][5]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b2a165e68c5419c194918ce3db51f03c83de12d4"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk1-6.csv',GameKey=video_review['GameKey'][6]) #2016-10-16 18:46:54.300","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ff09d03ab25c471ee4f4f01b8261742c1fde2b6c"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][6], player1=float(video_review['GSISID'][6]), player2=float(video_review['Primary_Partner_GSISID'][6]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"1ea919d3ff0d0aa601a00f68c025e9b23bcba4f3"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk1-6.csv',GameKey=video_review['GameKey'][7]) #2016-10-16 19:38:01.400","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c8c730d3fc721b4b982a9b680b76ea9a4410eeb0"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][7], player1=float(video_review['GSISID'][7]), player2=float(video_review['Primary_Partner_GSISID'][7]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"5cecc3e160b9292c88bc143262cc32d5bf2f869b"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk7-12.csv',GameKey=video_review['GameKey'][8]) #2016-11-06 21:00:52.800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"4847409a10d29e50f5660948f6b7697c11d6d4db"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][8], player1=float(video_review['GSISID'][8]), player2=float(video_review['Primary_Partner_GSISID'][8]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"4ef9d792044c41eb83a3a1086a25e6dd221d412b"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk7-12.csv',GameKey=video_review['GameKey'][9]) #2016-11-20 20:41:57.200","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"f01041449084cb269eae3543e3235cc90d89097c"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][9], player1=float(video_review['GSISID'][9]), player2=float(video_review['Primary_Partner_GSISID'][9]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"09fa6175fa95d45e4e4a108ad45bc0eff941b216"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk7-12.csv',GameKey=video_review['GameKey'][10]) #2016-11-27 19:21:55.800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"708ead67549866cbf44ee3ff9578e66ec5a6d6f1"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][10], player1=float(video_review['GSISID'][10]), player2=float(video_review['Primary_Partner_GSISID'][10]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"ef515426fe77c40125ac1caaa9ac6b61d321aeb6"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk7-12.csv',GameKey=video_review['GameKey'][11]) #2016-11-27 20:32:16.000","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"8f0a72842ef999e3d4a3f92db6e94c6e7fc12bcc"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][11], player1=float(video_review['GSISID'][11]), player2=float(video_review['Primary_Partner_GSISID'][11]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"cf22478966ca95f391c39bf4f60760760b11df42"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][12]) #2016-12-11 20:30:37.200","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"3b459aadaa025793bb9ace380aae5e6beecd3bb0"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][12], player1=float(video_review['GSISID'][12]), player2=float(video_review['Primary_Partner_GSISID'][12]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"f884926b655bb1ecf1116c4d0b3f56b8350653dd"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][13]) #2016-12-16 04:19:02.700","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"8a0eb9333ac76e03dadc435f93640f1ad189d623"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][13], player1=float(video_review['GSISID'][13]), player2=float(video_review['Primary_Partner_GSISID'][13]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"74916546cc07dfd9fd1762b2aadb46d0a85df276"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][14]) #2016-12-18 20:20:51.500","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"4fefa7224d2dcf7e93c4294912dae9351fc81029"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][14], player1=float(video_review['GSISID'][14]), player2=float(video_review['Primary_Partner_GSISID'][14]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e9cb4b2b8720e7f8335fe7bbf5b16bc6b65a7d57"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][15]) #2016-12-18 20.55.49.100","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"f811881dbb06720897594faf0cd7204a35bfa869"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][15], player1=float(video_review['GSISID'][15]), player2=float(video_review['Primary_Partner_GSISID'][15]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"63bd102bfef19591abe3f9cde155c508649714ca"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][16])#2016-12-18 19:16:08.700","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"11ab61fa0363d33bc2c5919fec6b3668945bf60c"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][16], player1=float(video_review['GSISID'][16]), player2=float(video_review['Primary_Partner_GSISID'][16]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"5e34adbff8b7dce3aa8b15156a107657d23bc7b7"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][17])#2016-12-20 03:19:55.100","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"7bd9f39ba026d92756b9e418539b7eb62e42ba6b"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][17], player1=float(video_review['GSISID'][17]), player2=float(video_review['Primary_Partner_GSISID'][17]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"98264211b2fc07baa690605d852c7c2eec3002b3"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2016-reg-wk13-17.csv',GameKey=video_review['GameKey'][18]) #2016-12-24 19:59:49.300","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c96dbd41bd10920693a55828fb20b8466cdba962","scrolled":true},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][18], player1=float(video_review['GSISID'][18]), player2=float(video_review['Primary_Partner_GSISID'][18]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"7a7b63d638ca3ccb07b87394310a57f1ff5547f3"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-pre.csv',GameKey=video_review['GameKey'][19]) #2017-08-18 01:39:15.000","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"f1233b202f20346f5cfea292b3e4d04a6d9631d5"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][19], player1=float(video_review['GSISID'][19]), player2=float(video_review['Primary_Partner_GSISID'][19]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"4cba252673116b7bae3e938bd74225e1476fc9a8"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-pre.csv',GameKey=video_review['GameKey'][20])# 2017-08-20 01:29:19.200","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"592db2ae7dd9e8de6ef294942408494dbb4a372b"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][20], player1=float(video_review['GSISID'][20]), player2=float(video_review['Primary_Partner_GSISID'][20]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e01ef43ba671f00c3104c258c9638ea9a605dc20"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-pre.csv',GameKey=video_review['GameKey'][21]) #2017-08-20 01:42:36.800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e45c3713ff250576f0273efa5166fab6b02fd7d1"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][21], player1=float(video_review['GSISID'][21]), player2=float(video_review['Primary_Partner_GSISID'][21]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"2a09ff8cd096e7e611c2f4062886d7a591aea9b3"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-pre.csv',GameKey=video_review['GameKey'][22]) #2017-08-31 23:10:42.500","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"a2d453263fb90c9123a6cad80ecf7cc03a244656"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][22], player1=float(video_review['GSISID'][22]), player2=float(video_review['Primary_Partner_GSISID'][22]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"182e0793d776b2c10546c3d2799cd9aa4d648eec"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-pre.csv',GameKey=video_review['GameKey'][23]) #2017-09-01 01:24:07.800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c64a1673d2a29e8e973adc4f717f5d95da3cf120"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][23], player1=float(video_review['GSISID'][23]), player2=float(video_review['Primary_Partner_GSISID'][23]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"8fa658984626cd01b4bbd0fc095355c5be1475ab"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-pre.csv',GameKey=video_review['GameKey'][24]) #2017-09-01 03:10:23.800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"741ea3517ef00754100cadd5ec451cf7e3bf7202"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][24], player1=float(video_review['GSISID'][24]), player2=float(video_review['Primary_Partner_GSISID'][24]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"94c517b921e6a6466efc436136b4110dcbf6fae5"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk1-6.csv',GameKey=video_review['GameKey'][25]) #2017-09-08 03:10:57.300","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"f18308ff6cb2dd585787322de792f87cadf5c2f5"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][25], player1=float(video_review['GSISID'][25]), player2=float(video_review['Primary_Partner_GSISID'][25]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"4490f90beb57e8dae18c3f6037015801c0f08d2b"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk1-6.csv',GameKey=video_review['GameKey'][26]) ","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"3a0dba95d72de39bbbcb5555e2b4f3ed2f54d69f"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][26], player1=float(video_review['GSISID'][26]), player2=float(video_review['Primary_Partner_GSISID'][26]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"19fbe8bcf76a8fcd8e024e56ba69d88c95caf346"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk1-6.csv',GameKey=video_review['GameKey'][27]) #2017-10-01 15:39:58.200","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"549ecb03b73551c76514884371763095249400de"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][27], player1=float(video_review['GSISID'][27]), player2=float(video_review['Primary_Partner_GSISID'][27]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"1d954415080dc6847bc109a4677770bb26fd4e3c"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk1-6.csv',GameKey=video_review['GameKey'][28])  #2017-10-08 21:48:30.500","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c687b45e46a1ed856854eeca9ff4f9a9ca230198"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][28], player1=float(video_review['GSISID'][28]), player2=float(video_review['Primary_Partner_GSISID'][28]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"c9814893cf5d323f043c32cb047f150542990dc0"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk7-12.csv',GameKey=video_review['GameKey'][29])  ","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"eb8059257a4fc082a7a58bd027bdee3392ee2b5a"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][29], player1=float(video_review['GSISID'][29]), player2=float(video_review['Primary_Partner_GSISID'][29]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"7c753e5bb02b181dfee2cae7e1bb49e0e777e5f1"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk7-12.csv',GameKey=video_review['GameKey'][30])  #2017-11-19 19:16:21.400","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"scrolled":true,"_uuid":"f12222ff30b7b1f2f3fcc41d1b36555ab33ff2a4"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][30], player1=float(video_review['GSISID'][30]), player2=float(video_review['Primary_Partner_GSISID'][30]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d670edf2bd21aa01400b529e364efa2909231702"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk7-12.csv',GameKey=video_review['GameKey'][31])  #2017-11-26 18:59:23.700","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"5c224442a2b5a799b14012c711cb6f97580b03ef"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][31], player1=float(video_review['GSISID'][31]), player2=float(video_review['Primary_Partner_GSISID'][31]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"9e068fc76de4d37f4f3eec7ef13f8ddf80be9eba"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk13-17.csv',GameKey=video_review['GameKey'][32])  #2017-12-03 19:51:17.000","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"677c55b3dc6943609bb6a3b70f25bec52de99946"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][32], player1=float(video_review['GSISID'][32]), player2=float(video_review['Primary_Partner_GSISID'][32]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"d5883d4a50eb0430db5aeba71ad2b463fe9ce4f2"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk13-17.csv',GameKey=video_review['GameKey'][33])  ","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"1f4b1db9e467a51802144aada2d04c2b380f3229"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][33], player1=float(video_review['GSISID'][33]), player2=0)","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"6915c36013d860e4747937d9bc9be1575b2e0f60"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk13-17.csv',GameKey=video_review['GameKey'][34])  #2017-12-10 21:27:21.400","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"e3593df8f68e6fe3642307b4c495b0fd89f724e3"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][34], player1=float(video_review['GSISID'][34]), player2=float(video_review['Primary_Partner_GSISID'][34]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"b4df2f957acfcfbdb16619c3deb17dea6bd51b29"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk13-17.csv',GameKey=video_review['GameKey'][35])  #2017-12-15 02:03:15.800","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"8848bdb89211d5ffe3fec78d6c92afcb0fc06104"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][35], player1=float(video_review['GSISID'][35]), player2=float(video_review['Primary_Partner_GSISID'][35]))","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"43bbba33ab70f5068053d4a5461505f0bbdf5a48"},"cell_type":"code","source":"game = load_game_and_ngs('../input/NGS-2017-reg-wk13-17.csv',GameKey=video_review['GameKey'][36])   #2017-12-17 23:13:36.300","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"afed521d2452821cc17f3dd56d3f3b527239f681"},"cell_type":"code","source":"plot_play(game_df=game, PlayID=video_review['PlayID'][36], player1=float(video_review['GSISID'][36]), player2=float(video_review['Primary_Partner_GSISID'][36]))","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"name":"python","version":"3.6.6","mimetype":"text/x-python","codemirror_mode":{"name":"ipython","version":3},"pygments_lexer":"ipython3","nbconvert_exporter":"python","file_extension":".py"}},"nbformat":4,"nbformat_minor":1}