import requests
import re
import json
import pandas as pd
base_url=""
commentlist=[]
for page in range (0,7):
url=base_url.format(page=page)
r=requests.get(url)
res=json.loads(r.text)
for i in res['comments']:
serises=[]
serises.append(i['creationTime'])
serises.append((i['content']))
commentlist.append(serises)
print(commentlist)
df=pd.DataFrame(commentlist,columns=['评论时间','评论内容'])
print(df)
df.to_excel(r'21数据4班_2214230403_马正.xlsx')