擅长:python、mysql、java
<p>您可以考虑使用包<a href="https://github.com/datamade/usaddress" rel="nofollow noreferrer">usaddress</a>创建函数。当我需要将地址分成几部分时,这对我非常有帮助:</p>
<pre><code>import usaddress
df = pd.DataFrame(['123 Main St. Suite 100 Chicago, IL', '123 Main St. PO Box 100 Chicago, IL'], columns=['Address'])
</code></pre>
<p>然后创建用于分割数据的函数:</p>
^{pr2}$
<p>输出:</p>
<pre><code> Address Address1 Address2 City
0 123 Main St. Suite 100 Chicago, IL 123 Main St. Suite 100 Chicago
1 123 Main St. PO Box 100 Chicago, IL 123 Main St. PO Box 100 Chicago
</code></pre>