df['real_lastName'] = np.where(df['LastName'].isnull(), df['Middle'], df['LastName'] ) print (df) FirstName Middle LastName real_lastName 0 Tom Ju NaN Ju 1 Kity NaN Rob Rob