我有一個大數據框的問題。這是一個小片段。我想用最大值填充最后一列 E，如果有一些值或讓它為空。那就是數據：d = {'A': [4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074, 4000074], 'B': ['SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746','SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746', 'SP000796746'], 'C': [201926, 201926, 201926, 201926, 201926, 201926, 201909,201909, 201909, 201909, 201909, 201909, 201933, 201933, 201933, 201933, 201933, 201933], 'D': [-1, 0, 1, 2, 3, 4, -1, 0, 1, 2, 3, 4, -1, 0, 1, 2, 3, 4], 'E': [np.nan, 1000, 1000, np.nan, np.nan, np.nan, np.nan, np.nan, np.nan, np.nan, np.nan, np.nan, np.nan, np.nan, 3000, 3000, np.nan]}它看起來像這樣： A B C D E0 4000074 SP000796746 201926 -1 NaN1 4000074 SP000796746 201926 0 1000.02 4000074 SP000796746 201926 1 1000.03 4000074 SP000796746 201926 2 NaN4 4000074 SP000796746 201926 3 NaN5 4000074 SP000796746 201926 4 NaN6 4000074 SP000796746 201909 -1 NaN7 4000074 SP000796746 201909 0 NaN8 4000074 SP000796746 201909 1 NaN9 4000074 SP000796746 201909 2 NaN10 4000074 SP000796746 201909 3 NaN11 4000074 SP000796746 201909 4 NaN12 4000074 SP000796746 201933 -1 NaN13 4000074 SP000796746 201933 0 NaN14 4000074 SP000796746 201933 1 NaN15 4000074 SP000796746 201933 2 3000.016 4000074 SP000796746 201933 3 3000.017 4000074 SP000796746 201933 4 NaN
python pandas 用最大值填充 NaN 或毯子
慕無忌1623718
2022-12-06 17:29:11
