擅长:python、mysql、java
<p>你可以像我一样搜索unicodes。也可以反转匹配:</p>
<pre><code>df.query("FirstName.str.contains(r'[\u4e00-\u9FFF]', regex=True) or LastName.str.contains(r'[\u4e00-\u9FFF]', regex=True)")
or
df[(df['FirstName'].str.contains(r'[\u4e00-\u9FFF]', regex=True)) | ( df['LastName'].str.contains(r'[\u4e00-\u9FFF]', regex=True))]
</code></pre>
<p>或者不匹配中文名字和姓氏:</p>
<pre><code>df[((df['FirstName'].str.contains(r'[\u4e00-\u9FFF]', regex=True)) | ( df['LastName'].str.contains(r'[\u4e00-\u9FFF]', regex=True))) & (~df['FirstName'].str.contains(r'[\u4e00-\u9FFF]', regex=True) | (~df['LastName'].str.contains(r'[\u4e00-\u9FFF]', regex=True)))]
</code></pre>
<p>输出:</p>
<pre><code> FirstName LastName
2 西德哈斯 supreet
3 yuvi 雷迪
5 sreeja 巴尔加维
</code></pre>