擅长:python、mysql、java
<p>使用列表理解创建删除列表并删除这些列</p>
<pre><code>d = {'instrument': {0: 'EURUSD', 1: 'NZDUSD'},
'Bid0Mkt': {0: 1.1, 1: 0.6},
'Bid1Mkt': {0: 1.2, 1: 0.65},
'Bid2Mkt': {0: 1.2, 1: 0.7},
'Bid3Mkt': {0: 1.3, 1: 0.9},
'Bid4Mkt': {0: 1.3, 1: 0.92},
'Another': {0: 1, 1: 2}}
df = pd.DataFrame(d)
remove = [col for col in df.columns if col.startswith('Bid') and int(col[3]) > 0]
new_df = df.drop(columns=remove)
instrument Bid0Mkt Another
0 EURUSD 1.1 1
1 NZDUSD 0.6 2
</code></pre>