pandas add column tutors = ['William', 'Henry', 'Michael', 'John', 'Messi'] df2 = df.assign(TutorsAssigned=tutors) OR df2=df.assign(Discount_Percent=lambda x: x.Fee * x.Discount / 100) filter rows df[df.apply(lambda x: x['b'] > x['c'], axis=1)]