python - 将字典与 DataFrame 中的列和索引匹配 | Python
问题描述
我有一个数据框,其列名如示例,索引从 0 到 1000。数据框用零填充。
House 1 | House 2 | House 5 | House 8 | ...
0
1
2
3
4...
然后,我有字典,例如:
dict_of_houses = {'House 1':[100,201,306,387,500,900],'House 2':[31,87,254,675,987],'House 5':[23,45,67,123,345,654,789,808,864,987,999],'House 8':[23,675,786,858,868,912,934]}
字典名称已编辑,以免以后混淆任何人。
我的目标是:
- 对于每个 dict 键,将其与列匹配
- 将列表中的每个数字作为字典值与索引匹配
- 如果索引和列匹配,则将单元格更改为 1
- 否则:留零
你会怎么做?
解决方案
您可以使用for
循环:
for house, indices in dict_.items():
df.loc[indices, house] = 1
推荐阅读
- javascript - Angular JS, JSON via extern Libary Function not storing in $scope
- microprocessors - How to do Interfacing of Dot Matrix display with 8088 microprocessor using MDA-8086 Trainer?
- javascript - missing 2 required positional arguments but I don't want them to be arguments to begin with?
- webrtc - How to send to Chrome-cast the CMSampleBuffer from iOS Replaykit?
- django - TypeError: expected str, bytes or os.PathLike object, not FieldFile while show pdf from DB
- swift - Swift: Parse does not load a video from URL
- c++ - Can you help to find some mistake in the code?
- reactjs - Building own custom backend server in nextjs
- javascript - Decoding nested objects in Javascript
- c++ - 修复 C++ 编译器错误 - 多重定义