擅长:python、mysql、java
<p>IIUC公司:</p>
<pre><code>df = df.loc[:, df.columns.astype(str).str.contains('\d') | df.columns.isin(['Name','Id'])]
</code></pre>
<p>演示:</p>
<pre><code>In [224]: df
Out[224]:
Name Id xyz ijk 1 2 3 val1 val2
0 1 2 3 4 5 6 7 8 9
In [225]: df = df.loc[:, df.columns.astype(str).str.contains('\d') | df.columns.isin(['Name','Id'])]
In [226]: df
Out[226]:
Name Id 1 2 3 val1 val2
0 1 2 5 6 7 8 9
</code></pre>