# 本程序用于爬取酷我音乐网站中新歌榜前200名的歌曲和歌手信息

# # 获取信息保存在xls文件中

import requests

from lxmlimport etree

import xlwt

url ='http://www.kuwo.cn/bang/index'

res = requests.get(url)

html = etree.HTML(res.text)

info_s = html.xpath('//ul[@class="listMusic"]/li')

all_info_list = []

for infoin info_s:

rank1 = info.xpath('div[1]/p')[0]

rank = rank1.xpath('string(.)').strip()

song1 = info.xpath('div[2]/a')[0]

song = song1.xpath('string(.)').strip()

singer1 = info.xpath('div[3]/a')[0]

singer = singer1.xpath('string(.)').strip()

# 打印排行、歌曲、歌手

# print(rank, song, singer)

    info_list = [rank,  song, singer]

all_info_list.append(info_list)

book = xlwt.Workbook(encoding='utf-8')

sheet = book.add_sheet('Sheet1')

header = ['rank', 'song', 'singer']

for tin range(len(header)):

sheet.write(0, t, header[t])

i =1

for lin all_info_list:

j =0

    for datain l:

sheet.write(i, j, data)

j +=1

    i +=1

book.save('C:/Users/madin/Desktop/test.xls')