Py / Python網頁資料擷取與分析班-筆記 8/16

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29

import requests
html = requests.get("https://www.taifex.com.tw/data_gov/taifex_open_data.asp?data_name=DailyForeignExchangeRates")
html.encoding="CP950"
print(html.text)

#切割換行
list1=html.text.split("\r\n")
print(list1)
listx1=[]
listy1=[]
for i in range(1,len(list1)-1):
    list2=list1[i].split(",")
    print(list2[0]+","+list2[1])
    listx1.append("{}/{}".format(list2[0][4:6],list2[0][6:8]))
    listy1.append(eval(list2[1])) #eval()函數將去掉字符串的兩個引號

print(listx1) 
print(listy1)     

##引用matplotlib繪製折線圖  
import matplotlib.pyplot as plt 
import matplotlib as mpl 

mpl.rcParams['font.sans-serif'] = ['FangSong'] 
mpl.rcParams['axes.unicode_minus'] = False 

plt.plot(listx1, listy1, color="red", linewidth=1, linestyle="--", label="美元／新台幣")
plt.legend()
plt.show()

1
2
3
4
5
6
7
8

import requests,json
html = requests.get("https://data.epa.gov.tw/api/v2/aqx_p_02?api_key=e8dd42e6-9b8b-43f8-991e-b3dee723a52d&limit=1000&sort=datacreationdate%20desc&format=json")
print(html.text)

#2.解析JSON
dict1=json.loads(html.text)
# print(dict1)
list1=dict1.get("records") #取出 key值為 records的資料