users = {"Angelica": {"Blues Traveler": 3.5, "Broken Bells": 2.0, "Norah
Jones": 4.5, "Phoenix": 5.0, "Slightly Stoopid": 1.5, "Pantera": 2.5,
"Metallica": 2.0}, "Bill":{"Blues Traveler": 2.0, "Broken Bells": 3.5,
"Deadmau5": 4.0, "Phoenix": 2.0, "Slightly Stoopid": 3.5, "Metallica": 3.0,
"Norah Jones": 5.0}}
pd.DataFrame(users).transpose().to_dict()
>>>{'Blues Traveler': {'Angelica': 3.5, 'Bill': 2.0}, 'Broken Bells':
{'Angelica': 2.0, 'Bill': 3.5}, 'Deadmau5': {'Angelica': **nan**, 'Bill':
4.0}, 'Metallica': {'Angelica': 2.0, 'Bill': 3.0}, 'Norah Jones':
{'Angelica': 4.5, 'Bill': 5.0}, 'Pantera': {'Angelica': 2.5, 'Bill':
**nan**}, 'Phoenix': {'Angelica': 5.0, 'Bill': 2.0}, 'Slightly Stoopid':
{'Angelica': 1.5, 'Bill': 3.5}}
我想要一个字典,当值为**nan**时,内部字典中的所有键和值都被删除:即'Angelica':**nan**和'Bill':**nan** .
我的代码:
for key in pd.DataFrame(users).transpose().to_dict():
for k in pd.DataFrame(users).transpose().to_dict()[key]:
if math.isnan(pd.DataFrame(users).transpose().to_dict()[key][k]) == False:
listA.append((key, (k, pd.DataFrame(users).transpose().to_dict()
[key][k])))
没有值的期望输出:
>>>{'Blues Traveler': {'Angelica': 3.5, 'Bill': 2.0}, 'Broken Bells':
{'Angelica': 2.0, 'Bill': 3.5}, 'Deadmau5': {'Bill': 4.0}, 'Metallica':
{'Angelica': 2.0, 'Bill': 3.0}, 'Norah Jones': {'Angelica': 4.5, 'Bill':
5.0}, 'Pantera': {'Angelica': 2.5, 'Phoenix': {'Angelica': 5.0, 'Bill':
2.0}, 'Slightly Stoopid': {'Angelica': 1.5, 'Bill': 3.5}}
请您参考如下方法:
你可以为此使用一个defaultdict:
from collections import defaultdict
def transpose(dct):
d = defaultdict(dict)
for key1, inner in dct.items():
for key2, value in inner.items():
d[key2][key1] = value
return d
