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: A B 1 2 4 9 I manually assign the values: A<-c(1,4) B<-c(2,9) to plot it on a graph: plot(A,B) or make histograms: hist(A) But actualy I am using very large colums, does exist any other way to do it automatically? Best Regards, Lämarão [[alternative HTML version deleted]]
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 fromthis> 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 guidehttp://www.R-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.
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. 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. 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 fromthis> 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 guidehttp://www.R-project.org/posting-guide.html> and provide commented, minimal, self-contained, reproducible code.
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. > 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. > > 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.
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 knowhow 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 notclear 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 readingfrom 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 todo> > > > > >> 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 guidehttp://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.