作者talon0222 (talon)
看板Python
標題[閒聊] 抓取資料後如何讀取特定檔案
時間Thu Aug 30 04:53:59 2018
剛入坑這個程式
連接url到政府的youbike之後都會跳出404項
目前想做到 可以使用者輸入代碼後
只顯示輸入代碼的資料
希望有大神可以幫忙
看了一整天的電腦找不到解答QQ
附上5000p 感謝
或是輸入城市也可以
目前程式碼
import requests
import json
import pandas as pd
def show(request):
conn = None
url = "
https://tcgbusfs.blob.core.windows.net/blobyoubike/YouBikeTP.gz"
data = requests.get(url).json()
z = input("請輸入城市")
if z in data:
print(z)
for key, value in data["retVal"].items():
sno = value["sno"]
sna = value["sna"]
tot = value["tot"]
sbi = value ["sbi"]
sarea = value ["sarea"]
mday = value ["mday"]
lat = value ["lat"]
lng = value["lng"]
ar = value["ar"]
sareaen =value ["sareaen"]
snaen =value ["snaen"]
aren =value ["aren"]
bemp =value["bemp"]
act = value["act"]
print("代號:", sno,"名稱:", sna,"停車格:", tot,"目前車輛數量:", sbi,"場站區域:", sarea,"資料更新時間:", mday,"緯度:", lat,"經度:", lng,"地:", ar,"場站區:", sareaen,"場站名:", snaen,"地址:", aren,"空位數量:", bemp,"全站禁用狀態:", act )
-----
Sent from JPTT on my iPhone
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 218.161.3.60
※ 文章網址: https://www.ptt.cc/bbs/Python/M.1535576044.A.0F3.html
→ InfinityGate: 他給的資料看起來key就是代號,直接取就好了吧 08/30 05:49
→ InfinityGate: 城市看是要在for裡面判斷還是用filter 08/30 05:52
推 coeric: ubike的資料 09/03 14:05
→ coeric: 原來內文有寫阿... 09/03 14:06
→ coeric: 我印象中,ubike各縣市的資料 是分開放的 09/03 14:08