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)