擅长:python、mysql、java
<p><strong>编码</strong>以获取索引:</p>
<pre><code>df.query('Sell.notna() | Buy.notna()').index
</code></pre>
<p><strong>输出:</strong></p>
<pre><code>Index(['2020-05-21', '2020-05-22'], dtype='object', name='Date')
</code></pre>
<p><strong>代码</strong>
获得过滤df</p>
<pre><code>df.query('Sell.notna() | Buy.notna()')
</code></pre>
<p><strong>输出</strong></p>
<pre><code> Close Upper SMA Lower Buy Sell
Date
2020-05-21 231.389999 219.042175 207.178002 195.313829 NaN 231.389999
2020-05-22 234.910004 222.051354 209.420002 196.788650 NaN 234.910004
</code></pre>