擅长:python、mysql、java
<p>首先需要使<code>NaN</code>字段为true,以度量它们是否为null,然后我们可以使用<code>isnull</code>后跟<code>.dot</code></p>
<pre><code>df['NullableFields'] = df.replace("null", np.nan).isnull().dot(df.columns)
print(df)
ID Animal Building Letter Fruit Number \
0 1 Dog House C null 4
1 2 null House null Apple null
2 3 Cat null B Orange null
3 4 null null null null 6
4 5 Snake null A null 7
NullFields NullableFields
0 Fruit Fruit
1 Animal, Letter, Number Animal Letter Number
2 Building, Number Building Number
3 Animal, Building, Letter, Fruit Animal Building Letter Fruit
4 Building, Fruit Building Fruit
</code></pre>