[R] Dataframes and text identifier columns
Richard M. Heiberger
rmh at temple.edu
Sun Jun 29 19:34:08 CEST 2014
Inp_dat<- read.csv("/File/Input data.csv")
out_put[i,]<-data.frame(Case, stdL, stdPP, stdSE, L, PP, PP_SE)
These two statements look like the source of the problem.
Add the optional argument
stringsAsFactors=FALSE
to both.
Rich
On Sun, Jun 29, 2014 at 8:46 AM, Brian Willis <b.h.willis at bham.ac.uk> wrote:
> I am trying to incrementally add rows to an empty data frame. The data has 7
> columns, the last 6 are numeric.
>
> For the first columns I would like to include a text identifier, called
> ‘Case’ like Andrew, Burt, Charlie etc. that is also output to a data frame –
> this is where I am having the problem
>
> The identifiers are being input from file which automatically assigns them
> to a data frame
> Code:
>
> Inp_dat<- read.csv("/File/Input data.csv")
>
> out_put<-data.frame(Case=character(), StdL=numeric(), StdPP=numeric(),
> StdSE=numeric(), L=numeric(), MRPP=numeric(), MRSE=numeric(),
> stringsAsFactors=FALSE)
>
> for(i in 1:4)
> {
> if (i==1) b<-Andrew
> if (i==2) b<-Burt
> if (i==3) b<-Charlie
> if (i==4) b<-Dave
>
> pr <- Inp_dat$p[i]
> SE_pr <- Inp_dat$SE[i]
> r<- Inp_dat$r[i]
> n<- Inp_dat$n[i]
> Case<- levels(Inp_dat$Case)[i])
> …
>
> out_put[i,]<-data.frame(Case, stdL, stdPP, stdSE, L, PP, PP_SE)
>
> }
> out_put
>
> Case StdL StdPP StdSE L
> MRPP MRSE
> 1 1 19.466823 0.16432300 0.03137456 26.002294 0.2080145
> 0.03804692
> 2 1 2.334130 0.22566939 0.08962662 5.095703 0.3888451
> 0.08399101
> 3 1 2.588678 0.05502765 0.00454159 42.058326 0.4861511
> 0.02128030
> 4 1 7.857898 0.18457822 0.04372297 4.705487 0.1193687
> 0.01921609
>
>
> Unfortunately the Case column loses the labels Andrew, Burt …
>
> I’ve tried always to keep these, but are clearly doing something wrong. Can
> anyone help?
>
>
>
>
> --
> View this message in context: http://r.789695.n4.nabble.com/Dataframes-and-text-identifier-columns-tp4693184.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
More information about the R-help
mailing list