爬取视频专栏每集名称与时长

  1. import requests
  2. import pandas as pd
  4. url = 'https://api.bilibili.com/x/player/pagelist?bvid=BV12b411K7Zu&jsonp=jsonp'
  5. headers = {
  6.     'user-agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/103.0.0.0 '
  7.                   'Safari/537.36 '
  8. }
  9. res = requests.get(url=url, headers=headers).json()['data']
  10. print(res)
  11. df = pd.DataFrame(columns=['集名', '时长/秒'])
  12. for row in res:
  13.     df = pd.concat([df, pd.DataFrame({
  14.         '集名': ['P' + str(row['page']) + ' ' + row['part']],
  15.         '时长/秒': [row['duration']]
  16.     })], ignore_index=True)
  17. df.to_excel('B站视频集名与时长.xlsx')