5行代码实现网页表格数据爬取

# 方式一：
import  requests
import pandas as pd

resp = requests.get('http://antpython.net/webspider/grade_form')
data = pd.read_html(resp.text)

'''知识点'''
print(data[0]) 
print(type(data[0]))
data[0].to_excel('./ant_grade_form.xlsx',index=False)

# 方式二：
import pandas as pd
data = pd.read_html('http://antpython.net/webspider/grade_form',encoding='utf-8')
print(data[0].head())
print(type(data[0]))

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19