当tenant列含wcdma时删除指定行数据的单行实现方法咨询
2026-8-8
用单行代码实现目标行过滤
先把你的数据样本整理成表格形式：
| CIRCLE | RecordDate | tenant | name | value |
|---|---|---|---|---|
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Cells with RCA | 55 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Cells with RCA (%) | 55 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Cells with CIC Issues | 99 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Cells with CIC Issues (%) | 99 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Cells with UIC Issues | 99 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Cells with UIC Issues (%) | 99 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | No PM data found | 0 |
| ATM_AL_WCDMA | 2022-12-08 | atmdza#wcdma | Null counters | 0 |
单行实现代码
假设你的数据存在名为df的Pandas DataFrame中，直接用布尔索引过滤即可：
df = df[~((df['tenant'].str.contains('wcdma')) & (df['name'] == 'Cells with RCA (%)'))]
代码逻辑说明
df['tenant'].str.contains('wcdma')：判断每行的tenant列是否包含"wcdma"字符串df['name'] == 'Cells with RCA (%)'：判断name列是否为目标值&：同时满足两个条件的行即为需要删除的行~：取反，保留不满足删除条件的所有行- 赋值回
df即完成目标行的删除操作，tenant列的内容会完整保留
内容的提问来源于stack exchange，提问作者Indranil
相关产品推荐
相关产品推荐
