player_type_help.py

import time
from collections import defaultdict

import nfldb

START = time.time()


def tally_points(db, y, w, ph):
    q = nfldb.Query(db)
    player_score = defaultdict(int)

    q.game(season_year=y, week=w, season_type=ph)
    for pp in q.as_aggregate():
        player_score[pp.player] += 1.0*pp.kicking_xpmade

    q.play_player(kicking_fgm=1)
    for pp in q.as_play_players():
        fg_length = getattr(pp, 'kicking_fgm_yds')
        if fg_length < 40:
            player_score[pp.player] += 3.0
        elif fg_length < 50:
            player_score[pp.player] += 4.0
        else:
            player_score[pp.player] += 5.0

    return player_score

if __name__ == '__main__':
    db = nfldb.connect()
    player_points = tally_points(db, 2014, 6, 'Regular')
    for player in player_points:
        if player.player_id == '00-0025565':  # Nick Folk
            print player, type(player), player_points[player]

END = time.time()
print('Run time = %s' % (END-START))

output

Nick Folk (NYJ, K) <class 'nfldb.types.Player'> 2.0
Nick Folk (NYJ, K) <class 'nfldb.types.Player'> 3.0
Run time = 4.02799987793