Pandas DataFrame按条件筛选数据后索引不连续问题的处理
方法一:直接引用不连续的索引
例如:
#df.index就是取当前索引,与索引是否连续无关
df['starttime_datetime']=[datetime.datetime.fromtimestamp(time.mktime(df['Start_Time_Format'][i])) for i in df.index]
方法二:重建索引
tmp=df['endtime-starttime'][0:10]
print(tmp)
print(tmp.shape)
0 00:05:21
5 00:09:46
18 00:07:14
21 00:11:53
23 00:15:17
25 00:25:59
27 00:03:35
31 00:43:30
32 00:16