Help Using Spreadsheets
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 <lamarao at 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.pikal at precheza.cz>
To: "Pedro Henrique" <lamarao at superig.com.br> Cc: <r-help at 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 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. ______________________________________________ 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.
-- 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.