You can provide this column to fillna
(see docs), it will use those values on matching indexes to fill:
In [17]: df['Cat1'].fillna(df['Cat2'])
Out[17]:
0 cat
1 dog
2 cat
3 ant
Name: Cat1, dtype: object
You can provide this column to fillna
(see docs), it will use those values on matching indexes to fill:
In [17]: df['Cat1'].fillna(df['Cat2'])
Out[17]:
0 cat
1 dog
2 cat
3 ant
Name: Cat1, dtype: object