python - Summing columns to form a new dataframe -


i have dataframe 

                             b             c            d 2015-07-18  4.534390e+05  2.990611e+05  5.706540e+05  4.554383e+05    2015-07-22  3.991351e+05  2.606576e+05  3.876394e+05  4.019723e+05    2015-08-07  1.085791e+05  8.215599e+04  1.356295e+05  1.096541e+05    2015-08-19  1.397305e+06  8.681048e+05  1.672141e+06  1.403100e+06   ...

i want sum columns new dataframe

        b  c  d sum   s   s  s  s

with columnwise sums , print to_csv(). when use

 df.sum(axis=0)  print(df)          9.099377e+06  b       5.897003e+06  c       1.049932e+07  d       9.208681e+06  dtype: float64

you can transform df.sum() dataframe , transpose it:

in [39]: df.sum().to_frame('sum').t out[39]:                        b          c          d sum  2358458.2  1509979.49  2766063.9  2370164.7

Comments

Post a Comment

Popular posts from this blog

PHP and MySQL WP -

i trying accomplish 2 things here code. writing php directly wp page using insert php plugin. 1) query mysql database , return results 1 column 4 columns. 2) make each result own hyperlink directs user new wp page runs new query on page. i able query show results , turn results dynamic hyperlink, cannot formatting down. right returns result 1 column. here have: [insert_php] $servername = "localhost"; $username = "login"; //edited privacy $password = "password"; //edited privacy $database = "database"; //edited privacy // create connection $conn = new mysqli($servername, $username, $password, $database); // check connection if ($conn->connect_error) { die("connection failed: " . $conn->connect_error); } echo "connected successfully"; //get results database $result = mysqli_query($conn,"select mine mines order mine"); $all_property = array(); //declare array saving property //showing proper...
Read more

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

i'm implementing inapp billing in android app. works well, however, i'm trying decouple broadcast receiver activity manifest. suggestion in android's trivialdrive sample: // important: dynamically register broadcast messages updated purchases. // register receiver here instead of <receiver> in manifest // because call getpurchases() @ startup, therefore can ignore // broadcasts sent while app isn't running. // note: registering listener in activity bad idea, done here // because sample. regardless, receiver must registered after // iabhelper setup, before first call getpurchases(). currently there's class extends broadcastreceiver : public class iabbroadcastreceiver extends broadcastreceiver { /** * intent action receiver should filter for. */ public static final string action = "com.android.vending.billing.purchases_updated"; private final iabbroadcastlistener mlistener; public iabbroadcastreceiver(iabbroadcastlistener listener) { m...
Read more

go - golang pprof for c library code -

i have been trying profile golang application pprof, seems details of c code(linked static library) missed in output result. flame graph from frame graph can see c code time consuming reported within "runtime._externalcode", no details @ all. , sure static library compiled debug enable. so there way make pprof details(like stack trace) of 3rd party c code? or there other golang profiling tool this?
Read more