我有一个几百行和十几列的数据帧.我需要创建一个新列,其中每个单元格都是True
或False
,这将通过将相邻的值与矩阵中的最大值进行比较来确定,该矩阵由来自原始值不属于的行和列的值组成.
我try 通过pandas
和NumPy
创建矩阵中的值列表.我还try 使用openpyxl
和Excel中的数据来编制该列表.我只是想不出如何引用不是当前行的行.
需要明确的是,我希望根据单元格E1
中的6
大于A2:D5
矩阵中的任何值的事实来生成单词True
in column F
:
整个F列应该填满True
或False
(except near the end where there aren't enough values, which will not matter).
编辑以显示实际数据:
{'Unnamed: 0': [datetime.datetime(2022, 2, 14, 0, 0), datetime.datetime(2022, 2, 8, 0, 0), datetime.datetime(2022, 2, 16, 0, 0), datetime.datetime(2022, 2, 9, 0, 0), datetime.datetime(2022, 2, 7, 0, 0)],
'A': [86.3600006103515, 91.1299972534179, 87.9199981689453, 99.4199981689453, 89.8399963378906],
'B': [86.3600006103515, 91.1299972534179, 87.9199981689453, 99.4199981689453, 89.8399963378906],
'C': [93.7399978637695, 92.2099990844726, 93.4599990844726, 99.6900024414062, 90.370002746582],
'D': [85.3799972534179, 89.0100021362304, 86.5299987792968, 91.6999969482421, 85.3199996948242],
'E': [92.870002746582, 89.8499984741211, 87.8399963378906, 98.1800003051757, 85.6600036621093],
'F': [91.8566665649414, 88.8299967447916, 87.6700007120768, 93.4633305867513, 88.3333307902018],
'G': [93.2239990234375, 88.2079986572265, 90.4440002441406, 91.1099975585937, 87.0139999389648],
'H': [90.1189994812011, 88.8899993896484, 90.7769989013672, 89.4299995422363, 89.4699996948242],
'I': [91.8989994049072, 93.9099994659423, 91.107999420166, 93.5399993896484, 94.8799995422363],
'J': [98.1313329060872, 101.261666107177, 95.9039995829264, 100.749666086832, 102.087999471028]}