Title Of Stuff

2 minute read

Published:

import pandas as pd
df = pd.read_csv('/Users/abramson/Desktop/cfb_data/2017/CSV/PBP - 2017 - Week 1.csv')
df[(df.homeTeam == 'Miami') & (df.isScoringPlay == True)]
gameIdyearweekhomeIdhomeTeamhomeAbbrawayIdawayTeamawayAbbrdriveIndex...isScoringPlayquarterclocktypedowndistanceyardLineyardsGainedendYardLinedescription
7032400937449201712390MiamiMIAMI2065Bethune-CookmanBCU0...True17:25Field Goal Good416193619Uriel Hernandez 36 yd FG GOOD
7045400937449201712390MiamiMIAMI2065Bethune-CookmanBCU1...True13:19Field Goal Good40902790Michael Badgley 27 yd FG GOOD
7064400937449201712390MiamiMIAMI2065Bethune-CookmanBCU3...True213:31Rushing Touchdown10955100Mark Walton run for 5 yds for a TD, (Michael B...
7078400937449201712390MiamiMIAMI2065Bethune-CookmanBCU5...True28:31Passing Touchdown30955100Malik Rosier pass complete to Lawrence Cager f...
7087400937449201712390MiamiMIAMI2065Bethune-CookmanBCU7...True25:34Passing Touchdown24955100Malik Rosier pass complete to Darrell Langham ...
7105400937449201712390MiamiMIAMI2065Bethune-CookmanBCU8...True20:53Field Goal Good40183518Uriel Hernandez 35 yd FG GOOD
7122400937449201712390MiamiMIAMI2065Bethune-CookmanBCU10...True312:30Rushing Touchdown10946100Mark Walton run for 6 yds for a TD, (Michael B...
7136400937449201712390MiamiMIAMI2065Bethune-CookmanBCU11...True36:16Rushing Touchdown20110Michael Jones run for 1 yd for a TD, (Uriel He...
7155400937449201712390MiamiMIAMI2065Bethune-CookmanBCU14...True31:08Passing Touchdown1107822100Malik Rosier pass complete to Braxton Berrios ...
7187400937449201712390MiamiMIAMI2065Bethune-CookmanBCU18...True45:14Field Goal Good423675080Michael Badgley 50 yd FG GOOD

10 rows × 29 columns

df.columns
Index(['gameId', 'year', 'week', 'homeId', 'homeTeam', 'homeAbbr', 'awayId',
       'awayTeam', 'awayAbbr', 'driveIndex', 'playIndex', 'offenseId',
       'offenseTeam', 'offenseAbbr', 'defenseId', 'defenseTeam', 'defenseAbbr',
       'homeScore', 'awayScore', 'isScoringPlay', 'quarter', 'clock', 'type',
       'down', 'distance', 'yardLine', 'yardsGained', 'endYardLine',
       'description'],
      dtype='object')