python接口测试-获取csv数据并批量调用

import math
import time
import requests
import pandas as pd
df=pd.read_csv("虫害数据.csv")

url="新增的地址"
headers={
    "X-Access-Token": " ",
    "Content-Type": "application/json",
    "Tenant-Id":" "
}
i=0
for i in range(len(df)):
    print(i)
    print(type(df['cover'][i]),type(df['name'][i]),type(df['occurMonths'][i]),type(df['nickname'][i]),type(df['harmLevel'][i]),type(df['content'][i]))
    cover=df['cover'][i]
    name=df['name'][i]
    occurMonths=df['occurMonths'][i]
    nickname=df['nickname'][i]

    if type(df['nickname'][i])==float and math.isnan(df['nickname'][i]):#处理nickname为NaN的情况
        nickname = ""
        print(nickname)
    harmLevel=df['harmLevel'][i]
    content=df['content'][i]
    data={
        "cover": cover,
        "name": name,
        "occurMonths": occurMonths,
        "nickname": nickname,
        "harmLevel": harmLevel,
        "breedId": "1801159902193709057",
        "breedName": "玉米",
        "content": content,
        "type": "INSECT_CODE_1"
    }
    print(data)
    time.sleep(1)
    response=requests.post(url,json=data,headers=headers)
    print(response.encoding)