I have a dataframe, something like this
import pandas as pd dic = {'animal':["cat", "dog", "rabbit"], 'colour': ["yellow", None, "red"], 'size':[None, "large", "small"]} df = pd.DataFrame(dic) animal colour size 0 cat yellow None 1 dog None large 2 rabbit red small
I want to create a new column that contains True
if any other column is null and False
if not.
animal colour size bool 0 cat yellow None True 1 dog None large True 2 rabbit red small False
How do I do this?
Advertisement
Answer
There are 2 functions for that: pandas.isna
and pandas.any
:
df['bool'] = df.isna().any(axis = 1)