擅长:python、mysql、java
<p>另一个解决方案是,regex可能会有一些不友好的外观,尽管它有强大的功能:</p>
<pre><code>columns = ['Time', '101 <RoomTemperature> (C)', '102 <ChemberTemperature> (C)', '103 <U1100> (C)', '103 <U1200 (C)', '103 U1500> (C)']
df = pd.DataFrame([[1,2,3,4,5,6]],columns=columns)
p = re.compile(r'((?<=<).*?(?=>))')
#create a dict for the replacement
replace_dict = {w:p.search(w).group() for w in df.columns if p.search(w)}
#pass dictionary into rename method
df.rename(columns=replace_dict)
</code></pre>