网络爬虫作业

目前只是完成了第一部分，

# -*- coding: utf-8 -*-
"""
Created on Thu Nov 29 15:41:51 2018

@author: 10029
"""

import requests
import json
import os
url = 'https://edu.cnblogs.com/Homework/GetAnswers?homeworkId=2420&_=1542959851766'

try:
    r = requests.get(url,timeout=30)
    r.raise_for_status() # 如果状态不是200，引发异常
    r.encoding='utf-8'#无论原来采用什么编码，都改成utf-8    
except:
    print("产生异常")
result = ""
Data = json.loads(r.text)['data']
for data in Data:
    result += str(data['StudentNo'])+','+data['RealName']+','+data['DateAdded'].replace('T',' ')+','+data['Title']+','+data['Url']+'\n'
f=open('E:\hwlist.csv','w')
f.write(result)
f.close()

创建好的Excel文件为

第二部分的库不知道该怎么用了！