import pandas as pd

df = pd.DataFrame({"国家": ["中国", "美国", "俄罗斯"], "首都": ["北京", "华盛顿", "莫斯科"]})
df.to_csv("data_excel.csv", encoding="utf_8_sig", index=False, lineterminator="\r\n")