python协程异步方式爬取短视频（高清无水印）

import requests
import pandas as pd
from jsonpath_ng import jsonpath, parse
import os
import aiohttp
import asyncio
import time
import json
import re
from collections import defaultdict
from typing import List
import random
def open_file_url():
    urls = []
    excel_file_path = 'D://targeturl.xlsx'  # 替换为你的Excel文件路径
    df = pd.read_excel(excel_file_path)
    # 假设URL在名为'URL'的列中
    for index, row in df.iterrows():
        url = row['URL']  # 假设URL列名为'URL'即表格的第一行
        urls.append(url)
    return urls

def req_url(url):
    url = url
    payload = {}
    headers = {
    'Cookie':'Hm_lvt_2fc126',#换成自己的cookie
    'User-Agent':'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/85.0.4183.83 Safari/537.3:authority:www.douyin.com',
    'accept':'application/json, text/plain, */*',
    'accept-encoding':'UTF-8,gzip, deflate,'