Pandas sumproduct

Question

I have a df:

Value1  Value2  1   2   3
  1       A     0   1   2
  2       B     3   4   5
  3       C     2   2   2

I want to perform sumproduct between the rows and the columns 1 2 3:

Value1  Value2  1   2   3   sumproduct
  1       A     0   1   2   8    = 0*1 + 1*2 + 2*3
  2       B     3   4   5   26   = 3*1 + 4*2 + 5*3
  3       C     2   2   2   12   = 2*1 + 2*2 + 2*3

I've tried (df.values*df.columns.values).sum(1) but then I need to drop Value1 and Value2 columns first. Is there a better approach?

Many thanks!

Answer 1

What I will do

df.iloc[:,2:].dot([1,2,3])
Out[239]: 
0     8
1    26
2    12
dtype: int64

To make it automatic

s=df.iloc[:,2:]

s.dot(s.columns.astype(int))
Out[242]: 
0     8
1    26
2    12
dtype: int64