Nov-09-2020, 03:06 PM
Hi,
I have below data:
df1:
time1 time2
2020/11/05 20:30:23 2020/11/05 20:20:23
2020/11/05 20:40:12 2020/11/05 20:20:23
2020/11/05 20:49:53 2020/11/05 20:20:23
2020/11/05 20:56:28 2020/11/05 20:20:23
df2:
time
2020/11/05 20:36:23
I want to get df1 row indices (1) time2 > time, 2. time1 should be close (minimum difference).
How to get this.
I can only filter
df1_filter = df1[df1['time1'] < df2['time'], but after this I sruck how to get match the (1) time2 > time, 2. time1 should be close (minimum difference).
Please kindly someone help,
I have below data:
df1:
time1 time2
2020/11/05 20:30:23 2020/11/05 20:20:23
2020/11/05 20:40:12 2020/11/05 20:20:23
2020/11/05 20:49:53 2020/11/05 20:20:23
2020/11/05 20:56:28 2020/11/05 20:20:23
df2:
time
2020/11/05 20:36:23
I want to get df1 row indices (1) time2 > time, 2. time1 should be close (minimum difference).
How to get this.
I can only filter
df1_filter = df1[df1['time1'] < df2['time'], but after this I sruck how to get match the (1) time2 > time, 2. time1 should be close (minimum difference).
Please kindly someone help,