用python抓一个页面的表格数据

Question

酬劳，抓单一页面的表格数据，最好用pandas库抓。有兴趣的私信我，我给你网址。

Answer 1

import requests
import pandas as pd

url="https://www.ninwin.cn/index.php?m=cb&a=cb_all&show_cb_only=Y&show_listed_only=Y"
headers = {'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36'}
cookies = {
    'csrf_token': '2e14968939466e3e',
    '__51cke__': '',
    'P0s_answerTime': '1690346391',
    'P0s_q_n': '9',
    'P0s_cbQuestion': 'a7f7afd7f275a978722479dd060968c3',
    'P0s_Pw_verify_code': 'DeP71aUdg%2FY%3D',
    'P0s_winduser': 'Rah8VZuDNRGcrDXDVzpQ5xGM%2BJqkFF%2FPUAFE7RRGKklUQNJUClkaH59iFUA%3D',
    'P0s_visitor': 'bCN5uSnZ0KMivmZC0a60EjqW%2BEUZjVbkNuTlki9GR%2FY3KSOM',
    'P0s_lastvisit': '2555%091690346843%09%2Findex.php%3Fm%3DmyAdmin%26c%3Dlog',
    '__tins__4771153': '%7B%22sid%22%3A%201690346210679%2C%20%22vd%22%3A%2028%2C%20%22expires%22%3A%201690348644789%7D',
    '__51laig__': '83',
}
response = requests.get(url,headers=headers,cookies=cookies)
data=pd.read_html(response.text)[0]
data.to_csv(r"e:/cz.csv",encoding="gbk")