擅长:python、mysql、java
<p>给定数据帧</p>
<pre><code>df = pd.DataFrame({'Name': ['ABC'], 'Address': ['Line1, Line2, LineN, PostCode']})
Address Name
0 Line1, Line2, LineN, PostCode ABC
</code></pre>
<p>如果只需要post代码,可以使用rsplit提取它并将其重新分配给列地址。它会帮你省下一步。在</p>
^{pr2}$
<p>你得到了</p>
^{3}$
<p>编辑:给你一个数据帧,地址值在列表中</p>
<pre><code>df = pd.DataFrame({'Name': ['FAUCET INN LIMITED'], 'Address': [['Union, 88-90 George Street, London, W1U 8PA']]})
Address Name
0 [Union, 88-90 George Street, London, W1U 8PA] FAUCET INN LIMITED
</code></pre>
<p>您可以使用</p>
<pre><code>df['Address'] = df['Address'].apply(lambda x: x[0].split(',')[-1])
</code></pre>
<p>你得到了</p>
<pre><code> Address Name
0 W1U 8PA FAUCET INN LIMITED
</code></pre>