我有一個看起來像這樣的表：Dates, Minutes1/24/2020 2:58:04 PM, 01/24/2020 3:13:04 PM, 01/27/2020 10:04:09 AM, 31/27/2020 10:19:09 AM, 01/27/2020 10:34:09 AM, 01/27/2020 10:49:10 AM, 11/27/2020 11:04:09 AM, 01/27/2020 11:19:09 AM, 11/27/2020 11:34:09 AM, 11/27/2020 11:49:09 AM, 01/27/2020 12:04:09 PM, 131/27/2020 12:19:09 PM, 01/27/2020 12:34:09 PM, 01/27/2020 12:49:09 PM, 01/27/2020 1:04:09 PM, 111/27/2020 1:19:09 PM, 261/27/2020 1:34:09 PM, 411/27/2020 1:49:09 PM, 01/27/2020 2:04:09 PM, 01/27/2020 2:19:09 PM, 121/27/2020 2:34:09 PM, 0我正在檢查當前行與前一行之間的差異是否大于或等于 15，如果是，則將值更改為 15。因此新表如下所示：Dates, Minutes1/24/2020 2:58:04 PM, 01/24/2020 3:13:04 PM, 01/27/2020 10:04:09 AM, 31/27/2020 10:19:09 AM, 01/27/2020 10:34:09 AM, 01/27/2020 10:49:10 AM, 11/27/2020 11:04:09 AM, 01/27/2020 11:19:09 AM, 11/27/2020 11:34:09 AM, 11/27/2020 11:49:09 AM, 01/27/2020 12:04:09 PM, 131/27/2020 12:19:09 PM, 01/27/2020 12:34:09 PM, 01/27/2020 12:49:09 PM, 01/27/2020 1:04:09 PM, 111/27/2020 1:19:09 PM, 15*1/27/2020 1:34:09 PM, 15*1/27/2020 1:49:09 PM, 01/27/2020 2:04:09 PM, 01/27/2020 2:19:09 PM, 121/27/2020 2:34:09 PM, 0*=值改變
2 回答
臨摹微笑
TA貢獻1982條經(jīng)驗 獲得超2個贊
.loc使用&的另一種方法shift
df.loc[(df['Minutes'] - df['Minutes'].shift(1)).ge(15),'Minutes'] = 15
print(df)
Dates Minutes
0 1/24/2020 2:58:04 PM 0
1 1/24/2020 3:13:04 PM 0
2 1/27/2020 10:04:09 AM 3
3 1/27/2020 10:19:09 AM 0
4 1/27/2020 10:34:09 AM 0
5 1/27/2020 10:49:10 AM 1
6 1/27/2020 11:04:09 AM 0
7 1/27/2020 11:19:09 AM 1
8 1/27/2020 11:34:09 AM 1
9 1/27/2020 11:49:09 AM 0
10 1/27/2020 12:04:09 PM 13
11 1/27/2020 12:19:09 PM 0
12 1/27/2020 12:34:09 PM 0
13 1/27/2020 12:49:09 PM 0
14 1/27/2020 1:04:09 PM 11
15 1/27/2020 1:19:09 PM 15
16 1/27/2020 1:34:09 PM 15
17 1/27/2020 1:49:09 PM 0
18 1/27/2020 2:04:09 PM 0
19 1/27/2020 2:19:09 PM 12
20 1/27/2020 2:34:09 PM 0
添加回答
舉報
0/150
提交
取消