thr3ads.net - R help - [R] data.frame query [Oct 2010]

If this information is useful, please help other people find it:
Share via:

Etn

2010-Oct-21 16:52 UTC

[R] data.frame query

Hi All,

Apologies for the simplicity of my question, but I would be grateful for any
advice. Thanks

I'm trying to put the output from a for loop into a data frame, however I
have not been successful.

The steps I have taken are:



*R-code:*
>for (k in 1:(nt-1-n0) ){
>    n<- n0-1+k
>    lam=n/nt
>    Q=x[n]
> output1<-data.frame(cbind(k,n,lam,Q))
> output1
>  }
> output1

*R-Output *
     k    n  lam   Q
1 14  18  0.9   18


I would like the output in this format, but for all the values of k (i.e.
1-14 as opposed to just the last value)


I have also tried

*R-code:*
> nt=20
> n0=5
> x=c(1:20)
> for (k in 1:(nt-1-n0) ){
>      n<- n0-1+k
>      lam=n/nt
>      Q=x[n]
> output1<-data.frame(cbind(k,n,lam,Q))
> print(output1)
>  }

*R-Output  *

    k n  lam Q
1 1 5 0.25 5
   k n lam Q
1 2 6 0.3 6
   k n  lam Q
1 3 7 0.35 7
   k n lam Q
1 4 8 0.4 8
  k n  lam Q
1 5 9 0.45 9
  k  n lam  Q
1 6 10 0.5 10
  k  n  lam  Q
1 7 11 0.55 11

	[[alternative HTML version deleted]]

Dennis Murphy

2010-Oct-21 17:23 UTC

head link

[R] data.frame query

Hi:

Does this work?

mdat <- function(nt, n0, n1) {
    l <- nt - n0 - 1
    k <- seq(l)      # same as 1:l
    n <- n0 - 1 + k
    lam <- n/nt
    Q <- seq(n1)[n]
    data.frame(k = k, n = n, lam = lam, Q = Q)
  }
>  mdat(20, 5, 20)    k  n  lam  Q
1   1  5 0.25  5
2   2  6 0.30  6
3   3  7 0.35  7
4   4  8 0.40  8
5   5  9 0.45  9
6   6 10 0.50 10
7   7 11 0.55 11
8   8 12 0.60 12
9   9 13 0.65 13
10 10 14 0.70 14
11 11 15 0.75 15
12 12 16 0.80 16
13 13 17 0.85 17
14 14 18 0.90 18

No loops :)

HTH,
Dennis


On Thu, Oct 21, 2010 at 9:52 AM, Etn <2nuzzbot@gmail.com> wrote:
> Hi All,
>
> Apologies for the simplicity of my question, but I would be grateful for
> any
> advice. Thanks
>
> I'm trying to put the output from a for loop into a data frame, however
I
> have not been successful.
>
> The steps I have taken are:
>
>
>
> *R-code:*
>
> >for (k in 1:(nt-1-n0) ){
> >    n<- n0-1+k
> >    lam=n/nt
> >    Q=x[n]
>
> > output1<-data.frame(cbind(k,n,lam,Q))
> > output1
> >  }
>
> > output1
>
>
> *R-Output *
>     k    n  lam   Q
> 1 14  18  0.9   18
>
>
> I would like the output in this format, but for all the values of k (i.e.
> 1-14 as opposed to just the last value)
>
>
> I have also tried
>
> *R-code:*
>
> > nt=20
> > n0=5
> > x=c(1:20)
> > for (k in 1:(nt-1-n0) ){
> >      n<- n0-1+k
> >      lam=n/nt
> >      Q=x[n]
>
> > output1<-data.frame(cbind(k,n,lam,Q))
> > print(output1)
> >  }
>
>
> *R-Output  *
>
>    k n  lam Q
> 1 1 5 0.25 5
>   k n lam Q
> 1 2 6 0.3 6
>   k n  lam Q
> 1 3 7 0.35 7
>   k n lam Q
> 1 4 8 0.4 8
>  k n  lam Q
> 1 5 9 0.45 9
>  k  n lam  Q
> 1 6 10 0.5 10
>  k  n  lam  Q
> 1 7 11 0.55 11
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@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.
>
	[[alternative HTML version deleted]]

Adrienne Wootten

2010-Oct-21 17:24 UTC

head link

[R] data.frame query

Try this:

before your loop put this

output1 <- NULL

in the loop at the end put this

temp <- data.frame(cbind(k,n,lam,Q))
output1 <- rbind(output1,temp)

this should do the trick for you

Adrienne
NCSU

On Thu, Oct 21, 2010 at 12:52 PM, Etn <2nuzzbot@gmail.com> wrote:
> Hi All,
>
> Apologies for the simplicity of my question, but I would be grateful for
> any
> advice. Thanks
>
> I'm trying to put the output from a for loop into a data frame, however
I
> have not been successful.
>
> The steps I have taken are:
>
>
>
> *R-code:*
>
> >for (k in 1:(nt-1-n0) ){
> >    n<- n0-1+k
> >    lam=n/nt
> >    Q=x[n]
>
> > output1<-data.frame(cbind(k,n,lam,Q))
> > output1
> >  }
>
> > output1
>
>
> *R-Output *
>     k    n  lam   Q
> 1 14  18  0.9   18
>
>
> I would like the output in this format, but for all the values of k (i.e.
> 1-14 as opposed to just the last value)
>
>
> I have also tried
>
> *R-code:*
>
> > nt=20
> > n0=5
> > x=c(1:20)
> > for (k in 1:(nt-1-n0) ){
> >      n<- n0-1+k
> >      lam=n/nt
> >      Q=x[n]
>
> > output1<-data.frame(cbind(k,n,lam,Q))
> > print(output1)
> >  }
>
>
> *R-Output  *
>
>    k n  lam Q
> 1 1 5 0.25 5
>   k n lam Q
> 1 2 6 0.3 6
>   k n  lam Q
> 1 3 7 0.35 7
>   k n lam Q
> 1 4 8 0.4 8
>  k n  lam Q
> 1 5 9 0.45 9
>  k  n lam  Q
> 1 6 10 0.5 10
>  k  n  lam  Q
> 1 7 11 0.55 11
>
>        [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@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.
>
	[[alternative HTML version deleted]]

David Winsemius

2010-Oct-21 17:27 UTC

head link

[R] data.frame query

On Oct 21, 2010, at 12:52 PM, Etn wrote:
> Hi All,
>
> Apologies for the simplicity of my question, but I would be grateful  
> for any
> advice. Thanks
>
> I'm trying to put the output from a for loop into a data frame,  
> however I
> have not been successful.
>
> The steps I have taken are:
>
>
>
> *R-code:*
>
>> for (k in 1:(nt-1-n0) ){
>>   n<- n0-1+k
>>   lam=n/nt
>>   Q=x[n]
so n=n0+1+(1:(nt-1-n0))
and lam=(n0+1+(1:(nt-1-n0))/nt
and Q=x[0+1+(1:(nt-1-n0))]

Using the parameters below:

nt=20
n0=5
x=c(1:20)

 > output3 = data.frame(k = 1:(nt-1-n0),
+                      n = n0+1+(1:(nt-1-n0)),
+                      lam = (n0+1+(1:(nt-1-n0)))/nt ,
+                      Q = x[0+1+(1:(nt-1-n0))] )


(I don't get what you calculated but you should be able to work toward  
a solution.)
 > output3
     k  n  lam  Q
1   1  7 0.35  2
2   2  8 0.40  3
3   3  9 0.45  4
4   4 10 0.50  5
5   5 11 0.55  6
6   6 12 0.60  7
7   7 13 0.65  8
8   8 14 0.70  9
9   9 15 0.75 10
10 10 16 0.80 11
11 11 17 0.85 12
12 12 18 0.90 13
13 13 19 0.95 14
14 14 20 1.00 15>
>> output1<-data.frame(cbind(k,n,lam,Q))
>> output1
>> }
>
>> output1
>
>
> *R-Output *
>     k    n  lam   Q
> 1 14  18  0.9   18
>
>
> I would like the output in this format, but for all the values of k  
> (i.e.
> 1-14 as opposed to just the last value)
>
>
> I have also tried
>
> *R-code:*
>
>> nt=20
>> n0=5
>> x=c(1:20)
>> for (k in 1:(nt-1-n0) ){
>>     n<- n0-1+k
>>     lam=n/nt
>>     Q=x[n]
>
>> output1<-data.frame(cbind(k,n,lam,Q))
>> print(output1)
>> }
>
>
> *R-Output  *
>
>    k n  lam Q
> 1 1 5 0.25 5
>   k n lam Q
> 1 2 6 0.3 6
>   k n  lam Q
> 1 3 7 0.35 7
>   k n lam Q
> 1 4 8 0.4 8
>  k n  lam Q
> 1 5 9 0.45 9
>  k  n lam  Q
> 1 6 10 0.5 10
>  k  n  lam  Q
> 1 7 11 0.55 11
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
David Winsemius, MD
West Hartford, CT

J.delasHeras at ed.ac.uk

2010-Oct-21 17:31 UTC

head link

[R] data.frame query

you forgot to include "output1" in your cbind call.

what I normally do is initialise the variable where I want to store  
the dataframe prior to starting the loop:

output1<-NULL

then run the loop, and within it there should be a:

output1<-cbind(output1, newdata)

where 'newdata' will be the new column the loop just calculated and I  
want to add to the dataframe.

That way the dataframe grows as the data is produced.

As long as you don't have many columns/rows to add it will work fine.  
When I was handling large dataframes I found it was a very inefficient  
method and it takes too long after it has a few thousand data points.  
In that case it's much better to calculate beforehand how big the  
dataframe will be, and initialise it in full size, then just fill in  
as needed.

I hope this helps.

Jose





Quoting Etn <2nuzzbot at gmail.com>:
> Hi All,
>
> Apologies for the simplicity of my question, but I would be grateful for
any
> advice. Thanks
>
> I'm trying to put the output from a for loop into a data frame, however
I
> have not been successful.
>
> The steps I have taken are:
>
>
>
> *R-code:*
>
>> for (k in 1:(nt-1-n0) ){
>>    n<- n0-1+k
>>    lam=n/nt
>>    Q=x[n]
>
>> output1<-data.frame(cbind(k,n,lam,Q))
>> output1
>>  }
>
>> output1
>
>
> *R-Output *
>      k    n  lam   Q
> 1 14  18  0.9   18
>
>
> I would like the output in this format, but for all the values of k (i.e.
> 1-14 as opposed to just the last value)
>
>
> I have also tried
>
> *R-code:*
>
>> nt=20
>> n0=5
>> x=c(1:20)
>> for (k in 1:(nt-1-n0) ){
>>      n<- n0-1+k
>>      lam=n/nt
>>      Q=x[n]
>
>> output1<-data.frame(cbind(k,n,lam,Q))
>> print(output1)
>>  }
>
>
> *R-Output  *
>
>     k n  lam Q
> 1 1 5 0.25 5
>    k n lam Q
> 1 2 6 0.3 6
>    k n  lam Q
> 1 3 7 0.35 7
>    k n lam Q
> 1 4 8 0.4 8
>   k n  lam Q
> 1 5 9 0.45 9
>   k  n lam  Q
> 1 6 10 0.5 10
>   k  n  lam  Q
> 1 7 11 0.55 11
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> 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.
>
>


-- 
Dr. Jose I. de las Heras                      Email: J.delasHeras at ed.ac.uk
The Wellcome Trust Centre for Cell Biology    Phone: +44 (0)131 6507095
Institute for Cell & Molecular Biology        Fax:   +44 (0)131 6507360
Swann Building, Mayfield Road
University of Edinburgh
Edinburgh EH9 3JR
UK


-- 
The University of Edinburgh is a charitable body, registered in
Scotland, with registration number SC005336.

Possibly Parallel Threads

Search for more seemingly similar threads

R help - Oct 2010 - data.frame query

[R] data.frame query

[R] data.frame query

[R] data.frame query

[R] data.frame query

[R] data.frame query

Possibly Parallel Threads