Trying to add the values in a list in python using for loop

Question

    id        POSTINGS  
     1     [9,9,9,9,9,9,9,9]
     2     [9,9,9,9,9,9,9,9]
     3     [9,0,0,0,0,0,0,0]
     4     [9,1,2,0,0,0,0,0]
     5     [9,9,9,9,9,9,9,9]
     6     [9,9,9,9,9,8,9,9]
     7     [9,9,9,9,9,9,8,9]
     8     [9,9,9,9,8,8,9,9]

Here i am trying to add a list of values in POSTING column and store the result in a new "SUM" column

Expected output

     id        POSTINGS               SUM
     1     [9,9,9,9,9,9,9,9]           56
     2     [9,9,9,9,9,9,8,8]           54
     3     [9,0,0,0,0,0,0,0]            9
     4     [9,1,2,0,0,0,0,0]           12
     5     [9,9,9,9,9,9,9,9]           56
     6     [9,9,9,9,9,8,9,9]           55
     7     [9,9,9,9,9,9,8,9]           55
     8     [9,9,9,9,8,8,9,9]           54

Is this R or Python?

s3bw
– s3bw

2017-10-23 17:02:40 +00:00
Commented Oct 23, 2017 at 17:02 — s3bw
– s3bw, Commented Oct 23, 2017 at 17:02
@giantslovedeathmetal in python

user8545255
– user8545255

2017-10-23 17:05:14 +00:00
Commented Oct 23, 2017 at 17:05 — user8545255
– user8545255, Commented Oct 23, 2017 at 17:05
Are you using Pandas?

s3bw
– s3bw

2017-10-23 17:05:50 +00:00
Commented Oct 23, 2017 at 17:05 — s3bw
– s3bw, Commented Oct 23, 2017 at 17:05
Yes @GiantsLoveDeathMetal

user8545255
– user8545255

2017-10-23 17:06:26 +00:00
Commented Oct 23, 2017 at 17:06 — user8545255
– user8545255, Commented Oct 23, 2017 at 17:06
Where is your code?

takendarkk
– takendarkk

2017-10-23 17:13:37 +00:00
Commented Oct 23, 2017 at 17:13 — takendarkk
– takendarkk, Commented Oct 23, 2017 at 17:13

s3bw · Accepted Answer · 2017-10-23 23:49:33Z

2

You can use the built-in sum function in apply and you'll get a column containing the sum of the list in POSTINGS:

df['SUM'] = df['POSTINGS'].apply(sum)

edited Oct 23, 2017 at 23:49

answered Oct 23, 2017 at 17:16

s3bw

3,0872 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Trying to add the values in a list in python using for loop

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related