Python代码源码-实操案例-框架案例-获取网页表格数据(read html()方法).zip

import pandas as pd df = pd.DataFrame() url_list = ['http://www.espn.com/nba/salaries/_/seasontype/4'] for i in range(2, 13): url = 'http://www.espn.com/nba/salaries/_/page/%s/seasontype/4' % i url_list.append(url) #遍历网页中的table读取网页表格数据 for url in url_list: df = df.append(pd.read_html(url), ignore_index=True) #列表解析：遍历dataframe第3列，以子字符串$开头 df = df[[x.startswith('$') for x in df[3]]] df.to_csv('NAB11.csv',header=['RK','NAME','TEAM','SALARY'], index=False)