python 访问excel 、pdf链接 读取并处理 数据

python访问excel链接，读取内容

res_url = ‘https://dispozitive.anm.ro/f1f2-display’
res = requests.get(res_url, timeout=60)
selector = etree.HTML(res.text)
xls_link = selector.xpath("//*[@class='btn btn-danger']/@href")[0]
xls_link = self.url + xls_link
xls_res = requests.get(xls_link, timeout=60)
df = pd.read_excel(io.BytesIO(xls_res.content), engine="openpyxl")

print（df）

python访问pdf链接，读取内容、处理成二进制

pdf_url =r''https://www.retsinformation.dk/eli/ft/20221XX00088/dan/pdf''

response = utils.multi_requests(url=str(pdf_url), headers=headers, timeout=120)
reader = PdfReader(io.BytesIO(response.content))
writer = PdfWriter()
page_count = len(reader.pages)
for i in range(1, page_count):
　　writer.add_page(reader.pages[i])
fw = io.BytesIO()
writer.write(fw)
fw.flush()
print(fw.getvalue())