<p>我注意到您可以使用以下正则表达式模式将地址列拆分为地址和郊区:</p>
<blockquote>
<p>number word word <em><strong>split here</strong></em> word</p>
</blockquote>
<pre><code>(df["Address Column"]
.str.extract("(?P<Address>.*\d+[\w+?|\s]\s?\w+\s+\w+),?\s(?P<Suburb>.*$)")
.apply(lambda x: x.str.title()))
</code></pre>
<p>输出:</p>
<pre><code> Address Suburb
0 4A Mcarthurs Road Altona North
1 1 Neal Court Altona North
2 4 Vermilion Drive Greenvale
3 Lot 307 Bonds Lane Greenvale
4 430 Blackshaws Rd Altona North
5 159 Bonds Lane Greenvale
6 Lot 1105 4 Compass Drive Greenvale
7 6005 Bethany Dr Tarneet
8 Lot 655 Potofino Way Wollert
9 Lot 403 Binds Lane Greenvale
10 157 Maidstone Street Altona
11 11 Laramie Street Greenvale
12 10 Preveli Way Wollert
13 21 Laramie Street Greenvale
14 20 Taipan Crt Tarneit
15 4 Bisect Road Greenvale
16 83 Everton Road Truganina
17 Lot 450 Vermilion Drive Greenvale
18 Lot 641 Preveli Way Wollert
19 648 Hogans Rd Tarneit
</code></pre>
<p><em><strong>注意:</strong></em>我相信这个正则表达式会更整洁</p>