**NEW TO R**-been trying to teach myself with no prior experience in computer languages, so I apologize if I am poor at using technical terms Hi, I have perused some of the previous posts on this topic and tried their solutions, but am still coming up with error messages(sometimes more than 50 at a time) I have: a csv file with four columns(that I have read into R, no problem, we will call it DATA) date, Location1, Location2, total Dates cover almost a year location values are number of fish seen at that location I would like to show a stacked bar plot so someone can see the breakdown for total fish seen on any particular day. I was able to create a simple bar plot for total number of fish versus Date, but when I have tried to make a stacked graph it creates four bars(one for each column). Do I have to convert my data so each date has its own column or is there a way I can use my data as is? script I have tried: barplot(as.matrix(DATA)) barplot(t(DATA),names.arg=DATA$Date) fish<-table(DATA$Location1,DATA$Location2) barplot(fish,names.arg=DATA$Date) Any help is appreciated. -- View this message in context: http://r.789695.n4.nabble.com/using-csv-file-for-stacked-bar-plot-rows-to-columns-tp3899909p3899909.html Sent from the R help mailing list archive at Nabble.com.
using csv file for stacked bar plot, rows to columns
2 messages · Davis_fishgirl, Sarah Goslee
Hi,
On Wed, Oct 12, 2011 at 6:11 PM, Davis_fishgirl <lrledesma at gmail.com> wrote:
**NEW TO R**-been trying to teach myself with no prior experience in computer languages, so I apologize if I am poor at using technical terms Hi, I have perused some of the previous posts on this topic and tried their solutions, but am still coming up with error messages(sometimes more than 50 at a time) I have: a csv file with four columns(that I have read into R, no problem, we will call it DATA) date, Location1, Location2, total Dates cover almost a year location values are number of fish seen at that location
So your question doesn't have anything to do with CSV files, but only with making a stacked barplot from a data frame.
I would like to show a stacked bar plot so someone can see the breakdown for total fish seen on any particular day. ?I was able to create a simple bar plot for total number of fish versus Date, but when I have tried to make a stacked graph it creates four bars(one for each column). Do I have to convert my data so each date has its own column or is there a way I can use my data as is? script I have tried: barplot(as.matrix(DATA)) barplot(t(DATA),names.arg=DATA$Date) fish<-table(DATA$Location1,DATA$Location2) barplot(fish,names.arg=DATA$Date)
If you read the help for barplot, you'll see that the argument beside controls whether the bars are next to each other or stacked. You'll get better answers if you provide a reproducible example (see posting guide, please), but this may be enough to get you going.
testdata <- data.frame(Date=1:5, Location1=sample(1:10, 5, replace=TRUE), Location2=sample(1:10, 5, replace=TRUE)) testdata
Date Location1 Location2 1 1 3 10 2 2 10 6 3 3 2 9 4 4 4 10 5 5 8 2
barplot(t(testdata[, 2:3]), beside=FALSE, names=testdata$Date)
Sarah
Sarah Goslee http://www.functionaldiversity.org