pandas - Group by of a Column and Sum Contents of another column with python -

-

i have dataframe merged_df_energy:

merged_df_energy.head()  act_time_aerateur_1_f1 act_time_aerateur_1_f3 act_time_aerateur_1_f5 class_energy 63.333333 63.333333 63.333333 low 0 0 0 high 45.67 0 55.94 high 0 0 23.99 low 0 20 23.99 medium

i create each act_time_aerateur_1_fx (act_time_aerateur_1_f1, act_time_aerateur_1_f3 , act_time_aerateur_1_f5) dataframe wich contains these columns : class_energy , sum_time

for example dataframe corresponding act_time_aerateur_1_f1:

class_energy    sum_time low            63.333333 medium         0 high           45.67

i thing should use group this:

data.groupby(by=['class_energy'])['sum_time'].sum()

any idea me please?

you can add columns [] aggregating:

print (df.groupby(by=['class_energy'])['act_time_aerateur_1_f1', 'act_time_aerateur_1_f3','act_time_aerateur_1_f5'].sum())               act_time_aerateur_1_f1  act_time_aerateur_1_f3  \ class_energy                                                    high                       45.670000                0.000000    low                        63.333333               63.333333    medium                      0.000000               20.000000                   act_time_aerateur_1_f5   class_energy                           high                       55.940000   low                        87.323333   medium                     23.990000

you can use parameter as_index=false:

print (df.groupby(by=['class_energy'], as_index=false)['act_time_aerateur_1_f1', 'act_time_aerateur_1_f3','act_time_aerateur_1_f5'].sum())   class_energy  act_time_aerateur_1_f1  act_time_aerateur_1_f3  \ 0         high               45.670000                0.000000    1          low               63.333333               63.333333    2       medium                0.000000               20.000000        act_time_aerateur_1_f5   0               55.940000   1               87.323333   2               23.990000

if need aggregate first 3 columns:

print (df.groupby(by=['class_energy'], as_index=false)[df.columns[:3]].sum())   class_energy  act_time_aerateur_1_f1  act_time_aerateur_1_f3  \ 0         high               45.670000                0.000000    1          low               63.333333               63.333333    2       medium                0.000000               20.000000        act_time_aerateur_1_f5   0               55.940000   1               87.323333   2               23.990000

...or columns without last:

print (df.groupby(by=['class_energy'], as_index=false)[df.columns[:-1]].sum())   class_energy  act_time_aerateur_1_f1  act_time_aerateur_1_f3  \ 0         high               45.670000                0.000000    1          low               63.333333               63.333333    2       medium                0.000000               20.000000        act_time_aerateur_1_f5   0               55.940000   1               87.323333   2               23.990000

Comments

Post a Comment

Popular posts from this blog

mysql - Dreamhost PyCharm Django Python 3 Launching a Site -

-
i'm new python/django , created simple django website using pycharm. site works fine running on computer, i'm lost when comes taking site onto host (dreamhost). i'm able upload files correct directories fine, , believe made correct changes database on mysql. i'm not sure go there though. right now, page shows files rather site. direction appreciated. much! you should not run django application using python manage.py runserver on production. how run application on django depends on server (apache, nginx) want use for apache - https://docs.djangoproject.com/en/1.10/howto/deployment/wsgi/modwsgi/ for nginx - https://www.digitalocean.com/community/tutorials/how-to-serve-django-applications-with-uwsgi-and-nginx-on-ubuntu-14-04 the mysql database should, of course, exist , have correct credentials. or, if choose use sqlite, file should accessible, readable , writable www-user (may different depending on linux distributive)
Read more

java - Sending SMS with SMSLib and Web Services -

-
i have made rest web service send smss using hsdpa usb modem. using smslib in java send smss. every time web service invoked, create gateway start service, send message, stop service , remove gateway. takes 20 seconds each message. found starting service takes lot of time. part of code use send smss service.getinstance().addgateway(gateway); service.getinstance().startservice(); outboundmessage msg = new outboundmessage(phonenumber, message); if (service.getinstance().sendmessage(msg)) { result = "message sent successfully!!"; } else { result = "could not send message."; } service.getinstance().stopservice(); service.getinstance().removegateway(gateway);//remove gateway is there way can start service once if not started , use send message when ever web service invoked? why dont group messages , send in 1 go? service.getinstance().sendmessages(messa...
Read more

python 3.5 - Pyqtgraph string in x tick -

-
Image
so have been playing pyqtgraph , came problem needed add strings x axis tick label (instead of default float). looked around , found show string values on x-axis in pyqtgraph the solution kind of need (the first solution on page, second 1 cause problems because on python 3.5). tried modified first solution, did not work. from pyqt4 import qtcore import pyqtgraph pg x = ['a', 'b', 'c', 'd', 'e', 'f'] y = [1, 2, 3, 4, 5, 6] xdict = dict(enumerate(x)) win = pg.graphicswindow() stringaxis = pg.axisitem(orientation='bottom') stringaxis.setticks([xdict.items()]) plot = win.addplot(axisitems={'bottom': stringaxis}) curve = plot.plot(xdict.keys(),y) if __name__ == '__main__': import sys if sys.flags.interactive != 1 or not hasattr(qtcore, 'pyqt_version'): pg.qtgui.qapplication.exec_() the error getting typeerror: 'dict_keys' object not support indexing on line curve = plot.plo...
Read more