利用python爬取QQ音乐排行榜的数据,并存入csv文件的代码
时间: 2024-06-10 11:06:08 浏览: 192
好的,下面是利用Python爬取QQ音乐排行榜并存入CSV文件的代码:
```python
import requests
import csv
url = "https://c.y.qq.com/v8/fcg-bin/fcg_v8_toplist_cp.fcg?g_tk=5381&uin=0&format=json&inCharset=utf-8&outCharset=utf-8¬ice=0&platform=h5&needNewCode=1&tpl=3&page=detail&type=top&topid=4"
header = {
"Referer": "https://y.qq.com/n/yqq/toplist/4.html",
"User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3029.110 Safari/537.3"
}
response = requests.get(url, headers=header)
json_data = response.json()
song_list = json_data['songlist']
with open('QQ音乐排行榜.csv', 'w', newline='', encoding='utf-8') as file:
writer = csv.writer(file)
writer.writerow(['歌曲名称', '歌手', '专辑'])
for song in song_list:
song_name = song['data']['songname']
singer = song['data']['singer'][0]['name']
album = song['data']['albumname']
writer.writerow([song_name, singer, album])
print('已成功爬取QQ音乐排行榜并存入CSV文件')
```
在以上代码中,我们首先将需要爬取的URL地址存储在变量中,并设置请求头Referer和User-Agent以模拟浏览器访问。然后使用requests库发送get请求,并将响应数据转为json格式。接着我们需要提取排行榜中的歌曲信息并进行存储,这里我们选择将数据存入CSV文件中。最后输出爬取成功的提示信息。
注意:未来如果该网站做了反爬虫的处理,以上代码可能会失效。
阅读全文
相关推荐
![csv](https://img-home.csdnimg.cn/images/20241231044821.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![txt](https://img-home.csdnimg.cn/images/20241231045021.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![docx](https://img-home.csdnimg.cn/images/20241231044901.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![7z](https://img-home.csdnimg.cn/images/20241231044736.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)
![pdf](https://img-home.csdnimg.cn/images/20241231044930.png)