import requests
import pandas as p
from bs4 import BeautifulSoup as bs
defspider(url):req=requests.get(url)req.encoding='utf-8'return bs(req.text,'html.parser')defpandaWork(lis1,lis2,lis3):data=p.DataFrame({'地區名稱':lis1,'地址':lis2,'起步價格':lis3})w=p.ExcelWriter('去哪兒網.xlsx')data.to_excel(w,'去哪兒網')w.save()
lis1=[]
lis2=[]
lis3=[]for i inrange(5):url='https://piao.qunar.com/ticket/list.htm?keyword=%E6%9D%AD%E5%B7%9E®ion=%E6%9D%AD%E5%B7%9E&from=mpshouye_hotcity&page='+str(i+1)pbj=spider(url)for i in pbj.find_all('div',class_="sight_item"):lis1.append(i.find('a',class_='name').text)lis2.append(i.find('div',class_="intro color999").text)lis3.append(i.find('span',class_="sight_item_price").text)
pandaWork(lis1,lis2,lis3)