priority expected actual high 47 30 medium 22 14 required 16 5 i'm trying create 2 other columns 'expected_values' have values row high 47*5, row medium 22*3,for row required 16*10 , 'actual_values' row high 30*5, row medium 14*3,for row required 5*10
like this
priority expected actual expected_values actual_values required 16 5 160 50 high 47 30 235 150 medium 22 14 66 42 any simple way in pandas or numpy?
try:
a = np.array([5, 3, 10]) df['expected_values'] = df.expected * df['actual_values'] = df.actual * print df priority expected actual expected_values actual_values 0 high 47 30 235 150 1 medium 22 14 66 42 2 required 16 5 160 50 