| 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'依旧存在，未被删除
删除满足条件的行
df['event'] == 'VEH200110') &(df['event'] == 'VEH200217')
==>
df['event'] == 'VEH200110') |(df['event'] == 'VEH200217')