擅长:python、mysql、java
<p>您可以使用<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.cat.html" rel="noreferrer">^{<cd1>}</a>和<code>na_rep</code>选项来填充<code>word</code>列,即使是<code>nan</code>中的一个源列,然后使用<code>str.strip</code>来修剪不在单词之间的任何前导/尾随<code>' , '</code>。你知道吗</p>
<pre><code>m['word'] = m['word_x'].str.cat(m['word_y'], sep=' , ', na_rep='').str.strip(' , ')
</code></pre>
<p>退货</p>
<pre><code> ID word_x word_y word
0 1 srv1 NaN srv1
1 2 srv2 srv12 srv2 , srv12
2 3 srv1 srv10 srv1 , srv10
3 4 NaN srv8 srv8
4 5 srv3 srv4 srv3 , srv4
5 6 srv1 srv7 srv1 , srv7
6 7 srv5 NaN srv5
7 8 NaN srv9 srv9
</code></pre>