def generate_sched_table(team, year, max_rows=20):
df = pd.DataFrame(teams)
filter_team = df.loc[df["TeamAlt"] == team]
filter_team['ESPNID'] = "http://www.espn.com/college-football/team/fpi/_/id/" \
+ filter_team.ESPNID.map(str) + "/year/" + str(year)
link = filter_team.tail(1)['ESPNID'].values[0]
sched_dataframe = pd.read_html(link, header=1)[4]
sched_dataframe.columns = ['Date', 'Opponent', 'Result/Proj', 'Opp FPI', 'Game Rating']
return html.Table(
# Header1
[html.Tr([
html.Th(html.H6([team + ' ' + str(year) + ' ' + 'Schedule']), colSpan=5, style=dict(textAlign="center")),
])] +
# Header2
[html.Tr([html.Td(col) for col in sched_dataframe.columns], style=dict(fontWeight="bold"))] +
# Body
[html.Tr([
html.Td(sched_dataframe.iloc[i][col]) for col in sched_dataframe.columns
]) for i in range(min(len(sched_dataframe), max_rows))]
)
评论列表
文章目录