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, May 29 '17 at 13:51

score 1 · Answer 1 · answered Jun 04 '17 at 03:42

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 04 '17 at 03:42

Scott Boston

147,308
15
139
187

This is good but,m but this solved my problem col1.sum(axis = 1);;Thanks anyways :) – Andre_k Jun 05 '17 at 05:50

Adding multiple elements of a single columns of dataframe in python

1 Answers1