将存在于两个列表中的字典转换为csv

import csv

headers = ['Name', 'Age', 'Location']
data = [{'Name': 'John', 'Age': 28, 'Location': 'New York'},
        {'Name': 'Alice', 'Age': 32, 'Location': 'London'},
        {'Name': 'Bob', 'Age': 45, 'Location': 'Tokyo'}]

with open('data.csv', 'w', newline='') as file:
    writer = csv.writer(file)

    writer.writerow(headers)

    for item in data:
        writer.writerow(item.values())

Name,Age,Location
John,28,New York
Alice,32,London
Bob,45,Tokyo