Adding multiple elements of a single columns of dataframe in python

Question

dataframe = ax

Col1
0.98 0.076 0.09
0.81 0.01  0.378
0.12 0.33 0.001

I want to add these multiple elements of a single row which are separated by space in python such that my output be like

   Col1                    Summm
0.98 0.076 0.09        0.98+0.076+0.09          
0.81 0.01  0.378       0.81+0.01+0.378
0.12 0.33 0.001        0.12+0.33+0.001

I have tried this

summ = numpy.sum(array[0:len(ax),1:len(ax[0])],axis=1).tolist()

but this doesnt giv me proper output Any help would be much appreciated..Thanks

You can make an iterable over the rows and use the following numpy.sum([float(i) for i in str.split(Col1 , ' ')]) — Raja Sattiraju
– Raja Sattiraju, Commented May 29, 2017 at 13:51

Scott Boston · Accepted Answer · 2017-06-04 03:42:12Z

1

Let's try:

df.assign(Summm=df.Col1.str.split('\s+',expand=True).astype(float).sum(1))

Output:

               Col1  Summm
0   0.98 0.076 0.09  1.146
1  0.81 0.01  0.378  1.198
2   0.12 0.33 0.001  0.451

answered Jun 4, 2017 at 3:42

Scott Boston

154k15 gold badges160 silver badges207 bronze badges

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

1 Comment

Andre_k Over a year ago

This is good but,m but this solved my problem col1.sum(axis = 1);;Thanks anyways :)

Collectives™ on Stack Overflow

Adding multiple elements of a single columns of dataframe in python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related