import pandas as pd

df = pd.DataFrame(
    {
        "国家": ["中国", "美国", "俄罗斯"],
        "首都": ["北京", "华盛顿", "莫斯科"],
    }
)
with open("data_excel.csv", "w", newline="\r\n", encoding="utf-8-sig") as f:
    df.to_csv(f, index=False)