pandas ：如何消除以特定字符结尾的值的行？ [英] pandas: how to eliminate rows with value ending with a specific character?

问题描述

我有一个熊猫DataFrame，如下所示：

I have a pandas DataFrame as follows:

mail = DataFrame({'mail' : ['[e-mail]', '[e-mail]', '[e-mail]', '[e-mail]', '[e-mail]', '[e-mail]', '[e-mail]']})

如下所示：

                    mail
0          [e-mail]
1        [e-mail]
2       [e-mail]
3   [e-mail]
4  [e-mail]
5  [e-mail]
6       [e-mail]

我想做的是过滤掉（删除）所有列邮件中以 @ gmail.com结尾的行。

What I want to do is to filter out (elimiante) all those rows in which the value in the column mail ends with '@gmail.com'.

推荐答案

您可以使用 str.endswith 并使用〜：

mail[~mail['mail'].str.endswith('@gmail.com')]

会产生以下内容：

                    mail
2       [e-mail]
3   [e-mail]
4  [e-mail]
5  [e-mail]
6       [e-mail]

熊猫还有许多其他向量化的字符串操作，可通过 .str 访问器进行访问。其中许多都是Python自己的字符串方法立即为您所熟悉，但它们会以处理 NaN 值的方式构建。

Pandas has many other vectorised string operations which are accessible through the .str accessor. Many of these are instantly familiar from Python's own string methods, but come will built in handling of NaN values.

这篇关于 pandas ：如何消除以特定字符结尾的值的行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！