擅长:python、mysql、java
<p>使用<code>dropna</code>和<code>agg.join</code>筛选<code>NaN</code>并分配回:</p>
<pre><code>df['col_list'] = df.col_list.dropna().agg(', '.join)
Out[205]:
id col_list
0 1 Lorem ipsum dolor sit amet, Donec non sem convallis, vulputate odio
1 2 NaN
2 3 Mauris diam purus, luctus in rutrum venenatis, eros in luctus lobortis
3 4 Lorem ipsum dolor sit amet
</code></pre>