擅长:python、mysql、java
<p>您已经在正确的轨道上了,我刚刚添加了代码来删除不满足条件的行</p>
<pre><code>import pandas as pd
df = pd.DataFrame({'scientist':["Wendelaar Bonga"," Sjoerd E.", "Grätzel"," Michael", "Willett", "Walter C.",
"Kessler", "Ronald C.", "Witten, Edward", "Wang, Zhong Lin"],
'SubjectField': ["Biomedical Engineering", "Inorganic & Nuclear Chemistry",
"Organic Chemistry", "Biomedical Engineering", "Developmental Biology",
"Mechanical Engineering & Transports", "Biomedical Engineering", "Microbiology",
"Cardiovascular System & Hematology", "Biomedical Engineering"]})
x = df.groupby('SubjectField')['scientist'].count()
</code></pre>
<p>您可以使用<code>drop</code>和参数<code>index</code>来删除与条件不匹配的行</p>
<blockquote>
<p>Tilde <code>~</code> is used as the negation to fetch the opposite of a condition</p>
</blockquote>
<pre><code>drop_idx = x[~(x > 2)].index.values
x = x.drop(index=drop_idx)
</code></pre>
<p><code>x</code>将只包含计数大于2的行</p>