如何使用python将csv文件上传到API

import requests
import csv

with open('file.csv', 'r') as file:
    reader = csv.reader(file)
    data = list(reader)

# 假设CSV文件的第一行是标题行
headers = data[0]
rows = data[1:]

# 将每一行数据转换为字典形式
formatted_data = []
for row in rows:
    formatted_data.append(dict(zip(headers, row)))

url = 'https://api.example.com/upload'
response = requests.post(url, json=formatted_data)

if response.status_code == 200:
    print('文件上传成功！')
    print(response.json())
else:
    print('文件上传失败！')
    print(response.text)