擅长:python、mysql、java
<p>另一种方法</p>
<pre><code>df=pd.DataFrame({'hobbiesStrings':['"hobby1, hobby2"']})
df
</code></pre>
<p>用<code>","</code>替换<strong>、空格</strong>,并将<code>hobbiesStrings</code>值放入列表中</p>
<pre><code>x=df.hobbiesStrings.str.replace('((?<=)(\,\s+)+)','","').values.tolist()
x
</code></pre>
<p>这里我使用正则表达式
基本上,我用<code>","</code>替换<code>comma \,</code>后面的空格<code>\s</code></p>
<p>使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.DataFrame.assign.html" rel="nofollow noreferrer">df.assign</a>重写列s</p>
<pre><code>df=df.assign(hobbies_stringsnes=[x])
</code></pre>
<p>拴在一起</p>
<pre><code> df=df.assign(hobbies_stringsnes=[df.hobbiesStrings.str.replace('((\,\s))','","').values.tolist()])
df
</code></pre>
<p>输出</p>
<p><a href="https://i.stack.imgur.com/jyfXs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/jyfXs.png" alt="enter image description here"/></a></p>