import requests
import os
import csv
def insert_data_to_api():
    # CSV file path
    csv_folder = "csv"
    csv_file_name = "my_data.csv"
    csv_file_path = os.path.join(csv_folder, csv_file_name)
    url = "http://127.0.0.1:8000/api/url/"
    with open(csv_file_path, newline='') as file:
        # create a CSV reader object using DictReader
        reader = csv.DictReader(file)
        print("")
        print("==== FOR LOOP =====")
        print("")
        # iterate over each row in the CSV file
        for row in reader:
            # access the values in the row using the column headers
           
            print(row)
        print("")
        print("==== From data =====")
        print("")
        response = requests.post(url, json=row)
        if response.status_code == 200 or 201:
            print("Data inserted successfully")
        else:
            print(f"Failed to insert data: {response.status_code}")
insert_data_to_api()

import csv
with open('names.csv', newline='') as csvfile:
    reader = csv.DictReader(csvfile)
    for row in reader:
        print(row['first_name'], row['last_name'])

rows = []
    with open(read, 'r') as file:
        csvreader = csv.DictReader(file)
        
        for row in csvreader:
            rows.append(row)
    
    print(rows)
    print("")
    print("==== Sending POST to an API URL ===")
    print("")
    
    for row in rows:
        response = requests.post(url, json=json.dumps(row))
        print(response)
</details>
# 答案2
**得分**: 0
你实际上想创建一个字典，并将其放入你的工作函数中。
（你也可以使用 `pandas` 模块来完成这个任务）。
创建字典的方法如下：
```python
import csv
with open('data.csv', 'r') as f:
    reader = csv.DictReader(f)
    data = {}
    for row in reader:
        data[row['region']] = row
```
现在，你可以将这个字典解析到你的函数 `insert_data_to_api()` 中，尽管你需要修改它以接受一个字典作为参数。
<details>
<summary>英文:</summary>
You actually want to create a dict and put this into your working function.
(You could also do this with the `pandas` module).
creating a dict is done like this:
```python
import csv
with open(&#39;data.csv&#39;, &#39;r&#39;) as f:
    reader = csv.DictReader(f)
    data = {}
    for row in reader:
        data[row[&#39;region&#39;]] = row
```
Now you are able to read parse the dict into your function `insert_data_to_api()` although you will need to modify it to take a dict as an argument.
</details>