擅长:python、mysql、java
<p>您可以将功能提取到函数中并执行以下操作:</p>
<pre><code>import re
import pandas as pd
# sample data
df = pd.DataFrame(
columns=['Time', '101 <RoomTemperature> (C)', '102 <ChemberTemperature> (C)', '103 <U1100> (C)', '103 <U1200 (C)',
'103 U1500> (C)'])
# replacement function
def repl(name):
match = re.search(r"<(.*?)>", name)
return match.group(1) if match else name
df.rename(columns={c: repl(c.strip()) for c in df.columns}, inplace=True)
print(df.columns)
</code></pre>
<p><strong>输出</strong></p>
<pre><code>Index(['Time', 'RoomTemperature', 'ChemberTemperature', 'U1100',
'103 <U1200 (C)', '103 U1500> (C)'],
dtype='object')
</code></pre>
<p>也就是说,您还需要修复正则表达式</p>