4

(this follows ggplot2 loess Q for which I got a nice answer) -- leading to this plot:

answer image to first question

My R knowledge is quite limited (sorry!)

I plot a scatter using data from a table data1.

data1<-NaRV.omit(data[,c(2,3,7,10)]) #(2=start, 3=end, 7=value, 10=type)
ylabs='E / A - ratio'
p1<-ggplot(data1, aes(x=start, y=value)) +
ylim(0,5) +
geom_point(shape=points, col=pointcol1, na.rm=T) +
geom_hline(aes(yintercept=1, col=linecol)) +
geom_smooth(method="loess", span=spanv, fullrange=F, se=T, na.rm=T) +
#
xlab(xlabs) +
ylab(ylabs)

Some regions have no-data (incl one big region in the middle but also smaller discrete regions) where I would like to draw a colored segments at y=0 to illustrate this fact

I combined both data types into one table with a label column#10='type' (content for the scatter data ='cnv' and for the no-data='nregion'). nregions have 0 in the value column.

How can I take only 'cnv' data for the scatter and only 'nregion' data to draw the segments; both on the same plot?

I found geom_segment:

+ geom_segment(aes(x=data1$start, y=0, xend=data1$end, yend=0))

BUT I did not find a way to subset for each ggplot sub-plot.

Thanks

#### follow up on @gauden solution

Hi @gauden I tried your approach and it partly worked. My problem is that I cannot divide my data as nicely as you do using ]-1; 0] because my nregions are scattered (represented by the blue dots and lines in the picture) and are different for each new graph, as in this image:

target image with multiple segments

Consequently, the loess goes through the large nregion as before. How can I prevent loess in nregions?

#############################
## plot settings (edit below)
spanv<-0.1
pointcol1="#E69F00"
pointcol2="#56B4E9"
pointcol3="#009E73"
points=20
onecol="green"
colnreg="blue"
xlabs=paste(onechr, " position", " (loess-span=", spanv, ")", sep="")

##### end edit ##############

########################################################
## using the center coordinate of each segment and points

## prepare plot #1
# plot E / A - ratio
## draw loess average for cnv
## draw line for nregion
ylabs='E / A - ratio'
p1<-ggplot(chrdata, aes(x=start+1000, y=E.R, group=type, label=type)) +
ylim(0,5) +
geom_hline(aes(yintercept=1, col=onecol)) +
geom_point(data = chrdata[chrdata$type != 'nregion',], shape=points, col=pointcol2) +
geom_smooth(data = chrdata[chrdata$type != 'nregion',], method="loess", span=spanv) +
geom_point(data = chrdata[chrdata$type == 'nregion',], col=colnreg) +
geom_segment(data = chrdata[chrdata$type == 'nregion',], aes(x=start, y=E.R, xend=end, yend=E.R), colour=colnreg, linetype=1, size=1) +
xlab(xlabs) +
ylab(ylabs)
Community
  • 1
  • 1
splaisan
  • 845
  • 6
  • 22

1 Answers1

7

EDIT: Complete revision to allow for clarified request

Here is my target plot: multiple-segment scatter plot

And here is the code that produces it:

library("ggplot2")

# CREATE DATA FRAME
# This is the sort of data that I understand you to have
start <- rnorm(200)
value <- rnorm(200) 
df <- data.frame( cbind(start, value) )
df[ df$start > -0.6 & df$start <= 0, "value"] <- 0
df[ df$start > -1.6 & df$start <= -1.3, "value"] <- 0
df[ df$start > 0.9 & df$start <= 1.2, "value"] <- 0

df$type <- rep('cnv', 200)
df[ df$value == 0, "type"] <- 'nregion'
df[ df$value != 0, "type"] <- 'cnv'

# SORT the data frame by value so that the 'cnv' and 
# 'nregion' chunks become contiguous
df <- df[order(start),]

# See note below. 
r <- rle(df$type)
df$label <- rep(seq(from=0, length=length(r$lengths)), times=r$lengths)

# set up plot with colour aesthetic to distinguish the three regions
# playing around with colour and group produces different effects
p <- ggplot(df, aes(x = start, 
                    y= value,
                    colour=type,
                    group = label)
            )
p <- p + theme_bw()
# draw points outside the 'nregion'
p <- p + geom_point( data = df[df$type != 'nregion',] )

# draw smoothed lines outside the 'nregion'
p <- p + geom_smooth( data = df[df$type != 'nregion',] )


# plot zero points inside the 'nregion' 
p <- p + geom_smooth( data = df[df$type == 'nregion',], size = 2 )
p

The use of rle is further explained in an answer to a supplementary question

Community
  • 1
  • 1
daedalus
  • 10,873
  • 5
  • 50
  • 71
  • this is eaxctly what I was searching, thanks sooo much @gauden. I now ONLY need to understand the R-syntax and translate this to my own data. Great support!! – splaisan May 14 '12 at 12:43
  • Dear @gauden, I added some more info on my top post with link to a new picture. (PS: how can I tick on Stackoverflow? I do not have enough points to vote <15?) – splaisan May 15 '12 at 07:03
  • you are a wizard!! I also admire the collaborative effort of the several other people answering your supplementary question (how can I best reward you all?). This is now completely in line with my needs. I realize I still have a long way to go in R with only a basic perl knowledge which does not easily translate here. The vector structure is counter-intuitive to my biologist mind and I always have to struggle to get it. Anyway, I wish you a very good day and THANK you so much for the help and teaching. – splaisan May 17 '12 at 08:16
  • Glad it worked for you. Just keep answering and questioning on SO and that is reward enough for all :) In a short while, I will delete my chatty comments here to reduce clutter... – daedalus May 17 '12 at 09:07