[已解决]两个链接怎么For循环

Vastsea

如何下代码，原来只去一个链接的内容，现在增加了一个链接，该如何写？红色为增加的链接。

import requests
from bs4 import BeautifulSoup
from openpyxl import Workbook
wb = Workbook()
ws = wb.active
ws['A1'] = "IP地址"
ws['B1'] = "总数"
n = 2
ip1 = ['192.168.3.12','192.168.55.20','192.168.3.18','192.168.70.18','192.168.3.15','192.168.70.20','192.168.70.24']
for i in ip1:
    url1 = "http://" + i + "/web/guest/cn/websys/status/getUnificationCounter.cgi"
    url3 = "http://" + i + "/web/guest/cn/websys/status/configuration.cgi"
    req = requests.get(url1)
    html = req.text
    bs = BeautifulSoup(html,"html.parser")
    trs = bs.select('tr.staticProp')[1].get_text()
    r = str(n)
    n = n + 1
    ws['a' + r] = i
    ws['b' + r] = i
    ws['c' + r] = trs[3:]
wb.save("C:\\New folder\\11.xlsx")

最佳答案

月排行榜 / 总排行榜

suchocolate

2021-8-12 13:25:42

Vastsea 发表于 2021-8-12 11:36
对不住，想自己写，不想一粘了之。还是搞错了。

两个链接取的位置不同，该怎么处理？

1. import requests
   
2. from bs4 import BeautifulSoup
   
3. from openpyxl import Workbook
   
4. 
   
5. wb = Workbook()
   
6. ws = wb.active
   
7. ws['A1'] = "IP地址"
   
8. ws['B1'] = "总数"
   
9. n = 2
   
10. ips = ['192.168.3.12', '192.168.55.20', '192.168.3.18', '192.168.70.18', '192.168.3.15', '192.168.70.20',
    
11.        '192.168.70.24']
    
12. urls = [f"http://%s/web/guest/cn/websys/status/getUnificationCounter.cgi",
    
13.         f"http://%s/web/guest/cn/websys/status/configuration.cgi"]
    
14. for i in ips:
    
15.     for x, url in enumerate(urls):
    
16.         req = requests.get(url % i)
    
17.         html = req.text
    
18.         bs = BeautifulSoup(html, "html.parser")
    
19.         if x:
    
20.             trs = bs.select('tr.staticProp')[17].get_text()
    
21.         else:
    
22.             trs = bs.select('tr.staticProp')[1].get_text()
    
23.         r = str(n)
    
24.         n = n + 1
    
25.         ws['a' + r] = i
    
26.         ws['b' + r] = i
    
27.         ws['c' + r] = trs[3:]
    
28. wb.save("C:\\New folder\\11.xlsx")
    

复制代码

跳转到最佳答案楼层

suchocolate

1. import requests
   
2. from bs4 import BeautifulSoup
   
3. from openpyxl import Workbook
   
4. 
   
5. wb = Workbook()
   
6. ws = wb.active
   
7. ws['A1'] = "IP地址"
   
8. ws['B1'] = "总数"
   
9. n = 2
   
10. ips = ['192.168.3.12', '192.168.55.20', '192.168.3.18', '192.168.70.18', '192.168.3.15', '192.168.70.20',
    
11.        '192.168.70.24']
    
12. 
    
13. urls = ["http://%s/web/guest/cn/websys/status/getUnificationCounter.cgi",
    
14.         "http://%s/web/guest/cn/websys/status/configuration.cgi"]
    
15. for i in ips:
    
16.     for url in urls:
    
17.         req = requests.get(url % i)
    
18.         html = req.text
    
19.         bs = BeautifulSoup(html, "html.parser")
    
20.         trs = bs.select('tr.staticProp')[1].get_text()
    
21.         r = str(n)
    
22.         n = n + 1
    
23.         ws['a' + r] = i
    
24.         ws['b' + r] = i
    
25.         ws['c' + r] = trs[3:]
    
26. wb.save("C:\\New folder\\11.xlsx")
    

复制代码

Vastsea

suchocolate 发表于 2021-8-12 08:05

非常感谢。运行时给出如下错误。

1. ---------------------------------------------------------------------------
   
2. TypeError                                 Traceback (most recent call last)
   
3. <ipython-input-3-5932eff03bb4> in <module>
   
4.       6 for i in ip1:
   
5.       7     for url in urls:
   
6. ----> 8         req = requests.get(urls % i)
   
7.       9         html = req.text
   
8.      10         bs = BeautifulSoup(html,"html.parser")
   
9. 
   
10. TypeError: unsupported operand type(s) for %: 'list' and 'str'

复制代码

suchocolate

Vastsea 发表于 2021-8-12 10:50
非常感谢。运行时给出如下错误。

req = requests.get(url % i)
我写的是url，你写的urls，仔细核对。

Vastsea

suchocolate 发表于 2021-8-12 11:06
req = requests.get(url % i)
我写的是url，你写的urls，仔细核对。

对不住，想自己写，不想一粘了之。还是搞错了。

两个链接取的位置不同，该怎么处理？

第一个链接

bs.select('tr.staticProp')[1].get_text()

第二个链接

bs.select('tr.staticProp')[17].get_text()

suchocolate

Vastsea 发表于 2021-8-12 11:36
对不住，想自己写，不想一粘了之。还是搞错了。

两个链接取的位置不同，该怎么处理？

1. import requests
   
2. from bs4 import BeautifulSoup
   
3. from openpyxl import Workbook
   
4. 
   
5. wb = Workbook()
   
6. ws = wb.active
   
7. ws['A1'] = "IP地址"
   
8. ws['B1'] = "总数"
   
9. n = 2
   
10. ips = ['192.168.3.12', '192.168.55.20', '192.168.3.18', '192.168.70.18', '192.168.3.15', '192.168.70.20',
    
11.        '192.168.70.24']
    
12. urls = [f"http://%s/web/guest/cn/websys/status/getUnificationCounter.cgi",
    
13.         f"http://%s/web/guest/cn/websys/status/configuration.cgi"]
    
14. for i in ips:
    
15.     for x, url in enumerate(urls):
    
16.         req = requests.get(url % i)
    
17.         html = req.text
    
18.         bs = BeautifulSoup(html, "html.parser")
    
19.         if x:
    
20.             trs = bs.select('tr.staticProp')[17].get_text()
    
21.         else:
    
22.             trs = bs.select('tr.staticProp')[1].get_text()
    
23.         r = str(n)
    
24.         n = n + 1
    
25.         ws['a' + r] = i
    
26.         ws['b' + r] = i
    
27.         ws['c' + r] = trs[3:]
    
28. wb.save("C:\\New folder\\11.xlsx")
    

复制代码