import pandas as pd
df=pd.DataFrame()
url_list=['http://www.espn.com/nba/salaries']
for i in range(2,13):
url='http://www.espn.com/nba/salaries/_/page/%s'%i
url_list.append(url)
for url in url_list:
df=df.append(pd.read_html(url),ignore_index=True)
df=df[[x.startswith('$')for x in df[3]]]
df.to_excel('nba.xls',header=['排行','球员名字','球队名称','工资'],index=False)
生产.xls电子表格文档
获取2019~2020年NBA球员薪资排行榜电子表格