import csv
import os

# 确保目录存在
os.makedirs(r'C:\Users\jerry\PyCharmProjects\footviz\footviz\data', exist_ok=True)

# 创建国家名和联赛名映射的CSV文件
mapping_data = [
    ["country_name", "league_name"],
    ["England", "Premier League"],
    ["France", "Ligue 1"],
    ["Germany", "Bundesliga"],
    ["Spain", "La La Liga"],
    ["China", "Chinese Super League"]
]

# 写入CSV文件
with open(r'C:\Users\jerry\PyCharmProjects\footviz\footviz\data\league_country_mapping.csv', 'w', newline='', encoding='utf-8') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(mapping_data)

print("已创建国家名和联赛名映射文件: league_country_mapping.csv")