请问各位:python如何把爬出来的数据导入到excel里
还是初学者,这是自己改的一个代码,前面爬虫都没问题,加上导出文件之后就报错了。
TypeError: 'NoneType' object is not callable
因为刚接触,还不会把数据导出成excel,想求问各位怎么导出
import requests
from bs4 import BeautifulSoup
import pandas as pd
headers={
"User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/119.0.0.0 Safari/537.36 Edg/119.0.0.0"
}
for start_num in range(20,260,20):
response = requests.get(f"https://movie.douban.com/subject/26357307/comments?start={start_num}&limit=20&status=P&sort=new_score",headers=headers)
html=response.text
soup=BeautifulSoup(html,"html.parser")
all_titles=soup.findAll("span",attrs={"class":"short"})
for title in all_titles:
print(title.string)
title.to_excel('影评.xlsx')