- 爬取上櫃股價網址
- 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[3:])), header=None)
- df.head()
- df.columns = list(map(lambda l: l.replace(' ',''), lines[2].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[3:])), header=None)
df.to_csv('test2.csv') -->df.to_csv('test2.csv',encoding='utf_8_sig')
|