In [1]:
import sys
sys.path.append("/apps/stonefs1/azhu/libs/usau_fantasy/")
In [2]:
import urllib
from bs4 import BeautifulSoup
url = "https://www.reddit.com/r/ultimate/comments/4l74rn/fantasy_lineup_di_college_nationals_2016/"
soup = urllib.urlopen(url).read().decode('utf-8')
In [41]:
import re
with open("/apps/stonefs1/azhu/libs/usau_fantasy/fantasy_input.txt") as fd:
text = fd.read().replace("[\xe2\x80\x93]", "__START_USER__").replace("permalinkembedsavereportgive goldreply", "")
text = re.sub(r"__START_USER__([0-9a-zA-z_]+) .*", "\"\g<1>\": {", text)
lines = []
for line in text.split("\n"):
if line.strip() == "":
continue
if line.startswith("Men") or line.startswith("Women"):
gender = line.split(":", 1)[0].split("'", 1)[0]
assert gender in ('Men', 'Women')
roster = line.split(":", 1)[1].split(",")
# if len(roster) != 7:
# print "Missing player:", roster
lines.append(" \"" + gender + "\": [\"" + "\", \"".join([r.strip() for r in roster]) + "\"],")
elif line.startswith('"'):
lines.append(" },")
lines.append(line)
print "\n".join(lines)
},
"scottyskin96": {
"Men": ["Dalton Smith", "John Stubbs*", "Xavier Maxstadt", "Ben Jagt", "Joe Marmerstien", "Khalif", "Trent Dillon"],
"Women": ["Shof*", "Kaylor", "Wahlroos", "Marisa Rafter", "Claire revere", "Mira Donaldson", "Han Chen"],
},
"chubs45": {
"Men": ["Ben Jagt*", "Jack Williams", "John Stubbs", "Connor Kline", "Max Thorne", "Dalton Smith", "Jeff Babbitt"],
"Women": ["Jesse Shofner*", "Marisa Rafter", "Han Chen", "Mira Donaldson", "Janina Freystatter", "Jacyln Verzuh", "Kirstin Johnson"],
},
"duthracht": {
"Men": ["John Stubbs", "Aaron Speiss", "Khalif El-Salaam", "Dalton Smith", "Ben Jagt", "Xavier Maxstadt*"],
"Women": ["Marisa Rafter", "Jesse Shofner*", "Han Chen", "Mira Donaldson", "Kristin Pojunis", "Jenina Freystaeter", "Angela Zhu"],
},
"giftedbadly": {
"Men": ["Dalton Smith*", "Tannor Johnson", "Trent Dillon", "Pat Earles", "Jack Williams", "John Stubbs", "Jeff Babbitt"],
"Women": ["Mira Donaldson*", "Jesse Shofner", "Janina Freystatter", "Claire Revere", "Marisa Rafter", "Angela Zhu", "Kristen Pojunis"],
},
"krdonnie": {
"Men": ["John Stubbs", "Pat Earles", "Mark Vandenberg*", "Sam Little", "Dalton Smith", "Connor Holcombe", "Ben Jagt"],
"Women": ["Carolyn Normile", "Shayna Brock", "Jesse Shofner*", "Mira Donaldson", "Han Chen", "Chloe Rowse", "Janina Freystaetter"],
},
"Ultimatezach": {
"Men": ["Dalton Smith*", "Ben Jagt", "Xavier Maxstadt", "Khalif El-Salaam", "Trent Dillon", "John Stubbs", "Tannor Johnson"],
"Women": ["Jesse Shofner*", "Mira Donaldson", "Marisa Rafter", "Kristin Pojunis", "Janina Freystaetter", "Kirstin Johnson", "Bethany Kaylor"],
},
"dlquinonesII": {
"Men": ["Ben Jagt", "John Stubbs", "Dalton Smith*", "Conor Kline", "Xavier Maxstadt", "Khalif El-Salaam", "Trent Dillon"],
"Women": ["Mira Donaldson", "Janina Freystaetter", "Shayna Brock", "Claire Revere", "Jesse Shofner*", "Han Chen", "Carolyn Normile"],
},
"ultimatefrisbee": {
"Men": ["Dalton Smith", "Xavier Maxstadt", "Ben Jagt", "Khalif El-Salaam*", "Mark Vandenburg", "John Stubbs", "Ryan Landry"],
"Women": ["Mira Donaldson*", "Olivia Bartruff", "Jesse Shofner", "Monisha White", "Jaclyn Verzuh", "Claire Revere", "Kristen Pojunis"],
},
"livetweetyourgames": {
"Men": ["Tanner Johnson*", "Conor Kline", "Connor Matthews", "Connor Holcombe", "Max Thorne", "Ben Jagt", "Dalton Smith"],
"Women": ["Janina Freystaetter*", "Shayna Brock", "Mira Donaldson", "Kate Scarth", "Olivia Bartruff", "Jesse Shofner", "Courtney Gegg"],
},
"anti_spiral": {
"Men": ["Dalton Smith*", "Pat Earles", "Tanner Johnson", "Connor Matthews", "Jack Williams", "Jeff Babbitt", "John Stubbs"],
"Women": ["Kate Scarth", "Bethany Kaylor", "Courtney Gegg*", "Hayley Wahlroos", "Abbie Abramovich", "Mira Donaldson", "Alexa Wood"],
},
"grhgra002": {
"Men": ["Dalton Smith*", "John Stubbs", "Mark Vandenburg", "Xavier Maxstadt", "Ben Jagt", "Khalif El-Salaam", "Connor Matthews"],
"Women": ["Jesse Shofner*", "Marisa Rafter", "Mira Donaldson", "Han Chen", "Kristin Pojunis", "Courtney Gegg", "Claire Revere"],
},
"samth": {
"Women": ["Shofner*", "Taylor", "Verzuh", "Donaldson", "Wahlroos", "Brock", "Freystatter"],
"Men": ["Dillon", "Maxstadt", "Kline", "Babbit*", "Sadok", "Jagt", "Stubbs"],
},
"almondchipcookies": {
"Men": ["Jeff Babbit*", "Connor Matthews", "Adam Rees", "Ryan Osgar", "Pat Earles", "Dalton Smith", "John Stubbs"],
"Women": ["Beth Kaylor*", "Jesse Shofner", "Mira Donaldson", "Monisha White", "Shayna Brock", "Han Chen", "Angela Zhu"],
},
"azjps": {
"Men": ["Jeffrey Babbitt*", "Ryan Osgar", "Connor Matthews", "Dalton Smith", "Conor Kline", "Jack Williams", "Mark Vandenburg"],
"Women": ["Kate Scarth*", "Angela Zhu", "Bethany Kaylor", "Stephanie Williams", "Jesse Shofner", "Courtney Gegg", "Olivia Bartruff"],
In [43]:
fantasy_input = {
"scottyskin96": {
"Men": ["Dalton Smith", "John Stubbs*", "Xavier Maxstadt", "Ben Jagt", "Joe Marmerstien", "Khalif", "Trent Dillon"],
"Women": ["Shof*", "Kaylor", "Wahlroos", "Marisa Rafter", "Claire revere", "Mira Donaldson", "Han Chen"],
},
"chubs45": {
"Men": ["Ben Jagt*", "Jack Williams", "John Stubbs", "Connor Kline", "Max Thorne", "Dalton Smith", "Jeff Babbitt"],
"Women": ["Jesse Shofner*", "Marisa Rafter", "Han Chen", "Mira Donaldson", "Janina Freystatter", "Jacyln Verzuh", "Kirstin Johnson"],
},
"duthracht": {
"Men": ["John Stubbs", "Aaron Speiss", "Khalif El-Salaam", "Dalton Smith", "Ben Jagt", "Xavier Maxstadt*", "Jack Williams"],
"Women": ["Marisa Rafter", "Jesse Shofner*", "Han Chen", "Mira Donaldson", "Kristin Pojunis", "Jenina Freystaeter", "Angela Zhu"],
},
"giftedbadly": {
"Men": ["Dalton Smith*", "Tannor Johnson", "Trent Dillon", "Pat Earles", "Jack Williams", "John Stubbs", "Jeff Babbitt"],
"Women": ["Mira Donaldson*", "Jesse Shofner", "Janina Freystatter", "Claire Revere", "Marisa Rafter", "Angela Zhu", "Kristen Pojunis"],
},
"krdonnie": {
"Men": ["John Stubbs", "Pat Earles", "Mark Vandenberg*", "Sam Little", "Dalton Smith", "Connor Holcombe", "Ben Jagt"],
"Women": ["Carolyn Normile", "Shayna Brock", "Jesse Shofner*", "Mira Donaldson", "Han Chen", "Chloe Rowse", "Janina Freystaetter"],
},
"Ultimatezach": {
"Men": ["Dalton Smith*", "Ben Jagt", "Xavier Maxstadt", "Khalif El-Salaam", "Trent Dillon", "John Stubbs", "Tannor Johnson"],
"Women": ["Jesse Shofner*", "Mira Donaldson", "Marisa Rafter", "Kristin Pojunis", "Janina Freystaetter", "Kirstin Johnson", "Bethany Kaylor"],
},
"dlquinonesII": {
"Men": ["Ben Jagt", "John Stubbs", "Dalton Smith*", "Conor Kline", "Xavier Maxstadt", "Khalif El-Salaam", "Trent Dillon"],
"Women": ["Mira Donaldson", "Janina Freystaetter", "Shayna Brock", "Claire Revere", "Jesse Shofner*", "Han Chen", "Carolyn Normile"],
},
"ultimatefrisbee": {
"Men": ["Dalton Smith", "Xavier Maxstadt", "Ben Jagt", "Khalif El-Salaam*", "Mark Vandenburg", "John Stubbs", "Ryan Landry"],
"Women": ["Mira Donaldson*", "Olivia Bartruff", "Jesse Shofner", "Monisha White", "Jaclyn Verzuh", "Claire Revere", "Kristen Pojunis"],
},
"livetweetyourgames": {
"Men": ["Tanner Johnson*", "Conor Kline", "Connor Matthews", "Connor Holcombe", "Max Thorne", "Ben Jagt", "Dalton Smith"],
"Women": ["Janina Freystaetter*", "Shayna Brock", "Mira Donaldson", "Kate Scarth", "Olivia Bartruff", "Jesse Shofner", "Courtney Gegg"],
},
"anti_spiral": {
"Men": ["Dalton Smith*", "Pat Earles", "Tanner Johnson", "Connor Matthews", "Jack Williams", "Jeff Babbitt", "John Stubbs"],
"Women": ["Kate Scarth", "Bethany Kaylor", "Courtney Gegg*", "Hayley Wahlroos", "Abbie Abramovich", "Mira Donaldson", "Alexa Wood"],
},
"grhgra002": {
"Men": ["Dalton Smith*", "John Stubbs", "Mark Vandenburg", "Xavier Maxstadt", "Ben Jagt", "Khalif El-Salaam", "Connor Matthews"],
"Women": ["Jesse Shofner*", "Marisa Rafter", "Mira Donaldson", "Han Chen", "Kristin Pojunis", "Courtney Gegg", "Claire Revere"],
},
"samth": {
"Women": ["Shofner*", "Taylor", "Verzuh", "Donaldson", "Wahlroos", "Brock", "Freystatter"],
"Men": ["Dillon", "Maxstadt", "Kline", "Babbit*", "Sadok", "Jagt", "Stubbs"],
},
"almondchipcookies": {
"Men": ["Jeff Babbit*", "Connor Matthews", "Adam Rees", "Ryan Osgar", "Pat Earles", "Dalton Smith", "John Stubbs"],
"Women": ["Beth Kaylor*", "Jesse Shofner", "Mira Donaldson", "Monisha White", "Shayna Brock", "Han Chen", "Angela Zhu"],
},
"azjps": {
"Men": ["Jeffrey Babbitt*", "Ryan Osgar", "Connor Matthews", "Dalton Smith", "Conor Kline", "Jack Williams", "Mark Vandenburg"],
"Women": ["Kate Scarth*", "Angela Zhu", "Bethany Kaylor", "Stephanie Williams", "Jesse Shofner", "Courtney Gegg", "Olivia Bartruff"],
}
}
In [78]:
import pandas as pd
pd.options.display.width = 1000
pd.options.display.max_columns = 100
pd.options.display.max_colwidth = 500
import usau_results as usau
import usau_fantasy as fantasy
import markdown
reload(fantasy)
Out[78]:
<module 'usau_fantasy' from '/apps/stonefs1/azhu/libs/usau_fantasy/usau_fantasy.py'>
In [79]:
fantasy.print_d1_fantasy_results()
Name
Fantasy Score
10
Xander Cuizon Tice
6.8
22
Marvin Waldvogel
4.2
0
Aaron Warshauer
8.8
10
Elijah Long
6.0
16
Matt Gouchoe-Hanas
7.0
1
Joseph Marmerstein
5.0
16
Jacob Lunn
4.6
9
Benjamin Scharfstein
4.4
11
John Stubbs
5.6
16
Mark Vandenberg
5.6
3
Michael Rice
4.4
17
John Wodatch
5.4
2
Solomon Yanuck
5.2
4
Alex Olson
4.6
20
Jake Ritmire
4.2
2
Patrick Earles
5.4
6
Max Thorne
5.2
11
Trent Dillon
4.4
15
Michael Affleck
4.2
20
Joshua Zdrodowski
4.2
No.
Name
Fantasy Score
Position
Height
Goals
Assists
Ds
Turns
Team
Seed
Fantasy Picks
0
0
Aaron Warshauer
8.8
Deep
6'3"
4
4
3
1
North Carolina
7
0
16
21
Matt Gouchoe-Hanas
7.0
NaN
NaN
2
4
3
2
North Carolina
7
0
10
23
Xander Cuizon Tice
6.8
NaN
NaN
4
2
2
2
Oregon
2
0
10
12
Elijah Long
6.0
NaN
5'11"
3
3
0
0
North Carolina
7
0
11
14
John Stubbs
5.6
NaN
6'0"
2
3
2
1
Harvard
10
13
16
23
Mark Vandenberg
5.6
Handler
6'1"
1
4
1
2
Harvard
10
5
17
31
John Wodatch
5.4
Deep
6'1"
2
3
0
2
Connecticut
19
0
2
3
Patrick Earles
5.4
Handler/Cutter
6'2"
3
2
0
2
Pittsburgh
5
4
6
10
Max Thorne
5.2
Mid
5'7"
3
2
0
1
Pittsburgh
5
2
2
2
Solomon Yanuck
5.2
NaN
5'11"
1
3
3
3
Carleton College
9
0
1
3
Joseph Marmerstein
5.0
NaN
1'0"
0
3
1
9
Case Western Reserve
18
1
16
33
Jacob Lunn
4.6
NaN
NaN
2
2
0
3
Case Western Reserve
18
0
4
6
Alex Olson
4.6
Handler
5'11"
0
4
0
3
Carleton College
9
0
3
3
Michael Rice
4.4
Mid
5'11"
3
1
2
0
Connecticut
19
0
9
12
Benjamin Scharfstein
4.4
NaN
5'10"
2
2
0
2
Harvard
10
0
11
16
Trent Dillon
4.4
Defense (Cutter/Handler)
5'11"
2
2
1
1
Pittsburgh
5
5
15
21
Michael Affleck
4.2
Handler
6'2"
0
3
0
6
Utah
20
0
20
66
Joshua Zdrodowski
4.2
Deep
10'11"
2
1
1
5
Utah
20
0
20
55
Jake Ritmire
4.2
Handler
6'1"
1
3
0
1
Carleton College
9
0
22
75
Marvin Waldvogel
4.2
NaN
'"
2
2
0
1
Oregon
2
0
21
83
Ryan Landry
4.0
NaN
NaN
1
3
0
0
Auburn
16
1
17
55
Connor Matthews
3.2
NaN
6'0"
0
3
0
1
Oregon
2
5
11
24
Adam Rees
2.6
NaN
NaN
0
2
3
0
Oregon
2
1
18
27
Connor Holcombe
0.0
NaN
NaN
0
0
0
0
Florida State
14
2
2
3
Khalif El-Salaam
0.0
Defense (Cutter)
NaN
0
0
0
0
Washington
13
7
5
13
Dalton Smith
0.0
Defense (Handler)
5'10"
0
0
0
0
Texas A&M
12
18
5
9
Samuel Little
0.0
NaN
NaN
0
0
0
0
Georgia
8
1
13
22
Aaron Speiss
0.0
Deep
5'10"
0
0
0
0
Wisconsin
6
1
1
1
Ryan Osgar
0.0
Deep
6'1"
0
0
0
0
Minnesota
4
2
4
4
Ben Jagt
0.0
Defense (Cutter)
6'4"
0
0
0
0
Minnesota
4
11
6
11
Jack Williams
0.0
NaN
NaN
0
0
0
0
North Carolina-Wilmington
3
5
19
80
Xavier Maxstadt
0.0
NaN
NaN
0
0
0
0
North Carolina-Wilmington
3
8
1
3
Ben Sadok
0.0
Deep
5'5"
0
0
0
0
Massachusetts
1
1
6
11
Conor Kline
0.0
Deep
NaN
0
0
0
0
Massachusetts
1
5
8
15
Tannor Johnson
0.0
Deep
6'3"
0
0
0
0
Massachusetts
1
5
21
87
Jeffrey Babbitt
0.0
Deep
6'2"
0
0
0
0
Massachusetts
1
9
Name
Fantasy Score
21
Abbie Abramovich
5.6
4
Piper Curtis
4.0
6
Angela Zhu
8.4
12
Jaclyn Verzuh
7.0
17
Han Chen
7.4
0
Julia Zhang
4.4
3
Kate Scarth
4.4
10
Mira Donaldson
4.8
6
Sydney Overman
4.2
9
Susan Gilbert
5.4
16
Shiru Liu
4.0
4
Arianne Lozano
4.6
7
Marlena Sloss
4.4
9
Alex Hardesty
8.0
16
Claire Revere
5.4
3
Lorraine Guerin
5.0
10
Anna Hrovat-Staedter
5.8
14
Anneke Vermaak
6.2
3
Maude Carrier-Laforte
7.8
13
Isabelle Bedard
7.2
No.
Name
Fantasy Score
Position
Height
Goals
Assists
Ds
Turns
Team
Seed
Fantasy Picks
6
8
Angela Zhu
8.4
NaN
1'0"
0
6
2
10
Dartmouth
18
4
9
15
Alex Hardesty
8.0
NaN
NaN
3
4
1
4
Whitman
5
0
3
7
Maude Carrier-Laforte
7.8
NaN
NaN
2
5
0
4
Ottawa
20
0
17
25
Han Chen
7.4
Handler/Cutter
1'0"
2
3
4
8
UCLA
7
7
13
44
Isabelle Bedard
7.2
NaN
NaN
1
5
0
6
Ottawa
20
0
12
21
Jaclyn Verzuh
7.0
Defense (Cutter)
6'0"
4
2
1
4
Dartmouth
18
3
14
21
Anneke Vermaak
6.2
Handler
5'8"
1
4
0
6
Wisconsin
16
0
10
14
Anna Hrovat-Staedter
5.8
NaN
5'6"
1
3
3
6
Wisconsin
16
0
21
44
Abbie Abramovich
5.6
NaN
NaN
2
3
1
2
Chaos (Independent)
14
1
9
20
Susan Gilbert
5.4
NaN
NaN
3
2
2
0
Texas
9
0
16
28
Claire Revere
5.4
NaN
5'5"
0
5
2
0
Whitman
5
5
3
4
Lorraine Guerin
5.0
NaN
5'8"
2
2
4
1
Wisconsin
16
0
10
19
Mira Donaldson
4.8
Cutter
NaN
0
3
1
8
British Columbia
2
15
4
7
Arianne Lozano
4.6
Defense (Cutter/Handler)
5'6"
1
2
3
5
Whitman
5
0
7
11
Marlena Sloss
4.4
NaN
NaN
4
0
0
2
Whitman
5
0
0
4
Julia Zhang
4.4
NaN
NaN
1
3
1
1
British Columbia
2
0
3
8
Kate Scarth
4.4
NaN
1'0"
2
2
0
2
British Columbia
2
4
6
15
Sydney Overman
4.2
NaN
NaN
3
1
0
1
Texas
9
0
4
6
Piper Curtis
4.0
NaN
NaN
1
2
1
4
Dartmouth
18
0
16
89
Shiru Liu
4.0
NaN
NaN
1
2
1
4
Texas
9
0
3
4
Kristen Pojunis
4.0
Handler/Cutter
5'7"
2
1
0
5
UCLA
7
5
2
6
Chloe Rowse
0.0
NaN
NaN
0
0
0
0
Colorado College
17
1
19
27
Taylor Srebnick
0.0
NaN
NaN
0
0
0
0
Wisconsin
16
1
1
2
Marisa Rafter
0.0
NaN
NaN
0
0
0
0
California
12
6
18
36
Carolyn Normile
0.0
Handler
5'3"
0
0
0
0
Pittsburgh
11
2
5
9
Kirstin Johnson
0.0
NaN
5'4"
0
0
0
0
Colorado
8
2
1
6
Alexa Wood
0.0
NaN
NaN
0
0
0
0
Central Florida
4
1
3
8
Shayna Brock
0.0
NaN
NaN
0
0
0
0
Central Florida
4
5
5
11
Janina Freystaetter
0.0
Defense (Cutter)
5'9"
0
0
0
0
Central Florida
4
9
10
66
Stephanie Williams
0.0
NaN
3'8"
0
0
0
0
Central Florida
4
1
8
14
Monisha White
0.0
Handler
NaN
0
0
0
0
Stanford
3
2
12
23
Courtney Gegg
0.0
Cutter
6'0"
0
0
0
0
Stanford
3
5
1
2
Jesse Shofner
0.0
NaN
NaN
0
0
0
0
Oregon
1
21
7
9
Olivia Bartruff
0.0
NaN
NaN
0
0
0
0
Oregon
1
3
8
11
Bethany Kaylor
0.0
NaN
1'0"
0
0
0
0
Oregon
1
6
17
27
Hayley Wahlroos
0.0
NaN
NaN
0
0
0
0
Oregon
1
3
User
Total
Men's
Women's
6
giftedbadly
42.8
15.4
27.4
12
ultimatefrisbee
41.2
15.2
26.0
11
scottyskin96
38.2
20.6
17.6
0
almondchipcookies
37.4
16.8
20.6
7
grhgra002
36.0
14.4
21.6
8
krdonnie
34.4
22.2
12.2
5
duthracht
30.2
5.6
24.6
3
chubs45
30.0
10.8
19.2
1
anti_spiral
29.0
14.2
14.8
4
dlquinonesII
27.6
10.0
17.6
2
azjps
26.0
8.8
17.2
10
samth
21.8
10.0
11.8
13
Ultimatezach
18.8
10.0
8.8
9
livetweetyourgames
17.6
8.4
9.2
Out[79]:
User
Total
Men's
Women's
6
giftedbadly
42.8
15.4
27.4
12
ultimatefrisbee
41.2
15.2
26.0
11
scottyskin96
38.2
20.6
17.6
0
almondchipcookies
37.4
16.8
20.6
7
grhgra002
36.0
14.4
21.6
8
krdonnie
34.4
22.2
12.2
5
duthracht
30.2
5.6
24.6
3
chubs45
30.0
10.8
19.2
1
anti_spiral
29.0
14.2
14.8
4
dlquinonesII
27.6
10.0
17.6
2
azjps
26.0
8.8
17.2
10
samth
21.8
10.0
11.8
13
Ultimatezach
18.8
10.0
8.8
9
livetweetyourgames
17.6
8.4
9.2
In [44]:
mens, womens, users = fantasy.compute_d1_fantasy_results()
Automatic pdb calling has been turned ON
In [49]:
print markdown.pandas_to_markdown(mens[mens["Fantasy Total"] > 0].set_index("No.") \
[["Name", "Fantasy Total", "Position", "Height", "Team", "Seed"] + users] \
.sort(["Fantasy Total", "Seed"], ascending=False))
| Name | Fantasy Total | Position | Height | Team | Seed | almondchipcookies | anti_spiral | azjps | chubs45 | dlquinonesII | duthracht | giftedbadly | grhgra002 | krdonnie | livetweetyourgames | samth | scottyskin96 | ultimatefrisbee | Ultimatezach |
| :----------------- | :------------ | :----------------------- | :----- | :------------------------ | :--- | :---------------- | :---------- | :---- | :------ | :----------- | :-------- | :---------- | :-------- | :------- | :----------------- | :---- | :----------- | :-------------- | :----------- |
| Dalton Smith | 18 | Defense (Handler) | 5'10" | Texas A&M | 12 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 2 | 1 | 1 | 0 | 1 | 1 | 2 |
| John Stubbs | 13 | nan | 6'0" | Harvard | 10 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 1 | 2 | 1 | 1 |
| Ben Jagt | 11 | Defense (Cutter) | 6'4" | Minnesota | 4 | 0 | 0 | 0 | 2 | 1 | 1 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| Jeffrey Babbitt | 9 | Deep | 6'2" | Massachusetts | 1 | 2 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 2 | 0 | 0 | 0 |
| Xavier Maxstadt | 8 | nan | nan | North Carolina-Wilmington | 3 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 1 | 0 | 0 | 1 | 1 | 1 | 1 |
| Khalif El-Salaam | 7 | Defense (Cutter) | nan | Washington | 13 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 2 | 1 |
| Mark Vandenberg | 5 | Handler | 6'1" | Harvard | 10 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 2 | 0 | 0 | 0 | 1 | 0 |
| Trent Dillon | 5 | Defense (Cutter/Handler) | 5'11" | Pittsburgh | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0 | 1 |
| Jack Williams | 5 | nan | nan | North Carolina-Wilmington | 3 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Connor Matthews | 5 | nan | 6'0" | Oregon | 2 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
| Conor Kline | 5 | Deep | nan | Massachusetts | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 |
| Tannor Johnson | 5 | Deep | 6'3" | Massachusetts | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 1 |
| Patrick Earles | 4 | Handler/Cutter | 6'2" | Pittsburgh | 5 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Connor Holcombe | 2 | nan | nan | Florida State | 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 |
| Max Thorne | 2 | Mid | 5'7" | Pittsburgh | 5 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| Ryan Osgar | 2 | Deep | 6'1" | Minnesota | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Joseph Marmerstein | 1 | nan | 1'0" | Case Western Reserve | 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |
| Ryan Landry | 1 | nan | nan | Auburn | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| Samuel Little | 1 | nan | nan | Georgia | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Aaron Speiss | 1 | Deep | 5'10" | Wisconsin | 6 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Adam Rees | 1 | nan | nan | Oregon | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Ben Sadok | 1 | Deep | 5'5" | Massachusetts | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
In [57]:
womens["argsort"] = womens["Fantasy Total"].argsort()
In [59]:
womens.iloc[womens["argsort"][::-1]]
Out[59]:
No.
Name
Position
Year
Height
Goals
Assists
Ds
Turns
url
Team
Seed
UpperName
grhgra002
anti_spiral
duthracht
azjps
ultimatefrisbee
Ultimatezach
krdonnie
samth
giftedbadly
almondchipcookies
chubs45
livetweetyourgames
dlquinonesII
scottyskin96
Fantasy Total
argsort
1
2
Jesse Shofner
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=%2fLGdnvAi%2bq1Wzmdd1TxP6fwGc62QmnID%2bYQeKfpK0W4%3d
Oregon
1
JESSE SHOFNER
2
0
2
1
1
2
2
2
1
1
2
1
2
2
21
275
10
19
Mira Donaldson
Cutter
NaN
NaN
0
3
1
8
/events/teams/?EventTeamId=OTGwhNFaylnX0EPHt68VhC3MfWvO%2bMbimx406sg6FfA%3d
British Columbia
2
MIRA DONALDSON
1
1
1
0
2
1
1
1
2
1
1
1
1
1
15
74
5
11
Janina Freystaetter
Defense (Cutter)
NaN
5'9"
0
0
0
0
/events/teams/?EventTeamId=6f1Cyu6unOe0y0g9PjR0%2fKaB4r8%2fEpu9yWeBvHpmDuI%3d
Central Florida
4
JANINA FREYSTAETTER
0
0
1
0
0
1
1
1
1
0
1
2
1
0
9
147
17
25
Han Chen
Handler/Cutter
NaN
1'0"
2
3
4
8
/events/teams/?EventTeamId=BZu0EY31Su799QuYK2aOHjWaN7wXD5w3nuIzdBautMI%3d
UCLA
7
HAN CHEN
1
0
1
0
0
0
1
0
0
1
1
0
1
1
7
309
8
11
Bethany Kaylor
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=%2fLGdnvAi%2bq1Wzmdd1TxP6fwGc62QmnID%2bYQeKfpK0W4%3d
Oregon
1
BETHANY KAYLOR
0
1
0
1
0
1
0
0
0
2
0
0
0
1
6
267
1
2
Marisa Rafter
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=Bheh95Yv%2bllNr05UGTY4NS5jV5S4YuTAHK9FIa3ZoII%3d
California
12
MARISA RAFTER
1
0
1
0
0
1
0
0
1
0
1
0
0
1
6
206
3
8
Shayna Brock
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=6f1Cyu6unOe0y0g9PjR0%2fKaB4r8%2fEpu9yWeBvHpmDuI%3d
Central Florida
4
SHAYNA BROCK
0
0
0
0
0
0
1
1
0
1
0
1
1
0
5
148
3
4
Kristen Pojunis
Handler/Cutter
NaN
5'7"
2
1
0
5
/events/teams/?EventTeamId=BZu0EY31Su799QuYK2aOHjWaN7wXD5w3nuIzdBautMI%3d
UCLA
7
KRISTEN POJUNIS
1
0
1
0
1
1
0
0
1
0
0
0
0
0
5
327
16
28
Claire Revere
NaN
NaN
5'5"
0
5
2
0
/events/teams/?EventTeamId=tbhpUZDr7cHDEPhRnsRwx0K2D94WYRkIRq1oCIlQ7cY%3d
Whitman
5
CLAIRE REVERE
1
0
0
0
1
0
0
0
1
0
0
0
1
1
5
175
12
23
Courtney Gegg
Cutter
NaN
6'0"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
COURTNEY GEGG
1
2
0
1
0
0
0
0
0
0
0
1
0
0
5
13
3
8
Kate Scarth
NaN
NaN
1'0"
2
2
0
2
/events/teams/?EventTeamId=OTGwhNFaylnX0EPHt68VhC3MfWvO%2bMbimx406sg6FfA%3d
British Columbia
2
KATE SCARTH
0
1
0
2
0
0
0
0
0
0
0
1
0
0
4
335
6
8
Angela Zhu
NaN
NaN
1'0"
0
6
2
10
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
ANGELA ZHU
0
0
1
1
0
0
0
0
1
1
0
0
0
0
4
395
17
27
Hayley Wahlroos
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=%2fLGdnvAi%2bq1Wzmdd1TxP6fwGc62QmnID%2bYQeKfpK0W4%3d
Oregon
1
HAYLEY WAHLROOS
0
1
0
0
0
0
0
1
0
0
0
0
0
1
3
257
12
21
Jaclyn Verzuh
Defense (Cutter)
NaN
6'0"
4
2
1
4
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
JACLYN VERZUH
0
0
0
0
1
0
0
1
0
0
1
0
0
0
3
388
7
9
Olivia Bartruff
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=%2fLGdnvAi%2bq1Wzmdd1TxP6fwGc62QmnID%2bYQeKfpK0W4%3d
Oregon
1
OLIVIA BARTRUFF
0
0
0
1
1
0
0
0
0
0
0
1
0
0
3
268
5
9
Kirstin Johnson
NaN
NaN
5'4"
0
0
0
0
/events/teams/?EventTeamId=Z0N2cCqUDZWmdbYpTuSamK6C221K8ZKpuUZnGogZx0k%3d
Colorado
8
KIRSTIN JOHNSON
0
0
0
0
0
1
0
0
0
0
1
0
0
0
2
232
18
36
Carolyn Normile
Handler
NaN
5'3"
0
0
0
0
/events/teams/?EventTeamId=PflArUV43ljCKXtMCQecWpD0Xp3smr1BiegyGv%2boEIs%3d
Pittsburgh
11
CAROLYN NORMILE
0
0
0
0
0
0
1
0
0
0
0
0
1
0
2
341
8
14
Monisha White
Handler
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
MONISHA WHITE
0
0
0
0
1
0
0
0
0
1
0
0
0
0
2
5
10
66
Stephanie Williams
NaN
NaN
3'8"
0
0
0
0
/events/teams/?EventTeamId=6f1Cyu6unOe0y0g9PjR0%2fKaB4r8%2fEpu9yWeBvHpmDuI%3d
Central Florida
4
STEPHANIE WILLIAMS
0
0
0
1
0
0
0
0
0
0
0
0
0
0
1
194
1
6
Alexa Wood
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=6f1Cyu6unOe0y0g9PjR0%2fKaB4r8%2fEpu9yWeBvHpmDuI%3d
Central Florida
4
ALEXA WOOD
0
1
0
0
0
0
0
0
0
0
0
0
0
0
1
150
21
44
Abbie Abramovich
NaN
NaN
NaN
2
3
1
2
/events/teams/?EventTeamId=3KAG6vC1HVnNN3OBmBubT2%2b6kpVw9ry6wWIx9%2f%2bnqAM%3d
Chaos (Independent)
14
ABBIE ABRAMOVICH
0
1
0
0
0
0
0
0
0
0
0
0
0
0
1
404
19
27
Taylor Srebnick
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=h%2blBhk2ZPM4qTSZex7jcvPLgrhjSUSjp77TB91L998s%3d
Wisconsin
16
TAYLOR SREBNICK
0
0
0
0
0
0
0
1
0
0
0
0
0
0
1
317
2
6
Chloe Rowse
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=O4sOJojXa44zsMclVSyhk3Lot5xkbeQUs5bvmSTl6Sw%3d
Colorado College
17
CHLOE ROWSE
0
0
0
0
0
0
1
0
0
0
0
0
0
0
1
280
22
71
Kelsea Kilbride
NaN
NaN
NaN
0
0
0
1
/events/teams/?EventTeamId=3KAG6vC1HVnNN3OBmBubT2%2b6kpVw9ry6wWIx9%2f%2bnqAM%3d
Chaos (Independent)
14
KELSEA KILBRIDE
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
403
11
17
Magdalene Pizzo
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
MAGDALENE PIZZO
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
390
23
81
Tian Qing Yen
NaN
NaN
1'0"
0
1
0
5
/events/teams/?EventTeamId=3KAG6vC1HVnNN3OBmBubT2%2b6kpVw9ry6wWIx9%2f%2bnqAM%3d
Chaos (Independent)
14
TIAN QING YEN
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
402
0
1
Sophia Siu
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
SOPHIA SIU
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
401
8
12
Erica Ng
NaN
NaN
NaN
0
0
1
0
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
ERICA NG
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
393
1
2
Sarah Heyborne
NaN
NaN
NaN
0
0
1
0
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
SARAH HEYBORNE
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
400
2
3
Carolyn Susman
NaN
NaN
NaN
0
0
1
0
/events/teams/?EventTeamId=A7uEPG7zo7KUF1twrR1W3vTxvcg4dhL8EnZHVyx0JBM%3d
Dartmouth
18
CAROLYN SUSMAN
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
399
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
4
10
Kelly Ross
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=vZGzXeNrDAH4Frklq81Ku8NDt1Cb7esY8wxSvlfI%2bRQ%3d
Ohio State
15
KELLY ROSS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
97
5
11
Sadie Jezierski
Mid
NaN
5'5"
0
0
0
0
/events/teams/?EventTeamId=vZGzXeNrDAH4Frklq81Ku8NDt1Cb7esY8wxSvlfI%2bRQ%3d
Ohio State
15
SADIE JEZIERSKI
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
105
6
12
Katie Backus
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=vZGzXeNrDAH4Frklq81Ku8NDt1Cb7esY8wxSvlfI%2bRQ%3d
Ohio State
15
KATIE BACKUS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
170
7
14
Emily Steedman
NaN
NaN
1'0"
0
0
0
0
/events/teams/?EventTeamId=vZGzXeNrDAH4Frklq81Ku8NDt1Cb7esY8wxSvlfI%2bRQ%3d
Ohio State
15
EMILY STEEDMAN
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
169
3
11
Christie Yeh
NaN
NaN
5'6"
0
0
0
0
/events/teams/?EventTeamId=gpa%2fJfx4F9MuJIHKjI1iekIOztp85JPxG%2biSL7di%2bKs%3d
Southern California
19
CHRISTIE YEH
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
44
1
8
Becklin Davis
NaN
NaN
5'3"
0
0
0
0
/events/teams/?EventTeamId=gpa%2fJfx4F9MuJIHKjI1iekIOztp85JPxG%2biSL7di%2bKs%3d
Southern California
19
BECKLIN DAVIS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
47
17
37
Hannah Henkin
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=uRWg%2bj12%2fx969pEhWRbVgsFmvh6WsK4v8YfMujtshgw%3d
Michigan
10
HANNAH HENKIN
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
22
0
5
Rachel Chang
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=gpa%2fJfx4F9MuJIHKjI1iekIOztp85JPxG%2biSL7di%2bKs%3d
Southern California
19
RACHEL CHANG
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
48
18
44
Grace Denney
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=uRWg%2bj12%2fx969pEhWRbVgsFmvh6WsK4v8YfMujtshgw%3d
Michigan
10
GRACE DENNEY
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
21
19
46
Amy Stoddard
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=uRWg%2bj12%2fx969pEhWRbVgsFmvh6WsK4v8YfMujtshgw%3d
Michigan
10
AMY STODDARD
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
20
20
48
Hannah Gannon
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=uRWg%2bj12%2fx969pEhWRbVgsFmvh6WsK4v8YfMujtshgw%3d
Michigan
10
HANNAH GANNON
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
19
21
66
Tia Esposito
Cutter
NaN
5'4"
0
0
0
0
/events/teams/?EventTeamId=uRWg%2bj12%2fx969pEhWRbVgsFmvh6WsK4v8YfMujtshgw%3d
Michigan
10
TIA ESPOSITO
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
18
22
77
Phoebe Hopp
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=uRWg%2bj12%2fx969pEhWRbVgsFmvh6WsK4v8YfMujtshgw%3d
Michigan
10
PHOEBE HOPP
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
16
0
2
Veronica Cruz
Cutter
NaN
5'2"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
VERONICA CRUZ
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
15
1
3
Rachel Thomson
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
RACHEL THOMSON
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
25
2
5
Anne Gordon
Cutter
NaN
5'5"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
ANNE GORDON
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
14
3
6
Carly Eckstrom
Cutter
NaN
5'2"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
CARLY ECKSTROM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
12
4
7
Natasha Field-marsham
Cutter
NaN
5'6"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
NATASHA FIELD-MARSHAM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
11
5
9
Amanda Somvilay
Handler
NaN
5'2"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
AMANDA SOMVILAY
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
10
6
11
Freya Chay
Cutter
NaN
5'8"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
FREYA CHAY
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
9
7
12
Rosemarie Sandino
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
ROSEMARIE SANDINO
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
6
9
15
Anne Rempel
Handler/Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
ANNE REMPEL
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
4
10
18
Michelle McGhee
Cutter
NaN
5'8"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
MICHELLE MCGHEE
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
3
11
22
Rahcel Gianforte
Handler/Cutter
NaN
5'6"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
RAHCEL GIANFORTE
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2
13
27
Deanna Abrams
Handler/Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
DEANNA ABRAMS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
26
14
30
Emma Heath
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
EMMA HEATH
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
27
15
51
Shayla Harris
Cutter
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
SHAYLA HARRIS
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
28
16
60
Caitlin Go
Handler
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
CAITLIN GO
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
50
17
84
Hallie Dunham
Handler
NaN
5'5"
0
0
0
0
/events/teams/?EventTeamId=2amZyf4ayBAARb%2bxwa7YR3pGFAjXBaBIdMAChYJ46gI%3d
Stanford
3
HALLIE DUNHAM
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
49
0
1
Margaret Kennedy
NaN
NaN
5'10"
0
0
0
0
/events/teams/?EventTeamId=%2fLGdnvAi%2bq1Wzmdd1TxP6fwGc62QmnID%2bYQeKfpK0W4%3d
Oregon
1
MARGARET KENNEDY
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
409 rows × 29 columns
In [50]:
print markdown.pandas_to_markdown(womens[womens["Fantasy Total"] > 0].set_index("No.") \
[["Name", "Fantasy Total", "Position", "Height", "Team", "Seed"] + users] \
.sort(["Fantasy Total", "Seed"], ascending=False))
| Name | Fantasy Total | Position | Height | Team | Seed | almondchipcookies | anti_spiral | azjps | chubs45 | dlquinonesII | duthracht | giftedbadly | grhgra002 | krdonnie | livetweetyourgames | samth | scottyskin96 | ultimatefrisbee | Ultimatezach |
| :------------------ | :------------ | :--------------- | :----- | :------------------ | :--- | :---------------- | :---------- | :---- | :------ | :----------- | :-------- | :---------- | :-------- | :------- | :----------------- | :---- | :----------- | :-------------- | :----------- |
| Jesse Shofner | 21 | nan | nan | Oregon | 1 | 1 | 0 | 1 | 2 | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 1 | 2 |
| Mira Donaldson | 15 | Cutter | nan | British Columbia | 2 | 1 | 1 | 0 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 2 | 1 |
| Janina Freystaetter | 9 | Defense (Cutter) | 5'9" | Central Florida | 4 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 1 | 2 | 1 | 0 | 0 | 1 |
| Han Chen | 7 | Handler/Cutter | 1'0" | UCLA | 7 | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 |
| Marisa Rafter | 6 | nan | nan | California | 12 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 1 | 0 | 1 |
| Bethany Kaylor | 6 | nan | 1'0" | Oregon | 1 | 2 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 |
| Kristen Pojunis | 5 | Handler/Cutter | 5'7" | UCLA | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 |
| Claire Revere | 5 | nan | 5'5" | Whitman | 5 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 1 | 0 |
| Shayna Brock | 5 | nan | nan | Central Florida | 4 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 1 | 0 | 0 | 0 |
| Courtney Gegg | 5 | Cutter | 6'0" | Stanford | 3 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 |
| Angela Zhu | 4 | nan | 1'0" | Dartmouth | 18 | 1 | 0 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Kate Scarth | 4 | nan | 1'0" | British Columbia | 2 | 0 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |
| Jaclyn Verzuh | 3 | Defense (Cutter) | 6'0" | Dartmouth | 18 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 1 | 0 |
| Olivia Bartruff | 3 | nan | nan | Oregon | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 |
| Hayley Wahlroos | 3 | nan | nan | Oregon | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 |
| Carolyn Normile | 2 | Handler | 5'3" | Pittsburgh | 11 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Kirstin Johnson | 2 | nan | 5'4" | Colorado | 8 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 |
| Monisha White | 2 | Handler | nan | Stanford | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 |
| Chloe Rowse | 1 | nan | nan | Colorado College | 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 |
| Taylor Srebnick | 1 | nan | nan | Wisconsin | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
| Abbie Abramovich | 1 | nan | nan | Chaos (Independent) | 14 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Alexa Wood | 1 | nan | nan | Central Florida | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Stephanie Williams | 1 | nan | 3'8" | Central Florida | 4 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
In [6]:
d1_mens = usau.USAUResults("USA-Ultimate-D-I-College-Championships-2016", "Men")
d1_womens = usau.USAUResults("USA-Ultimate-D-I-College-Championships-2016", "Women")
In [10]:
d1_mens.rosters[(d1_mens.rosters.UpperName.str.contains('MAR'))]
Out[10]:
No.
Name
Position
Year
Height
Goals
Assists
Ds
Turns
url
Team
Seed
UpperName
11
22
Zach Marbach
Defense (Cutter)
NaN
5'11"
0
0
0
0
/events/teams/?EventTeamId=WYJgfoS15UwIrhHv%2f...
Texas A&M
12
ZACH MARBACH
14
19
Oliver Marczynski
Dump
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=mPAmMpOArcp7jUv%2fZ...
Washington
13
OLIVER MARCZYNSKI
14
32
Martin Harris
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=A2BPqSvIvslgMWNJXLV...
Oregon
2
MARTIN HARRIS
18
64
Leandro Marx
NaN
NaN
NaN
1
0
0
1
/events/teams/?EventTeamId=A2BPqSvIvslgMWNJXLV...
Oregon
2
LEANDRO MARX
22
75
Marvin Waldvogel
NaN
NaN
'"
2
2
0
1
/events/teams/?EventTeamId=A2BPqSvIvslgMWNJXLV...
Oregon
2
MARVIN WALDVOGEL
8
10
Marcus Rovner
Cutter
NaN
5'9"
0
0
0
0
/events/teams/?EventTeamId=fdfCsO0xmr041Up41vm...
North Carolina
7
MARCUS ROVNER
0
0
Mark Rauls
Mid
NaN
5'5"
0
0
0
0
/events/teams/?EventTeamId=5csX922%2fB0CMbIKr3...
Colorado
11
MARK RAULS
12
15
Marc Kaylor
NaN
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=5csX922%2fB0CMbIKr3...
Colorado
11
MARC KAYLOR
1
3
Joseph Marmerstein
NaN
NaN
1'0"
0
3
1
9
/events/teams/?EventTeamId=EZUGFm%2bLN%2bu5tGZ...
Case Western Reserve
18
JOSEPH MARMERSTEIN
19
81
Mark Fertal
NaN
NaN
NaN
1
0
1
0
/events/teams/?EventTeamId=EZUGFm%2bLN%2bu5tGZ...
Case Western Reserve
18
MARK FERTAL
16
23
Mark Vandenberg
Handler
NaN
6'1"
1
4
1
2
/events/teams/?EventTeamId=pu2%2bLWNO1TaelKMQW...
Harvard
10
MARK VANDENBERG
9
23
Martin Newman
NaN
NaN
6'0"
0
3
0
1
/events/teams/?EventTeamId=1c2W%2fr85qv0agaqr6...
Auburn
16
MARTIN NEWMAN
5
5
Ivan Martins
Defense (Cutter)
NaN
NaN
0
0
0
0
/events/teams/?EventTeamId=T3tK32EV4ivVFgJ5VhD...
Utah
20
IVAN MARTINS
grhgra002 Mark Vandenburg Series([], name: UpperName, dtype: object) anti_spiral Tanner Johnson 8 TANNOR JOHNSON 5 AVERY JOHNSON Name: UpperName, dtype: object duthracht Jenina Freystaeter Series([], name: UpperName, dtype: object) azjps Mark Vandenburg Series([], name: UpperName, dtype: object) ultimatefrisbee Mark Vandenburg Series([], name: UpperName, dtype: object) samth Freystatter Series([], name: UpperName, dtype: object) giftedbadly Janina Freystatter Series([], name: UpperName, dtype: object) chubs45 Janina Freystatter Series([], name: UpperName, dtype: object) livetweetyourgames Tanner Johnson 8 TANNOR JOHNSON 5 AVERY JOHNSON Name: UpperName, dtype: object scottyskin96 Joe Marmerstien Series([], name: UpperName, dtype: object)
Content source: azjps/usau-py
Similar notebooks: