import requests
from bs4 import BeautifulSoup
import pandas
res = requests.get("https://news.qq.com/")
soup = BeautifulSoup(res.text, 'html.parser')
newsary = []
for news in soup.select('.Q-tpWrap .text'):
newsary.append({"title":news.select('a')[0].text,"url":news.select('a')[0]['href']})
newsdf = pandas.DataFrame(newsary)
newsdf.to_excel("news.xlsx")import requests
from bs4 import BeautifulSoup
i