CSV写文件的操作

import requests

import codecs
import json
import time
import os
import csv

headers = {
    'User-Agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/53.0.2785.113 Safari/537.36'
}
url = 'https://sec.wedengta.com/getIntelliStock?action=IntelliSecPool&id=99970_56&_={0}'.format(time.time())
r = requests.get(url, headers=headers)
result = json.loads(r.text)

rows = []
for every in json.loads(result['content'])['vtDaySec']:
    for company in every['vtSec']:
        row = (
            every['sOptime'],
            company['sChnName'],
            company['sDtCode'][4:]
        )


        rows.append(row)

with codecs.open('company.csv', 'w') as f:
    writer = csv.writer(f)
    writer.writerow(['date', 'stk_name', 'stk_num'])
    writer.writerows(rows)
    
    writer.writerow(['111', 'name1', 'stk_num1'])
    writer.writerow(['222', 'stk_name2', 'stk_num3'])
    writer.writerow(['333', 'stk_name4', 'stk_num5'])