python - How to sum values of particular rows in pandas? -


i not familiar python yet. have pandas data frame looks this:

          0         1     2     3 55   alice   12896399     8    45 45   bob     16891982     0     0 90   cybill   1800407     1     1 05   alice   12896399   100   200 33   bob     16891982   0.5     0 42   bob     16891982  -1.5  -0.5 46   bob     16891982     1     0 99   cybill   1800407  0.00  0.00 

how can sum values of columns 2 , 3 result each person? this:

   alice     108    245    bob       0     -0.5    cybill    1     1 

thank in advance reply.

iiuc can groupby , sum on cols of interest:

in [13]: df.groupby('0')[['2','3']].sum()  out[13]:             2      3 0                    alice   108.0  245.0 bob       0.0   -0.5 cybill    1.0    1.0 

Comments

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

windows - Debug iNetMgr.exe unhandle exception System.Management.Automation.CmdletInvocationException -

configurationsection - activeMq-5.13.3 setup configurations for wildfly 10.0.0 -