擅长:python、mysql、java
<p>只需添加和删除合并列,即可完成:</p>
<pre><code>df_seg['merge_col'] = df_seg.Country.apply(lambda x: x.split('-')[0])
df_g['merge_col'] = df_g.Country.apply(lambda x: x.split('-')[0])
</code></pre>
<p>然后做:</p>
<pre><code>df = pd.merge(df_g, df_seg[['merge_col', 'Precio']], on='merge_col', how='left').drop('merge_col', 1)
</code></pre>
<p>退货</p>
<pre><code>Sitio Country Precio
0 Los Andes Online HN - Honduras 0.5
1 Guarda14 US - Estados Unidos 2.1
2 Guarda14 PE - Peru NaN
</code></pre>