pandas - How to calculate group by cumulative sum for multiple columns in python -

-

i have data set like,

data=pd.dataframe({'id':pd.series([1,1,1,2,2,3,3,3]),'var1':pd.series([1,2,3,4,5,6,7,8]),'var2':pd.series([11,12,13,14,15,16,17,18]), 'var3':pd.series([21,22,23,24,25,26,27,28])})

here need calculate groupwise cumulative sum columns(var1,var2,var3) based on id. how can write python code crate output per requirement?

thanks in advance.

if have understood right, can use dataframe.groupby calculate cumulative sum across columns grouped 'id'-column. like:

import pandas pd data=pd.dataframe({'id':[1,1,1,2,2,3,3,3],'var1':[1,2,3,4,5,6,7,8],'var2':[11,12,13,14,15,16,17,18], 'var3':[21,22,23,24,25,26,27,28]}) data.groupby('id').apply(lambda x: x.drop('id', axis=1).cumsum(axis=1).sum())

Comments

Post a Comment

Popular posts from this blog

c# - ItextSharp font color issue in ver 5.5.4+ -

-
Image
i have code creates red "stamp" using red font color: string stampdate = datetime.now.tostring("mm/dd/yyyy"); string fontpath = server.mappath("/assets/fonts"); string origfile = server.mappath("/test.pdf"); const int opacitypercent = 80; const float pdfpaidfontsize = 28; const float pdfcopyx = 170; const float pdfpaidx = 385; const float pdfy = 20; const float pdfdatexoffset = 7; const float pdfdateyoffset = 12; const float pdfdatefontsize = 10; const string paidstamptxt = "paid"; const string copystamptxt = "copy"; const string arialfilename = "arialbd.ttf"; pdfstamper stamper = null; pdfreader reader = null; pdfreader.unethicalreading = true; memorystream streampdf; try { reader = new pdfreader(origfile); streampdf = new memorystream(); stamper = new pdfstamper(reader, streampdf); (int = 1; <= r...
Read more

jquery - Multiple issues with pushstate: history, loading, calling functions -

-
i have script pulling data via ajax/pushstate; works relatively well, there issues i'm running into. first , foremost, here code i'm using: function goto(href) { $.ajax({ url: href, success: function(data) { $('#wrapper').fadeout('fast', function(){ $(this).html(data).fadeto('fast', 1); $(".scroll").nicescroll({cursorcolor:"#f33d39", cursorwidth: "10px", cursorborder: "none", cursorborderradius: "0px", fixed: true}); }); // update page title var title = $('#page-right').find('h1').text(); $('head').find('title').text(title); } }); } if (typeof history.pushstate !== "undefined") { var historycount = 0; $('a[href*="rage.rage-wrestling.com"]').live('click',function(){ var href = $(this).attr('h...
Read more

opengl es - Android GLES 2 draw line flicker and strange effects -

-
Image
i trying draw 3d lines in android using gles 2. resulted in strange effects. flicker happens when rotate scene/camera. not that, there lines drawn in 2d (sometime dots) @ random. screenshot: while image shows no problem @ (using different camera angle): i've tried use gles 1 draw these lines , worked (no flicker or random lines). perhaps have shader code? vertex shader taken android gles example simple. update: after more tries, found happens when camera yaw (y axis rotary) more 90 degree. within range of 0-90 yaw, lines display normally. doing wrong? i'm running program on galaxy tab s android v4.4.2. here whole code used reproduce erroneous image: main activity: package com.mycompany.bug_test; import android.opengl.glsurfaceview; import android.support.v7.app.actionbaractivity; import android.os.bundle; public class opengles20activity extends actionbaractivity { private glsurfaceview mglview = null; @override protected void oncreate(bundle save...
Read more