我有一个代码,它将提供我的记录计数。除此之外,我需要知道'Vinod‘在哪一级(它是在第二级,第三级还是第四级’)。标签中需要此信息。
Select 'Open' label, count(*) value from DATA
WHERE SECOND_LEVEL = 'vinod' or THIRD_LEVEL = 'vinod' or FOURTH_LEVEL = 'vinod'
最初,我的代码是:
# encoding = utf-8
from bs4 import BeautifulSoup
import urllib
import re
import os
url = []
urlbase = "https://quizlet.com/subject/四级乱序/page/"
for i in range(0,2):
url.append(urlbase + str(i+1))
indexname = str(url[i])[-1] + ".html"
urllib.urlretrieve(url[i], i