从我问 here 的问题中,我得到了一个类似于此的 JSON 响应:
(请注意:id 在我下面的示例数据中是数字字符串,但有些是字母数字)
data=↓**
{
"state": "active",
"team_size": 20,
"teams": {
"id": "12345679",
"name": "Good Guys",
"level": 10,
"attacks": 4,
"destruction_percentage": 22.6,
"members": [
{
"id": "1",
"name": "John",
"level": 12
},
{
"id": "2",
"name": "Tom",
"level": 11,
"attacks": [
{
"attackerTag": "2",
"defenderTag": "4",
"damage": 64,
"order": 7
}
]
}
]
},
"opponent": {
"id": "987654321",
"name": "Bad Guys",
"level": 17,
"attacks": 5,
"damage": 20.95,
"members": [
{
"id": "3",
"name": "Betty",
"level": 17,
"attacks": [
{
"attacker_id": "3",
"defender_id": "1",
"damage": 70,
"order": 1
},
{
"attacker_id": "3",
"defender_id": "7",
"damage": 100,
"order": 11
}
],
"opponentAttacks": 0,
"some_useless_data": "Want to ignore, this doesn't show in every record"
},
{
"id": "4",
"name": "Fred",
"level": 9,
"attacks": [
{
"attacker_id": "4",
"defender_id": "9",
"damage": 70,
"order": 4
}
],
"opponentAttacks": 0
}
]
}
}
我加载它使用:
df = json_normalize([data['team'], data['opponent']],
'members',
['id', 'name'],
meta_prefix='team.',
errors='ignore')
print(df.iloc(1))
attacks [{'damage': 70, 'order': 4, 'defender_id': '9'...
id 4
level 9
name Fred
opponentAttacks 0
some_useless_data NaN
team.name Bad Guys
team.id 987654321
Name: 3, dtype: object
我有一个本质上由 3 部分组成的问题。
如何使用成员标签获得像上面那样的行?我试过:
member = df[df['id']=="1"].iloc[0] #Now this works, but am I correctly doing this? #It just feels weird is all.如果仅记录攻击而不记录防御,我将如何检索成员的防御(即使给出了 defender_id)?我试过:
df.where(df['tag']==df['attacks'].str.get('defender_id'), df['attacks'], axis=0) #This is totally not working.. Where am I going wrong?由于我正在从 API 检索新数据,因此我需要检查数据库中的旧数据,看看是否有任何新的攻击。然后我可以遍历新的攻击,然后向用户显示攻击信息。
老实说,我想不通,我也尝试研究 this question 和 this one,我觉得它们都接近我需要的东西,但我仍然无法理解这个概念。本质上我的逻辑是这样的:
def get_new_attacks(old_data, new_data) '''params old_data: Dataframe loaded from JSON in database new_data: Dataframe loaded from JSON API response hopefully having new attacks returns: iterator over the new attacks ''' #calculate a dataframe with new attacks listed return df.iterrows()
我知道上面的函数除了我提供的文档外几乎没有任何努力 (基本上是为了显示我想要的输入/输出) 但相信我,我一直在为这部分绞尽脑汁最多。我一直在研究合并所有攻击然后执行reset_index() 并且由于攻击是一个列表而引发错误。我在上面链接的第二个问题中的 map() 函数让我很困惑。
请您参考如下方法:
按顺序引用您的问题(代码如下):
- 我看起来像
id是数据的唯一索引,所以你可以使用df.set_index('id')它允许你通过玩家 ID 访问数据例如通过df.loc['1']。 - 据我了解你的数据,每个
攻击中列出的所有字典都是自包含的,因为不需要相应的玩家 ID(如attacker_id或defender_id似乎足以识别数据)。因此,与其处理包含列表的行,我建议将该数据交换到它自己的数据框中,这样可以轻松访问。 - 一旦您将
攻击存储在它自己的数据框中,您就可以简单地比较索引以过滤掉旧数据。
下面是一些示例代码来说明各个要点:
# Question 1.
df.set_index('id', inplace=True)
print(df.loc['1']) # For example player id 1.
# Question 2 & 3.
attacks = pd.concat(map(
lambda x: pd.DataFrame.from_dict(x).set_index('order'), # Is 'order' the right index?
df['attacks'].dropna()
))
# Question 2.
print(attacks[attacks['defender_id'] == '1']) # For example defender_id 1.
# Question 3.
old_attacks = attacks.iloc[:2] # For example.
new_attacks = attacks[~attacks.index.isin(old_attacks.index)]
print(new_attacks)
