用python查询考研调剂信息(用python查文献)

祝22考研党成功上岸~
附python查询代码
import requests
import time
from lxml import etree
import xlsxwriter

def get_html(page):
? ? url = .format(page)
? ? headers = {
? ? ? ?
? ? }
? ? response = requests.get(url, headers=headers).text
? ? return response

def parse_html(htmlcode, data)

:
? ? content = etree.html(htmlcode)
? ? results = content.xpath()
? ? for result in results[:]:
? ? ? ? title = result.xpath().strip()
? ? ? ? school = result.xpath(
? ? ? ? major = result.xpath().strip()
? ? ? ? num = result.xpath().strip()
? ? ? ? time = result.xpath().strip()
? ? ? ? data_dict = {
? ? ? ? ? ? : title,
? ? ? ? ? ? :school,
? ? ? ? ? ? :major,
? ? ? ? ? ? :num,
? ? ? ? ? ? :time
? ? ? ? }

? ? ? ? data.append(data_dict)


def excel_storage(response):
? ? workbook = xlsxwriter.workbook()
? ? worksheet = workbook.add_worksheet()
? ? bold_format = workbook.add_format({: true})
? ? worksheet.write(, bold_format)
? ? worksheet.write(, bold_format)
? ? worksheet.write(, bold_format)
? ? worksheet.write(, bold_format)
? ? worksheet.write(, bold_format)

? ? row = 1
? ? col = 0
? ? for item in response:
? ? ? ? worksheet.write_string(row, col, item[])
? ? ? ? worksheet.write_string(row, col + 1, item[])
? ? ? ? worksheet.write_string(row, col + 2, item[])
? ? ? ? worksheet.write_string(row, col + 3, item[])
? ? ? ? worksheet.write_string(row, col + 4, item[])
? ? ? ? row += 1
? ? workbook.close()


def main():
? ? all_datas = []
? ? for page in range(1, 145):
? ? ? ? html = get_html(page)??
? ? ? ? parse_html(html, all_datas)
? ? excel_storage(all_datas)


if __name__ == :
? ? main()
? ? print()