擅长:python、mysql、java
<p>使用提取物</p>
<pre><code>new_df = df['col'].str.extract('(val.*)?(.*)').replace('', np.nan).rename(columns = {1:'Country', 0:'Value'})
new_df['Country'] = new_df['Country'].ffill()
new_df.dropna(inplace = True)
Value Country
1 valA Japan
2 valB Japan
4 valC Ghana
5 valD Ghana
</code></pre>