擅长:python、mysql、java
<p>这样做可以:</p>
<pre><code># if ID is index, then just `df` instead of `df.iloc[...]
s = df.iloc[:,1:].isna()
df['NullFields'] = (s @ (s.columns + (', '))).str.strip(', ')
</code></pre>
<p>输出:</p>
<pre><code> ID Animal Building Letter Fruit Number NullFields
0 1 Dog House C NaN 4.0 Fruit
1 2 NaN House NaN Apple NaN Animal, Letter, Number
2 3 Cat NaN B Orange NaN Building, Number
3 4 NaN NaN NaN NaN 6.0 Animal, Building, Letter, Fruit
4 5 Snake NaN A NaN 7.0 Building, Fruit
</code></pre>