擅长:python、mysql、java
<p>您可以按<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.query.html" rel="nofollow noreferrer">^{<cd2>}</a>筛选出<code>0</code>值,并通过<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.idxmin.html" rel="nofollow noreferrer">^{<cd3>}</a>获得最小值的索引,最后按<code>loc</code>选择:</p>
<pre><code>s = df.loc[df.query('time != 0')['time'].idxmin()]
print (s)
x 240.0
y 19.0
time 9.7
Name: 3, dtype: float64
df = df.loc[[df.query('time != 0')['time'].idxmin()]]
print (df)
x y time
3 240 19 9.7
</code></pre>