# -*- coding: utf-8 -*-
import requests
import csv
import os


base_url = ‘https://m.weibo.cn/api/comments/show?id=4131150395559419&page={page}‘
cookies = {‘Cookie‘:‘xxx‘} 
headers = {‘User-Agent‘:‘xxx‘}

path = os.getcwd()+"/weibo.csv"
csvfile = open(path, ‘a+‘, encoding=‘utf-8‘,newline=‘‘)
writer = csv.writer(csvfile)
writer.writerow((‘username‘,‘source‘,‘comment‘))

for i in range(0,83):
    try:
        url = base_url.format(page=i)
        resp = requests.get(url, headers=headers, cookies=cookies)
        jsondata = resp.json()

        data = jsondata.get(‘data‘)
        for d in data:
            created_at = d.get("created_at")
            source = d.get("source")
            username = d.get("user").get("screen_name")
            comment = d.get("text")
            print((username,source,comment))
            writer.writerow((username, source, comment))
    except:
        print(‘*‘*1000)
        pass

csvfile.close()