擅长:python、mysql、java
<p><strong>选项1</strong><br/>
^基于{<cd1>}的过滤</p>
<pre><code>df[df.iloc[:, 1:3].apply(pd.to_numeric, errors='coerce').notnull().all(1)]
Title Recipe Start Recipe End Year
0 cookie 500 400 2013
1 soup 600 650 1993
</code></pre>
<hr/>
<p><strong>选项2</strong><br/>
<code>str.isdigit</code></p>
^{pr2}$
<p>如果这些是对象列,则需要事先转换为<code>str</code>,然后可以对这些列使用<code>str</code>访问器方法:</p>
<pre><code>i = df['Recipe Start'].astype(str).str.isdigit()
j = df['Recipe End'].astype(str).str.isdigit()
df[i & j]
</code></pre>
<hr/>
<p><strong>选项3</strong><br/>
<code>applymap</code>+<code>str.isdigit</code></p>
<pre><code>df[df.iloc[:, 1:3].astype(str).applymap(str.isdigit).all(1)]
Title Recipe Start Recipe End Year
0 cookie 500 400 2013
1 soup 600 650 1993
</code></pre>