擅长:python、mysql、java
<p>您需要排除带有<code>NaN</code>vlaues的列,一种方法如下:</p>
<pre class="lang-py prettyprint-override"><code>pd.concat([df, df.dropna().apply(lambda x: get_date_list(x), axis=1).to_frame('Months_List')], axis=1)
</code></pre>
<p><strong>输出</strong>:</p>
<pre class="lang-py prettyprint-override"><code>Out[169]:
Month1 Month2 Months_List
0 Mar2020 Dec2020 Mar 2020,Apr 2020,May 2020,Jun 2020,Jul 2020,A...
1 Nov2020 Jan2021 Nov 2020,Dec 2020,Jan 2021
2 NaN NaN NaN
3 Sep2020 Feb2021 Sep 2020,Oct 2020,Nov 2020,Dec 2020,Jan 2021,F...
4 Oct2020 Dec2020 Oct 2020,Nov 2020,Dec 2020
5 NaN NaN NaN
6 Dec2020 Mar2021 Dec 2020,Jan 2021,Feb 2021,Mar 2021
7 Dec2020 Mar2021 Dec 2020,Jan 2021,Feb 2021,Mar 2021
</code></pre>