How to merge/compare several tables by complex terms in R -

-

i tried compare 2 tables 2 terms. code in r: 

cbr <- c("usd", "eur", "sek", "rur") value <- c(2, 4, 5, 9) data <- data.frame(cur = cbr, rate = value)  deals1 <- c("usd", "usd", "usd", "eur", "sek", "eur", "rur", "sek") deals2 <- c("rur", "rur", "eur", "rur", "rur",  "usd", "usd", "rur") day <- 1:8 dealsn <- data.frame(day = day, cur_1 = deals1, cur_2 = deals2)  (i in 1:nrow(dealsn)) {     (j in 1:nrow(data)) {         if (dealsn$cur_1[i] == data$cur[j] & dealsn$cur_2[i] == "rur") {             dealsn$data[i] <- data$rate[data$cur[j]]         } else if            (dealsn$cur_1[i] == data$cur[j] & dealsn$cur_2[i] != "rur") {              dealsn$data[i] <- data$rate[data$cur[dealsn$cur_2[i]]]   /data$rate[data$cur[j]]          }     } }  dealsn

but not , result wrong: 

 day cur_1 cur_2 data     1   1   usd   rur 9.00     2   2   usd   rur 9.00     3   3   usd   eur 1.00     4   4   eur   rur 2.00     5   5   sek   rur 5.00     6   6   eur   usd 2.50     7   7   rur   usd 1.25     8   8   sek   rur 5.00

it should this, hope:

day cur_1   cur_2   data 1   usd      rur    2 2   usd      rur    2 3   usd      eur    2 4   eur      rur    4 5   sek      rur    5 6   eur      usd    0,5 7   rur      usd    0,22 8   sek      rur    5

help me please!


Comments

Post a Comment

Popular posts from this blog

How to run C# code using mono without Xamarin in Android? -

-
i want create program uses mono runtime run c# code (binary not application). i copied libmono.so unity app , i'm write code using documentation: http://www.mono-project.com/docs/advanced/embedding/ and it's working have problems references can access classes mscorlib.dll , have problems system.reflection.assembly class throwing exception, when print console see: system.missingmethodexception: method not found: 'system.reflection.assembly.op_inequality' can fix it? can use mono runtime in c binary on android? ps. i'm using android tests. edit: found solution loading libraries, need set environment variable mono_path libraries path. but have still problems assembly class. the system.missingmethodexception error have seems .net profile mismatch error, 1 explained here . can use mono runtime in c binary on android? yes, using ndk guess. there alternatives can use instead of rolling own, such xmadevlab .
Read more

c# - SharpSsh Command Execution -

-
Image
i trying create ssh client using c#. using tamir.sharpssh library. having issues sending command , getting appropriate response server. the way have been testing sending on ls command, followed cd.. command, followed ls command again -- see whether or not cd.. command being executed properly. however, there no difference between first ls command , second ls command. not entirely sure doing wrong. perhaps using wrong ssh type. have provided code , output getting. have added output expect. using tamir.sharpssh; namespace sshnetexample { class program { static void main(string[] args) { sshexec ssh = null; try { console.write("-connecting..."); ssh = new sshexec(host, username, password); ssh.connect(); console.writeline("ok ({0}/{1})", ssh.cipher, ssh.mac); console.writeline("server version={0}, client versio...
Read more

python - Specify path of savefig with pylab or matplotlib -

-
i struggling on how find correct way specify save path (or repository) when calling function savefig in matplotlib or pylab. i tried several syntaxes, everytime python console returns : filenotfounderror: [errno 2] no such file or directory: '../mydocs/resource/frames/myimage.png' currently, have written following : pylab.savefig('../mydocs/resource/frames/myimage.png') does know how it? thanks in advance! the tilde operator , variable $home entered strings , therefore not function while saving. have provide either relative path (as did) or provide full path. eg. pylab.savefig("/home/username/desktop/myfig.png") .
Read more