pandas 之 to_csv 儲存資料出現中文亂碼問題及解決辦法

admin

1. 爬取上櫃股價網址
   
2. import requests
   
3. 
   
4. import pandas as pd
   
5. from io import StringIO
   
6. 
   
7. #C:\Users\user\Downloads\RSTA3104_1110309.csv
   
8. 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'
   
9. r = requests.get(link)
   
10. r.ok
    
11. 
    
12. #使用pandas讀取
    
13. lines = r.text.replace('\r', '').split('\n')
    
14. 
    
15. df = pd.read_csv(StringIO("\n".join(lines[3:])), header=None)
    
16. df.head()
    
17. 
    
18. df.columns = list(map(lambda l: l.replace(' ',''), lines[2].split(',')))
    
19. df.index = df['代號']
    
20. df = df.drop(['代號'], axis=1)
    
21. df.head()
    
22. 
    
23. df.to_csv('test2.csv',encoding='utf_8_sig')
    
24. pd.read_csv('test2.csv', index_col='代號').head()
    
25. print (df)

複製代碼

df = pd.read_csv(StringIO("\n".join(lines[3:])), header=None)

df.to_csv('test2.csv')  -->df.to_csv('test2.csv',encoding='utf_8_sig')