$ pip install requests
#下載所有資訊 import requests url = 'https://tcgbusfs.blob.core.windows.net/blobyoubike/YouBikeTP.json' response = requests.get(url) if response.status_code == 200: json=response.json() print(json) else: print("下載失敗")
allData = list(json["retVal"].values()) allData
print("{:<30s}\t\t{:<3s}\t{:>5s}{:>5s}{:>5s}".format("站名","區域","可借數量","可還數量","總數量")) for site in allData: siteName = site["sna"] area = site["sarea"] sbi = site["sbi"] bemp = site["bemp"] total = site["tot"] print("{:<30s}\t{:<3s}\t{:>5s}\t{:>5s}\t{:>5s}".format(siteName,area,sbi,bemp,total))
$ pip install pandas
import pandas as pd dataFrame = pd.DataFrame(allData,columns=['sna','sarea','sbi','bemp','tot']) dataFrame.columns = ["站名","區域","可借數量","可還數量","總數量"] dataFrame.set_index('站名',inplace=True) dataFrame
徐國堂 老師
巨匠電腦 - AI程式設計講師 專長: 擁有20年的教學經驗,專攻於程式語言、手機程式設計、網頁程式、物聯網程式設計;已經有眾多學生就職於相關產業。 ⏰近期開課
免費學習資源不漏接