擅长:python、mysql、java
<p>如果您确定regex中的逗号<code>,</code>或空白<code/> you could use:</p>
^{pr 1}$
<hr/>
<p><strong>Explanation:</strong> <a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.str.split.html" rel="nofollow noreferrer">str.split</a> accepts a pat (pattern) parameter: String or <strong>regular expression</strong> to split on. If not specified, split on whitespace. Using the fact we can pass a regular expression this becomes an easy task as <code>[ ,]</code>表示<code/>或<code>,</code>。在</p>
<p>另一种选择是使用<code>' |,'</code>,或者如果可以有多个空格<code>'\s+|,'</code></p>
<hr/>
<p>完整示例:</p>
^{pr2}$
<p>退货:</p>
<pre><code> address Street Colony City
0 a,b,c a b c
1 a b c a b c
</code></pre>