In [5]:
from usau.reports import USAUResults
In [7]:
u = USAUResults.from_nationals("d1college", 2017, "Men")
In [8]:
def compute_plus_minus(df, g_weight=1, a_weight=1, d_weight=1, turn_weight=-0.5):
return (g_weight * df["Goals"] +
a_weight * df["Assists"] +
d_weight * df["Ds"] +
turn_weight * df["Turns"])
In [17]:
import os
os.getcwd()
u.load_from_csvs(os.path.join(os.getcwd(), '..', 'usau', 'data2'))
Out[17]:
USAUResults<2017_d1college_nationals_men>
In [18]:
roster = u.rosters
In [19]:
roster["+/-"] = compute_plus_minus(roster)
In [35]:
roster.loc[roster.Team == "Colorado State"]
Out[35]:
Unnamed: 0
No.
Name
Position
Year
Height
Goals
Assists
Ds
Turns
url
Team
Seed
UpperName
+/-
98
0
1
Jack Hinchsliff
NaN
NaN
5'9"
2
5
2
7
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JACK HINCHSLIFF
5.5
99
1
2
Easton Archibald
Handler/Cutter
NaN
6'1"
0
1
0
2
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
EASTON ARCHIBALD
0.0
100
2
3
John Miller
Deep
NaN
5'6"
4
2
1
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JOHN MILLER
7.0
101
3
4
Morgan Scott
Mid
NaN
5'9"
1
5
2
9
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
MORGAN SCOTT
3.5
102
4
5
Jordan Trepp
Handler
NaN
6'0"
0
0
0
1
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JORDAN TREPP
-0.5
103
5
7
Will McDonald
Cutter
NaN
6'0"
11
3
0
5
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
WILL MCDONALD
11.5
104
6
9
Jacob Servaty
Handler
NaN
5'8"
1
6
1
10
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JACOB SERVATY
3.0
105
7
11
Jack McGinnis
Cutter
NaN
5'10"
2
0
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JACK MCGINNIS
2.0
106
8
12
Mark Stratford
NaN
NaN
NaN
0
0
2
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
MARK STRATFORD
2.0
107
9
13
Dylan Custer
NaN
NaN
NaN
0
0
2
3
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
DYLAN CUSTER
0.5
108
10
15
Mason Kiefer
NaN
NaN
NaN
1
0
1
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
MASON KIEFER
2.0
109
11
16
Jake Marrapode
Handler/Cutter
NaN
5'11"
7
6
0
12
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JAKE MARRAPODE
7.0
110
12
17
Cole Turner
NaN
NaN
NaN
1
0
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
COLE TURNER
1.0
111
13
18
Dylan Johnson
NaN
NaN
6'1"
2
3
2
5
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
DYLAN JOHNSON
4.5
112
14
20
Clark Yarbrough
NaN
NaN
NaN
1
0
0
1
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
CLARK YARBROUGH
0.5
113
15
21
Lucas Beal
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
LUCAS BEAL
0.0
114
16
22
Hudson Martin
Handler
NaN
5'11"
0
4
0
3
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
HUDSON MARTIN
2.5
115
17
24
David Miller
NaN
NaN
1'0"
3
2
3
6
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
DAVID MILLER
5.0
116
18
30
Sten Larson
NaN
NaN
NaN
2
1
0
3
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
STEN LARSON
1.5
117
19
31
Toby Nordhoff
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
TOBY NORDHOFF
0.0
118
20
33
Matthew Bush
Defense (Cutter/Handler)
NaN
6'2"
3
2
1
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
MATTHEW BUSH
6.0
119
21
34
Cody Spicer
Defense (Cutter)
NaN
6'2"
5
9
2
2
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
CODY SPICER
15.0
120
22
36
Daniel Crump
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
DANIEL CRUMP
0.0
121
23
44
Thomas Theodorescu
NaN
NaN
NaN
0
0
0
1
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
THOMAS THEODORESCU
-0.5
122
24
54
Sean Peskin
Cutter
NaN
6'1"
4
1
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
SEAN PESKIN
5.0
123
25
90
Dylan Cheever
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
DYLAN CHEEVER
0.0
In [24]:
(roster.sort_values("+/-", ascending=False)
.reset_index(drop=True)
.head(60)
[["Name", "Team",
"Goals", "Assists", "Ds", "Turns", "Height"]]
.rename(columns={"Goals": "Gs",
"Assists": "As",
"Turns": "Ts",
})
)
Out[24]:
Name
Team
Gs
As
Ds
Ts
Height
0
Jack Williams
North Carolina-Wilmington
11
34
9
20
NaN
1
Ben Sadok
Massachusetts
14
30
2
11
5'5"
2
Khalif El-Salaam
Washington
20
19
5
12
NaN
3
Matthew Gouchoe-Hanas
North Carolina
17
19
3
9
1'0"
4
Adam Norrbom
Virginia Tech
16
17
7
15
NaN
5
Elliott Chartock
Stanford
4
27
1
7
NaN
6
Joe White
Carleton College
17
10
6
13
5'11"
7
Henry Fisher
Carleton College
18
5
4
4
6'5"
8
Ross Barker
Wisconsin
13
15
4
15
5'11"
9
Michael Ing
Pittsburgh
13
4
8
2
NaN
10
Matthew Ellis
North Carolina-Wilmington
19
5
2
5
1'6"
11
Michael Rice
Connecticut
14
7
10
15
5'11"
12
Nicholas Vogt
Wisconsin
16
6
3
4
6'1"
13
Connor McFadyen
British Columbia
5
10
12
8
NaN
14
Zach Marbach
Texas A&M
15
6
7
11
5'11"
15
Avery Johnson
Wisconsin
10
13
1
4
5'11"
16
Nick Macleod
North Carolina
16
10
2
13
NaN
17
Alex Olson
Carleton College
6
24
3
24
5'11"
18
Eric C Taylor
Carleton College
12
11
2
10
6'1"
19
Michael Volz
Auburn
9
11
3
6
NaN
20
Mark Rauls
Colorado
15
8
0
6
5'5"
21
Kevin Mateer
North Carolina-Wilmington
4
11
11
13
NaN
22
Nathan Pettyjohn
Cal Poly-SLO
10
11
1
7
NaN
23
Andrew Cohen
North Carolina
3
19
0
7
10'0"
24
Dillon Lanier
Carleton College
10
10
1
6
6'0"
25
Chris Wilen
Wisconsin
7
8
5
4
NaN
26
Braedon Petrus
Oregon
5
15
2
9
5'5"
27
Stanley Birdsong
Carleton College
11
6
3
5
6'3"
28
SOLOMON Maerowitz-McMahan
Massachusetts
10
7
4
7
NaN
29
Nathan Kwon
North Carolina
7
5
8
6
1'0"
30
Adam Rees
Oregon
11
8
1
7
NaN
31
Patrick Barron
Massachusetts
10
2
5
1
6'2"
32
Brett Gramann
Massachusetts
7
11
3
10
5'9"
33
Colton Clark
Oregon
4
14
1
6
NaN
34
Martin Newman
Auburn
7
11
4
12
6'0"
35
Cameron Wariner
Cal Poly-SLO
10
4
8
12
6'1"
36
Sam Vandusen
Pittsburgh
7
14
4
18
6'0"
37
Tannor Johnson
Massachusetts
10
7
5
12
6'3"
38
Solomon Yanuck
Carleton College
5
14
5
16
5'11"
39
Daniel Lee
Michigan
8
5
6
7
6'1"
40
Austin McGrayne
North Carolina-Wilmington
14
2
3
7
NaN
41
Quinn Buermeyer
Oregon State
13
3
3
8
5'10"
42
Cody Spicer
Colorado State
5
9
2
2
6'2"
43
Lucas Chen
Washington
13
3
1
4
1'0"
44
Jack Slevin
Pittsburgh
7
10
1
7
NaN
45
Rhys Bergeron
Virginia Tech
13
5
1
9
6'0"
46
James Hershey
Auburn
13
2
1
3
NaN
47
Caleb Merriam
Cal Poly-SLO
5
13
1
10
5'8"
48
Kai Marcus
North Carolina
6
10
5
14
6'0"
49
Dylan Best
Pittsburgh
9
2
5
4
NaN
50
Frederick Burke Hennighausen
North Carolina-Wilmington
4
5
8
6
6'3"
51
Nolan Walsh
Stanford
11
3
2
5
NaN
52
Quinn Finer
Colorado
10
3
2
4
6'0"
53
Nicholas Ladas
Wisconsin
8
5
5
10
NaN
54
Thomas Edmonds
Pittsburgh
2
13
4
12
1'0"
55
Norman Archer
North Carolina
8
2
4
2
NaN
56
Jeremy Harker
Colorado
3
11
4
11
6'2"
57
Dongyang Chen
Washington
2
16
0
11
NaN
58
Sam Bumsted
Minnesota
5
10
2
9
6'0"
59
Gavin Clemmey
Connecticut
6
10
1
9
6'2"
In [32]:
roster.loc[(roster.Height < "5'8\"") &
((roster.Height < "5'10") | (roster.Height > "5'11\""))].sort_values("+/-", ascending=False)
Out[32]:
Unnamed: 0
No.
Name
Position
Year
Height
Goals
Assists
Ds
Turns
url
Team
Seed
UpperName
+/-
1
1
3
Ben Sadok
Deep
NaN
5'5"
14
30
2
11
/events/teams/?EventTeamId=Ru72lE6DmcK5VE81Bru...
Massachusetts
1
BEN SADOK
40.5
262
15
21
Matthew Gouchoe-Hanas
NaN
NaN
1'0"
17
19
3
9
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
MATTHEW GOUCHOE-HANAS
34.5
131
7
8
Matthew Ellis
Deep
NaN
1'6"
19
5
2
5
/events/teams/?EventTeamId=seHoSGs221Scx9In%2b...
North Carolina-Wilmington
11
MATTHEW ELLIS
23.5
337
0
0
Mark Rauls
Mid
NaN
5'5"
15
8
0
6
/events/teams/?EventTeamId=AI0JDCPunGLTg8CEc%2...
Colorado
10
MARK RAULS
20.0
257
10
13
Andrew Cohen
NaN
NaN
10'0"
3
19
0
7
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
ANDREW COHEN
18.5
457
24
80
Braedon Petrus
Handler
NaN
5'5"
5
15
2
9
/events/teams/?EventTeamId=V%2bpmNYSO38hv1afvp...
Oregon
5
BRAEDON PETRUS
17.5
251
4
5
Nathan Kwon
NaN
NaN
1'0"
7
5
8
6
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
NATHAN KWON
17.0
37
15
21
Lucas Chen
Dump
NaN
1'0"
13
3
1
4
/events/teams/?EventTeamId=IMHhriGUJ4QbfX6Z1FP...
Washington
8
LUCAS CHEN
15.0
152
4
8
Thomas Edmonds
Handler
NaN
1'0"
2
13
4
12
/events/teams/?EventTeamId=ttY%2bYqh6olbDojziV...
Pittsburgh
2
THOMAS EDMONDS
13.0
405
22
48
Wyatt Mekler
Handler
NaN
1'0"
5
10
0
6
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
WYATT MEKLER
12.0
51
5
8
Dillon Whited
Mid
NaN
1'0"
5
5
3
3
/events/teams/?EventTeamId=gr79Z2m9X4ttLRdaiUT...
Cal Poly-SLO
17
DILLON WHITED
11.5
35
13
16
Cooper Schumacher
Dump
NaN
1'0"
7
0
3
1
/events/teams/?EventTeamId=IMHhriGUJ4QbfX6Z1FP...
Washington
8
COOPER SCHUMACHER
9.5
393
10
11
Sam Kaminsky
Handler
NaN
1'0"
7
3
3
7
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
SAM KAMINSKY
9.5
367
7
10
Ryan Rogers
Handler/Cutter
NaN
5'7"
4
5
3
5
/events/teams/?EventTeamId=JMzzH4dfkmnlpZ%2f%2...
Oregon State
19
RYAN ROGERS
9.5
259
12
16
Anders Juengst
NaN
NaN
5'7"
10
2
0
6
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
ANDERS JUENGST
9.0
79
5
7
Maxwell Perham
Defense (Cutter)
NaN
1'0"
0
2
9
4
/events/teams/?EventTeamId=7iY1anYTyh3FqR%2b%2...
Stanford
12
MAXWELL PERHAM
9.0
220
18
81
Luke Hebert
Dump
NaN
5'7"
4
4
3
5
/events/teams/?EventTeamId=ufjbughMPF5LZdHCKgk...
Texas A&M
14
LUKE HEBERT
8.5
176
3
4
Michael Burke
NaN
NaN
1'0"
6
1
2
3
/events/teams/?EventTeamId=Rl4YCTbNv2d%2fXogKG...
Michigan
7
MICHAEL BURKE
7.5
386
3
3
Malakai Stern
NaN
NaN
1'0"
1
5
3
4
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
MALAKAI STERN
7.0
100
2
3
John Miller
Deep
NaN
5'6"
4
2
1
0
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
JOHN MILLER
7.0
53
7
10
Jeremy Dolezal-Ng
Handler
NaN
5'0"
1
6
3
7
/events/teams/?EventTeamId=gr79Z2m9X4ttLRdaiUT...
Cal Poly-SLO
17
JEREMY DOLEZAL-NG
6.5
327
25
37
Michael Strobel
Handler
NaN
4'10"
7
4
0
9
/events/teams/?EventTeamId=cYUt2jw%2bpLMJzu5NU...
Auburn
15
MICHAEL STROBEL
6.5
341
4
6
Erik Hotaling
NaN
NaN
1'0"
0
8
1
7
/events/teams/?EventTeamId=AI0JDCPunGLTg8CEc%2...
Colorado
10
ERIK HOTALING
5.5
115
17
24
David Miller
NaN
NaN
1'0"
3
2
3
6
/events/teams/?EventTeamId=RLSTXojAYf7nIu4ULAW...
Colorado State
13
DAVID MILLER
5.0
167
19
35
Dan Goldstein
Defense (Cutter/Handler)
NaN
5'7"
2
2
1
0
/events/teams/?EventTeamId=ttY%2bYqh6olbDojziV...
Pittsburgh
2
DAN GOLDSTEIN
5.0
468
9
26
Joshua Lam
Defense (Handler)
NaN
5'6"
3
2
1
2
/events/teams/?EventTeamId=JdRZxVMmx9KV9xrXZMA...
British Columbia
16
JOSHUA LAM
5.0
208
6
10
Ibrahim El-sayed
Dump
NaN
1'0"
3
2
0
1
/events/teams/?EventTeamId=ufjbughMPF5LZdHCKgk...
Texas A&M
14
IBRAHIM EL-SAYED
4.5
408
0
1
Adam Klaus
Defense (Handler)
NaN
5'7"
3
0
1
0
/events/teams/?EventTeamId=EhORNyjzxU93aWy8QY2...
Wisconsin
9
ADAM KLAUS
4.0
384
1
1
Charles McCutcheon
NaN
NaN
1'0"
1
0
3
1
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
CHARLES MCCUTCHEON
3.5
34
12
15
Derek Mourad
Dump
NaN
5'2"
2
2
2
6
/events/teams/?EventTeamId=IMHhriGUJ4QbfX6Z1FP...
Washington
8
DEREK MOURAD
3.0
31
9
12
Tomas Delgado
Dump
NaN
3'6"
2
2
0
2
/events/teams/?EventTeamId=IMHhriGUJ4QbfX6Z1FP...
Washington
8
TOMAS DELGADO
3.0
366
6
8
Andrew McCullough
Defense (Cutter/Handler)
NaN
10'11"
1
0
2
1
/events/teams/?EventTeamId=JMzzH4dfkmnlpZ%2f%2...
Oregon State
19
ANDREW MCCULLOUGH
2.5
279
3
3
Eli Miller
NaN
NaN
1'0"
0
2
1
2
/events/teams/?EventTeamId=SqpwCCNWFn9gvSxsvqc...
Carleton College
6
ELI MILLER
2.0
139
15
18
Grayson Sanner
NaN
NaN
5'7"
2
0
0
0
/events/teams/?EventTeamId=seHoSGs221Scx9In%2b...
North Carolina-Wilmington
11
GRAYSON SANNER
2.0
396
13
18
James Nguyen
Defense (Cutter)
NaN
1'0"
1
0
1
0
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
JAMES NGUYEN
2.0
195
22
44
Samuel Vetromile
Deep
NaN
2'7"
1
0
1
1
/events/teams/?EventTeamId=Rl4YCTbNv2d%2fXogKG...
Michigan
7
SAMUEL VETROMILE
1.5
39
17
23
Xiao Dong Liu
Dump
NaN
10'0"
1
0
1
1
/events/teams/?EventTeamId=IMHhriGUJ4QbfX6Z1FP...
Washington
8
XIAO DONG LIU
1.5
84
10
16
Sergio Licon
Defense (Cutter)
NaN
5'5"
1
0
0
0
/events/teams/?EventTeamId=7iY1anYTyh3FqR%2b%2...
Stanford
12
SERGIO LICON
1.0
202
0
0
Richard Bovio
Dump
NaN
1'0"
1
5
1
12
/events/teams/?EventTeamId=ufjbughMPF5LZdHCKgk...
Texas A&M
14
RICHARD BOVIO
1.0
245
24
55
Bryan Maloney
Defense (Cutter/Handler)
NaN
5'7"
0
1
1
2
/events/teams/?EventTeamId=oFkZia%2bkGcdHByxKp...
Connecticut
18
BRYAN MALONEY
1.0
402
19
28
Nick Heid
NaN
NaN
1'0"
0
2
0
2
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
NICK HEID
1.0
404
21
42
Thomas Bakko
Cutter
NaN
1'0"
1
0
0
1
/events/teams/?EventTeamId=hMNfe834GZl18XdqLhj...
Minnesota
4
THOMAS BAKKO
0.5
450
17
33
Ben Pettis
NaN
NaN
5'5"
1
0
0
1
/events/teams/?EventTeamId=V%2bpmNYSO38hv1afvp...
Oregon
5
BEN PETTIS
0.5
497
15
22
Ferry Akbar Buchanan
Dump
NaN
1'0"
0
0
1
1
/events/teams/?EventTeamId=JYU7quoPaafjS%2fZoM...
Virginia Tech
20
FERRY AKBAR BUCHANAN
0.5
46
0
0
Sunghoon Chung
Defense (Handler)
NaN
10'11"
0
0
0
0
/events/teams/?EventTeamId=gr79Z2m9X4ttLRdaiUT...
Cal Poly-SLO
17
SUNGHOON CHUNG
0.0
460
1
7
Victor Cheng
Handler
NaN
5'6"
0
0
0
0
/events/teams/?EventTeamId=JdRZxVMmx9KV9xrXZMA...
British Columbia
16
VICTOR CHENG
0.0
434
1
2
Kerry Athey
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=V%2bpmNYSO38hv1afvp...
Oregon
5
KERRY ATHEY
0.0
124
0
0
Alex Bleuzen
Handler
NaN
5'7"
0
0
0
0
/events/teams/?EventTeamId=seHoSGs221Scx9In%2b...
North Carolina-Wilmington
11
ALEX BLEUZEN
0.0
56
10
14
Dean Otsuka
Defense (Cutter)
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=gr79Z2m9X4ttLRdaiUT...
Cal Poly-SLO
17
DEAN OTSUKA
0.0
309
7
14
William Thompson
NaN
NaN
1'11"
0
0
0
0
/events/teams/?EventTeamId=cYUt2jw%2bpLMJzu5NU...
Auburn
15
WILLIAM THOMPSON
0.0
293
17
24
Noah Cohen
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=SqpwCCNWFn9gvSxsvqc...
Carleton College
6
NOAH COHEN
0.0
280
4
5
Liam Holloway-Bidwell
Dump
NaN
3'9"
0
0
0
0
/events/teams/?EventTeamId=SqpwCCNWFn9gvSxsvqc...
Carleton College
6
LIAM HOLLOWAY-BIDWELL
0.0
272
25
42
Alex (Evan) Grosskurth
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
ALEX (EVAN) GROSSKURTH
0.0
263
16
22
Jacob Zurbuch
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
JACOB ZURBUCH
0.0
253
6
7
Jesse Kovacs
NaN
NaN
5'7"
0
0
0
0
/events/teams/?EventTeamId=X65J%2b93TG6YfjNJ5z...
North Carolina
3
JESSE KOVACS
0.0
182
9
18
David Innis
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=Rl4YCTbNv2d%2fXogKG...
Michigan
7
DAVID INNIS
0.0
307
5
11
Jack Missildine
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=cYUt2jw%2bpLMJzu5NU...
Auburn
15
JACK MISSILDINE
0.0
317
15
25
Reid Williams
Handler
NaN
1'8"
0
0
0
1
/events/teams/?EventTeamId=cYUt2jw%2bpLMJzu5NU...
Auburn
15
REID WILLIAMS
-0.5
325
23
35
James Missildine
Dump
NaN
10'11"
1
1
0
6
/events/teams/?EventTeamId=cYUt2jw%2bpLMJzu5NU...
Auburn
15
JAMES MISSILDINE
-1.0
200
27
87
Josh Becker
Deep
NaN
5'7"
0
2
1
9
/events/teams/?EventTeamId=Rl4YCTbNv2d%2fXogKG...
Michigan
7
JOSH BECKER
-1.5
In [45]:
shorties = roster.loc[
roster.Name.isin(["Ben Sadok", "Mark Rauls", "Nathan Kwon",
"Lucas Chen", "Xander Cuizon Tice", "Anders Juengst",
"John Miller"])].sort_values("+/-", ascending=False)[[
"Name", "Height", "Goals", "Assists", "Ds", "Turns", "Team", "No."]].set_index("No.")
In [44]:
from usau.markdown import pandas_to_markdown
In [49]:
shorties.Goals.sum(), shorties.Assists.sum(), shorties.Ds.sum()
Out[49]:
(69, 52, 15)
In [48]:
print(pandas_to_markdown(shorties))
| Name | Height | Goals | Assists | Ds | Turns | Team |
| :----------------- | :----- | :---- | :------ | :- | :---- | :------------- |
| Ben Sadok | 5'5" | 14 | 30 | 2 | 11 | Massachusetts |
| Mark Rauls | 5'5" | 15 | 8 | 0 | 6 | Colorado |
| Nathan Kwon | 1'0" | 7 | 5 | 8 | 6 | North Carolina |
| Lucas Chen | 1'0" | 13 | 3 | 1 | 4 | Washington |
| Xander Cuizon Tice | nan | 6 | 2 | 3 | 2 | Oregon |
| Anders Juengst | 5'7" | 10 | 2 | 0 | 6 | North Carolina |
| John Miller | 5'6" | 4 | 2 | 1 | 0 | Colorado State |
In [ ]:
Ben Sadok
Mark Rauls
Nathan Kwon
Lucas Chen
Xander Cuizon Tice / Brendon Petraues
Anders Jeungst
Content source: azjps/usau-py
Similar notebooks: