Dear R-friends,
Hope you doing well. I've been trying to deal with the following problem for
the couple of days but couldn't come up with a solution. It would be great
if
any of you could give some insight into it.
I have three matrices like:
dcvol<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,0.00,0.00,
0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,0.00,0.00,0.00,0.00,
0.09),nrow=5,ncol=5)
volinp<-matrix(c(100,0,0,0,0),nrow=5,ncol=1)
scvol<-matrix(c(1:40),nrow=5,ncol=8)
What I essentially want to do is to add each value in scvol[1,] with the
volinp[1,1] and then multiply each new volinp with dcvol and finally put the
outputs in a new matrix.
Thanks in advance.
Halim
---------------
Md. Abdul Halim
Assistant Professor
Department of Forestry and Environmental Science
Shahjalal University of Science and Technology,Sylhet-3114,
Bangladesh.
Cell: +8801714078386.
alt. e-mail: xou03 at yahoo.com
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Hi Arun,
Thank you very much for your response. Sorry, if I couldn't explain clearly.
I
think, I should restate the problem to get exactly what I want. Here it goes:
I have 2 matrices and 1 vector, namely,
dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,0.00,0.00,
0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,0.00,0.00,0.00,0.00,
0.09),nrow=5,ncol=5)
volmat<-matrix(c(100,0,0,0,0),nrow=5,ncol=1)
volinp<-c(1:40)
What I essentially want to do is to multiply 'dcmat' with
'volmat' and dump
the output in a new matrix 'vol'. But before that, in the first step, I
want
to add volinp[1] with volmat[1,1]. So, the first column of the output matrix
'vol' matrix will be:
[,1]
[1,] 13.13
[2,] 61.61
[3,] 25.25
[4,] 0.00
[5,] 0.00
In the 2nd step, I want to add vol[1,1] with volinp[2]. and replace this value
with volmat[1,1]. The new 'volmat' will look like:
[,1]
[1,] 15.13
[2,] 0.00
[3,] 0.00
[4,] 0.00
[5,] 0.00
And then multiply 'dcmat' with the new 'volmat', and the 2nd
column of output
matrix 'vol' will look like:
[,2]
[1,] 1.9669
[2,] 9.2293
[3,] 3.7825
[4,] 0.0000
[5,] 0.0000
Then again, replace the volmat[1,1] with vol[1,2] + volinp[3] and multiply the
new 'volmat' with 'dcmat'. This addition, multiplication, and
dumping will
continue up to the length of 'volinp' and the final output matrix
'vol' will
be something like:
[,1] [,2] [,3] ...length(volinp)
[1,] 13.13 1.9669 0.645697 ...
[2,] 61.61 9.2293 3.029809 ...
[3,] 25.25 3.7825 1.241725 ...
[4,] 0.00 0.0000 0.000000 ...
[5,] 0.00 0.0000 0.000000 ...
Within my limited capacity, I've tried to come up with a solution but
failed.
I'll appreciate your/others' help with gratefulness.
Regards,
Halim
---------------
Md. Abdul Halim
Assistant Professor
Department of Forestry and Environmental Science
Shahjalal University of Science and Technology,Sylhet-3114,
Bangladesh.
Cell: +8801714078386.
alt. e-mail: xou03 at yahoo.com
On Sat, 23 Nov 2013 14:10:12 -0800 (PST), arun wrote> Hi,
> Could you show your expected output?? It is a bit unclear from the
description.>
> On Saturday, November 23, 2013 2:00 PM, halim10-fes <halim10-
> fes at sust.edu> wrote: Dear R-friends,
>
> Hope you doing well. I've been trying to deal with the following
> problem for the couple of days but couldn't come up with a solution.
> It would be great if any of you could give some insight into it.
>
> I have three matrices like:
>
> dcvol<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,
> 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,
> 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5)
volinp<-> matrix(c(100,0,0,0,0),nrow=5,ncol=1)
>
> scvol<-matrix(c(1:40),nrow=5,ncol=8)
>
> What I essentially want to do is to add each value in scvol[1,] with
> the volinp[1,1] and then multiply each new volinp with dcvol and
> finally put the outputs in a new matrix.
>
> Thanks in advance.
>
> Halim? ? ? ? ? ? ? ?
> ---------------
> Md. Abdul Halim
> Assistant Professor
> Department of Forestry and Environmental Science
> Shahjalal University of Science and Technology,Sylhet-3114,
> Bangladesh.
> Cell: +8801714078386.
> alt. e-mail: xou03 at yahoo.com
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Please apologize me! Earlier I've sent a message erroneously. Following is
the
original problem for which I'm seeking help. Extremely sorry...
Hi Arun,
Thank you very much for your response. Sorry, if I couldn't explain clearly.
I
think, I should restate the problem to get exactly what I want. Here it goes:
I have 2 matrices and 1 vector, namely,
dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,0.00,0.00,
0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,0.00,0.00,0.00,0.00,
0.09),nrow=5,ncol=5)
volmat<-matrix(c(100,0,0,0,0),nrow=5,ncol=1)
volinp<-c(1:40)
What I essentially want to do is to multiply 'dcmat' with
'volmat' and dump
the output in a new matrix 'vol'. But before that, in the first step, I
want
to add volinp[1] with volmat[1,1]. So, the first column of the output matrix
'vol' matrix will be:
[,1]
[1,] 13.13
[2,] 61.61
[3,] 25.25
[4,] 0.00
[5,] 0.00
In the 2nd step, I want to replace 'volmat' with vol[,1] and add
volinp[2]
with vol[1,1]. The new 'volmat' will look like:
[,1]
[1,] 15.13
[2,] 61.61
[3,] 25.25
[4,] 0.00
[5,] 0.00
Then multiply 'dcmat' with the new 'volmat', and the 2nd column
of output
matrix 'vol' will look like:
[,2]
[1,] 1.9669
[2,] 41.2665
[3,] 41.2232
[4,] 13.1199
[5,] 2.7775
Then again, replace the 'volmat' with vol[,2], add volinp[3] with
vol[1,2] and
multiply the new 'volmat' with 'dcmat'. This replacement,
addition,
multiplication, and dumping will continue up to the length of 'volinp'
and the
final output matrix 'vol' will be something like:
[,1] [,2] [,3] ...length(volinp)
[1,] 13.13 1.9669 0.645697 ...
[2,] 61.61 41.2665 24.488389 ...
[3,] 25.25 41.2232 40.419786 ...
[4,] 0.00 13.1199 22.116099 ...
[5,] 0.00 2.7775 7.670905 ...
Within my limited capacity, I've tried to come up with a solution but
failed.
I'll appreciate your/others' help with gratefulness.
Regards,
Halim
---------------
Md. Abdul Halim
Assistant Professor
Department of Forestry and Environmental Science
Shahjalal University of Science and Technology,Sylhet-3114,
Bangladesh.
Cell: +8801714078386.
alt. e-mail: xou03 at yahoo.com
On Sat, 23 Nov 2013 14:10:12 -0800 (PST), arun wrote> Hi,
> Could you show your expected output?? It is a bit unclear from the
description.>
> On Saturday, November 23, 2013 2:00 PM, halim10-fes <halim10-
> fes at sust.edu> wrote: Dear R-friends,
>
> Hope you doing well. I've been trying to deal with the following
> problem for the couple of days but couldn't come up with a solution.
> It would be great if any of you could give some insight into it.
>
> I have three matrices like:
>
> dcvol<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,
> 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,
> 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5)
volinp<-> matrix(c(100,0,0,0,0),nrow=5,ncol=1)
>
> scvol<-matrix(c(1:40),nrow=5,ncol=8)
>
> What I essentially want to do is to add each value in scvol[1,] with
> the volinp[1,1] and then multiply each new volinp with dcvol and
> finally put the outputs in a new matrix.
>
> Thanks in advance.
>
> Halim? ? ? ? ? ? ? ?
> ---------------
> Md. Abdul Halim
> Assistant Professor
> Department of Forestry and Environmental Science
> Shahjalal University of Science and Technology,Sylhet-3114,
> Bangladesh.
> Cell: +8801714078386.
> alt. e-mail: xou03 at yahoo.com
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Hi Halim,
I guess this works for you.? Modifying Jeff's solution:
volinp<-c(0,0.000467,0.002762,0.008621,0.020014,0.038907,0.067094)
vol1 <- dcmat %*% (volmat +wt)
for(idx in seq_along(volinp)[-1]){
?vol1 <- cbind(vol1,dcmat %*% (vol1[,idx-1] + volinp[idx] *wt))
?}
#or
vol <- matrix( NA, nrow=5, ncol=length( volinp ) )
vol[ , 1 ] <- dcmat %*% ( volmat + wt )
for ( idx in seq_along(volinp)[ -1 ] ) {
? vol[ , idx ] <- dcmat %*% ( vol[ , idx-1 ] + volinp[idx] * wt )
}
identical(vol,vol1)
#[1] TRUE
A.K.
On Sunday, November 24, 2013 7:16 AM, halim10-fes <halim10-fes at
sust.edu> wrote:
Hi Arun,
OK, no problem. Thank you very much for your attention. I've posted an annex
to my previous problem. I will appreciate your comments/suggestions on it.
Off-topic: You're a very helpful man. I like your attitude to helping
others.
Take care.
Halim
On Sun, 24 Nov 2013 01:18:18 -0800 (PST), arun wrote> Hi,
> Please disregard my earlier message. Looks like Jeff understand it
> better and answered it. Regards, Arun
>
> On Sunday, November 24, 2013 3:23 AM, arun <smartpink111 at
yahoo.com> wrote:
> Hi,
> I am finding some inconsistency with your description.
> For example:
> volinp[1]+volmat[1,1]
> [1] 101
>
> On Sunday, November 24, 2013 1:52 AM, halim10-fes <halim10-
> fes at sust.edu> wrote:
>
> Please apologize me! Earlier I've sent a message erroneously.
> Following is the original problem for which I'm seeking help.
> Extremely sorry...?
>
> Hi Arun,
>
> Thank you very much for your response. Sorry, if I couldn't explain
> clearly. I think, I should restate the problem to get exactly what I
> want. Here it goes:
>
> I have 2 matrices and 1 vector, namely,
>
> dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,
> 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,
> 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5)
>
> volmat<-matrix(c(100,0,0,0,0),nrow=5,ncol=1)
>
> volinp<-c(1:40)
>
> What I essentially want to do is to multiply 'dcmat' with
'volmat'
> and dump the output in a new matrix 'vol'. But before that, in the
> first step, I want to add volinp[1] with volmat[1,1]. So, the first
> column of the output matrix 'vol' matrix will be:
>
> ? ? ? ? [,1]
> [1,]?? 13.13
> [2,]?? 61.61
> [3,]?? 25.25
> [4,]? ? 0.00
> [5,]? ? 0.00
>
> In the 2nd step, I want to replace 'volmat' with vol[,1] and add
> volinp[2] with vol[1,1]. The new 'volmat' will look like:
>
> ? ? ? ? [,1]
> [1,]?? 15.13
> [2,]?? 61.61
> [3,]?? 25.25
> [4,]? ? 0.00
> [5,]? ? 0.00
>
> Then multiply 'dcmat' with the new 'volmat', and the 2nd
column of
> output matrix 'vol' will look like:
>
> ? ? ? ? [,2]
> [1,]? 1.9669
> [2,] 41.2665
> [3,] 41.2232
> [4,] 13.1199
> [5,]? 2.7775
>
> Then again, replace the 'volmat' with vol[,2], add volinp[3] with
> vol[1,2] and multiply the new 'volmat' with 'dcmat'. This
> replacement, addition, multiplication, and dumping will continue up
> to the length of 'volinp' and the final output matrix 'vol'
will be
> something like:
>
> ? ? ? [,1]? ? [,2]? ? ? [,3]? ? ...length(volinp)
> [1,] 13.13?? 1.9669?? 0.645697? ...
> [2,] 61.61? 41.2665? 24.488389? ...
> [3,] 25.25? 41.2232? 40.419786? ...
> [4,]? 0.00? 13.1199? 22.116099? ...
> [5,]? 0.00?? 2.7775?? 7.670905? ...?
>
> Within my limited capacity, I've tried to come up with a solution
> but failed.
>
> I'll appreciate your/others' help with gratefulness.
>
> Regards,
>
> Halim
>
> ---------------
> Md. Abdul Halim
> Assistant Professor
> Department of Forestry and Environmental Science
> Shahjalal University of Science and Technology,Sylhet-3114,
> Bangladesh.
> Cell: +8801714078386.
> alt. e-mail: xou03 at yahoo.com
>
> On Sat, 23 Nov 2013 14:10:12 -0800 (PST), arun wrote
> > Hi,
> > Could you show your expected output?? It is a bit unclear from the
> description.
> >
> > On Saturday, November 23, 2013 2:00 PM, halim10-fes <halim10-
> > fes at sust.edu> wrote: Dear R-friends,
> >
> > Hope you doing well. I've been trying to deal with the following
> > problem for the couple of days but couldn't come up with a
solution.
> > It would be great if any of you could give some insight into it.
> >
> > I have three matrices like:
> >
> > dcvol<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,
> > 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,
> > 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5)
> volinp<-
> > matrix(c(100,0,0,0,0),nrow=5,ncol=1)
> >
> > scvol<-matrix(c(1:40),nrow=5,ncol=8)
> >
> > What I essentially want to do is to add each value in scvol[1,] with
> > the volinp[1,1] and then multiply each new volinp with dcvol and
> > finally put the outputs in a new matrix.
> >
> > Thanks in advance.
> >
> > Halim? ? ? ? ? ? ? ?
> > ---------------
> > Md. Abdul Halim
> > Assistant Professor
> > Department of Forestry and Environmental Science
> > Shahjalal University of Science and Technology,Sylhet-3114,
> > Bangladesh.
> > Cell: +8801714078386.
> > alt. e-mail: xou03 at yahoo.com
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> >
> > ______________________________________________
> > R-help at r-project.org mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide http://www.R-project.org/posting-
guide.html> > and provide commented, minimal, self-contained, reproducible code.
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
---------------
Md. Abdul Halim
Assistant Professor
Department of Forestry and Environmental Science
Shahjalal University of Science and Technology,Sylhet-3114,
Bangladesh.
Cell: +8801714078386.
alt. e-mail: xou03 at yahoo.com
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Hi,
Sorry for continuous bothering. Continuum of the previous problem...
I have the following matrices and vectors,
dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,0.00,0.00,
0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,0.00,0.00,0.00,0.00,
0.09),nrow=5,ncol=5)
volini<-matrix(c(0,0,0,0,0),nrow=5,ncol=1)
volinp1<-c(0, 0.0004669094, 0.0027610861, 0.0086204692, 0.0200137754,
0.0389069106 ,0.0670942588, 0.1060941424, 0.1570990708, 0.2209672605,
0.2982420945, 0.3891882830, 0.4938361307, 0.6120278338, 0.7434618363,
0.8877329008, 1.0443667375, 1.2128488387, 1.3926476912, 1.5832328410,
1.7840884399, 1.9947229566, 2.2146757191, 2.4435209092, 2.6808695568,
2.9263700050, 3.1797072430, 3.4406014299, 3.7088058696, 3.9841046430,
4.2663100561, 4.5552600226, 4.8508154713, 5.1528578389, 5.4612866929,
5.7760175114, 6.0969796345, 6.4241143947, 6.7573734248, 7, 7 ,7, 7, 7, 7, 7,
7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7,
7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7,
7, 7, 7)
I've calculated the following matrices vol and volyrdc1 (obviously with the
help of Jeff and Arun):
#Blank matrices for dumping final values
vol <- matrix( NA, nrow=5, ncol=length(volinp1))
volyrdc1<-matrix(NA, nrow=5,ncol=length(volinp1),dimnames=
list(c("DC1","DC2","DC3","DC4","DC5"),c(seq(0,500,5))))
vol[ , 1 ] <- dcmat %*% (volini+(volinp1[1]*wt))
wt<-matrix(c(1,0,0,0,0),nrow=5)
for ( idx in seq_along(volinp1)[ -1 ] ) {
vol[ , idx ] <- dcmat %*% ( vol[ , idx-1 ] + volinp1[idx] * wt )
}
vol
volyrdc1[,1]<-vol[,1]
for ( idx in seq_along(volinp1)[ -1 ] ) {
volyrdc1[ , idx ] <- vol[ , idx-1 ] + volinp1[idx] * wt
}
volyrdc1
My final matrix in 'volyrdc1' (kind of transition matrix model).
Now, what I want to do is to calculate when the colsum<-colSums(volyrdc1)
reaches a certain value and I want to get the index of the element in the
'colsum' vector at that point. For e.g. when colsum[colsum>=18] ? It
will give
a series of cases where the condition is true. But I want index of the element
immediately when the condition is met. In this case, the answer I want is 140
(colsum[29] returns both value (18.63) and the character ("140")
attributing
the index). Actually, in my case 140 is year (age) when the 'colsum'
becomes >=18. At is point it would be great if I can calculate when 'colsum'
levels
off (up to two decimal place)? The answer is: 305 and at that point
colsum==45.37.
I also want to calculate what should be the value in volini[1,1] to get a
certain value in 'colsum' at a certain year (age)(vector element index
explained earlier)? For e.g. I want to find out that what should be the value
in volini[1,1] if I want colsum==18 at 100(charater attributing colsum[21])?
The answer is: 15910 and the 'volini' matrix will look like:
volini<-matrix(c(15910,0,0,0,0),nrow=5,ncol=1)
Any pointer, suggestions,... will be gratefully acknowledged.
P.S. Can you please suggest me any effective R programming book that describe
core elements of R programming?
Thanks in advance.
Regards,
Halim? ? ? ? ? ? ? ?
---------------
Md. Abdul Halim
Assistant Professor
Department of Forestry and Environmental Science
Shahjalal University of Science and Technology,Sylhet-3114,
Bangladesh.
Cell: +8801714078386.
alt. e-mail: xou03 at yahoo.com
On Tue, 26 Nov 2013 20:21:14 -0800 (PST), arun wrote> HI Halim,
>
> No problem.
> Regards,
> Arun
>
> On Tuesday, November 26, 2013 11:18 PM, halim10-fes <halim10-
> fes at sust.edu> wrote: Hi Arun,
>
> Thanks for your help. Sorry for my late response. Take care and stay
> fine.
>
> Regards,
>
> Halim
>
> On Sun, 24 Nov 2013 07:45:24 -0800 (PST), arun wrote
> > Hi Halim,
> > I guess this works for you.? Modifying Jeff's solution:
> >
> > volinp<-c(0,0.000467,0.002762,0.008621,0.020014,0.038907,0.067094)
> > vol1 <- dcmat %*% (volmat +wt)
> > for(idx in seq_along(volinp)[-1]){
> > ?vol1 <- cbind(vol1,dcmat %*% (vol1[,idx-1] + volinp[idx] *wt))
> > ?}
> >
> > #or
> >
> > vol <- matrix( NA, nrow=5, ncol=length( volinp ) )
> > vol[ , 1 ] <- dcmat %*% ( volmat + wt )
> >
> > for ( idx in seq_along(volinp)[ -1 ] ) {
> > ? vol[ , idx ] <- dcmat %*% ( vol[ , idx-1 ] + volinp[idx] * wt )
> > }
> > identical(vol,vol1)
> > #[1] TRUE
> >
> > A.K.
> >
> > On Sunday, November 24, 2013 7:16 AM, halim10-fes <halim10-
> > fes at sust.edu> wrote: Hi Arun,
> >
> > OK, no problem. Thank you very much for your attention. I've
posted
> > an annex to my previous problem. I will appreciate your
> > comments/suggestions on it.
> >
> > Off-topic: You're a very helpful man. I like your attitude to
> > helping others.
> >
> > Take care.
> >
> > Halim
> >
> > On Sun, 24 Nov 2013 01:18:18 -0800 (PST), arun wrote
> > > Hi,
> > > Please disregard my earlier message. Looks like Jeff understand
it
> > > better and answered it. Regards, Arun
> > >
> > > On Sunday, November 24, 2013 3:23 AM, arun <smartpink111 at
yahoo.com>
wrote:> > > Hi,
> > > I am finding some inconsistency with your description.
> > > For example:
> > > volinp[1]+volmat[1,1]
> > > [1] 101
> > >
> > > On Sunday, November 24, 2013 1:52 AM, halim10-fes <halim10-
> > > fes at sust.edu> wrote:
> > >
> > > Please apologize me! Earlier I've sent a message erroneously.
> > > Following is the original problem for which I'm seeking help.
> > > Extremely sorry...?
> > >
> > > Hi Arun,
> > >
> > > Thank you very much for your response. Sorry, if I couldn't
explain
> > > clearly. I think, I should restate the problem to get exactly
what I
> > > want. Here it goes:
> > >
> > > I have 2 matrices and 1 vector, namely,
> > >
> > >
dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,
> > > 0.00,0.00, ? ? ? ? ? ? ? ?
0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,
> > > 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5)
> > >
> > > volmat<-matrix(c(100,0,0,0,0),nrow=5,ncol=1)
> > >
> > > volinp<-c(1:40)
> > >
> > > What I essentially want to do is to multiply 'dcmat' with
'volmat'
> > > and dump the output in a new matrix 'vol'. But before
that, in the
> > > first step, I want to add volinp[1] with volmat[1,1]. So, the
first
> > > column of the output matrix 'vol' matrix will be:
> > >
> > > ? ? ? ? [,1]
> > > [1,]?? 13.13
> > > [2,]?? 61.61
> > > [3,]?? 25.25
> > > [4,]? ? 0.00
> > > [5,]? ? 0.00
> > >
> > > In the 2nd step, I want to replace 'volmat' with vol[,1]
and add
> > > volinp[2] with vol[1,1]. The new 'volmat' will look like:
> > >
> > > ? ? ? ? [,1]
> > > [1,]?? 15.13
> > > [2,]?? 61.61
> > > [3,]?? 25.25
> > > [4,]? ? 0.00
> > > [5,]? ? 0.00
> > >
> > > Then multiply 'dcmat' with the new 'volmat', and
the 2nd column of
> > > output matrix 'vol' will look like:
> > >
> > > ? ? ? ? [,2]
> > > [1,]? 1.9669
> > > [2,] 41.2665
> > > [3,] 41.2232
> > > [4,] 13.1199
> > > [5,]? 2.7775
> > >
> > > Then again, replace the 'volmat' with vol[,2], add
volinp[3] with
> > > vol[1,2] and multiply the new 'volmat' with
'dcmat'. This
> > > replacement, addition, multiplication, and dumping will continue
up
> > > to the length of 'volinp' and the final output matrix
'vol' will be
> > > something like:
> > >
> > > ? ? ? [,1]? ? [,2]? ? ? [,3]? ? ...length(volinp)
> > > [1,] 13.13?? 1.9669?? 0.645697? ...
> > > [2,] 61.61? 41.2665? 24.488389? ...
> > > [3,] 25.25? 41.2232? 40.419786? ...
> > > [4,]? 0.00? 13.1199? 22.116099? ...
> > > [5,]? 0.00?? 2.7775?? 7.670905? ...?
> > >
> > > Within my limited capacity, I've tried to come up with a
solution
> > > but failed.
> > >
> > > I'll appreciate your/others' help with gratefulness.
> > >
> > > Regards,
> > >
> > > Halim
> > >
> > > ---------------
> > > Md. Abdul Halim
> > > Assistant Professor
> > > Department of Forestry and Environmental Science
> > > Shahjalal University of Science and Technology,Sylhet-3114,
> > > Bangladesh.
> > > Cell: +8801714078386.
> > > alt. e-mail: xou03 at yahoo.com
> > >
> > > On Sat, 23 Nov 2013 14:10:12 -0800 (PST), arun wrote
> > > > Hi,
> > > > Could you show your expected output?? It is a bit unclear
from the
> > > description.
> > > >
> > > > On Saturday, November 23, 2013 2:00 PM, halim10-fes
<halim10-
> > > > fes at sust.edu> wrote: Dear R-friends,
> > > >
> > > > Hope you doing well. I've been trying to deal with the
following
> > > > problem for the couple of days but couldn't come up with
a solution.
> > > > It would be great if any of you could give some insight into
it.
> > > >
> > > > I have three matrices like:
> > > >
> > > >
dcvol<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00,
> > > > 0.00,0.00, ? ? ? ? ? ? ? ?
0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22,
> > > > 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5)
> > > volinp<-
> > > > matrix(c(100,0,0,0,0),nrow=5,ncol=1)
> > > >
> > > > scvol<-matrix(c(1:40),nrow=5,ncol=8)
> > > >
> > > > What I essentially want to do is to add each value in
scvol[1,] with
> > > > the volinp[1,1] and then multiply each new volinp with dcvol
and
> > > > finally put the outputs in a new matrix.
> > > >
> > > > Thanks in advance.
> > > >
> > > > Halim? ? ? ? ? ? ? ?
> > > > ---------------
> > > > Md. Abdul Halim
> > > > Assistant Professor
> > > > Department of Forestry and Environmental Science
> > > > Shahjalal University of Science and Technology,Sylhet-3114,
> > > > Bangladesh.
> > > > Cell: +8801714078386.
> > > > alt. e-mail: xou03 at yahoo.com
> > > >
> > > > --
> > > > This message has been scanned for viruses and
> > > > dangerous content by MailScanner, and is
> > > > believed to be clean.
> > > >
> > > > ______________________________________________
> > > > R-help at r-project.org mailing list
> > > > https://stat.ethz.ch/mailman/listinfo/r-help
> > > > PLEASE do read the posting guide
http://www.R-project.org/posting-
> > guide.html
> > > > and provide commented, minimal, self-contained, reproducible
code.
> > >
> > > --
> > > This message has been scanned for viruses and
> > > dangerous content by MailScanner, and is
> > > believed to be clean.
> > >
> > > --
> > > This message has been scanned for viruses and
> > > dangerous content by MailScanner, and is
> > > believed to be clean.
>
> >
> > ---------------
> > Md. Abdul Halim
> > Assistant Professor
> > Department of Forestry and Environmental Science
> > Shahjalal University of Science and Technology,Sylhet-3114,
> > Bangladesh.
> > Cell: +8801714078386.
> > alt. e-mail: xou03 at yahoo.com
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
> >
> > --
> > This message has been scanned for viruses and
> > dangerous content by MailScanner, and is
> > believed to be clean.
>
> ---------------
> Md. Abdul Halim
> Assistant Professor
> Department of Forestry and Environmental Science
> Shahjalal University of Science and Technology,Sylhet-3114,
> Bangladesh.
> Cell: +8801714078386.
> alt. e-mail: xou03 at yahoo.com
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
>
> --
> This message has been scanned for viruses and
> dangerous content by MailScanner, and is
> believed to be clean.
---------------
Md. Abdul Halim
Assistant Professor
Department of Forestry and Environmental Science
Shahjalal University of Science and Technology,Sylhet-3114,
Bangladesh.
Cell: +8801714078386.
alt. e-mail: xou03 at yahoo.com
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Hi Halim, I tried, but couldn't come up with a solution. Regards, Arun On Sunday, December 1, 2013 1:26 AM, halim10-fes <halim10-fes at sust.edu> wrote: Hi Arun, Thank you very much for your kind response. Sorry for my delayed response. Your solutions for the first two questions are quite good for my purpose. Since nobody responded, can you please have a look at the 3rd question? It'll be my great help, if you can give me suggestions. Regards, Halim On Thu, 28 Nov 2013 08:11:20 -0800 (PST), arun wrote> Hi Halim, > > For the first two questions, you may try: > colsum1 <- colSums(volyrdc1) > min(which(colsum1>=18)) > #[1] 29 > #or > ?head(which(colsum1>=18),1) > #140 > # 29? > > colsum1[substr(colsum1,6,7)=="00"]? ## this is not very clear > ???? 305 > 45.37004? > #or > colsum1[colsum1>=18][substr(colsum1[colsum1>=18],6,7)=="00"] > ???? 305 > 45.37004 > > #because > sprintf("%.4f",colsum1[colsum1>=18]) > colsum1[colsum1>=18][gsub(".*\\.\\d{2}","",sprintf("%.4f", > colsum1[colsum1>=18]))=="00"] ???? 180????? 305 > 32.88996 45.37004 > > A.K. > > On Thursday, November 28, 2013 3:57 AM, halim10-fes <halim10- > fes at sust.edu> wrote: Hi, > > Sorry for continuous bothering. Continuum of the previous problem... > > I have the following matrices and vectors, > > dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00, > 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22, > 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5) > > volini<-matrix(c(0,0,0,0,0),nrow=5,ncol=1) > > volinp1<-c(0, 0.0004669094, 0.0027610861, 0.0086204692, 0.0200137754, > 0.0389069106 ,0.0670942588, 0.1060941424, 0.1570990708, 0.2209672605, > 0.2982420945, 0.3891882830, 0.4938361307, 0.6120278338, 0.7434618363, > 0.8877329008, 1.0443667375, 1.2128488387, 1.3926476912, 1.5832328410, > 1.7840884399, 1.9947229566, 2.2146757191, 2.4435209092, 2.6808695568, > 2.9263700050, 3.1797072430, 3.4406014299, 3.7088058696, 3.9841046430, > 4.2663100561, 4.5552600226, 4.8508154713, 5.1528578389, 5.4612866929, > 5.7760175114, 6.0969796345, 6.4241143947, 6.7573734248, 7, 7 ,7, 7, >? 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, >? 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, 7, >? 7, 7, 7, 7, 7, 7, 7, 7,? 7,? 7, 7, 7) > > I've calculated the following matrices vol and volyrdc1 (obviously > with the help of Jeff and Arun): > > #Blank matrices for dumping final values > > vol <- matrix( NA, nrow=5, ncol=length(volinp1)) > > volyrdc1<-matrix(NA, nrow=5,ncol=length(volinp1),dimnames= > list(c("DC1","DC2","DC3","DC4","DC5"),c(seq(0,500,5)))) > > vol[ , 1 ] <- dcmat %*% (volini+(volinp1[1]*wt)) > > wt<-matrix(c(1,0,0,0,0),nrow=5) > > for ( idx in seq_along(volinp1)[ -1 ] ) { > ? vol[ , idx ] <- dcmat %*% ( vol[ , idx-1 ] + volinp1[idx] * wt ) > }? > > vol > > volyrdc1[,1]<-vol[,1] > > for ( idx in seq_along(volinp1)[ -1 ] ) { > ? volyrdc1[ , idx ] <- vol[ , idx-1 ] + volinp1[idx] * wt > ? }? > volyrdc1 > > My final matrix in 'volyrdc1' (kind of transition matrix model). > > Now, what I want to do is to calculate when the colsum<- > colSums(volyrdc1) reaches a certain value and I want to get the > index of the element in the 'colsum' vector at that point. For e.g. > when colsum[colsum>=18] ? It will give a series of cases where the > condition is true. But I want index of the element immediately when > the condition is met. In this case, the answer I want is 140 > (colsum[29] returns both value (18.63) and the character ("140") > attributing the index). Actually, in my case 140 is year (age) when > the 'colsum' becomes > >=18. At is point it would be great if I can calculate when 'colsum' levels > off (up to two decimal place)? The answer is: 305 and at that point > colsum==45.37.? > > I also want to calculate what should be the value in volini[1,1] to > get a certain value in 'colsum' at a certain year (age)(vector > element index explained earlier)? For e.g. I want to find out that > what should be the value in volini[1,1] if I want colsum==18 at > 100(charater attributing colsum[21])? The answer is: 15910 and the > 'volini' matrix will look like: > > volini<-matrix(c(15910,0,0,0,0),nrow=5,ncol=1) > > Any pointer, suggestions,... will be gratefully acknowledged. > > P.S. Can you please suggest me any effective R programming book that > describe core elements of R programming? > > Thanks in advance. > > Regards, > > Halim? ? ? ? ? ? ? ? > --------------- > Md. Abdul Halim > Assistant Professor > Department of Forestry and Environmental Science > Shahjalal University of Science and Technology,Sylhet-3114, > Bangladesh. > Cell: +8801714078386. > alt. e-mail: xou03 at yahoo.com > > On Tue, 26 Nov 2013 20:21:14 -0800 (PST), arun wrote > > HI Halim, > > > > No problem. > > Regards, > > Arun > > > > On Tuesday, November 26, 2013 11:18 PM, halim10-fes <halim10- > > fes at sust.edu> wrote: Hi Arun, > > > > Thanks for your help. Sorry for my late response. Take care and stay > > fine. > > > > Regards, > > > > Halim > > > > On Sun, 24 Nov 2013 07:45:24 -0800 (PST), arun wrote > > > Hi Halim, > > > I guess this works for you.? Modifying Jeff's solution: > > > > > > volinp<-c(0,0.000467,0.002762,0.008621,0.020014,0.038907,0.067094) > > > vol1 <- dcmat %*% (volmat +wt) > > > for(idx in seq_along(volinp)[-1]){ > > > ?vol1 <- cbind(vol1,dcmat %*% (vol1[,idx-1] + volinp[idx] *wt)) > > > ?} > > > > > > #or > > > > > > vol <- matrix( NA, nrow=5, ncol=length( volinp ) ) > > > vol[ , 1 ] <- dcmat %*% ( volmat + wt ) > > > > > > for ( idx in seq_along(volinp)[ -1 ] ) { > > > ? vol[ , idx ] <- dcmat %*% ( vol[ , idx-1 ] + volinp[idx] * wt ) > > > } > > > identical(vol,vol1) > > > #[1] TRUE > > > > > > A.K. > > > > > > On Sunday, November 24, 2013 7:16 AM, halim10-fes <halim10- > > > fes at sust.edu> wrote: Hi Arun, > > > > > > OK, no problem. Thank you very much for your attention. I've posted > > > an annex to my previous problem. I will appreciate your > > > comments/suggestions on it. > > > > > > Off-topic: You're a very helpful man. I like your attitude to > > > helping others. > > > > > > Take care. > > > > > > Halim > > > > > > On Sun, 24 Nov 2013 01:18:18 -0800 (PST), arun wrote > > > > Hi, > > > > Please disregard my earlier message. Looks like Jeff understand it > > > > better and answered it. Regards, Arun > > > > > > > > On Sunday, November 24, 2013 3:23 AM, arun <smartpink111 at yahoo.com> > wrote: > > > > Hi, > > > > I am finding some inconsistency with your description. > > > > For example: > > > > volinp[1]+volmat[1,1] > > > > [1] 101 > > > > > > > > On Sunday, November 24, 2013 1:52 AM, halim10-fes <halim10- > > > > fes at sust.edu> wrote: > > > > > > > > Please apologize me! Earlier I've sent a message erroneously. > > > > Following is the original problem for which I'm seeking help. > > > > Extremely sorry...? > > > > > > > > Hi Arun, > > > > > > > > Thank you very much for your response. Sorry, if I couldn't explain > > > > clearly. I think, I should restate the problem to get exactly what I > > > > want. Here it goes: > > > > > > > > I have 2 matrices and 1 vector, namely, > > > > > > > > dcmat<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00, > > > > 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22, > > > > 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5) > > > > > > > > volmat<-matrix(c(100,0,0,0,0),nrow=5,ncol=1) > > > > > > > > volinp<-c(1:40) > > > > > > > > What I essentially want to do is to multiply 'dcmat' with 'volmat' > > > > and dump the output in a new matrix 'vol'. But before that, in the > > > > first step, I want to add volinp[1] with volmat[1,1]. So, the first > > > > column of the output matrix 'vol' matrix will be: > > > > > > > > ? ? ? ? [,1] > > > > [1,]?? 13.13 > > > > [2,]?? 61.61 > > > > [3,]?? 25.25 > > > > [4,]? ? 0.00 > > > > [5,]? ? 0.00 > > > > > > > > In the 2nd step, I want to replace 'volmat' with vol[,1] and add > > > > volinp[2] with vol[1,1]. The new 'volmat' will look like: > > > > > > > > ? ? ? ? [,1] > > > > [1,]?? 15.13 > > > > [2,]?? 61.61 > > > > [3,]?? 25.25 > > > > [4,]? ? 0.00 > > > > [5,]? ? 0.00 > > > > > > > > Then multiply 'dcmat' with the new 'volmat', and the 2nd column of > > > > output matrix 'vol' will look like: > > > > > > > > ? ? ? ? [,2] > > > > [1,]? 1.9669 > > > > [2,] 41.2665 > > > > [3,] 41.2232 > > > > [4,] 13.1199 > > > > [5,]? 2.7775 > > > > > > > > Then again, replace the 'volmat' with vol[,2], add volinp[3] with > > > > vol[1,2] and multiply the new 'volmat' with 'dcmat'. This > > > > replacement, addition, multiplication, and dumping will continue up > > > > to the length of 'volinp' and the final output matrix 'vol' will be > > > > something like: > > > > > > > > ? ? ? [,1]? ? [,2]? ? ? [,3]? ? ...length(volinp) > > > > [1,] 13.13?? 1.9669?? 0.645697? ... > > > > [2,] 61.61? 41.2665? 24.488389? ... > > > > [3,] 25.25? 41.2232? 40.419786? ... > > > > [4,]? 0.00? 13.1199? 22.116099? ... > > > > [5,]? 0.00?? 2.7775?? 7.670905? ...? > > > > > > > > Within my limited capacity, I've tried to come up with a solution > > > > but failed. > > > > > > > > I'll appreciate your/others' help with gratefulness. > > > > > > > > Regards, > > > > > > > > Halim > > > > > > > > --------------- > > > > Md. Abdul Halim > > > > Assistant Professor > > > > Department of Forestry and Environmental Science > > > > Shahjalal University of Science and Technology,Sylhet-3114, > > > > Bangladesh. > > > > Cell: +8801714078386. > > > > alt. e-mail: xou03 at yahoo.com > > > > > > > > On Sat, 23 Nov 2013 14:10:12 -0800 (PST), arun wrote > > > > > Hi, > > > > > Could you show your expected output?? It is a bit unclear from the > > > > description. > > > > > > > > > > On Saturday, November 23, 2013 2:00 PM, halim10-fes <halim10- > > > > > fes at sust.edu> wrote: Dear R-friends, > > > > > > > > > > Hope you doing well. I've been trying to deal with the following > > > > > problem for the couple of days but couldn't come up with a solution. > > > > > It would be great if any of you could give some insight into it. > > > > > > > > > > I have three matrices like: > > > > > > > > > > dcvol<-matrix(c(0.13,0.61,0.25,0.00,0.00,0.00,0.52,0.37,0.09,0.00, > > > > > 0.00,0.00, ? ? ? ? ? ? ? ? 0.58,0.30,0.11,0.00,0.00,0.00,0.46,0.22, > > > > > 0.00,0.00,0.00,0.00, ? ? ? ? ? ? ? ? 0.09),nrow=5,ncol=5) > > > > volinp<- > > > > > matrix(c(100,0,0,0,0),nrow=5,ncol=1) > > > > > > > > > > scvol<-matrix(c(1:40),nrow=5,ncol=8) > > > > > > > > > > What I essentially want to do is to add each value in scvol[1,] with > > > > > the volinp[1,1] and then multiply each new volinp with dcvol and > > > > > finally put the outputs in a new matrix. > > > > > > > > > > Thanks in advance. > > > > > > > > > > Halim? ? ? ? ? ? ? ? > > > > > --------------- > > > > > Md. Abdul Halim > > > > > Assistant Professor > > > > > Department of Forestry and Environmental Science > > > > > Shahjalal University of Science and Technology,Sylhet-3114, > > > > > Bangladesh. > > > > > Cell: +8801714078386. > > > > > alt. e-mail: xou03 at yahoo.com > > > > > > > > > > -- > > > > > This message has been scanned for viruses and > > > > > dangerous content by MailScanner, and is > > > > > believed to be clean. > > > > > > > > > > ______________________________________________ > > > > > R-help at r-project.org mailing list > > > > > https://stat.ethz.ch/mailman/listinfo/r-help > > > > > PLEASE do read the posting guide http://www.R-project.org/posting- > > > guide.html > > > > > and provide commented, minimal, self-contained, reproducible code. > > > > > > > > -- > > > > This message has been scanned for viruses and > > > > dangerous content by MailScanner, and is > > > > believed to be clean. > > > > > > > > -- > > > > This message has been scanned for viruses and > > > > dangerous content by MailScanner, and is > > > > believed to be clean.> > > > > > > > > --------------- > > > Md. Abdul Halim > > > Assistant Professor > > > Department of Forestry and Environmental Science > > > Shahjalal University of Science and Technology,Sylhet-3114, > > > Bangladesh. > > > Cell: +8801714078386. > > > alt. e-mail: xou03 at yahoo.com > > > > > > -- > > > This message has been scanned for viruses and > > > dangerous content by MailScanner, and is > > > believed to be clean. > > > > > > -- > > > This message has been scanned for viruses and > > > dangerous content by MailScanner, and is > > > believed to be clean. > > > > --------------- > > Md. Abdul Halim > > Assistant Professor > > Department of Forestry and Environmental Science > > Shahjalal University of Science and Technology,Sylhet-3114, > > Bangladesh. > > Cell: +8801714078386. > > alt. e-mail: xou03 at yahoo.com > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > > > -- > > This message has been scanned for viruses and > > dangerous content by MailScanner, and is > > believed to be clean. > > --------------- > Md. Abdul Halim > Assistant Professor > Department of Forestry and Environmental Science > Shahjalal University of Science and Technology,Sylhet-3114, > Bangladesh. > Cell: +8801714078386. > alt. e-mail: xou03 at yahoo.com > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean.--------------- Md. Abdul Halim Assistant Professor Department of Forestry and Environmental Science Shahjalal University of Science and Technology,Sylhet-3114, Bangladesh. Cell: +8801714078386. alt. e-mail: xou03 at yahoo.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.