擅长:python、mysql、java
<p>有了您展示的样品,请尝试以下内容。在这里使用Pandas的<a href="https://pandas.pydata.org/docs/reference/api/pandas.Series.str.extract.html" rel="nofollow noreferrer">^{<cd1>}</a>函数。简单的解释是:在extract中提到regex以在DataFrame中创建3个新列。它基本上是根据显示的示例为每个新字段创建3个捕获组</p>
<pre><code>df[["first", "second", "third"]] = df['val'].str.extract(r'^([^,]*),([^,]*),(.*)$',expand=True)
</code></pre>
<p><a href="https://regex101.com/r/fHNYGc/3" rel="nofollow noreferrer">Here is online demo of above regex</a></p>
<p>df的输出如下所示:</p>
<pre><code> val first second third
0 V583 ,ATTENTION, PRIMARY V583 ATTENTION PRIMARY
1 Y9207,INDOOR LIVING, sEcondary Y9207 INDOOR LIVING sEcondary
2 z526, liver,primary z526 liver primary
3 12345678, test, secondary 12345678 test secondary
4 ,project, project
</code></pre>