我正在學習如何從數組中獲取數據，并且我有點陷入一種簡單的方法來定位數據從數組中提取數據的位置。感覺應該有比在屏幕上數更簡單的方法。這是我所擁有的：r2 = requests.get( f'https://www.thesportsdb.com/api/v1/json/{apiKey}/lookupevent.php?id={id}')arr_events = np.array([r2.json()])#print(arr_events)event_id = arr_events[0]['events'][0]['idEvent']locate = arr_events.index('strHomeTeam')print(locate)問題是，在控制臺上打印出一個巨大的數組，看起來像（我將給出一行，你可能明白了）：[{'events': [{'idEvent': '1032723', 'idSoccerXML': None, 'idAPIfootball': '592172', 'strEvent': 'Aston Villa vs Liverpool', 'strEventAlternate': 'Liverpool @ Aston Villa', 'strFilename': 'English Premier League 2020-10-04 Aston Villa vs Liverpool'...}]}]這是一個相當大的數組，如果我需要提取一些信息，足以導致輕微的速度減慢。因此，使用上面的方法很容易拉取 idEvent。如果我想要其中一些位于頂行，可能不難數到 5 或 6。但我知道 Python 必須有一種更簡單的方法來定位我想要的那些。例如，我想要主隊和客隊：'strHomeTeam': 'Aston Villa', 'strAwayTeam': 'Liverpool',那么有沒有一種更簡單的方法來拉動“strHomeTeam”而不是一直計數到數組中的點呢？我意識到這是一個基本問題 - 我已經搜索了又搜索，但所有內容似乎都在一個非常小的數組中，并且它們似乎沒有解釋如何輕松地從大數組中獲取數據。JSON 文件位于：https://www.thesportsdb.com/api/v1/json/1/lookupevent.php ?id=1032723感謝您對此的幫助 - 我很感激。
3 回答
慕斯709654
TA貢獻1840條經驗 獲得超5個贊
那么有沒有一種更簡單的方法來拉動“strHomeTeam”而不是一直計數到數組中的點呢？
嘗試下面的方法
data = {"events": [
{"idEvent": "1032723", "idSoccerXML": "", "idAPIfootball": "592172", "strEvent": "Aston Villa vs Liverpool",
"strEventAlternate": "Liverpool @ Aston Villa",
"strFilename": "English Premier League 2020-10-04 Aston Villa vs Liverpool", "strSport": "Soccer",
"idLeague": "4328", "strLeague": "English Premier League", "strSeason": "2020-2021",
"strDescriptionEN": "Aston Villa and Liverpool square off at Villa Park, where last season, these teams produced one of the most exciting finishes of the campaign, as Liverpool scored twice late on to overturn an early Trezeguet goal.",
"strHomeTeam": "Aston Villa", "strAwayTeam": "Liverpool", "intHomeScore": "7", "intRound": "4",
"intAwayScore": "2", "intSpectators": "", "strOfficial": "", "strHomeGoalDetails": "", "strHomeRedCards": "",
"strHomeYellowCards": "", "strHomeLineupGoalkeeper": "", "strHomeLineupDefense": "",
"strHomeLineupMidfield": "", "strHomeLineupForward": "", "strHomeLineupSubstitutes": "",
"strHomeFormation": "", "strAwayRedCards": "", "strAwayYellowCards": "", "strAwayGoalDetails": "",
"strAwayLineupGoalkeeper": "", "strAwayLineupDefense": "", "strAwayLineupMidfield": "",
"strAwayLineupForward": "", "strAwayLineupSubstitutes": "", "strAwayFormation": "", "intHomeShots": "",
"intAwayShots": "", "strTimestamp": "2020-10-04T18:15:00+00:00", "dateEvent": "2020-10-04",
"dateEventLocal": "2020-10-04", "strDate": "", "strTime": "18:15:00", "strTimeLocal": "19:15:00",
"strTVStation": "", "idHomeTeam": "133601", "idAwayTeam": "133602", "strResult": "", "strVenue": "Villa Park",
"strCountry": "England", "strCity": "", "strPoster": "", "strFanart": "",
"strThumb": "https:\/\/www.thesportsdb.com\/images\/media\/event\/thumb\/r00vzl1601721606.jpg", "strBanner": "",
"strMap": "", "strTweet1": "https:\/\/twitter.com\/brfootball\/status\/1312843172385521665",
"strTweet2": "https:\/\/twitter.com\/TomJordan21\/status\/1312854281444306946",
"strTweet3": "https:\/\/twitter.com\/FutbolBible\/status\/1312847622592442370",
"strVideo": "https:\/\/www.youtube.com\/watch?v=0Nbw3jSafGM", "strStatus": "Match Finished", "strPostponed": "no",
"strLocked": "unlocked"}]}
filtered_data = [{'home':entry['strHomeTeam'],'away':entry['strAwayTeam']}for entry in data['events']]
print(filtered_data)
輸出
[{'home': 'Aston Villa', 'away': 'Liverpool'}]
慕無忌1623718
TA貢獻1744條經驗 獲得超4個贊
呃......我嘗試了一些不同的東西，它起作用了 - 嘆息......我很抱歉。
event_id = arr_events[0]['events'][0]['idEvent']
home_team = arr_events[0]['events'][0]['strHomeTeam']
away_team = arr_events[0]['events'][0]['strAwayTeam']
home_score = arr_events[0]['events'][0]['intHomeScore']
away_score = arr_events[0]['events'][0]['intAwayScore']
我認為這是正確的方法。
白豬掌柜的
TA貢獻1893條經驗 獲得超10個贊
您應該查看 https://python-json-pointer.readthedocs.io/en/latest/tutorial.html
檢查 json，獲取要訪問值的路徑 -> 使用https://github.com/stefankoegl/python-json-pointer
添加回答
舉報
0/150
提交
取消