R help - Sep 2009 - (no subject)

How would I make a histogram using R from a table in excel that has 4
variables, but I only want to use 2 of the columns to make the histogram?


	[[alternative HTML version deleted]]

Hi Karen,

As you are just starting (I guess), I suggest you take a shortcut:
1. copy and paste the data from Excel to the notepad, and
save it as .TXT
2. If all is ok, you will have a tab-delimited file.
3. Be sure that your variables have its names on first line
4. read your data using

setwd("c:\\temp")
myDF<-read.table("myfile.txt", head=T, sep="\t")
myDF   #here you will see all your data.frame (i.e. your table)

hist(myDF$VARNAME)
or
hist(myD[,1]) #to plot 1st collumn
 hist(myD[,2]) #to plot 2nd collumn


good luck..

milton

On Sun, Sep 13, 2009 at 7:44 PM, Karen Federico
<kfederic@stevens.edu>wrote:
> How would I make a histogram using R from a table in excel that has 4
> variables, but I only want to use 2 of the columns to make the histogram?
>
>
>        [[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<http://www.r-project.org/posting-guide.html>
> and provide commented, minimal, self-contained, reproducible code.
>
	[[alternative HTML version deleted]]

Karen
You can copy and paste data directly into R from Excel:
1. Mark the data including the headings in Excel
2. Ctrl-C
3. In R:
myDF <- read.delim("clipboard")

Following from Milton:
hist(myDF$VARNAME)
or
hist(myD[,1]) #to plot 1st collumn
hist(myD[,2]) #to plot 2nd collumn

Schalk Heunis


On Mon, Sep 14, 2009 at 1:44 AM, Karen Federico
<kfederic@stevens.edu>wrote:
> How would I make a histogram using R from a table in excel that has 4
> variables, but I only want to use 2 of the columns to make the histogram?
>
>
>        [[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.
>
	[[alternative HTML version deleted]]