擅长:python、mysql、java
<p><strong>进近#1</strong></p>
<p>对于带有<code>ints</code>的数据帧,这里有一个带有<code>bincount</code>的矢量化数据帧-</p>
<pre><code># https://stackoverflow.com/a/46256361/ @Divakar
def bincount2D_vectorized(a):
N = a.max()+1
a_offs = a + np.arange(a.shape[0])[:,None]*N
return np.bincount(a_offs.ravel(), minlength=a.shape[0]*N).reshape(-1,N)
out = df[(bincount2D_vectorized(df.values)<=3).all(1)]
</code></pre>
<p>样本输出-</p>
<pre><code>In [563]: df[(bincount2D_vectorized(df.values)<=3).all(1)]
Out[563]:
A B C D E F G
0 1 4 9 4 6 9 8
3 2 6 9 5 4 4 5
4 2 8 1 9 5 8 9
5 2 2 2 5 6 3 6
</code></pre>