擅长:python、mysql、java
<p>使用<code>str.split(series,expand=True)</code>和<code>join</code></p>
<pre><code>print(df)
Name
0 PPPP_OVS_ARG_MBC_MM-Models_RTNT_Always-On...
1 PPPP_OVS_ARG_MBC_MM-Models_RTNT_Always-On...
</code></pre>
<hr/>
<pre><code>s = df['Name'].str.split('_',expand=True)
df1 = df.join(
s.iloc[:,:3].join(
s.iloc[:,3:].agg('_'.join,axis=1).to_frame('string')
)
)
</code></pre>
<hr/>
<pre><code>print(df1)
</code></pre>
<p><a href="https://i.stack.imgur.com/D0ISm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/D0ISm.png" alt="enter image description here"/></a></p>
<h3>编辑以获取最后一个值。</h3>
<pre><code>df['last_value'] = df['Name'].str.split('_',expand=True).iloc[:,3]
</code></pre>