[R] Import from excel

Petr PIKAL petr.pikal at precheza.cz
Wed Jun 27 16:00:58 CEST 2007


Hi

r-help-bounces at stat.math.ethz.ch napsal dne 27.06.2007 15:43:53:

> 
> Thank you, but it still doesn't work completely
> 
> Thanks to you and the "dec=","" option, I can now do cours[5,5]*5 and 
get the 
> exact value
> 
> But I still cannot do matrix operations like cours[2,]%*%cours[5,]

As only you have cours we can only guess. You read it into data.frame 
which can have columns of different type. So my bet is, that you have one 
or more columns which is not numeric.

See how your cours looks like by

str(cours)

Regards
Petr

BTW. Maybe is time to look at some docummentation to R, especially R 
intro.

> 
> It says the arguments are neither matrix nor vectors.
> 
> :(> Date: Wed, 27 Jun 2007 09:30:32 -0400> From: ccleland at optonline.net> 

> Subject: Re: [R] Import from excel> To: croero at hotmail.com> CC: 
r-help at stat.
> math.ethz.ch> > Bruce Willy wrote:> > Hello,> > > > I have imported data 
from 
> Excel using the command > > 
cours=read.delim("w:/apprentissage/cours_2.txt")> 
> > after transforming my initial file with tab delimiters> > > > It 
seemed to 
> work> > > > It is 2-dimensionnal. When I type cours[5,5],> > I get this 
type 
> of message : "[1] 0,9760942761824 Levels: 0,495628477 0,893728761 
0,89640592 
> 0,903398558 ... 3,864414217"> > And when I want to multiply it, for 
example by
> 2 (cours[5,5]*2), I get : "Warning message:* ceci n'est pas pertinent 
pour des
> variables facteurs in: Ops.factor(cours[5, 5], 2)"> > i.e. approximately 
"this
> is not relevant for factor variables.> > > > What can I do if I want to 
> manipulate my variables ?> > > > Thank you very much > > You might try 
the 
> following:> > cours <- read.delim("w:/apprentissage/cours_2.txt", 
dec=",")> > 
> See the "dec" argument on the help page for read.delim().> > > 
> _________________________________________________________________> > > > 

> stallées directement dans votre Messenger !> > > > [[alternative HTML 
version 
> deleted]]> > > > > > > > 
> 
------------------------------------------------------------------------> 
> > 
> > ______________________________________________> > 
R-help at stat.math.ethz.ch 
> 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.> > -- > Chuck 
Cleland, 
> Ph.D.> NDRI, Inc.> 71 West 23rd Street, 8th floor> New York, NY 10010> 
tel: 
> (212) 845-4495 (Tu, Th)> tel: (732) 512-0171 (M, W, F)> fax: (917) 
438-0894
> _________________________________________________________________
> 
> stallées directement dans votre Messenger !
> 
>    [[alternative HTML version deleted]]
> 
> ______________________________________________
> R-help at stat.math.ethz.ch 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