问题遇到的现象和发生背景
trip_start_time | trip_end_time | event |
---|---|---|
2022-09-01 11:00:01 | 2022-09-01 12:34:08 | VEH200110 |
2022-09-02 13:35:09 | 2022-09-02 14:02:07 | VEH200217 |
2022-09-03 12:02:09 | 2022-09-03 18:12:24 | VEH200220 |
2022-09-03 19:07:32 | 2022-09-04 03:14:53 | AIR900004 |
想清洗掉event为'VEH200110'和'VEH200217'的所在行
问题相关代码,请勿粘贴截图
import pandas as pd
df = pd.read_excel('test.xlsx')
clear_df = df.drop(df[(df['event'] == 'VEH200110') & (df['event'] == 'VEH200217')].index)
clear_df
运行结果及报错内容
trip_start_time trip_end_time event
0 2022-09-01 11:00:01 2022-09-01 12:34:08 VEH200110
1 2022-09-02 13:35:09 2022-09-02 14:02:07 VEH200217
2 2022-09-03 12:02:09 2022-09-03 18:12:24 VEH200220
3 2022-09-03 19:07:32 2022-09-04 03:14:53 AIR900004
'VEH200110'和'VEH200217'依旧存在,未被删除
我想要达到的结果
删除满足条件的行