python - Finding the sum of grouped data by column -

-

my grouped data looks like:

deviceid                                  time          total_sent 022009f075929be71975ce70db19cd47780b112f  1980-january  36            4                                                         52            1                                                         94            1                                                         211           1                                                         278           1                                                         318           2                                                         370           1                                                         426           1                                                         430           1                                                         435           1                                                         560           1                                                         674           1                                                         797           1                                                         813           4                                                         816           1  ff5b22df4ab9207bb6709cddef6d95c655565578  2013-august  11308408       4                                                        12075616       1                                                        17933654       1                                                        22754808      12                                                        22754987       1                                                        22755166       3                                                        22755345       4                                                        22788586       4                                                        22788765       2                                                        22788944       2                                                        22791830       1                                                        22792546       1                                                        22796843       1                                                        22797201       2                                                        22797380       2

where last column represents count. obtained grouped representation using expression: 

data1.groupby(['deviceid', 'time', 'total_sent'])

how sum total_sent per month?

deviceid                                  time            sum     022009f075929be71975ce70db19cd47780b112f  1980-january    6210 ff5b22df4ab9207bb6709cddef6d95c655565578  2013-august     xxxx

since total_sent column summed, shouldn't within groupby keys. can try following:

data1.groupby(['deviceid', 'time']).agg({'total_sent': sum})

which sum total_sent column each group, indexed deviceid , time.


Comments

Post a Comment

Popular posts from this blog

c++ - OpenMP unpredictable overhead -

-
i have simple openmp code runs 4 empty threads , reports time: #include "omp.h" #include <sys/time.h> #include <cstdio> double start_time; void process_thread() { } int main(){ struct timeval tv; gettimeofday(&tv, null); start_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("beginning time: %.3fms ",start_time-start_time); #pragma omp parallel schedule(static,1) for(int i=0;i<4;i++) process_thread(); gettimeofday(&tv, null); double cur_time = 1000*((double)tv.tv_sec + 1e-6*(double)tv.tv_usec); printf("finishing time: %.3fms\n\n",cur_time-start_time); } without openmp running time small , consistent: beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.050ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.049ms beginning time: 0.000ms finishing time: 0.050ms beginnin...
Read more

ruby on rails - RuntimeError: Circular dependency detected while autoloading constant - ActiveAdmin.register Role -

-
i using activeadmin , have file doing this: activeadmin.register role something--- end however, server gives me error: runtimeerror: circular dependency detected while autoloading constant role /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:461:in `load_missing_constant' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:184:in `const_missing' ~/desktop/boxfox/app/admin/role.rb:1:in `<top (required)>' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `load' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:424:in `block in load_file' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:616:in `new_constants_in' /library/ruby/gems/2.0.0/gems/activesupport-4.0.10/lib/active_support/dependencies.rb:423:in `load_file' /library/ruby/gems/2.0.0/gems/activesuppor...
Read more

javascript - Wordpress slider, not displayed 100% width -

-
so im making first wordpress theme scratch going fine got problem. want slider on homepage 1 thing wrong. im setting width of image 100% !important doesnt go 100% width. makes image wider not 100%. example here: http://bit.ly/11ouebg see image doesnt contain whole width. can see background-color. really weird, im using meteor slides. i hope can me out :d
Read more