Skip to content

Instantly share code, notes, and snippets.

@amankharwal
Created December 23, 2020 14:21
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save amankharwal/f8e5f44614889fa1cb90d98aba8d01fc to your computer and use it in GitHub Desktop.
Save amankharwal/f8e5f44614889fa1cb90d98aba8d01fc to your computer and use it in GitHub Desktop.
batsmen = matches[['id','season']].merge(deliveries, left_on = 'id', right_on = 'id', how = 'left').drop('id', axis = 1)
season=batsmen.groupby(['season'])['total_runs'].sum().reset_index()
avgruns_each_season=matches.groupby(['season']).count().id.reset_index()
avgruns_each_season.rename(columns={'id':'matches'},inplace=1)
avgruns_each_season['total_runs']=season['total_runs']
avgruns_each_season['average_runs_per_match']=avgruns_each_season['total_runs']/avgruns_each_season['matches']
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment