Hi petr,
Thanks for the reply.
My original data is in "comma separated variable" (csv) format with variable
names in column 1 and numeric data in the remaining columns. The "read.csv"
command reads this data set into object name "pcrdata" as a dataframe where
the variable names and numeric data are conserved (as required). However,
when I transpose the table it becomes a matrix and all the data become
"character". Using the "as.data.frame" command coerces the matrix to a
dataframe but, at the same time, changes all the data to "factor". As far as
I can see, for my analysis I need to coerce the data in the matrix, formed
by transposition of the raw data, to "factor" in row 1 and "numeric" for the
remaining rows before then converting the matrix to a dataframe, using the
"as.data.frame" command. Is this the information you required and, if so, is
what I am asking at all possible?
Best wishes,
Mike
On 17 March 2010 15:13, Petr PIKAL <petr.pi...@precheza.cz> wrote:
> Hi
>
> r-help-boun...@r-project.org napsal dne 17.03.2010 15:23:34:
>
> > I am currently trying to write a program that minimises the amount of
> work
> > required for auditable qPCR data. At the moment I am using an Excel
> (.csv)
> > spreadsheet as source data that has been transposed to the column format
> > required for R to read. Unfortunately, this means I have* *to manually
> > confirm the whole data set prior to doing any analysis, which is taking
> a
> > considerable amount of time! My idea now is to read the raw data in
> directly
> > and get R to do the transformation prior to analysis. The problem I now
> have
> > is that, upon transposition, the data are converted to character in a
> > matrix, rather than factor and numeric in a dataframe. I have
> succeeded
> > in changing the matrix to a dataframe (via as.data.frame(object)), but
> this
> > then converts all the data to factor which I cant use for my analysis
> > since, other than the column headings, I need the data to be numeric. I
> have
> > tried coercing the data to numeric using the as() and as.numeric()
> commands,
> > but this has no effect on the data format. I have no experience in
> > programming and so am at a loss as to what to do: am I making a basic
> error
> > in my programming or missing something essential (or both!)?
> >
> >
> >
> > I am using R version 2.9.0 at the moment, but this will change as soon
> as I
> > have sorted this issue out. Below is the code I have put together, as
> you
> > can see it is VERY brief but essential to allow my analysis to proceed:
> >
> >
> >
> > pcrdata<-read.csv("File_path",header=FALSE)
> ^^^^^^^^^^^^^^^^
>
> This is supposed to be data frame already. As you did not show us any of
> possible clues of data type like
>
> str(pcrdata)
>
> it is difficult to say.
>
> However from your description your original data are in columns which have
> numeric and character data together which is not possible. I believe that
> there are options for reading such data.
>
> >
> > pcrdata<-as.data.frame(t(pcrdata))
>
> OK. Here you say you get data in columns but they are all character.
>
> >
> > pcrdata[2:51]<-as.numeric(as.character(pcrdata))
> >
>
> Here it depends whether they are all numeric or if some of them shall be
> character (factor). Functions like those above can not be used directly on
> data frames. You need to use apply.
>
> apply(pcrdata, 1, as.character)
>
> Exact sequence of required functions is impossible to guess without
> knowing structure of your objects.
>
> You shall also consult R intro and R data manuals.
>
> Regards
> Petr
>
>
> >
> >
> > Any help would be gratefully appreciated,
> >
> >
> >
> > Mike Glanville
> >
> > [[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<http://www.r-project.org/posting-guide.html>
> > and provide commented, minimal, self-contained, reproducible code.
>
>
[[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.
