python批量下载csv表格里面的视频链接

如题，下载CVS表格里面的视频链接保存到本地，CSV的表格有两列，一列视频源地址“URL”,另外一列为视频源名“片名”，保存为MP4格式。

代码如下

import requests
import pandas as pd
import time
data = pd.read_csv(r'C:\Users\Administrator\Desktop\test.csv')
for i in range(data.shape[0]):
  url=data['URL'].get(i) 
  name=data['片名'].get(i)
  r = requests.get(url, stream=True)  
  file ="D:\\20221219\\"+str(name)+".mp4"
  with open(file,"wb") as mp4:
    for chunk in r.iter_content(chunk_size=1024 * 1024):
        if chunk:
            mp4.write(chunk)
            time.sleep(1)