擅长:python、mysql、java
<p>这可以通过<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.split.html" rel="nofollow noreferrer">^{<cd1>}</a>实现:</p>
<pre><code>df['Type'], df['Parameter'] = df['variable'].str.split('_')
# BatchNumber PhaseNumber SiteID variable Values Type Parameter
# 0 4552694035 0020B 2 min_tempC 27.0 min max
# 1 4552694035 OverAll 2 max_tempF 24.0 tempC tempF
</code></pre>