thr3ads.net - R help - [R] Help Using Spreadsheets [Apr 2012]

If this information is useful, please help other people find it:
Share via:

Pedro Henrique

2012-Apr-05 23:01 UTC

[R] Help Using Spreadsheets

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]]

Petr PIKAL

2012-Apr-06 09:27 UTC

head link

[R] Hi: 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.

Pedro Henrique

2012-Apr-06 13:08 UTC

head link

[R] Help Using Spreadsheets

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.

jim holtman

2012-Apr-06 17:07 UTC

head link

[R] Help Using Spreadsheets

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.

Petr PIKAL

2012-Apr-10 08:51 UTC

head link

[R] 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.

Apparently Analagous Threads

Search for more apparently analagous threads

R help - Apr 2012 - Help Using Spreadsheets

[R] Help Using Spreadsheets

[R] Hi: Help Using Spreadsheets

[R] Help Using Spreadsheets

[R] Help Using Spreadsheets

[R] Help Using Spreadsheets

Apparently Analagous Threads