在“https://money.cnn.com/data/markets/nasdaq/”抓取纳斯达克成分股数据并将数据表存到一个Excel表格中。
import requests
from lxml import etree
import xlwt
workbook = xlwt.Workbook(encoding='utf-8')
sheet = workbook.add_sheet('info')
sheet.write(0,0,'company')
sheet.write(0,1,'price')
sheet.write