擅长:python、mysql、java
<p>使用<code>pandas</code>解析这些表。只需在url中循环浏览季节(不要忘记将其添加到数据框中,否则您将不知道哪些行是针对哪些季节的:</p>
<pre><code>import pandas as pd
# To get last 10 seasons
years_look_back = 10
years_list = list(range(2021,2021-(years_look_back+1),-1))
years_list.reverse()
# Or just make a list of specific years:
years_list = [2001, 2005, 2008, 2010, 2011, 2015]
cols = ['Player', 'Tm','Cmp%', 'Yds', 'TD', 'Int', 'Y/A', 'Rate']
df_list = []
for year in years_list:
url_mac = f'https://www.pro-football-reference.com/years/{year}/passing.htm'
temp_df = pd.read_html(url_mac)[0][cols]
temp_df['Season'] = year
temp_df = temp_df[~temp_df["Player"].eq("Player")]
df_list.append(temp_df)
print(f'Collect: {year}')
data_radar = pd.concat(df_list)
#selecting specific player
data_mac = data_radar[data_radar['Player'] == 'Mac Jones']
</code></pre>