pandas 之 to_csv 儲存資料出現中文亂碼問題及解決辦法
爬取上櫃股價網址import requests
import pandas as pd
from io import StringIO
#C:\Users\user\Downloads\RSTA3104_1110309.csv
link = 'http://www.tpex.org.tw/web/stock/aftertrading/daily_close_quotes/stk_quote_download.php?l=zh-tw&d=111/03/09&s=0,asc,0'
r = requests.get(link)
r.ok
#使用pandas讀取
lines = r.text.replace('\r', '').split('\n')
df = pd.read_csv(StringIO("\n".join(lines)), header=None)
df.head()
df.columns = list(map(lambda l: l.replace(' ',''), lines.split(',')))
df.index = df['代號']
df = df.drop(['代號'], axis=1)
df.head()
df.to_csv('test2.csv',encoding='utf_8_sig')
pd.read_csv('test2.csv', index_col='代號').head()
print (df)
df = pd.read_csv(StringIO("\n".join(lines)), header=None)
df.to_csv('test2.csv')-->df.to_csv('test2.csv',encoding='utf_8_sig')
頁:
[1]