Hi > > You might want to re-read the "Intro to R" and the section on > dataframes. Your spreadsheet is read into R as a dataframe which is > very similar to an Excel spreadsheet. Exactly what problem are you > having with it? Is it trying to access the data? > > 2012/4/6 Pedro Henrique <lama...@superig.com.br>: > > Hi, Petr, > > Thanks for answering. > > Yes, I do read the file with the "read.xls" command but I do not know how to > > read it into an object.
What was the result of reading the file by read.xls? AFAIK Any read.* function does read some data either to console (and print them) or to some object for further use. mydata <- read.xls(something) > > I read the R-into document chapter of objects, but I is still not clear for > > me how to transform this kind of data into an object. My mind reading ability is rather undeveloped so if you PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. e.g. **how** did you read your file to R. Regards Petr > > > > Regards, > > > > Lämarao > > > > > > ----- Original Message ----- From: "Petr PIKAL" <petr.pi...@precheza.cz> > > To: "Pedro Henrique" <lama...@superig.com.br> > > Cc: <r-help@r-project.org> > > Sent: Friday, April 06, 2012 6:27 AM > > Subject: Hi: [R] Help Using Spreadsheets > > > > > > Hi > >> > >> Hello, > >> > >> I am a new user of R and I am trying to use the data I am reading from a > > > > > >> spreadsheet. > >> I installed the xlsReadWrite package and I am able to read data from > > > > this > >> > >> files, but how can I assign the colums into values? > >> E.g: > >> as I read a spreadsheet like this one: > > > > > > Maybe with read.xls? Did you read it into an object? > > > >> A B > >> 1 2 > >> 4 9 > >> > >> I manually assign the values: > >> A<-c(1,4) > >> B<-c(2,9) > > > > > > Why? If you read in to an object (e.g. mydata) > > > > > >> > >> to plot it on a graph: > >> plot(A,B) > > > > > > plot(mydata$A, mydata$B) > > > > > >> > >> or make histograms: > >> hist(A) > > > > > > hist(mydata$A) > > > >> > >> But actualy I am using very large colums, does exist any other way to do > > > > > >> it automatically? > > > > > > Yes. But before that you shall automatically read some introduction > > documentation like R-intro) > > > > Regards > > Petr > > > >> > >> Best Regards, > >> > >> Lämarăo > >> [[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. > > > > > > ______________________________________________ > > 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. > > > > -- > Jim Holtman > Data Munger Guru > > What is the problem that you are trying to solve? > Tell me what you want to do, not how you want to do it. ______________________________________________ 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.
