擅长:python、mysql、java
<p>我们还可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.query.html" rel="nofollow noreferrer">^{<cd1>}</a>方法进行过滤,结合pandas方法<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.mod.html" rel="nofollow noreferrer">^{<cd2>}</a>和<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.eq.html" rel="nofollow noreferrer">^{<cd3>}</a>表示<code>equal</code>:</p>
<pre><code>df = df.query('ones.mod(5).eq(0) | zeros.mod(3).eq(0)')
ones zeros
5 10 6
6 11 6
9 4 6
13 14 3
26 6 12
29 9 9
30 10 9
33 4 6
35 5 11
36 7 9
42 5 8
43 5 7
44 5 8
46 11 3
48 7 6
49 8 12
53 8 3
55 9 3
57 9 6
59 4 3
</code></pre>