{"cells":[{"metadata":{"_uuid":"e014a68f8fd574398fa868e70dc03954fcf09137","_execution_state":"idle","trusted":true},"cell_type":"code","source":"library(data.table)","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"0e702b882368d7f5a7669ebecad16bbd2d73cb4c"},"cell_type":"markdown","source":"I don't know the difference between the three different video CSV's. This kernel looks at them to try to figure out what's going on.\n\nHypothesis: \"video-footage-control\" shows video of plays that result in no injury. \"video-footage-injury\" shows video of plays that result in injury, but no concussion. \"video-review\" shows video of plays that result in concussion."},{"metadata":{"_uuid":"0b2365df10b55ff7cd45a192c51c4929120c6c34"},"cell_type":"markdown","source":"# Video Control:"},{"metadata":{"trusted":true,"_uuid":"b1a71711d106daa2967f93aad9c45ff79ee33b45"},"cell_type":"code","source":"video_control <- fread(\"../input/video_footage-control.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"adc0553b614eb1738d527331408df227fad45d92"},"cell_type":"code","source":"video_control","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"f305bef89874ae6fb9c6621b397ed61dc319b6d9"},"cell_type":"markdown","source":"Video control has a description of the play and a video link. There are some fair catches in here, which indicates to me that there are rows in here without injuries (because a fair catch cannot result in an injury).\n\nThe last row, GameKey 421 and PlayID 2870, has a \"questionable\" injury of NE #25 E.Rowe , injury of the groin.\n\nNotably, the GameKeys look sequential (they are increasing from 415 to 421). They al come from the 2017 Regular Season in Week 2."},{"metadata":{"_uuid":"d161eb1d1d080424aacfc8cfb33b5e327cefc2e4"},"cell_type":"markdown","source":"# Video Injury:"},{"metadata":{"trusted":true,"_uuid":"3970474011e407cc70d48ae3fe9e5e14e4accef0"},"cell_type":"code","source":"video_injury <- fread(\"../input/video_footage-injury.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"scrolled":false,"_uuid":"a155bf8b0b0cf353348352945c109d230a962494"},"cell_type":"code","source":"video_injury","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"8c33045713b6d97b574bac57b97445ccd78a85f4"},"cell_type":"markdown","source":"Video footage injury seems to only contain injuries on the punt play. For example, there are illegal blocks above the waist, there are fair catch interferences, unnecessary roughness, running into the kicker (wait, you can't do that?!), Offensive Holding, and probably some more. A lot of the Descriptions list specifically an injury occurred, but not all of them. Some of them just say that the runner ran out of bounds, and that's it. One of them said that a player was being \"evaluated\" for a concussion. So maybe these are all just plays that resulted in an injury, but no concussion? Hold up, let's verify with the last CSV."},{"metadata":{"_uuid":"e0b1b6aca908eddc9b8eda1aebba8473932af909"},"cell_type":"markdown","source":"# Video Review:"},{"metadata":{"trusted":true,"_uuid":"0fbca37cca781f96e10fdf375627e3f5bee40eee"},"cell_type":"code","source":"video_review <- fread(\"../input/video_review.csv\")","execution_count":null,"outputs":[]},{"metadata":{"trusted":true,"_uuid":"2aaa0dfc0d91ddabb1cf49ae81cdc2053205b5ca"},"cell_type":"code","source":"video_review","execution_count":null,"outputs":[]},{"metadata":{"_uuid":"d0ac6ad17ceac508fb491d17b57032ba01361f27"},"cell_type":"markdown","source":"Okay, it all makes sense now. **Video_footage-injury.csv contains a description and video of punt plays that resulted in concussions. You can join this with video_review.csv to obtain specific information about the concussion, like the player (GSISID) who was concussed and the partner concusser, how it occurred (blocking? tackling? helmet-to-helmet collision? helmet-to-ground collision? did 2 teammates collide or was it 2 opponents?).**\n\n**By contrast, video_footage-control.csv seems to contain non-injury footage to reveal differences in what the plays look like. The only questionable row in that data.table is with description \"(7:42) R.Allen punts 27 yards to NO 29, Center-J.Cardona, downed by NE-M.Flowers. PENALTY on NE-D.Allen, Offensive Too Many Men on Field, 5 yards, enforced at NO 29. INJURY UPDATE: NE #25 E.Rowe, groin, questionable.\" because an injury might have been sustained (but if it's a groin injury, then that can't yield a concussion, anyway.)**"},{"metadata":{"trusted":true,"_uuid":"18dc358a1dbae25556cd035debaed768d7022007"},"cell_type":"code","source":"","execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"R","language":"R","name":"ir"},"language_info":{"mimetype":"text/x-r-source","name":"R","pygments_lexer":"r","version":"3.4.2","file_extension":".r","codemirror_mode":"r"}},"nbformat":4,"nbformat_minor":1}