#给import requests
from bs4 import BeautifulSoup
import requests
res = requests.get('http://10.7.1.168/problemset.php?search=%E5%9F%BA%E7%A1%80-%E5%BE%AA%E7%8E%AF%E8%BE%93%E5%87%BA')
text = res.text
# print(text)
tree = BeautifulSoup(text,'html.parser')
tbody = tree.find('tbody')
tr = tbody.find_all('tr')
for item in tr:
print(item.find_all('td')[0].text,end=',')
# 给import requests
from bs4 import BeautifulSoup
import requests
from openpyxl import load_workbook
book = load_workbook('zhongben.xlsx')
sheet = book.active
maxcol=sheet.max_column+1 #最大列
import time
for j in range(1,20):
data = []
i=2
for item in range(220600,220650):
res = requests.get('http://10.7.1.168/ranklist.php?prefix='+str(item)+'&csrf=ir70XMrfNwPnkxNFlo6km4LuRfAg2rCZ')
text = res.text
# print(text)
tree = BeautifulSoup(text, 'html.parser')
tbody = tree.find('tbody')
td = tbody.find_all('td')
print(sheet.cell(i,1).value ,td [2].text, td [3].text )
sheet.cell(i,maxcol).value = td[3].text
data.append( td [3].text )
i=i+1
book.save('zhongben.xlsx')
print(data)
time.sleep(60)
pip install matplotlib -i https://pypi.tuna.tsinghua.edu.cn/simple
import matplotlib.pyplot as plt
plt.figure(figsize=(20,10),dpi=100)
game = []
from openpyxl import load_workbook
book = load_workbook('zblab.xlsx')
sheet = book.active
maxrow = sheet.max_row
for i in range(2,5):
for j in range(1,sheet.max_column+1):
print(sheet.cell(i,j).value,end=' ')
print()