import requests_html
import xlwt
import time
session = requests_html.HTMLSession()
list1=["shanghai","xiamen",'guilin',"kunming","lijiang","xianggelila","dali","xining","dunhuang","helunbeier"]
time = time.strftime("%Y%m%d%H")
def write_file(file_path,Values):
with open(file_path,"a+") as f:
f.write(Values+"\n")
for i in range(len(list1)):
url = "http://www.15tianqi.com/%s/" %list1[i]
# print(url)
res = session.get(url)
write_file("tianqi%s.txt" %time,url)
tr = res.html.find("tbody>tr")
for text in range(len(tr)):
"""爬取的内容写入txt"""
values = tr[text].text.replace("\n"," ")
write_file("tianqi%s.txt" %time,values)
with open("tianqi%s.txt" %time,"r") as f:
file = xlwt.Workbook()
table = file.add_sheet("tianqi",cell_overwrite_ok=True)
list_title = ["URL","Date","WeekDay","WeatherStatus","℃","Wind direction" ,"Wind Power","plain"]
for i in range(7):
table.write(0,i,list_title[i])
list_tianqi = f.readlines()
for i in range(len(list_tianqi)):
if list_tianqi[i][:4] == "http":
table.write(i+1,0,list_tianqi[i])
else:
# list1 = list_tianqi[i].replace(" ",",")
list2 = list_tianqi[i].split(' ')
for j in range(len(list2)):
table.write(i,j+1,list2[j])
params = {"shanghai":"sha","xiamen":"xmn","guilin":"kwl","kunming":"kmg",
"lijiang":"ljg","xianggelila":"dig","dali":"dlu","xining":"xnn",
"dunhuang":"dnh","helunbeier":"hld,hld"}
for i in range(len(list_tianqi)):
if list_tianqi[i][:4] == "http":
address = list_tianqi[i].split("/")[-2]
if address == "shanghai":
pass
# print("你个傻逼,人就在上海")
# else:
# # print(params[address])
else:
date = "2019-" + list_tianqi[i].split(' ')[0].replace("月","-").replace("日","")
# print(date)
url = "https://flights.ctrip.com/itinerary/oneway/sha-{0}?date={1}" .format(params[address],date)
# print(url)
file.save("test%s.xls" %time)
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· Manus重磅发布:全球首款通用AI代理技术深度解析与实战指南
· 被坑几百块钱后,我竟然真的恢复了删除的微信聊天记录!
· 没有Manus邀请码?试试免邀请码的MGX或者开源的OpenManus吧
· 园子的第一款AI主题卫衣上架——"HELLO! HOW CAN I ASSIST YOU TODAY
· 【自荐】一款简洁、开源的在线白板工具 Drawnix