python 爬虫

#给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()