r - dividing all values in one column by values in a separate data frame (colnames match) -

-

i need divide every value in given column of first data frame value in corresponding column name of second data frame. example, need divide every value in 0 column of demand_copy 25.5, every value in 1 column 13.0, etc. , output same structure first data frame

how 1 in r? 

  > head(demand_copy)    0  1  2  3  4  5  6   7   8   9  10  11  12  13  14  15  16  17  18  19  20  21  22  23 1 25  9 14  3 10 10 28 175 406 230 155 151 202 167 179 185 275 298 280 185 110  84  93  51 2 36 17  9  3  2  7 32  88 110 131  89 125 149 165 161 147 178 309 339 201 115  78  67  39 3 10  3  5 10  0 11 15  58 129 110  49  62  62 100  70  73  72  86 116  61  49  37  26  22 4 24 15 10  5  3  4 39  53 108  98  80 118 116 110 135 158 157 196 176 132 118  94  91 102 5 40 45 15  9 16 37 75 205 497 527 362 287 316 353 359 309 365 653 598 468 328 242 168 102 6  0  0  1  2  0  0 11  56  26  12  21   6  27  15  18   5  14  19  25   6   4   0   1   0  
  > medians    medians 0     25.5 1     13.0 2      8.0 3      4.0 4      4.0 5     10.0 6     38.5 7    106.5 8    205.5 9    164.0 10   111.5 11   130.5 12   160.0 13   164.5 14   170.0 15   183.0 16   202.0 17   282.0 18   256.5 19   178.0 20   109.0 21    80.0 22    60.5 23    41.0

you use

t(t(demand_copy) / medians[, 1])

or

sweep(demand_copy, 2, medians[, 1], "/")

notice first approach returns matrix, whereas second 1 returns data frame.

i suggest have medians vector, not data frame single column. use medians instead of medians[, 1] in 2 lines above.


Comments

Post a Comment

Popular posts from this blog

Delphi XE2 Indy10 udp client-server interchange using SendBuffer-ReceiveBuffer -

-
i use delphi xe2 , indy10 udp protocol. can't receive server echo on client side if use receivebuffer method. got "socket error # 10040" although send small echo message server client. console application illustrate problem below. in advance. program project1; {$apptype console} {$r *.res} uses system.sysutils, idglobal, idbasecomponent, idcomponent, idsockethandle, idudpclient, idudpserver, idudpbase, idstack; type tudp_serv = class(tidudpserver) procedure udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); end; var udpserver: tudp_serv; udpcl: tidudpclient; bsnd, brcv: tbytes; s: string; k: integer; //============================================================================== procedure tudp_serv.udpsvudpread(athread: tidudplistenerthread; adata: tidbytes; abinding: tidsockethandle); begin writeln(' server read: ' + tohex(adata, length(adata))); abinding sendto(peerip, peerport, adat...
Read more

Qt ActiveX WMI QAxBase::dynamicCallHelper: ItemIndex(int): No such property in -

-
i new windows programming. here goes code objiwbemlocator = new qaxobject("wbemscripting.swbemlocator"); objwmiservice = objiwbemlocator->querysubobject("connectserver(qstring&,qstring&)",qstring("."),qstring("root\\cimv2")); qaxobject* returnlist = objwmiservice->querysubobject("execquery(qstring&)", qstring("select * %1").arg(domain)); qaxobject* result = returnlist->querysubobject("itemindex(int)", 0); i getting error on runtime qt activex wmi qaxbase::dynamiccallhelper: itemindex(int): no such property in but itemindex method exists msdn says the itemindex method not work collections not contain swbemobjects, such swbemmethodset, swbemnamedvalueset, swbemprivilegeset, swbempropertyset, , swbemqualifierset. what selecting ? have tried iterating on collection ? plus need minimum windows vista itemindex method. hope helps
Read more

Enable autocomplete or intellisense in Atom editor for PHP -

-
i'm first time user of atom editor php code. atom can autocomplete built-in functions of php. possible make editor autocomplete custom function written in separate file? function.php <?php function printsomething() { echo "hello world"; } index.php <?php require_once "function.php"; printsomething(); // autocompleted atom editor while typing thanks in advance. there text file in %userprofile%.atom called snippets.cson. in there can add snippet. more this: http://flight-manual.atom.io/using-atom/sections/snippets/ but need think can use later on other files well. otherwise need copy , paste.
Read more