Data Collection American Football Head Coach Player Years Statistics

For all of the 100 head coaches listed here at Wikipedia ([login to view URL]) please extract the following focusing on the collection of player years for each coach: - rank (as listed) - coach name (as listed) - years served as coach (cumulative across all years as listed) - indicator if currently and active coach (encode active coaches with a 1 as listed and inactive with 0) - total years served as a player (pre graduation & professional career as described in referenced profile) - years served as player before graduation (years played in college/high school, excl. years in military or schools without football teams) - years served as professional player (years played after graduation) - wins (as listed) - losses (as listed) - ties (as listed) - pct_win (as listed) While most data points are in the table and can be extracted as listed (additionally refer to [login to view URL] for assistance) the key task is to collect the years each coach has been playing football during his career. The following date counting rules apply: 1. First year counts as 1 full year, independent of starting month. 2. Ending year counts as 1 full year, independent of starting month. 3. Time attending military service or school without football teams does NOT count towards years served. 4. Any breaks taken does not account as served years. 5. For any episode in #3 and #4 the first year referenced is subtracted and the end year is NOT subtracted, if the episode runs for less than 1 year, i.e., 3 months a full year is subtracted. 6. Only count verified and disclosed years as player, either in personal profile or PRO Football Reference web site. EXAMPLE 1 - Don Shula: a) Years as coach: 7 years (1963-1969) + 26 (1970-1995) = 33 b) Years as player pre-graduation: 3 (Harvey High School 1945, 1946, 1947 inclusive as not yet graduated) + 3 (John Carroll University 1948, 1949, 1950 inclusive since it's the senior year, 1951 exclusive since it's the ending year) = 6 c) Professional player years: 7 (1951/1952 Cleveland, 1953-1956 Baltimore, 1957 Washington) = 7 EXAMPLE 2 - Bill Belichick: a) Years as coach: 5 years (1991-1995) + 21 (2000-2020) = 26 b) Years as player pre-graduation: 5 (Undisclosed years at Annapolis High School plus 1970 to 1975 at Wesleyan) = 5 c) Professional player years: 0 (No professional player career) = 0 While coach and professional player years can easily collected via Wikipedia or PRO Football Reference web-site the crux of the task is to accurately extract the years played before graduation. Good command of English with regards of temporal event description is required. Complete the project by entering the data into the attached CSV file. Two examples have been provided in the file for your reference.