Pandas to_csv 中文乱码及保存路径问题

import pandas as pd
import numpy as np
import os

data = [['百度','www.baidu.com'],['小米','www.xiaomi.com'],['google','www.google.com']]
data2 = {'name':['百度','小米','谷歌'],'map':['www.baidu.com','www.xiaomi.com','www.google.com']}
data3 = [{'name':'百度','site':'www.baidu.com'},{'name':'小米','site':'www.xiaomi.com'},{'name':'谷歌','site':'www.google.com'}]
df = pd.DataFrame(data3)

path = os.path.dirname(__file__)
print(path)
df.to_csv(os.path.join(path,'site.csv'),index=False, encoding='utf_8_sig')

posted @ 2022-06-04 23:12  HF10  阅读(224)  评论(0)    收藏  举报