CODEWITHSUNDEEP
python
Chio
Chio

Reputation: 43

SUMPRODUCT two columns PYTHON

I am working on clipping loss coding.. I want an example code of how to SUMPRODUCT two columns

clipping = clipping_daily ['Column1'] * [int(x) for x in 'Column2'].sum(axis=1)

Upvotes: 1

Views: 764

Answers (3)

U13-Forward
U13-Forward

Reputation: 71560

I guess you meant:

clipping = clipping_daily['Column1'] * clipping_daily['Column2'].astype(int)

Or you mean by?

clipping = clipping_daily['Column1'] * clipping_daily['Column2'].astype(int).sum()

Upvotes: 2

CutePoison
CutePoison

Reputation: 5355

EDIT:

With some inspiration from U12-Forward answer to make it all pandas-operations

This should do it (if I understand your problem correctly)

sum_col_2 = clipping_daily['Column2'].astype(int).sum()
clipping = clipping_daily ['Column1'] * sum_col_2

or as one -liner

clipping = clipping_daily ['Column1'] * clipping_daily['Column2'].astype(int).sum()

Upvotes: 0

Dean Taler
Dean Taler

Reputation: 753

I think you better use groupby:

clipping  = df.groupby(['Column1', 'Column2']).sum()

Upvotes: 0

Related Questions