擅长:python、mysql、java
<p>你可以试试<code>str.replace</code>
找到的正则表达式的详细信息<a href="https://regex101.com/r/VVGojz/1" rel="nofollow noreferrer">here</a></p>
<pre class="lang-py prettyprint-override"><code>df = pd.DataFrame(['date','customer','region[level1]','priority[s2]','planning[WIP]'], columns=['col'])
df['col'].str.replace(r'(.*\[)|(\].*)', '', regex=True)
# 0 date
# 1 customer
# 2 level1
# 3 s2
# 4 WIP
# Name: col, dtype: object
</code></pre>
<p>更改列名的步骤</p>
<pre class="lang-py prettyprint-override"><code>df = pd.DataFrame([[1,1,1,1,1]], columns=['date','customer','region[level1]','priority[s2]','planning[WIP]'])
df.columns = df.columns.str.replace(r'(.*\[)|(\].*)', '', regex=True)
# date customer level1 s2 WIP
# 0 1 1 1 1 1
</code></pre>