0

I want to draw Boxplots of Measurement-Data grouped by a distance value. My csv-File is like this:

distance;fp1;fp2;fp3;...;fp99
30;-54;-51;-45;...;-56
40;...
...
400;...

Now I want to draw Boxplots for each row with the value of fp1-fp99 and the distance as x-Axis value, so that I have multiple boxplots for the different distance side by side ordered by their distance. Hope somebody can help me.

So here is a sample:

library(ggplot2)
library(reshape)

data <- read.csv(file='file.csv', head=TRUE, sep=';')

pdf(file="output.pdf", onefile=TRUE, pagecentre=TRUE, width=12, height=6)
data$group <- row.names(data)
data.m <- melt(data, id.vars = "group")



print(
    ggplot(data.m, aes(group, value)) + geom_boxplot()  
)

That produces this:

enter image description here

I want to exclude the distance for the box plot and use it as x-coordinate. I hope you guys understand what I mean.

Sven Hohenstein
  • 80,497
  • 17
  • 145
  • 168
moogle
  • 33
  • 1
  • 5
  • Welcome to SO. People are much more happy to help if you provide a [**minimal, reproducible example**](http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example/5963610#5963610) and show us the code you have tried and explain what went wrong. – Henrik Feb 20 '14 at 14:44

1 Answers1

0

An example filename.csv

distance;fp1;fp2;fp3;fp99
30;-54;-51;-45;-56
40;-30;-40;-40;-50

Here's a solution:

# read data
dat <- read.csv2("filename.csv")

# reshape data
library(reshape2)
dat_m <- melt(dat, id.vars = "distance")

# plot data
boxplot(value ~ distance, dat_m)

enter image description here

If you prefer ggplot2, you can use:

library(ggplot2)
ggplot(dat_m, aes(x = as.factor(distance), y = value)) +
  geom_boxplot()

enter image description here

Sven Hohenstein
  • 80,497
  • 17
  • 145
  • 168