import datetime
import pymysql
import requests
import re
import time
import csv
import json
import random
import citys
def mysql(sql):
# 链接数据库
db = pymysql.connect(host='localhost', user="root", port=3306, password="123456", database="asd")
cursor = db.cursor()
cursor.execute(sql)
db.commit()
cursor.close()
db.close()
def get_headers(header_raw):
return dict(line.split(": ", 1) for line in header_raw.split("\n"))
# 获取网页源码的文本文件
def get_html(url):
response = requests.get(url, headers=get_headers(headers))
response.close()
return response
def post_html(url, data):
res = requests.post(url, headers=get_headers(headers), json=data)
time.sleep(1)
return res
def save_data(demcity, arrcity, demTime, arrTime, Airline, flightNo, lowPrice):
with open("data.csv", "a", encoding="
爬取机票价格相关信息
于 2023-05-23 12:49:46 首次发布
本文介绍如何利用Python爬取机票价格信息,提供了包含多个城市的源文件citys,并提示读者可根据需求进行修改或替换。
摘要由CSDN通过智能技术生成